query("CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}ajeadresse` ( `id` int(5) NOT NULL AUTO_INCREMENT, `adresse` text NOT NULL, `titre` text NOT NULL, `lat` text NOT NULL, `lng` text NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) );"); $wpdb->query("INSERT INTO `{$wpdb->prefix}ajeadresse` (`adresse`) VALUES ('Tour Eiffel, Paris');"); } public static function uninstall() { } public static function initialisationUpdate() { global $wpdb;//Prefixe des tables Wordpress $wpdb->query("CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}ajeadresse` ( `id` int(5) NOT NULL AUTO_INCREMENT, `adresse` text NOT NULL, `titre` text NOT NULL, `lat` text NOT NULL, `lng` text NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) );"); $adresses = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}ajeadresse"); $titreExiste = $wpdb->get_results("SELECT titre FROM {$wpdb->prefix}ajeadresse"); if( count($titreExiste)==0 && count($adresses)>0 ){ $wpdb->query("ALTER TABLE `{$wpdb->prefix}ajeadresse` ADD `titre` TEXT NOT NULL AFTER `adresse`;"); } } function myplugin_load_textdomain() { load_plugin_textdomain( 'ajeadresse-textdomain', false, plugin_basename( dirname( __FILE__ ) ) . '/langues' ); } public function adressemaps_menuadmin() { add_options_page('Options plugin AdresseMaps', 'AdresseMaps', 'manage_options', 'adresses-maps', array($this, 'menu_html')); } //page du menu Réglages pour le plugin public function menu_html() { global $wpdb; include(REPERTOIRE_ADRESSEMAPS.'reglages/Menu_reglage/tout.php'); } } new AJE_AdresseMaps();