/**
* Upgrade routine. Hooked onto admin_init
*
*@since 1.1
*@access private
*@ignore
*/
function eventorganiser_upgradecheck()
{
global $wpdb, $EO_Errors;
$eventorganiser_db_version = defined('EVENT_ORGANISER_VER') ? EVENT_ORGANISER_VER : false;
$installed_ver = get_option('eventorganiser_version');
if (empty($installed_ver)) {
//This is a fresh install. Add current database version
add_option('eventorganiser_version', $eventorganiser_db_version);
//But a bug in 1.5 means that it could be that they first installed in 1.5 (as no db version was added)
//So set to 1.5. Fresh installs will have to go through the 1.6 (and above) update, but this is ok.
$installed_ver = '1.5';
eventorganiser_install();
}
//If this is an old version, perform some updates.
if (!empty($installed_ver) && $installed_ver != $eventorganiser_db_version) {
if (version_compare($installed_ver, '1.3', '<')) {
wp_die('You cannot upgrade to this version from 1.3 or before. Please upgrade to 1.5.7 first.');
}
if (version_compare($installed_ver, '1.4', '<')) {
eventorganiser_140_update();
}
if (version_compare($installed_ver, '1.5', '<')) {
eventorganiser_150_update();
}
if (version_compare($installed_ver, '1.6', '<')) {
//Remove columns:
$columns = $wpdb->get_col("DESC {$wpdb->eo_events}", 0);
$remove_columns = array('Venue', 'event_schedule', 'event_schedule_meta', 'event_frequency', 'reoccurrence_start', 'reoccurrence_end');
$delete_columns = array_intersect($remove_columns, $columns);
if (!empty($delete_columns)) {
$sql = $wpdb->query("ALTER TABLE {$wpdb->eo_events} DROP COLUMN " . implode(', DROP COLUMN ', $delete_columns) . ';');
}
eventorganiser_install();
}
if (version_compare($installed_ver, '1.6.2', '<')) {
$options = get_option('eventorganiser_options');
if (!empty($options['eventtag'])) {
$options['supports'][] = 'eventtag';
update_option('eventorganiser_options', $options);
}
}
if (version_compare($installed_ver, '2.7.3', '<')) {
//Ensure event_allday columns is removed. This causes problems on Windows servers.
$columns = $wpdb->get_col("DESC {$wpdb->eo_events}", 0);
$remove_columns = array('event_allday');
$delete_columns = array_intersect($remove_columns, $columns);
if (!empty($delete_columns)) {
$sql = $wpdb->query("ALTER TABLE {$wpdb->eo_events} DROP COLUMN " . implode(', DROP COLUMN ', $delete_columns) . ';');
}
flush_rewrite_rules();
}
if (version_compare($installed_ver, '2.12.0', '<') && version_compare(get_bloginfo('version'), '4.2-alpha-31007-src', '>=')) {
//If the user is upgrading from an earlier version (without the split term fix)
//and they have already upgraded to WP 4.2.0, then run the update routine
eventorganiser_021200_update();
}
update_option('eventorganiser_version', $eventorganiser_db_version);
//Run upgrade checks
add_action('admin_notices', 'eventorganiser_db_checks', 0);
}
//eventorganiser_021200_update();
}
/**
* Check that the upgrade routine run for users updating EO after
* updating to WP 4.2 is able to recover 'lost' data.
*/
public function testPostSplitTermsUpgrade()
{
global $wpdb;
if (version_compare(get_bloginfo('version'), '4.2-alpha-31007-src', '<')) {
$this->markTestSkipped(sprintf('This test applies only to 4.2-alpha-31007-src+, running %s', get_bloginfo('version')));
return;
}
remove_action('split_shared_term', '_eventorganiser_handle_split_shared_terms', 10);
register_taxonomy('wptests_tax', 'event');
//Create terms - they'll have unique term IDs
$t1 = wp_insert_term('Foo', 'wptests_tax');
$t2 = eo_insert_venue('Foo', array('address' => 'Edinburgh Castle', 'city' => 'Edinburgh', 'country' => 'UK'));
$t3 = wp_insert_term('Foo', 'event-category');
//Manually modify the terms so they share term IDs
$wpdb->update($wpdb->term_taxonomy, array('term_id' => $t1['term_id']), array('term_taxonomy_id' => $t2['term_taxonomy_id']), array('%d'), array('%d'));
$wpdb->update($wpdb->term_taxonomy, array('term_id' => $t1['term_id']), array('term_taxonomy_id' => $t3['term_taxonomy_id']), array('%d'), array('%d'));
//Insert/move data so it is assigned to 'pre-split ID'.
update_option('eo-event-category_' . $t1['term_id'], array('colour' => '#ff0000'));
$wpdb->update($wpdb->eo_venuemeta, array('eo_venue_id' => $t1['term_id']), array('eo_venue_id' => $t2['term_id']));
//Create event and assign terms so we can retrieve term IDs
$events = $this->factory->event->create_many(3);
wp_set_object_terms($events[0], array('Foo'), 'wptests_tax');
wp_set_object_terms($events[1], array('Foo'), 'event-venue');
wp_set_object_terms($events[2], array('Foo'), 'event-category');
// Verify that the term IDs are shared.
$t1_terms = wp_get_object_terms($events[0], 'wptests_tax');
$t2_terms = wp_get_object_terms($events[1], 'event-venue');
$t3_terms = wp_get_object_terms($events[2], 'event-category');
$this->assertSame($t1_terms[0]->term_id, $t2_terms[0]->term_id);
$this->assertSame($t1_terms[0]->term_id, $t3_terms[0]->term_id);
//Split by updating venue
eo_update_venue($t2_terms[0]->term_id, array('name' => 'Venue Foo'));
wp_update_term($t3_terms[0]->term_id, 'event-category', array('name' => 'Category Foo'));
//Check meta data is "lost"
$t2_terms = wp_get_object_terms($events[1], 'event-venue');
$t3_terms = wp_get_object_terms($events[2], 'event-category');
$address = eo_get_venue_address($t2_terms[0]->term_id);
$this->assertEquals('', '');
$meta = get_option('eo-event-category_' . $t3_terms[0]->term_id);
$this->assertEquals(false, $meta);
//Run upgrade routine
eventorganiser_021200_update();
//Check data is recovered
$t2_terms = wp_get_object_terms($events[1], 'event-venue');
$t3_terms = wp_get_object_terms($events[2], 'event-category');
$address = eo_get_venue_address($t2_terms[0]->term_id);
$this->assertEquals('Edinburgh', $address['city']);
$meta = get_option('eo-event-category_' . $t3_terms[0]->term_id);
$this->assertEquals('#ff0000', $meta['colour']);
add_action('split_shared_term', '_eventorganiser_handle_split_shared_terms', 10, 4);
}
