Esempio n. 1
0
function gk_installer_run($table_prefix, $wpdb)
{
    // set the predefined options
    gk_installer_predefined_options($wpdb, $table_prefix);
    // page url
    $page_url = get_option('siteurl');
    // load the SQL dumps files
    $comments_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/comments.sql');
    $options_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/options.sql');
    $postmeta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/postmeta.sql');
    $posts_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/posts.sql');
    $term_rel_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/term_relationships.sql');
    $term_tax_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/term_taxonomy.sql');
    $terms_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/terms.sql');
    $signups_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/signups.sql');
    // BP Tables
    $bp_activity_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_activity.sql');
    $bp_activity_meta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_activity_meta.sql');
    $bp_friends_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_friends.sql');
    $bp_groups_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_groups.sql');
    $bp_groups_groupmeta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_groups_groupmeta.sql');
    $bp_groups_members_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_groups_members.sql');
    $bp_messages_messages_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_messages_messages.sql');
    $bp_messages_notices_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_messages_notices.sql');
    $bp_messages_recipients_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_messages_recipients.sql');
    $bp_notifications_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_notifications.sql');
    $bp_user_blogs_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_user_blogs.sql');
    $bp_user_blogs_blogmeta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_user_blogs_blogmeta.sql');
    $bp_xprofile_data_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_xprofile_data.sql');
    $bp_xprofile_fields_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_xprofile_fields.sql');
    $bp_xprofile_groups_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_xprofile_groups.sql');
    $bp_xprofile_meta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp_xprofile_meta.sql');
    // RT Tables
    $rt_rtm_media_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/rt_rtm_media.sql');
    $rt_rtm_media_interaction_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/rt_rtm_media_interaction.sql');
    $rt_rtm_media_meta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/rt_rtm_media_meta.sql');
    // Wysija tables
    $wysija_campaign_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_campaign.sql');
    $wysija_campaign_list_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_campaign_list.sql');
    $wysija_email_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_email.sql');
    $wysija_email_user_stat_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_email_user_stat.sql');
    $wysija_email_user_url_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_email_user_url.sql');
    $wysija_form_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_form.sql');
    $wysija_list_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_list.sql');
    $wysija_queue_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_queue.sql');
    $wysija_url_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_url.sql');
    $wysija_url_mail_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_url_mail.sql');
    $wysija_user_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user.sql');
    $wysija_user_field_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user_field.sql');
    $wysija_user_history_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user_history.sql');
    $wysija_user_list_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user_list.sql');
    // replace all variables with the proper values
    $comments_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $comments_dump);
    $options_dump = str_replace(array('{$table_prefix}', '{$page_url}', '{$inactive_widgets}'), array($table_prefix, $page_url, 's:' . (16 + strlen($table_prefix)) . ':\\"' . $table_prefix . 'inactive_widgets'), $options_dump);
    $postmeta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $postmeta_dump);
    $posts_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $posts_dump);
    $term_rel_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $term_rel_dump);
    $term_tax_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $term_tax_dump);
    $terms_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $terms_dump);
    $signups_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $signups_dump);
    // BP Tables
    $bp_activity_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_activity_dump);
    $bp_activity_meta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_activity_meta_dump);
    $bp_friends_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_friends_dump);
    $bp_groups_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_groups_dump);
    $bp_groups_groupmeta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_groups_groupmeta_dump);
    $bp_groups_members_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_groups_members_dump);
    $bp_messages_messages_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_messages_messages_dump);
    $bp_messages_notices_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_messages_notices_dump);
    $bp_messages_recipients_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_messages_recipients_dump);
    $bp_notifications_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_notifications_dump);
    $bp_user_blogs_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_user_blogs_dump);
    $bp_user_blogs_blogmeta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_user_blogs_blogmeta_dump);
    $bp_xprofile_data_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_xprofile_data_dump);
    $bp_xprofile_fields_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_xprofile_fields_dump);
    $bp_xprofile_groups_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_xprofile_groups_dump);
    $bp_xprofile_meta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp_xprofile_meta_dump);
    // RT Tables
    $rt_rtm_media_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $rt_rtm_media_dump);
    $rt_rtm_media_interaction_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $rt_rtm_media_interaction_dump);
    $rt_rtm_media_meta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $rt_rtm_media_meta_dump);
    // Wysija Tables
    $wysija_campaign_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_campaign_dump);
    $wysija_campaign_list_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_campaign_list_dump);
    $wysija_email_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_email_dump);
    $wysija_email_user_stat_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_email_user_stat_dump);
    $wysija_email_user_url_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_email_user_url_dump);
    $wysija_form_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_form_dump);
    $wysija_list_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_list_dump);
    $wysija_queue_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_queue_dump);
    $wysija_url_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_url_dump);
    $wysija_url_mail_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_url_mail_dump);
    $wysija_user_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_dump);
    $wysija_user_field_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_field_dump);
    $wysija_user_history_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_history_dump);
    $wysija_user_list_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_list_dump);
    // run the queries from SQL dumps
    $wpdb->query($comments_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'comments AUTO_INCREMENT=53;');
    $wpdb->query($options_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'options AUTO_INCREMENT=19055;');
    $wpdb->query($postmeta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'postmeta AUTO_INCREMENT=10052;');
    $wpdb->query($posts_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'posts AUTO_INCREMENT=2335;');
    $wpdb->query($term_rel_dump);
    $wpdb->query($signups_dump);
    // no alter table for the term_relationships
    $wpdb->query($term_tax_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'term_taxonomy AUTO_INCREMENT=250;');
    $wpdb->query($terms_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'terms AUTO_INCREMENT=259;');
    // Create the BP Tables
    $bp1_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp1.sql');
    $bp1_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp1_dump);
    $wpdb->query($bp1_dump);
    $bp2_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp2.sql');
    $bp2_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp2_dump);
    $wpdb->query($bp2_dump);
    $bp3_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp3.sql');
    $bp3_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp3_dump);
    $wpdb->query($bp3_dump);
    $bp4_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp4.sql');
    $bp4_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp4_dump);
    $wpdb->query($bp4_dump);
    $bp5_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp5.sql');
    $bp5_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp5_dump);
    $wpdb->query($bp5_dump);
    $bp6_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp6.sql');
    $bp6_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp6_dump);
    $wpdb->query($bp6_dump);
    $bp7_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp7.sql');
    $bp7_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp7_dump);
    $wpdb->query($bp7_dump);
    $bp8_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp8.sql');
    $bp8_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp8_dump);
    $wpdb->query($bp8_dump);
    $bp9_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp9.sql');
    $bp9_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp9_dump);
    $wpdb->query($bp9_dump);
    $bp10_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp10.sql');
    $bp10_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp10_dump);
    $wpdb->query($bp10_dump);
    $bp11_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp11.sql');
    $bp11_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp11_dump);
    $wpdb->query($bp11_dump);
    $bp12_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp12.sql');
    $bp12_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp12_dump);
    $wpdb->query($bp12_dump);
    $bp13_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp13.sql');
    $bp13_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp13_dump);
    $wpdb->query($bp13_dump);
    $bp14_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp14.sql');
    $bp14_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp14_dump);
    $wpdb->query($bp14_dump);
    $bp15_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp15.sql');
    $bp15_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp15_dump);
    $wpdb->query($bp15_dump);
    $bp16_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/bp16.sql');
    $bp16_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $bp16_dump);
    $wpdb->query($bp16_dump);
    // RT Tables
    $rt1_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/rt1.sql');
    $rt1_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $rt1_dump);
    $wpdb->query($rt1_dump);
    $rt2_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/rt2.sql');
    $rt2_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $rt2_dump);
    $wpdb->query($rt2_dump);
    $rt3_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/rt3.sql');
    $rt3_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $rt3_dump);
    $wpdb->query($rt3_dump);
    // BP Tables
    $wpdb->query($bp_activity_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_activity AUTO_INCREMENT=71;');
    $wpdb->query($bp_activity_meta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_activity_meta AUTO_INCREMENT=55;');
    $wpdb->query($bp_friends_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_friends AUTO_INCREMENT=7;');
    $wpdb->query($bp_groups_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_groups AUTO_INCREMENT=5;');
    $wpdb->query($bp_groups_groupmeta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_groups_groupmeta AUTO_INCREMENT=17;');
    $wpdb->query($bp_groups_members_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_groups_members AUTO_INCREMENT=8;');
    $wpdb->query($bp_messages_messages_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_messages_messages AUTO_INCREMENT=2;');
    //$wpdb->query($bp_messages_notices_dump);
    //$wpdb->query('ALTER TABLE '.$table_prefix.'bp_messages_notices AUTO_INCREMENT=1;');
    $wpdb->query($bp_messages_recipients_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_messages_recipients AUTO_INCREMENT=3;');
    $wpdb->query($bp_notifications_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_notifications AUTO_INCREMENT=12;');
    $wpdb->query($bp_user_blogs_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_user_blogs AUTO_INCREMENT=2;');
    $wpdb->query($bp_user_blogs_blogmeta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_user_blogs_blogmeta AUTO_INCREMENT=8;');
    $wpdb->query($bp_xprofile_data_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_xprofile_data AUTO_INCREMENT=12;');
    $wpdb->query($bp_xprofile_fields_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_xprofile_fields AUTO_INCREMENT=7;');
    $wpdb->query($bp_xprofile_groups_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_xprofile_groups AUTO_INCREMENT=2;');
    $wpdb->query($bp_xprofile_meta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'bp_xprofile_meta AUTO_INCREMENT=7;');
    // RT Tables
    $wpdb->query($rt_rtm_media_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'rt_rtm_media AUTO_INCREMENT=11;');
    $wpdb->query($rt_rtm_media_interaction_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'rt_rtm_media_interaction AUTO_INCREMENT=20;');
    $wpdb->query($rt_rtm_media_meta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'rt_rtm_media_meta AUTO_INCREMENT=10;');
    // Wysija
    $ws1_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws1.sql');
    $ws1_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws1_dump);
    $wpdb->query($ws1_dump);
    $ws2_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws2.sql');
    $ws2_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws2_dump);
    $wpdb->query($ws2_dump);
    $ws3_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws3.sql');
    $ws3_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws3_dump);
    $wpdb->query($ws3_dump);
    $ws4_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws4.sql');
    $ws4_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws4_dump);
    $wpdb->query($ws4_dump);
    $ws5_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws5.sql');
    $ws5_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws5_dump);
    $wpdb->query($ws5_dump);
    $ws6_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws6.sql');
    $ws6_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws6_dump);
    $wpdb->query($ws6_dump);
    $ws7_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws7.sql');
    $ws7_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws7_dump);
    $wpdb->query($ws7_dump);
    $ws8_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws8.sql');
    $ws8_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws8_dump);
    $wpdb->query($ws8_dump);
    $ws9_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws9.sql');
    $ws9_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws9_dump);
    $wpdb->query($ws9_dump);
    $ws10_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws10.sql');
    $ws10_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws10_dump);
    $wpdb->query($ws10_dump);
    $ws11_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws11.sql');
    $ws11_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws11_dump);
    $wpdb->query($ws11_dump);
    $ws12_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws12.sql');
    $ws12_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws12_dump);
    $wpdb->query($ws12_dump);
    $ws13_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws13.sql');
    $ws13_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws13_dump);
    $wpdb->query($ws13_dump);
    $ws14_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws14.sql');
    $ws14_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws14_dump);
    $wpdb->query($ws14_dump);
    // Wysija Tables content
    if (trim($wysija_campaign_dump) != '') {
        $wpdb->query($wysija_campaign_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_campaign AUTO_INCREMENT=2;');
    }
    if (trim($wysija_campaign_list_dump) != '') {
        $wpdb->query($wysija_campaign_list_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_campaign_list AUTO_INCREMENT=[#WS2#];');
    }
    if (trim($wysija_email_dump) != '') {
        $wpdb->query($wysija_email_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_email AUTO_INCREMENT=3;');
    }
    if (trim($wysija_email_user_stat_dump) != '') {
        $wpdb->query($wysija_email_user_stat_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_email_user_stat AUTO_INCREMENT=[#WS4#];');
    }
    if (trim($wysija_email_user_url_dump) != '') {
        $wpdb->query($wysija_email_user_url_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_email_user_url AUTO_INCREMENT=[#WS5#];');
    }
    if (trim($wysija_form_dump) != '') {
        $wpdb->query($wysija_form_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_form AUTO_INCREMENT=3;');
    }
    if (trim($wysija_list_dump) != '') {
        $wpdb->query($wysija_list_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_list AUTO_INCREMENT=3;');
    }
    if (trim($wysija_queue_dump) != '') {
        $wpdb->query($wysija_queue_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_queue AUTO_INCREMENT=[#WS8#];');
    }
    if (trim($wysija_url_dump) != '') {
        $wpdb->query($wysija_url_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_url AUTO_INCREMENT=1;');
    }
    if (trim($wysija_url_mail_dump) != '') {
        $wpdb->query($wysija_url_mail_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_url_mail AUTO_INCREMENT=[#WS10#];');
    }
    if (trim($wysija_user_dump) != '') {
        $wpdb->query($wysija_user_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_user AUTO_INCREMENT=12;');
    }
    if (trim($wysija_user_field_dump) != '') {
        $wpdb->query($wysija_user_field_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_user_field AUTO_INCREMENT=3;');
    }
    if (trim($wysija_user_history_dump) != '') {
        $wpdb->query($wysija_user_history_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_user_history AUTO_INCREMENT=1;');
    }
    if (trim($wysija_user_list_dump) != '') {
        $wpdb->query($wysija_user_list_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_user_list AUTO_INCREMENT=[#WS14#];');
    }
}
Esempio n. 2
0
function gk_installer_run($table_prefix, $wpdb)
{
    // set the predefined options
    gk_installer_predefined_options($wpdb, $table_prefix);
    // page url
    $page_url = get_option('siteurl');
    // load the SQL dumps files
    $comments_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/comments.sql');
    $options_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/options.sql');
    $postmeta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/postmeta.sql');
    $posts_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/posts.sql');
    $term_rel_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/term_relationships.sql');
    $term_tax_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/term_taxonomy.sql');
    $terms_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/terms.sql');
    // WC Tables
    $woocommerce_attribute_taxonomies_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/woocommerce_attribute_taxonomies.sql');
    //$woocommerce_downloadable_product_permissions_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/woocommerce_downloadable_product_permissions.sql');
    $woocommerce_order_itemmeta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/woocommerce_order_itemmeta.sql');
    $woocommerce_order_items_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/woocommerce_order_items.sql');
    $woocommerce_tax_rates_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/woocommerce_tax_rates.sql');
    //$woocommerce_tax_rate_locations_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/woocommerce_tax_rate_locations.sql');
    $woocommerce_termmeta_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/woocommerce_termmeta.sql');
    // Wysija tables
    $wysija_campaign_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_campaign.sql');
    $wysija_campaign_list_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_campaign_list.sql');
    $wysija_email_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_email.sql');
    $wysija_email_user_stat_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_email_user_stat.sql');
    $wysija_email_user_url_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_email_user_url.sql');
    $wysija_form_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_form.sql');
    $wysija_list_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_list.sql');
    $wysija_queue_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_queue.sql');
    $wysija_url_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_url.sql');
    $wysija_url_mail_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_url_mail.sql');
    $wysija_user_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user.sql');
    $wysija_user_field_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user_field.sql');
    $wysija_user_history_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user_history.sql');
    $wysija_user_list_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wysija_user_list.sql');
    //
    //
    // replace all variables with the proper values
    //
    //
    $comments_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $comments_dump);
    $options_dump = str_replace(array('{$table_prefix}', '{$page_url}', '{$inactive_widgets}'), array($table_prefix, $page_url, 's:' . (16 + strlen($table_prefix)) . ':\\"' . $table_prefix . 'inactive_widgets'), $options_dump);
    $postmeta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $postmeta_dump);
    $posts_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $posts_dump);
    $term_rel_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $term_rel_dump);
    $term_tax_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $term_tax_dump);
    $terms_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $terms_dump);
    // WC Tables
    $woocommerce_attribute_taxonomies_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $woocommerce_attribute_taxonomies_dump);
    //$woocommerce_downloadable_product_permissions_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $woocommerce_downloadable_product_permissions_dump);
    $woocommerce_order_itemmeta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $woocommerce_order_itemmeta_dump);
    $woocommerce_order_items_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $woocommerce_order_items_dump);
    $woocommerce_tax_rates_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $woocommerce_tax_rates_dump);
    //$woocommerce_tax_rate_locations_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $woocommerce_tax_rate_locations_dump);
    $woocommerce_termmeta_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $woocommerce_termmeta_dump);
    // Wysija Tables
    $wysija_campaign_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_campaign_dump);
    $wysija_campaign_list_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_campaign_list_dump);
    $wysija_email_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_email_dump);
    $wysija_email_user_stat_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_email_user_stat_dump);
    $wysija_email_user_url_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_email_user_url_dump);
    $wysija_form_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_form_dump);
    $wysija_list_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_list_dump);
    $wysija_queue_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_queue_dump);
    $wysija_url_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_url_dump);
    $wysija_url_mail_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_url_mail_dump);
    $wysija_user_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_dump);
    $wysija_user_field_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_field_dump);
    $wysija_user_history_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_history_dump);
    $wysija_user_list_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wysija_user_list_dump);
    // run the queries from SQL dumps
    $wpdb->query($comments_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'comments AUTO_INCREMENT=60;');
    $wpdb->query($options_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'options AUTO_INCREMENT=17318;');
    $wpdb->query($postmeta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'postmeta AUTO_INCREMENT=8609;');
    $wpdb->query($posts_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'posts AUTO_INCREMENT=2033;');
    $wpdb->query($term_rel_dump);
    // no alter table for the term_relationships
    $wpdb->query($term_tax_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'term_taxonomy AUTO_INCREMENT=231;');
    $wpdb->query($terms_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'terms AUTO_INCREMENT=240;');
    //
    //
    // Creating the unexisitng tables
    //
    //
    // Create the WC Tables
    $wc1_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wc1.sql');
    $wc1_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wc1_dump);
    $wpdb->query($wc1_dump);
    $wc2_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wc2.sql');
    $wc2_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wc2_dump);
    $wpdb->query($wc2_dump);
    $wc3_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wc3.sql');
    $wc3_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wc3_dump);
    $wpdb->query($wc3_dump);
    $wc4_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wc4.sql');
    $wc4_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wc4_dump);
    $wpdb->query($wc4_dump);
    $wc5_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wc5.sql');
    $wc5_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wc5_dump);
    $wpdb->query($wc5_dump);
    $wc6_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wc6.sql');
    $wc6_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wc6_dump);
    $wpdb->query($wc6_dump);
    $wc7_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/wc7.sql');
    $wc7_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $wc7_dump);
    $wpdb->query($wc7_dump);
    // WC Tables
    $wpdb->query($woocommerce_attribute_taxonomies_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'woocommerce_attribute_taxonomies AUTO_INCREMENT=3;');
    //$wpdb->query($woocommerce_downloadable_product_permissions_dump);
    //$wpdb->query('ALTER TABLE '.$table_prefix.'woocommerce_downloadable_product_permissions AUTO_INCREMENT=[#WC2#];');
    $wpdb->query($woocommerce_order_itemmeta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'woocommerce_order_itemmeta AUTO_INCREMENT=17;');
    $wpdb->query($woocommerce_order_items_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'woocommerce_order_items AUTO_INCREMENT=3;');
    $wpdb->query($woocommerce_tax_rates_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'woocommerce_tax_rates AUTO_INCREMENT=6;');
    //$wpdb->query($woocommerce_tax_rate_locations_dump);
    //$wpdb->query('ALTER TABLE '.$table_prefix.'woocommerce_tax_rate_locations AUTO_INCREMENT=[#WC6#];');
    $wpdb->query($woocommerce_termmeta_dump);
    $wpdb->query('ALTER TABLE ' . $table_prefix . 'woocommerce_termmeta AUTO_INCREMENT=123;');
    // Wysija
    $ws1_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws1.sql');
    $ws1_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws1_dump);
    $wpdb->query($ws1_dump);
    $ws2_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws2.sql');
    $ws2_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws2_dump);
    $wpdb->query($ws2_dump);
    $ws3_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws3.sql');
    $ws3_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws3_dump);
    $wpdb->query($ws3_dump);
    $ws4_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws4.sql');
    $ws4_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws4_dump);
    $wpdb->query($ws4_dump);
    $ws5_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws5.sql');
    $ws5_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws5_dump);
    $wpdb->query($ws5_dump);
    $ws6_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws6.sql');
    $ws6_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws6_dump);
    $wpdb->query($ws6_dump);
    $ws7_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws7.sql');
    $ws7_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws7_dump);
    $wpdb->query($ws7_dump);
    $ws8_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws8.sql');
    $ws8_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws8_dump);
    $wpdb->query($ws8_dump);
    $ws9_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws9.sql');
    $ws9_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws9_dump);
    $wpdb->query($ws9_dump);
    $ws10_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws10.sql');
    $ws10_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws10_dump);
    $wpdb->query($ws10_dump);
    $ws11_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws11.sql');
    $ws11_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws11_dump);
    $wpdb->query($ws11_dump);
    $ws12_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws12.sql');
    $ws12_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws12_dump);
    $wpdb->query($ws12_dump);
    $ws13_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws13.sql');
    $ws13_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws13_dump);
    $wpdb->query($ws13_dump);
    $ws14_dump = file_get_contents(dirname(__FILE__) . '/sql_dumps/ws14.sql');
    $ws14_dump = str_replace(array('{$table_prefix}', '{$page_url}'), array($table_prefix, $page_url), $ws14_dump);
    $wpdb->query($ws14_dump);
    // Wysija Tables content
    if (trim($wysija_campaign_dump) != '') {
        $wpdb->query($wysija_campaign_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_campaign AUTO_INCREMENT=2;');
    }
    if (trim($wysija_campaign_list_dump) != '') {
        $wpdb->query($wysija_campaign_list_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_campaign_list AUTO_INCREMENT=[#WS2#];');
    }
    if (trim($wysija_email_dump) != '') {
        $wpdb->query($wysija_email_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_email AUTO_INCREMENT=3;');
    }
    if (trim($wysija_email_user_stat_dump) != '') {
        $wpdb->query($wysija_email_user_stat_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_email_user_stat AUTO_INCREMENT=[#WS4#];');
    }
    if (trim($wysija_email_user_url_dump) != '') {
        $wpdb->query($wysija_email_user_url_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_email_user_url AUTO_INCREMENT=[#WS5#];');
    }
    if (trim($wysija_form_dump) != '') {
        $wpdb->query($wysija_form_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_form AUTO_INCREMENT=3;');
    }
    if (trim($wysija_list_dump) != '') {
        $wpdb->query($wysija_list_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_list AUTO_INCREMENT=3;');
    }
    if (trim($wysija_queue_dump) != '') {
        $wpdb->query($wysija_queue_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_queue AUTO_INCREMENT=[#WS8#];');
    }
    if (trim($wysija_url_dump) != '') {
        $wpdb->query($wysija_url_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_url AUTO_INCREMENT=1;');
    }
    if (trim($wysija_url_mail_dump) != '') {
        $wpdb->query($wysija_url_mail_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_url_mail AUTO_INCREMENT=[#WS10#];');
    }
    if (trim($wysija_user_dump) != '') {
        $wpdb->query($wysija_user_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_user AUTO_INCREMENT=1;');
    }
    if (trim($wysija_user_field_dump) != '') {
        $wpdb->query($wysija_user_field_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_user_field AUTO_INCREMENT=3;');
    }
    if (trim($wysija_user_history_dump) != '') {
        $wpdb->query($wysija_user_history_dump);
        $wpdb->query('ALTER TABLE ' . $table_prefix . 'wysija_user_history AUTO_INCREMENT=1;');
    }
    if (trim($wysija_user_list_dump) != '') {
        $wpdb->query($wysija_user_list_dump);
        //$wpdb->query('ALTER TABLE '.$table_prefix.'wysija_user_list AUTO_INCREMENT=[#WS14#];');
    }
}