PHP ConfigManager::tableName方法代碼示例

 /**
  * Install the database of WSI
  */
 public function wsi_install_db()
 {
     global $wpdb;
     global $wsi_db_version;
     require_once ABSPATH . 'wp-admin/includes/upgrade.php';
     switch ($this->get_current_wsi_db_version()) {
         case "1.0":
             //write here, what is nececery to go to the next version (2.0)
             $table_name_splashimage = SplashImageManager::tableName();
             $sql_splashimage = "CREATE TABLE " . $table_name_splashimage . " (\r\n\t\t\t\t\tid                        MEDIUMINT(9) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\twsi_display_always        BOOLEAN,\r\n\t\t\t\t\twsi_idle_time             INT,\r\n\t\t\t\t\turl_splash_image          VARCHAR(255),\r\n\t\t\t\t\tsplash_image_width        INT,\r\n\t\t\t\t\tsplash_image_height       INT,\r\n\t\t\t\t\tsplash_color              VARCHAR(6),\r\n\t\t\t\t\tdatepicker_start          DATETIME,\r\n\t\t\t\t\tdatepicker_end            DATETIME,\r\n\t\t\t\t\twsi_display_time          INT,\r\n\t\t\t\t\twsi_fixed_splash          BOOLEAN,\r\n\t\t\t\t\twsi_picture_link_url      VARCHAR(255),\r\n\t\t\t\t\twsi_picture_link_target   VARCHAR(255),\r\n\t\t\t\t\twsi_include_url           VARCHAR(255),\r\n\t\t\t\t\twsi_close_esc_function    BOOLEAN,\r\n\t\t\t\t\twsi_hide_cross            BOOLEAN,\r\n\t\t\t\t\twsi_disable_shadow_border BOOLEAN,\r\n\t\t\t\t\twsi_type                  VARCHAR(20),\r\n\t\t\t\t\twsi_opacity               INT,\r\n\t\t\t\t\twsi_youtube               VARCHAR(255),\r\n\t\t\t\t\twsi_youtube_autoplay      BOOLEAN,\r\n\t\t\t\t\twsi_youtube_loop          BOOLEAN,\r\n\t\t\t\t\twsi_yahoo                 VARCHAR(255),\r\n\t\t\t\t\twsi_dailymotion           VARCHAR(255),\r\n\t\t\t\t\twsi_metacafe              VARCHAR(255),\r\n\t\t\t\t\twsi_swf                   VARCHAR(255),\r\n\t\t\t\t\twsi_html                  VARCHAR(255),\r\n\t\t\t\t\tPRIMARY KEY id (id)\r\n\t\t\t\t);";
             $table_name_config = ConfigManager::tableName();
             $sql_config = "CREATE TABLE " . $table_name_config . " (\r\n\t\t\t\t\tparam VARCHAR(255),\r\n\t\t\t\t\tvalue VARCHAR(255),\r\n\t\t\t\t\tPRIMARY KEY id (param)\r\n\t\t\t\t);";
             dbDelta($sql_config);
             dbDelta($sql_splashimage);
             $wpdb->insert($table_name_config, array('param' => 'splash_active', 'value' => get_option('splash_active') == 'true'));
             $wpdb->insert($table_name_config, array('param' => 'wsi_first_load_mode_active', 'value' => get_option('wsi_first_load_mode_active') == 'true'));
             $wpdb->insert($table_name_splashimage, array('url_splash_image' => get_option('url_splash_image'), 'splash_image_width' => get_option('splash_image_width'), 'splash_image_height' => get_option('splash_image_height'), 'splash_color' => get_option('splash_color'), 'datepicker_start' => get_option('datepicker_start'), 'datepicker_end' => get_option('datepicker_end'), 'wsi_display_time' => get_option('wsi_display_time'), 'wsi_picture_link_url' => get_option('wsi_picture_link_url'), 'wsi_picture_link_target' => get_option('wsi_picture_link_target'), 'wsi_include_url' => get_option('wsi_include_url'), 'wsi_type' => get_option('wsi_type'), 'wsi_opacity' => get_option('wsi_opacity'), 'wsi_idle_time' => get_option('wsi_idle_time'), 'wsi_close_esc_function' => get_option('wsi_close_esc_function') == 'true', 'wsi_hide_cross' => get_option('wsi_hide_cross') == 'true', 'wsi_disable_shadow_border' => get_option('wsi_disable_shadow_border') == 'true', 'wsi_youtube_autoplay' => get_option('wsi_youtube_autoplay') == 'true', 'wsi_youtube_loop' => get_option('wsi_youtube_loop') == 'true', 'wsi_fixed_splash' => get_option('wsi_fixed_splash') == 'true', 'wsi_display_always' => get_option('splash_test_active') == 'true', 'wsi_youtube' => get_option('wsi_youtube'), 'wsi_yahoo' => get_option('wsi_yahoo'), 'wsi_dailymotion' => get_option('wsi_dailymotion'), 'wsi_metacafe' => get_option('wsi_metacafe'), 'wsi_swf' => get_option('wsi_swf'), 'wsi_html' => get_option('wsi_html')));
             // Delete old options...
             delete_option('splash_active');
             delete_option('wsi_first_load_mode_active');
             delete_option('splash_test_active');
             delete_option('url_splash_image');
             delete_option('splash_image_width');
             delete_option('splash_image_height');
             delete_option('splash_color');
             delete_option('datepicker_start');
             delete_option('datepicker_end');
             delete_option('wsi_display_time');
             delete_option('wsi_picture_link_url');
             delete_option('wsi_picture_link_target');
             delete_option('wsi_include_url');
             delete_option('wsi_type');
             delete_option('wsi_opacity');
             delete_option('wsi_idle_time');
             delete_option('wsi_close_esc_function');
             delete_option('wsi_hide_cross');
             delete_option('wsi_disable_shadow_border');
             delete_option('wsi_youtube_autoplay');
             delete_option('wsi_youtube_loop');
             delete_option('wsi_fixed_splash');
             delete_option('wsi_youtube');
             delete_option('wsi_yahoo');
             delete_option('wsi_dailymotion');
             delete_option('wsi_metacafe');
             delete_option('wsi_swf');
             delete_option('wsi_html');
             //no break, because if the last version is 3.0, we must run this step and the next...
         //no break, because if the last version is 3.0, we must run this step and the next...
         case "2.0":
             $table_name_splashimage = SplashImageManager::tableName();
             $sql_update_wsi_html = "ALTER TABLE " . $table_name_splashimage . " MODIFY wsi_html LONGTEXT NULL;";
             $wpdb->query($sql_update_wsi_html);
         case "2.1":
             $table_name_splashimage = SplashImageManager::tableName();
             $sql_update = "ALTER TABLE " . $table_name_splashimage . " ADD COLUMN wsi_margin_top INT NULL;";
             $wpdb->query($sql_update);
         case "2.2":
             $table_name_splashimage = SplashImageManager::tableName();
             $sql_alter = "ALTER TABLE " . $table_name_splashimage . " ADD COLUMN wsi_hide_on_mobile_devices BOOLEAN NULL;";
             $wpdb->query($sql_alter);
             $sql_update = "UPDATE " . $table_name_splashimage . " SET wsi_hide_on_mobile_devices = 0;";
             $wpdb->query($sql_update);
         case "2.3":
             $table_name_splashimage = SplashImageManager::tableName();
             $wpdb->query("ALTER TABLE " . $table_name_splashimage . " ADD COLUMN wsi_close_on_click_function BOOLEAN NULL;");
             $wpdb->query("UPDATE " . $table_name_splashimage . " SET wsi_close_on_click_function = 0;");
             $wpdb->query("ALTER TABLE " . $table_name_splashimage . " DROP wsi_close_esc_function;");
             $wpdb->query("ALTER TABLE " . $table_name_splashimage . " ADD COLUMN wsi_close_on_esc_function BOOLEAN NULL;");
             $wpdb->query("UPDATE " . $table_name_splashimage . " SET wsi_close_on_esc_function = 0;");
         case "2.4":
             //nothing for the moment (it is the current version)
         //nothing for the moment (it is the current version)
         case "3.0":
             //do not exists
     }
     // Add or update the wsi db version.
     update_option("wsi_db_version", WSI_DB_VERSION);
 }

 /**
  * Retourne un tableau contenant la liste de toutes les tables propre au WSI.
  */
 public static function getWsiTablesList()
 {
     return array(ConfigManager::tableName(), SplashImageManager::tableName());
 }