PHP get_quest_text_table_name示例

示例#1

文件： uninstall.php 项目： Trying-On-The-Trades/panomanager

function panno_uninstall()
{
    global $wpdb;
    // Get all the table names
    $pano_table_name = get_pano_table_name();
    $pano_text_table_name = get_pano_text_table_name();
    $quest_table_name = get_quest_table_name();
    $quest_text_table_name = get_quest_text_table_name();
    $mission_table_name = get_mission_table_name();
    $mission_text_table_name = get_mission_text_table_name();
    $hotspot_table_name = get_hotspot_table_name();
    $progress_table_name = get_user_progress_table_name();
    $skill_progress_table_name = get_user_skill_progress_table_name();
    $skill_bonus_pts_table_name = get_user_skill_bonus_pts_table_name();
    $type_table_name = get_type_table_name();
    $prereq_table_name = get_prereq_table_name();
    $activation_code_table_name = get_activation_code_table_name();
    $ads_table_name = get_ads_table_name();
    $ads_text_table_name = get_ads_text_table_name();
    $domain_table_name = get_domain_table_name();
    $tool_table_name = get_tool_table_name();
    // Drop all the tables
    $wpdb->query("DROP TABLE IF EXISTS {$pano_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$pano_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$quest_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$quest_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$mission_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$mission_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$hotspot_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$progress_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$skill_progress_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$skill_bonus_pts_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$type_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$prereq_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$activation_code_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$ads_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$ads_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$domain_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$tool_table_name}");
    echo "bbbbbbbbb";
    // Update the db version to 0 so the next time the plugin is run it will reinstall
    update_option("panno_db_version", PANO_DB_VERSION);
}

示例#2

文件： db_functions.php 项目： Trying-On-The-Trades/panomanager

function update_quest($quest_id, $quest_name, $quest_description, $pano_id, $domain_id)
{
    global $wpdb;
    $quest_table_name = get_quest_table_name();
    $text_table_name = get_quest_text_table_name();
    $language_code = get_user_language();
    $language_code = str_replace("'", "", $language_code);
    if (isset($quest_id) && is_numeric($quest_id)) {
        $wpdb->update($quest_table_name, array('panno_id' => $pano_id, 'domain_id' => $domain_id), array('id' => $quest_id));
        $wpdb->update($text_table_name, array('language_code' => $language_code, 'name' => $quest_name, 'description' => $quest_description), array('quest_id' => $quest_id));
        return true;
    } else {
        return false;
    }
}

示例#3

文件： database.php 项目： Trying-On-The-Trades/panomanager

function build_quest_text_sql()
{
    $table_name = get_quest_text_table_name();
    $sql = 'CREATE TABLE ' . $table_name . ' (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `quest_id` int(11) NOT NULL,
      `language_code` varchar(2) NOT NULL DEFAULT "",
      `name` varchar(255) NOT NULL DEFAULT "",
      `description` text,
      PRIMARY KEY (`id`)
    );';
    return $sql;
}