function wordtour_install() { global $wpdb; if ($wpdb->get_var("SHOW TABLES LIKE '" . WORDTOUR_EVENTS . "'") != WORDTOUR_EVENTS) { require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta(wt_schema_table()); } }
function wordtour_upgrade_1_2_5_0() { global $_wt_options, $wpdb; // delete column genre from artist table $wpdb->query("ALTER TABLE " . WORDTOUR_ARTISTS . " DROP artist_genre"); // add schema of new tables $schema = wt_schema_table(); // create track table $wpdb->query($schema[10]); // create album table $wpdb->query($schema[11]); // Move thumbnail id to attachments table and delete column $events = $wpdb->get_results("SELECT event_id,event_thumbnail_id FROM " . WORDTOUR_EVENTS . " WHERE event_thumbnail_id>0"); foreach ($events as $event) { $wpdb->insert(WORDTOUR_ATTACHMENT, array('attachment_target' => 'event', 'attachment_target_id' => $event->event_id, "attachment_type" => "thumbnail", "attachment_type_id" => $event->event_thumbnail_id, "attachment_info" => "")); } $artists = $wpdb->get_results("SELECT artist_id,artist_thumbnail_id FROM " . WORDTOUR_ARTISTS . " WHERE artist_thumbnail_id>0"); foreach ($artists as $artist) { $wpdb->insert(WORDTOUR_ATTACHMENT, array('attachment_target' => 'artist', 'attachment_target_id' => $artist->artist_id, "attachment_type" => "thumbnail", "attachment_type_id" => $artist->artist_thumbnail_id, "attachment_info" => "")); } $tours = $wpdb->get_results("SELECT tour_id,tour_thumbnail_id FROM " . WORDTOUR_TOUR . " WHERE tour_thumbnail_id>0"); foreach ($tours as $tour) { $wpdb->insert(WORDTOUR_ATTACHMENT, array('attachment_target' => 'tour', 'attachment_target_id' => $tour->tour_id, "attachment_type" => "thumbnail", "attachment_type_id" => $tour->tour_thumbnail_id, "attachment_info" => "")); } $venues = $wpdb->get_results("SELECT venue_id,venue_thumbnail_id FROM " . WORDTOUR_VENUES . " WHERE venue_thumbnail_id>0"); foreach ($venues as $venue) { $wpdb->insert(WORDTOUR_ATTACHMENT, array('attachment_target' => 'venue', 'attachment_target_id' => $venue->venue_id, "attachment_type" => "thumbnail", "attachment_type_id" => $venue->venue_thumbnail_id, "attachment_info" => "")); } $wpdb->query("ALTER TABLE " . WORDTOUR_EVENTS . " DROP event_thumbnail_id"); $wpdb->query("ALTER TABLE " . WORDTOUR_ARTISTS . " DROP artist_thumbnail_id"); $wpdb->query("ALTER TABLE " . WORDTOUR_TOUR . " DROP tour_thumbnail_id"); $wpdb->query("ALTER TABLE " . WORDTOUR_VENUES . " DROP venue_thumbnail_id"); // delete panel state delete_option("wordtour_panel_state"); // update album permalink if ($_wt_options->options("permalinks") == 1) { $_wt_options->update(array("permalinks_album" => get_bloginfo("url") . "/album/%name%/%id%/")); } return 1; }