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;
}
