function build_domains_sql() { $table_name = get_domain_table_name(); $sql = 'CREATE TABLE ' . $table_name . ' ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT "", PRIMARY KEY (`id`) );'; return $sql; }
function registration_uninstall() { global $wpdb; // Get all the table names $domain_table_name = get_domain_table_name(); $tool_table_name = get_tool_table_name(); // Drop all the tables $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("register_db_version", REGISTER_DB_VERSION); }
function build_dictionary_sql() { $table_name = get_dictionary_table_name(); $sql = 'CREATE TABLE `' . $table_name . '` ( `id` int(10) NOT NULL AUTO_INCREMENT, `word` char(50) NOT NULL, `description` varchar(225) NOT NULL, `image` varchar(80), `audio` varchar(80), `points` integer(10), `domain_id` int(11) NOT NULL, `word_category_id` int(11) NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (domain_id) REFERENCES ' . get_domain_table_name() . '(id), FOREIGN KEY (word_category_id) REFERENCES ' . get_word_categories_table_name() . '(id) )ENGINE=MyISAM DEFAULT CHARSET=latin1;'; return $sql; }
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); }
function delete_domain($domain_id) { global $wpdb; $domain_table_name = get_domain_table_name(); $wpdb->delete($domain_table_name, array('id' => $domain_id)); }
function get_word_details($word_id) { global $wpdb; $word_table_name = get_dictionary_table_name(); $domain_table_name = get_domain_table_name(); $word_category_table_name = get_word_categories_table_name(); $word = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . $word_table_name . " AS word, " . $domain_table_name . " AS domain , " . $word_category_table_name . " AS category " . "WHERE word.domain_id = domain.id AND word.word_category_id = category.id" . "AND word.id = {$word_id}")); return $word; }