function upgrade_needed()
{
$mysql_version = PROSPER202::mysql_version();
$php_version = PROSPER202::php_version();
if ($mysql_version != $php_version) {
return true;
} else {
return false;
}
}
<span style="color: #900;">An unexpected error occured while you were trying to upgrade, please try again or if you keep encountering problems please contact <a href="http://prosper202.com/forum">our support forum</a>.</span>
<br/><br/>
<?php
}
?>
<h2>Upgrade to Prosper202 <?php
echo $version;
?>
</h2>
<!--<span style="color: #900;">YOU ARE ABOUT TO UPGRADE YOUR PROSPER202 SOFTWARE. <strong>YOU NEED TO MAKE SURE YOU DELETE ALL OF THE PREVIOUS FILES BEFORE YOU UPLOADED THIS NEW VERSION</strong>. THE ROOT WEB DIRECTORY SHOULD HAVE BEEN WIPED CLEAN BEFORE UPLOADING THESES FILES. IF YOU SIMPLY UPLOADED THE FILES AND REPLACED THE EXISTING ONES, YOU NEED TO GO BACK REMOVE ALL OLD FILES, DELETE THEM, AND THEN UPLOAD THE NEW PROSPER202 FILES TO A CLEAN DOMAIN. PLEASE FOLLOW THE INSTRUCTIONS EXACTLY <a href="http://prosper202.com/apps/docs/upgrading/">SHOWN HERE</a>.</span><br/><br/>
<span style="color: #900;">IT IS EXTREMELY IMPORTANT THAT YOU DELETED ALL THE OLD FILES BEFORE UPLOADING AND INSTALLING THIS NEW VERSION. BECAUSE IF YOU DID NOT YOUR PROSPER202 INSTALL WILL HAVE A KNOWN SECURITY VULNERABILTLY. MORE INFORMATION ON THIS CAN BE FOUND <a href="http://prosper202.com/blog/going-opensource-prosper-111-release-with-emergency-security-release">HERE</a>.</span><br/><br/>-->
You are upgrading from version <?php
echo PROSPER202::mysql_version();
?>
to <?php
echo $version;
?>
. To continue with the upgrade press the button below to begin the update process. Please do not click the button twice. This could take a while depending on the last time you updated your software.
<form method="post">
<table cellspacing="0" cellpadding="5" class="config" style="margin: 0px auto;">
<tr>
<td/>
<td ><br/><input id="submit" type="submit" value="Upgrade Prosper202 »" style="font-size: 1.2em;"/></td>
</tr>
</table>
</form>
function upgrade_databases()
{
ini_set('max_execution_time', 60 * 10);
ini_set('max_input_time', 60 * 10);
//get the old version
$mysql_version = PROSPER202::mysql_version();
$php_version = PROSPER202::php_version();
//if the mysql is 1.0.2, upgrade to 1.0.3
if ($mysql_version == '1.0.2') {
//create the new mysql version table
$sql = "CREATE TABLE IF NOT EXISTS `202_version` (\r\n\t\t\t\t\t `version` varchar(50) NOT NULL\r\n\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$result = _mysql_query($sql);
//drop the old table
$sql = "DROP TABLE `202_sort_landings`";
$result = _mysql_query($sql);
//create the new landing page sorting table
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_landing_pages` (\r\n\t\t\t\t `sort_landing_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `landing_page_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_click_throughs` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_ctr` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_payout` decimal(6,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_epc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_avg_cpc` decimal(5,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_income` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_cost` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_net` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_roi` decimal(10,2) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`sort_landing_id`),\r\n\t\t\t\t KEY `user_id` (`user_id`),\r\n\t\t\t\t KEY `landing_page_id` (`landing_page_id`),\r\n\t\t\t\t KEY `sort_landing_page_clicks` (`sort_landing_page_clicks`),\r\n\t\t\t\t KEY `sort_landing_page_click_throughs` (`sort_landing_page_click_throughs`),\r\n\t\t\t\t KEY `sort_landing_page_ctr` (`sort_landing_page_ctr`),\r\n\t\t\t\t KEY `sort_landing_page_leads` (`sort_landing_page_leads`),\r\n\t\t\t\t KEY `sort_landing_page_su_ratio` (`sort_landing_page_su_ratio`),\r\n\t\t\t\t KEY `sort_landing_page_payout` (`sort_landing_page_payout`),\r\n\t\t\t\t KEY `sort_landing_page_epc` (`sort_landing_page_epc`),\r\n\t\t\t\t KEY `sort_landing_page_avg_cpc` (`sort_landing_page_avg_cpc`),\r\n\t\t\t\t KEY `sort_landing_page_income` (`sort_landing_page_income`),\r\n\t\t\t\t KEY `sort_landing_page_cost` (`sort_landing_page_cost`),\r\n\t\t\t\t KEY `sort_landing_page_net` (`sort_landing_page_net`),\r\n\t\t\t\t KEY `sort_landing_page_roi` (`sort_landing_page_roi`)\r\n\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;";
$result = _mysql_query($sql);
//this is now up to 1.0.3
$sql = "INSERT INTO 202_version SET version='1.0.3'";
$result = _mysql_query($sql);
//now set the new mysql version
$mysql_version = '1.0.3';
}
//upgrade from 1.0.3 to 1.0.4
if ($mysql_version == '1.0.3') {
$sql = "UPDATE 202_version SET version='1.0.4'";
$result = _mysql_query($sql);
$mysql_version = '1.0.4';
}
//upgrade from 1.0.4 to 1.0.5
if ($mysql_version == '1.0.4') {
$sql = "UPDATE 202_version SET version='1.0.5'";
$result = _mysql_query($sql);
$mysql_version = '1.0.5';
}
//upgrade from 1.0.5 to 1.0.6
if ($mysql_version == '1.0.5') {
$sql = "UPDATE 202_version SET version='1.0.6'";
$result = _mysql_query($sql);
$mysql_version = '1.0.6';
}
//upgrade from 1.0.6 to 1.1.0 - here we had some database modifications to make it scale better.
if ($mysql_version == '1.0.6') {
//this is upgrading things to BIGINT
$result = _mysql_query("ALTER TABLE `202_clicks` \t\t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL");
$result = _mysql_query("ALTER TABLE `202_clicks_advance` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL , \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL");
$result = _mysql_query(" ALTER TABLE `202_clicks_counter` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysql_query(" ALTER TABLE `202_clicks_record` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_clicks_site` \t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_referer_site_url_id` `click_referer_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_landing_site_url_id` `click_landing_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_outbound_site_url_id` `click_outbound_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_cloaking_site_url_id` `click_cloaking_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_redirect_site_url_id` `click_redirect_site_url_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_clicks_spy` \t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_ips` \t\t\tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysql_query(" ALTER TABLE `202_keywords` \t\tCHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysql_query(" ALTER TABLE `202_last_ips` \t\tCHANGE `ip_id` `ip_id` BIGINT NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_mysql_errors` \tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `site_id` `site_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_site_domains` \tCHANGE `site_domain_id` `site_domain_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysql_query(" ALTER TABLE `202_site_urls` \t\tCHANGE `site_url_id` `site_url_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `site_domain_id` `site_domain_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_sort_ips` CHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_sort_keywords` CHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_sort_referers` CHANGE `referer_id` `referer_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysql_query(" ALTER TABLE `202_users` CHANGE `user_last_login_ip_id` `user_last_login_ip_id` BIGINT UNSIGNED NOT NULL ");
//mysql version set to 1.1.0 now
$sql = "UPDATE 202_version SET version='1.1.0'";
$result = _mysql_query($sql);
$mysql_version = '1.1.0';
}
//upgrade from 1.1.0 to 1.1.1
if ($mysql_version == '1.1.0') {
$sql = "UPDATE 202_version SET version='1.1.1'";
$result = _mysql_query($sql);
$mysql_version = '1.1.1';
}
//upgrade from 1.1.1 to 1.1.2
if ($mysql_version == '1.1.1') {
$sql = "UPDATE 202_version SET version='1.1.2'";
$result = _mysql_query($sql);
$mysql_version = '1.1.2';
}
//upgrade from 1.1.2 to 1.2.0
if ($mysql_version == '1.1.2') {
$result = _mysql_query("\t CREATE TABLE IF NOT EXISTS `202_rotations` (\r\n\t\t\t\t\t\t\t\t\t\t `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `rotation_num` tinyint(4) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`aff_campaign_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MEMORY DEFAULT CHARSET=latin1; ");
$result = _mysql_query("\tINSERT INTO 202_browsers SET browser_id = '9', browser_name = 'Chrome'");
$result = _mysql_query("\tINSERT INTO 202_browsers SET browser_id = '10', browser_name = 'Mobile'");
$result = _mysql_query("\tINSERT INTO 202_browsers SET browser_id = '11', browser_name = 'Console'");
$result = _mysql_query(" \tALTER TABLE `202_clicks` CHANGE `click_cpc` `click_cpc` DECIMAL( 7, 5 ) NOT NULL ");
$result = _mysql_query(" \tALTER TABLE `202_trackers` CHANGE `click_cpc` `click_cpc` DECIMAL( 7, 5 ) NOT NULL ");
$result = _mysql_query(" \tALTER TABLE `202_users_pref` ADD `user_cpc_or_cpv` CHAR( 3 ) NOT NULL DEFAULT 'cpc' AFTER `user_pref_chart` ; ");
$result = _mysql_query(" \tALTER TABLE `202_users_pref` ADD `user_keyword_searched_or_bidded` VARCHAR( 255 ) NOT NULL DEFAULT 'searched' AFTER `user_cpc_or_cpv` ; ");
$result = _mysql_query(" \tALTER TABLE `202_aff_campaigns` ADD `aff_campaign_url_2` TEXT NOT NULL AFTER `aff_campaign_url` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_3` TEXT NOT NULL AFTER `aff_campaign_url_2` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_4` TEXT NOT NULL AFTER `aff_campaign_url_3` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_5` TEXT NOT NULL AFTER `aff_campaign_url_4` ;");
$result = _mysql_query(" \tALTER TABLE `202_aff_campaigns` CHANGE `aff_campaign_url` `aff_campaign_url` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL");
$result = _mysql_query(" \tALTER TABLE `202_aff_campaigns` ADD `aff_campaign_rotate` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `aff_campaign_time` ;");
$result = _mysql_query(" \tALTER TABLE`202_sort_breakdowns` CHANGE `sort_breakdown_avg_cpc` `sort_breakdown_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_breakdown_cost` `sort_breakdown_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_breakdown_net` `sort_breakdown_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysql_query(" \tALTER TABLE`202_sort_ips` CHANGE `sort_ip_avg_cpc` `sort_ip_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_ip_cost` `sort_ip_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_ip_net` `sort_ip_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysql_query(" \tALTER TABLE`202_sort_keywords` CHANGE `sort_keyword_avg_cpc` `sort_keyword_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_keyword_cost` `sort_keyword_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_keyword_net` `sort_keyword_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysql_query(" ALTER TABLE`202_sort_landing_pages` CHANGE `sort_landing_page_avg_cpc` `sort_landing_page_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_landing_page_cost` `sort_landing_page_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_landing_page_net` `sort_landing_page_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysql_query(" \tALTER TABLE`202_sort_referers` CHANGE `sort_referer_avg_cpc` `sort_referer_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_referer_cost` `sort_referer_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_referer_net` `sort_referer_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysql_query(" \tALTER TABLE`202_sort_text_ads` CHANGE `sort_text_ad_avg_cpc` `sort_text_ad_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_text_ad_cost` `sort_text_ad_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_text_ad_net` `sort_text_ad_net` DECIMAL( 13, 5 ) NOT NULL; ");
$sql = "UPDATE 202_version SET version='1.2.0'";
$result = _mysql_query($sql);
$mysql_version = '1.2.0';
}
//upgrade from 1.2.0 to 1,2,1
if ($mysql_version == '1.2.0') {
$sql = "UPDATE 202_version SET version='1.2.1'";
$result = _mysql_query($sql);
$mysql_version = '1.2.1';
}
//upgrade from 1.2.1 to 1.3.0
if ($mysql_version == '1.2.1') {
$result = _mysql_query(" \tALTER TABLE `202_users` ADD `user_api_key` VARCHAR( 255 ) NOT NULL AFTER `user_pass_time` ; ");
$result = _mysql_query(" \tALTER TABLE `202_users` ADD `user_stats202_app_key` VARCHAR( 255 ) NOT NULL AFTER `user_api_key` ; ");
$sql = "UPDATE 202_version SET version='1.3.0'";
$result = _mysql_query($sql);
$mysql_version = '1.3.0';
}
//upgrade from 1.3.0 to 1.3.1
if ($mysql_version == '1.3.0') {
$result = _mysql_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysql_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.3.1'; ";
$result = _mysql_query($sql);
$mysql_version = '1.3.1';
}
//upgrade from 1.3.1 to 1.3.2
if ($mysql_version == '1.3.1') {
$result = _mysql_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysql_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.3.2'; ";
$result = _mysql_query($sql);
$mysql_version = '1.3.2';
}
//upgrade from 1.3.2 to 1.4
if ($mysql_version == '1.3.2') {
$result = _mysql_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_tracking_domain` varchar(255) NOT NULL DEFAULT '';");
$result = _mysql_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_1` tinyint(3);");
$result = _mysql_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_2` tinyint(3);");
$result = _mysql_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_3` tinyint(3);");
$result = _mysql_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_4` tinyint(3);");
$result = _mysql_query("\tUPDATE 202_aff_campaigns SET aff_campaign_url=CONCAT(aff_campaign_url,'[[subid]]') ");
$result = _mysql_query(" \tCREATE TABLE `202_clicks_tracking` (\r\n\t\t\t\t\t\t\t\t\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c1` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c2` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c3` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c4` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`click_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1; ");
$sql = "UPDATE 202_version SET version='1.4'; ";
$result = _mysql_query($sql);
$mysql_version = '1.4';
}
//upgrade from 1.4 to 1.4.1
if ($mysql_version == '1.4') {
$result = _mysql_query(" \tCREATE TABLE `202_tracking_c1` (\r\n\t\t\t\t\t\t\t\t\t\t `c1_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c1` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c1_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c1` (`c1`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; ");
$result = _mysql_query(" \tCREATE TABLE `202_tracking_c2` (\r\n\t\t\t\t\t\t\t\t\t\t `c2_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c2` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c2_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c2` (`c2`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; ");
$result = _mysql_query(" \tCREATE TABLE `202_tracking_c3` (\r\n\t\t\t\t\t\t\t\t\t\t `c3_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c3` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c3_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c3` (`c3`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; ");
$result = _mysql_query(" \tCREATE TABLE `202_tracking_c4` (\r\n\t\t\t\t\t\t\t\t\t\t `c4_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c4` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c4_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c4` (`c4`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; ");
$sql = "UPDATE 202_version SET version='1.4.1'; ";
$result = _mysql_query($sql);
$mysql_version = '1.4.1';
}
//upgrade from 1.4.1 to 1.4.2
if ($mysql_version == '1.4.1') {
$result = _mysql_query(" \t DROP TABLE `202_clicks_tracking`; ");
$result = _mysql_query(" \t CREATE TABLE `202_clicks_tracking` (\r\n\t\t\t\t\t\t\t\t\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c1_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c2_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c3_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c4_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`click_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1; ");
$sql = "UPDATE 202_version SET version='1.4.2'; ";
$result = _mysql_query($sql);
$mysql_version = '1.4.2';
}
//upgrade from 1.4.2 to 1.4.3
if ($mysql_version == '1.4.2') {
$result = _mysql_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysql_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.4.3'; ";
$result = _mysql_query($sql);
$mysql_version = '1.4.3';
}
//upgrade from 1.4.3 to 1.5
if ($mysql_version == '1.4.3') {
$sql = "UPDATE 202_version SET version='1.5'; ";
$result = _mysql_query($sql);
$mysql_version = '1.5';
}
//upgrade from 1.5 to 1.5.1
if ($mysql_version == '1.5') {
$sql = "UPDATE 202_version SET version='1.5.1'; ";
$result = _mysql_query($sql);
$mysql_version = '1.5.1';
}
return true;
}
<small>You are upgrading from version <span class="label label-primary"><?php
echo PROSPER202::mysql_version();
?>
</span> to <span class="label label-primary"><?php
echo $version;
?>
</span>. To continue with the upgrade press the button below to begin the update process. This could take a while depending on the last time you updated your software.</small>
<div class="row">
<div class="col-xs-12">
<br/>
<small>Changelogs:</small>
<div class="panel-group" id="changelog_accordion" style="margin-top:10px;">
<?php
$change_logs = changelog();
foreach ($change_logs as $logs) {
if (version_compare(PROSPER202::mysql_version(), $logs['version'], '<')) {
?>
<div class="panel panel-default">
<div class="panel-heading">
<a data-toggle="collapse" data-parent="#changelog_accordion" href="#release_<?php
echo str_replace('.', '', $logs['version']);
?>
">
<h4 class="panel-title">
v<?php
echo $logs['version'];
?>
</h4>
</a>
</div>
<div id="release_<?php
function upgrade_databases()
{
ini_set('max_execution_time', 60 * 10);
ini_set('max_input_time', 60 * 10);
//get the old version
$mysql_version = PROSPER202::mysql_version();
$php_version = PROSPER202::php_version();
//if the mysql is 1.0.2, upgrade to 1.0.3
if ($mysql_version == '1.0.2') {
//create the new mysql version table
$sql = "CREATE TABLE IF NOT EXISTS `202_version` (\r\n\t\t\t\t\t `version` varchar(50) NOT NULL\r\n\t\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//drop the old table
$sql = "DROP TABLE `202_sort_landings`";
$result = _mysqli_query($sql);
//create the new landing page sorting table
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_landing_pages` (\r\n\t\t\t\t `sort_landing_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `landing_page_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_click_throughs` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_ctr` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_payout` decimal(6,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_epc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_avg_cpc` decimal(5,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_income` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_cost` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_net` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_roi` decimal(10,2) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`sort_landing_id`),\r\n\t\t\t\t KEY `user_id` (`user_id`),\r\n\t\t\t\t KEY `landing_page_id` (`landing_page_id`),\r\n\t\t\t\t KEY `sort_landing_page_clicks` (`sort_landing_page_clicks`),\r\n\t\t\t\t KEY `sort_landing_page_click_throughs` (`sort_landing_page_click_throughs`),\r\n\t\t\t\t KEY `sort_landing_page_ctr` (`sort_landing_page_ctr`),\r\n\t\t\t\t KEY `sort_landing_page_leads` (`sort_landing_page_leads`),\r\n\t\t\t\t KEY `sort_landing_page_su_ratio` (`sort_landing_page_su_ratio`),\r\n\t\t\t\t KEY `sort_landing_page_payout` (`sort_landing_page_payout`),\r\n\t\t\t\t KEY `sort_landing_page_epc` (`sort_landing_page_epc`),\r\n\t\t\t\t KEY `sort_landing_page_avg_cpc` (`sort_landing_page_avg_cpc`),\r\n\t\t\t\t KEY `sort_landing_page_income` (`sort_landing_page_income`),\r\n\t\t\t\t KEY `sort_landing_page_cost` (`sort_landing_page_cost`),\r\n\t\t\t\t KEY `sort_landing_page_net` (`sort_landing_page_net`),\r\n\t\t\t\t KEY `sort_landing_page_roi` (`sort_landing_page_roi`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//this is now up to 1.0.3
$sql = "INSERT INTO 202_version SET version='1.0.3'";
$result = _mysqli_query($sql);
//now set the new mysql version
$mysql_version = '1.0.3';
}
//upgrade from 1.0.3 to 1.0.4
if ($mysql_version == '1.0.3') {
$sql = "UPDATE 202_version SET version='1.0.4'";
$result = _mysqli_query($sql);
$mysql_version = '1.0.4';
}
//upgrade from 1.0.4 to 1.0.5
if ($mysql_version == '1.0.4') {
$sql = "UPDATE 202_version SET version='1.0.5'";
$result = _mysqli_query($sql);
$mysql_version = '1.0.5';
}
//upgrade from 1.0.5 to 1.0.6
if ($mysql_version == '1.0.5') {
$sql = "UPDATE 202_version SET version='1.0.6'";
$result = _mysqli_query($sql);
$mysql_version = '1.0.6';
}
//upgrade from 1.0.6 to 1.1.0 - here we had some database modifications to make it scale better.
if ($mysql_version == '1.0.6') {
//this is upgrading things to BIGINT
$result = _mysqli_query("ALTER TABLE `202_clicks` \t\t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL");
$result = _mysqli_query("ALTER TABLE `202_clicks_advance` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL , \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL");
$result = _mysqli_query(" ALTER TABLE `202_clicks_counter` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_clicks_record` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_clicks_site` \t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_referer_site_url_id` `click_referer_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_landing_site_url_id` `click_landing_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_outbound_site_url_id` `click_outbound_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_cloaking_site_url_id` `click_cloaking_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_redirect_site_url_id` `click_redirect_site_url_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_clicks_spy` \t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_ips` \t\t\tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_keywords` \t\tCHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_last_ips` \t\tCHANGE `ip_id` `ip_id` BIGINT NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_mysql_errors` \tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `site_id` `site_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_site_domains` \tCHANGE `site_domain_id` `site_domain_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_site_urls` \t\tCHANGE `site_url_id` `site_url_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `site_domain_id` `site_domain_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_sort_ips` CHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_sort_keywords` CHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_sort_referers` CHANGE `referer_id` `referer_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_users` CHANGE `user_last_login_ip_id` `user_last_login_ip_id` BIGINT UNSIGNED NOT NULL ");
//mysql version set to 1.1.0 now
$sql = "UPDATE 202_version SET version='1.1.0'";
$result = _mysqli_query($sql);
$mysql_version = '1.1.0';
}
//upgrade from 1.1.0 to 1.1.1
if ($mysql_version == '1.1.0') {
$sql = "UPDATE 202_version SET version='1.1.1'";
$result = _mysqli_query($sql);
$mysql_version = '1.1.1';
}
//upgrade from 1.1.1 to 1.1.2
if ($mysql_version == '1.1.1') {
$sql = "UPDATE 202_version SET version='1.1.2'";
$result = _mysqli_query($sql);
$mysql_version = '1.1.2';
}
//upgrade from 1.1.2 to 1.2.0
if ($mysql_version == '1.1.2') {
$result = _mysqli_query("\t CREATE TABLE IF NOT EXISTS `202_rotations` (\r\n\t\t\t\t\t\t\t\t\t\t `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `rotation_num` tinyint(4) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`aff_campaign_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MEMORY ; ");
$result = _mysqli_query("\tINSERT INTO 202_browsers SET browser_id = '9', browser_name = 'Chrome'");
$result = _mysqli_query("\tINSERT INTO 202_browsers SET browser_id = '10', browser_name = 'Mobile'");
$result = _mysqli_query("\tINSERT INTO 202_browsers SET browser_id = '11', browser_name = 'Console'");
$result = _mysqli_query(" \tALTER TABLE `202_clicks` CHANGE `click_cpc` `click_cpc` DECIMAL( 7, 5 ) NOT NULL ");
$result = _mysqli_query(" \tALTER TABLE `202_trackers` CHANGE `click_cpc` `click_cpc` DECIMAL( 7, 5 ) NOT NULL ");
$result = _mysqli_query(" \tALTER TABLE `202_users_pref` ADD `user_cpc_or_cpv` CHAR( 3 ) NOT NULL DEFAULT 'cpc' AFTER `user_pref_chart` ; ");
$result = _mysqli_query(" \tALTER TABLE `202_users_pref` ADD `user_keyword_searched_or_bidded` VARCHAR( 255 ) NOT NULL DEFAULT 'searched' AFTER `user_cpc_or_cpv` ; ");
$result = _mysqli_query(" \tALTER TABLE `202_aff_campaigns` ADD `aff_campaign_url_2` TEXT NOT NULL AFTER `aff_campaign_url` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_3` TEXT NOT NULL AFTER `aff_campaign_url_2` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_4` TEXT NOT NULL AFTER `aff_campaign_url_3` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_5` TEXT NOT NULL AFTER `aff_campaign_url_4` ;");
$result = _mysqli_query(" \tALTER TABLE `202_aff_campaigns` CHANGE `aff_campaign_url` `aff_campaign_url` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL");
$result = _mysqli_query(" \tALTER TABLE `202_aff_campaigns` ADD `aff_campaign_rotate` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `aff_campaign_time` ;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_breakdowns` CHANGE `sort_breakdown_avg_cpc` `sort_breakdown_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_breakdown_cost` `sort_breakdown_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_breakdown_net` `sort_breakdown_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_ips` CHANGE `sort_ip_avg_cpc` `sort_ip_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_ip_cost` `sort_ip_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_ip_net` `sort_ip_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_keywords` CHANGE `sort_keyword_avg_cpc` `sort_keyword_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_keyword_cost` `sort_keyword_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_keyword_net` `sort_keyword_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" ALTER TABLE`202_sort_landing_pages` CHANGE `sort_landing_page_avg_cpc` `sort_landing_page_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_landing_page_cost` `sort_landing_page_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_landing_page_net` `sort_landing_page_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_referers` CHANGE `sort_referer_avg_cpc` `sort_referer_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_referer_cost` `sort_referer_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_referer_net` `sort_referer_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_text_ads` CHANGE `sort_text_ad_avg_cpc` `sort_text_ad_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_text_ad_cost` `sort_text_ad_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_text_ad_net` `sort_text_ad_net` DECIMAL( 13, 5 ) NOT NULL; ");
$sql = "UPDATE 202_version SET version='1.2.0'";
$result = _mysqli_query($sql);
$mysql_version = '1.2.0';
}
//upgrade from 1.2.0 to 1,2,1
if ($mysql_version == '1.2.0') {
$sql = "UPDATE 202_version SET version='1.2.1'";
$result = _mysqli_query($sql);
$mysql_version = '1.2.1';
}
//upgrade from 1.2.1 to 1.3.0
if ($mysql_version == '1.2.1') {
$result = _mysqli_query(" \tALTER TABLE `202_users` ADD `user_api_key` VARCHAR( 255 ) NOT NULL AFTER `user_pass_time` ; ");
$result = _mysqli_query(" \tALTER TABLE `202_users` ADD `user_stats202_app_key` VARCHAR( 255 ) NOT NULL AFTER `user_api_key` ; ");
$sql = "UPDATE 202_version SET version='1.3.0'";
$result = _mysqli_query($sql);
$mysql_version = '1.3.0';
}
//upgrade from 1.3.0 to 1.3.1
if ($mysql_version == '1.3.0') {
$result = _mysqli_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysqli_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.3.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.3.1';
}
//upgrade from 1.3.1 to 1.3.2
if ($mysql_version == '1.3.1') {
$result = _mysqli_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysqli_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.3.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.3.2';
}
//upgrade from 1.3.2 to 1.4
if ($mysql_version == '1.3.2') {
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_tracking_domain` varchar(255) NOT NULL DEFAULT '';");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_1` tinyint(3);");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_2` tinyint(3);");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_3` tinyint(3);");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_4` tinyint(3);");
$result = _mysqli_query("\tUPDATE 202_aff_campaigns SET aff_campaign_url=CONCAT(aff_campaign_url,'[[subid]]') ");
$result = _mysqli_query(" \tCREATE TABLE `202_clicks_tracking` (\r\n\t\t\t\t\t\t\t\t\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c1` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c2` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c3` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c4` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`click_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB ; ");
$sql = "UPDATE 202_version SET version='1.4'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4';
}
//upgrade from 1.4 to 1.4.1
if ($mysql_version == '1.4') {
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c1` (\r\n\t\t\t\t\t\t\t\t\t\t `c1_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c1` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c1_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c1` (`c1`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c2` (\r\n\t\t\t\t\t\t\t\t\t\t `c2_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c2` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c2_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c2` (`c2`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c3` (\r\n\t\t\t\t\t\t\t\t\t\t `c3_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c3` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c3_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c3` (`c3`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c4` (\r\n\t\t\t\t\t\t\t\t\t\t `c4_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c4` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c4_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c4` (`c4`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$sql = "UPDATE 202_version SET version='1.4.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4.1';
}
//upgrade from 1.4.1 to 1.4.2
if ($mysql_version == '1.4.1') {
$result = _mysqli_query(" \t DROP TABLE `202_clicks_tracking`; ");
$result = _mysqli_query(" \t CREATE TABLE `202_clicks_tracking` (\r\n\t\t\t\t\t\t\t\t\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c1_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c2_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c3_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c4_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`click_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB ; ");
$sql = "UPDATE 202_version SET version='1.4.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4.2';
}
//upgrade from 1.4.2 to 1.4.3
if ($mysql_version == '1.4.2') {
$result = _mysqli_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysqli_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.4.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4.3';
}
//upgrade from 1.4.3 to 1.5
if ($mysql_version == '1.4.3') {
$sql = "UPDATE 202_version SET version='1.5'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.5';
}
//upgrade from 1.5 to 1.5.1
if ($mysql_version == '1.5') {
$sql = "UPDATE 202_version SET version='1.5.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.5.1';
}
//upgrade from 1.5.1 to 1.6
if ($mysql_version == '1.5.1') {
$result = _mysqli_query("CREATE TABLE IF NOT EXISTS `202_alerts` (\r\n\t\t\t `prosper_alert_id` int(11) NOT NULL,\r\n\t\t\t `prosper_alert_seen` tinyint(1) NOT NULL,\r\n\t\t\t UNIQUE KEY `prosper_alert_id` (`prosper_alert_id`)\r\n\t\t\t) ENGINE=InnoDB ;");
$result = _mysqli_query("CREATE TABLE IF NOT EXISTS `202_offers` (\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `offer_id` mediumint(10) unsigned NOT NULL,\r\n\t\t\t\t `offer_seen` tinyint(1) NOT NULL DEFAULT '1',\r\n\t\t\t\t UNIQUE KEY `user_id` (`user_id`,`offer_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;");
$result = _mysqli_query("ALTER TABLE `202_cronjobs` ENGINE = MYISAM;");
$sql = "UPDATE 202_version SET version='1.6'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.6';
}
//upgrade from 1.6 beta to 1.6.1 stable
if ($mysql_version == '1.6') {
$sql = "UPDATE 202_version SET version='1.6.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.6.1';
}
//upgrade from 1.6.1 to 1.6.2 beta
if ($mysql_version == '1.6.1') {
$sql = "UPDATE 202_version SET version='1.6.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.6.2';
}
//upgrade from 1.6.2 to 1.7 beta
if ($mysql_version == '1.6.2') {
$sql = "UPDATE 202_version SET version='1.7'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7';
$sql = "CREATE TABLE IF NOT EXISTS `202_pixel_types` (\r\n \t\t\t `pixel_type_id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT ,\r\n \t\t \t `pixel_type` VARCHAR(45) NULL ,\r\n \t\t\t PRIMARY KEY (`pixel_type_id`) ,\r\n \t\t UNIQUE INDEX `pixel_type_UNIQUE` (`pixel_type` ASC) \r\n \t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_ppc_account_pixels` (\r\n \t\t\t `pixel_id` mediumint(8) unsigned NOT NULL auto_increment,\r\n \t\t\t `pixel_code` text NOT NULL,\r\n \t\t\t `pixel_type_id` mediumint(8) unsigned NOT NULL,\r\n \t\t\t `ppc_account_id` mediumint(8) unsigned NOT NULL,\r\n \t\t\t PRIMARY KEY (`pixel_id`)\r\n \t\t\t ) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_clicks_total` (\r\n\t\t\t `click_count` int(20) unsigned NOT NULL default '0',\r\n \t\t\t PRIMARY KEY (`click_count`)\r\n\t\t\t ) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "INSERT IGNORE INTO `202_pixel_types` (`pixel_type`) VALUES \r\n\t\t\t ('Image'),\r\n\t\t\t ('Iframe'),\r\n\t\t\t ('Javascript'),\r\n\t\t\t ('Postback')";
$result = _mysqli_query($sql);
$sql = "INSERT IGNORE INTO `202_platforms` (`platform_name`) VALUES \r\n\t\t\t ('Mobile'),\r\n\t\t\t ('Tablet');";
$result = _mysqli_query($sql);
$sql = "INSERT IGNORE INTO `202_clicks_total` (`click_count`) VALUES\r\n\t\t(0);";
$result = _mysqli_query($sql);
}
//upgrade from 1.7 beta to 1.7.1 beta
if ($mysql_version == '1.7') {
$sql = "UPDATE 202_version SET version='1.7.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.1';
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_keywords_lpctr` (\r\n \t\t\t `sort_keyword_id` int(10) unsigned NOT NULL auto_increment,\r\n \t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n \t\t\t `keyword_id` bigint(20) unsigned NOT NULL,\r\n \t\t\t `sort_keyword_clicks` mediumint(8) unsigned NOT NULL,\r\n \t\t\t `sort_keyword_click_throughs` mediumint(8) unsigned NOT NULL,\r\n\t\t `sort_keyword_ctr` decimal(10,2) NOT NULL, \r\n \t\t `sort_keyword_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_keyword_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_keyword_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_keyword_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_keyword_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_keyword_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_keyword_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_keyword_net` decimal(13,5) NOT NULL,\r\n \t\t\t `sort_keyword_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_keyword_id`),\r\n\t\t\t KEY `user_id` (`user_id`),\r\n\t\t\t KEY `keyword_id` (`keyword_id`),\r\n\t\t\t KEY `sort_keyword_clicks` (`sort_keyword_clicks`)\r\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_text_ads_lpctr` (\r\n `sort_text_ad_id` int(10) unsigned NOT NULL auto_increment,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `text_ad_id` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_clicks` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_click_throughs` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_ctr` decimal(10,2) NOT NULL, \r\n `sort_text_ad_leads` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_su_ratio` decimal(10,2) NOT NULL,\r\n `sort_text_ad_payout` decimal(6,2) NOT NULL,\r\n `sort_text_ad_epc` decimal(10,2) NOT NULL,\r\n `sort_text_ad_avg_cpc` decimal(7,5) NOT NULL,\r\n `sort_text_ad_income` decimal(10,2) NOT NULL,\r\n `sort_text_ad_cost` decimal(13,5) NOT NULL,\r\n `sort_text_ad_net` decimal(13,5) NOT NULL,\r\n `sort_text_ad_roi` decimal(10,2) NOT NULL,\r\n PRIMARY KEY (`sort_text_ad_id`),\r\n KEY `user_id` (`user_id`),\r\n KEY `keyword_id` (`text_ad_id`),\r\n KEY `sort_keyword_clicks` (`sort_text_ad_clicks`),\r\n KEY `sort_keyword_leads` (`sort_text_ad_leads`),\r\n KEY `sort_keyword_signup_ratio` (`sort_text_ad_su_ratio`),\r\n KEY `sort_keyword_payout` (`sort_text_ad_payout`),\r\n KEY `sort_keyword_epc` (`sort_text_ad_epc`),\r\n KEY `sort_keyword_cpc` (`sort_text_ad_avg_cpc`),\r\n KEY `sort_keyword_income` (`sort_text_ad_income`),\r\n KEY `sort_keyword_cost` (`sort_text_ad_cost`),\r\n KEY `sort_keyword_net` (`sort_text_ad_net`),\r\n KEY `sort_keyword_roi` (`sort_text_ad_roi`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=1 ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_referers_lpctr` (\r\n `sort_referer_id` int(10) unsigned NOT NULL auto_increment,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `referer_id` bigint(20) unsigned NOT NULL,\r\n `sort_referer_clicks` mediumint(8) unsigned NOT NULL,\r\n `sort_referer_click_throughs` mediumint(8) unsigned NOT NULL,\r\n `sort_referer_ctr` decimal(10,2) NOT NULL,\r\n `sort_referer_leads` mediumint(8) unsigned NOT NULL,\r\n `sort_referer_su_ratio` decimal(10,2) NOT NULL,\r\n `sort_referer_payout` decimal(6,2) NOT NULL,\r\n `sort_referer_epc` decimal(10,2) NOT NULL,\r\n `sort_referer_avg_cpc` decimal(7,5) NOT NULL,\r\n `sort_referer_income` decimal(10,2) NOT NULL,\r\n `sort_referer_cost` decimal(13,5) NOT NULL,\r\n `sort_referer_net` decimal(13,5) NOT NULL,\r\n `sort_referer_roi` decimal(10,2) NOT NULL,\r\n PRIMARY KEY (`sort_referer_id`),\r\n KEY `user_id` (`user_id`),\r\n KEY `keyword_id` (`referer_id`),\r\n KEY `sort_keyword_clicks` (`sort_referer_clicks`),\r\n KEY `sort_keyword_leads` (`sort_referer_leads`),\r\n KEY `sort_keyword_signup_ratio` (`sort_referer_su_ratio`),\r\n KEY `sort_keyword_payout` (`sort_referer_payout`),\r\n KEY `sort_keyword_epc` (`sort_referer_epc`),\r\n KEY `sort_keyword_cpc` (`sort_referer_avg_cpc`),\r\n KEY `sort_keyword_income` (`sort_referer_income`),\r\n KEY `sort_keyword_cost` (`sort_referer_cost`),\r\n KEY `sort_keyword_net` (`sort_referer_net`),\r\n KEY `sort_keyword_roi` (`sort_referer_roi`)\r\n) ENGINE=InnoDB;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c1` CHANGE COLUMN `c1` `c1` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c2` CHANGE COLUMN `c2` `c2` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c3` CHANGE COLUMN `c3` `c3` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c4` CHANGE COLUMN `c4` `c4` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.1 to 1.7.2 beta
if ($mysql_version == '1.7.1') {
$sql = "UPDATE 202_version SET version='1.7.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.2';
}
//upgrade from 1.7.2 to 1.7.3
if ($mysql_version == '1.7.2') {
$sql = "UPDATE 202_version SET version='1.7.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.3';
$sql = "ALTER TABLE `202_users` MODIFY COLUMN `user_timezone` VARCHAR(50) NOT NULL default 'Pacific/Pitcairn';";
$result = _mysqli_query($sql);
$sql = "UPDATE `202_users` SET user_timezone='Pacific/Pitcairn' WHERE user_id=1";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_sort_breakdowns`" . " ADD `sort_breakdown_click_throughs` mediumint(8) unsigned NOT NULL AFTER `sort_breakdown_clicks`," . " ADD `sort_breakdown_ctr` decimal(10,2) NOT NULL AFTER `sort_breakdown_click_throughs`," . " ADD KEY `sort_breakdown_click_throughs` (`sort_breakdown_click_throughs`)," . " ADD KEY `sort_breakdown_ctr` (`sort_breakdown_ctr`)";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_spy` ADD INDEX (`click_id`)";
$result = _mysqli_query($sql);
$sql = "INSERT INTO `202_pixel_types` (`pixel_type`) VALUES ('Raw')";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `cache_time` VARCHAR(4) NOT NULL default '0';";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.3 to 1.7.4
if ($mysql_version == '1.7.3') {
$sql = "UPDATE 202_version SET version='1.7.4'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.4';
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `cb_key` VARCHAR(250) NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `cb_verified` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.4 to 1.7.5
if ($mysql_version == '1.7.4') {
$sql = "UPDATE 202_version SET version='1.7.5'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.5';
}
//upgrade from 1.7.5 to 1.7.6
if ($mysql_version == '1.7.5') {
$sql = "UPDATE 202_version SET version='1.7.6'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.6';
$sql = "ALTER TABLE `202_users` ADD COLUMN `clickserver_api_key` VARCHAR(250) NOT NULL;";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.6 to 1.8.0
if ($mysql_version == '1.7.6') {
$sql = "UPDATE 202_version SET version='1.8.0'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.0';
}
//upgrade from 1.8.0 to 1.8.1
if ($mysql_version == '1.8.0') {
$sql = "UPDATE 202_version SET version='1.8.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.1';
}
//upgrade from 1.8.1 to 1.8.2
if ($mysql_version == '1.8.1') {
$sql = "UPDATE 202_version SET version='1.8.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.2';
}
//upgrade from 1.8.2 to 1.8.2.1
if ($mysql_version == '1.8.2') {
$sql = "DROP TABLE IF EXISTS 202_locations";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_country";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_city";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_block";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_coordinates";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_region";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `country_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `city_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_locations_city` (\r\n\t\t\t\t `city_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `main_country_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `city_name` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t\t PRIMARY KEY (`city_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_locations_country` (\r\n\t\t\t\t `country_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `country_code` varchar(3) NOT NULL DEFAULT '',\r\n\t\t\t\t `country_name` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t\t PRIMARY KEY (`country_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_cities` (\r\n\t\t\t `sort_city_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `city_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `country_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_city_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_city_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_city_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_city_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_city_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_city_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_city_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_city_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_city_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_city_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_city_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_countries` (\r\n\t\t\t\t `sort_country_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `country_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t `sort_country_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_country_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_country_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_country_payout` decimal(6,2) NOT NULL,\r\n\t\t\t\t `sort_country_epc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_country_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t\t `sort_country_income` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_country_cost` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_country_net` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_country_roi` decimal(10,2) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`sort_country_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_locations_isp` (\r\n\t\t\t\t `isp_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `isp_name` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t\t PRIMARY KEY (`isp_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_isps` (\r\n\t\t\t\t `sort_isp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `isp_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t `sort_isp_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_isp_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_isp_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_isp_payout` decimal(6,2) NOT NULL,\r\n\t\t\t\t `sort_isp_epc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_isp_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t\t `sort_isp_income` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_isp_cost` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_isp_net` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_isp_roi` decimal(10,2) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`sort_isp_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `isp_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `maxmind_isp` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_isp_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_device_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_browser_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_platform_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_api_keys` (\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `api_key` varchar(250) NOT NULL DEFAULT '',\r\n\t\t\t\t `created_at` int(10) NOT NULL\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "TRUNCATE TABLE 202_browsers;";
$result = _mysqli_query($sql);
$sql = "TRUNCATE TABLE 202_platforms;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_device_types` (\r\n\t\t\t `type_id` tinyint(1) unsigned NOT NULL,\r\n\t\t\t `type_name` varchar(50) NOT NULL,\r\n\t\t\t PRIMARY KEY (`type_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "INSERT INTO `202_device_types` (`type_id`, `type_name`)\r\n\t\t\t\tVALUES\r\n\t\t\t\t\t(1, 'Desktop'),\r\n\t\t\t\t\t(2, 'Mobile'),\r\n\t\t\t\t\t(3, 'Tablet'),\r\n\t\t\t\t\t(4, 'Bot');";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_device_models` (\r\n\t\t\t `device_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `device_name` varchar(50) NOT NULL,\r\n\t\t\t `device_type` tinyint(1) NOT NULL,\r\n\t\t\t PRIMARY KEY (`device_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `device_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks` ADD COLUMN `click_bot` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_spy` ADD COLUMN `click_bot` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_devices` (\r\n\t\t\t `sort_device_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `device_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_device_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_device_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_device_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_device_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_device_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_device_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_device_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_device_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_device_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_device_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_device_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_browsers` (\r\n\t\t\t `sort_browser_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `browser_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_browser_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_browser_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_browser_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_browser_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_browser_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_browser_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_browser_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_browser_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_browser_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_browser_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_browser_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_platforms` (\r\n\t\t\t `sort_platform_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `platform_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_platform_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_platform_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_platform_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_platform_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_platform_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_platform_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_platform_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_platform_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_platform_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_platform_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_platform_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users` ADD COLUMN `install_hash` varchar(255) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t ADD COLUMN `user_hash` varchar(255) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t ADD COLUMN `modal_status` int(1) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t ADD COLUMN `vip_perks_status` int(1) NOT NULL;";
$result = _mysqli_query($sql);
$hash = md5(uniqid(rand(), TRUE));
$user_hash = intercomHash($hash);
$sql = "UPDATE 202_users SET install_hash='" . $hash . "', user_hash='" . $user_hash . "' WHERE user_id='1'";
$result = _mysqli_query($sql);
$sql = "UPDATE 202_version SET version='1.8.2.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.2.1';
}
//upgrade from 1.8.2.1 to 1.8.2.2
if ($mysql_version == '1.8.2.1') {
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `region_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_locations_region` (\r\n\t\t\t\t `region_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `main_country_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `region_name` varchar(50) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`region_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_regions` (\r\n\t\t\t `sort_regions_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `region_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `country_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_region_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_region_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_region_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_region_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_region_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_region_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_region_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_region_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_region_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_region_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_regions_id`)\r\n\t\t\t) ENGINE=InnoDB;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_region_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "UPDATE 202_version SET version='1.8.2.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.2.2';
}
//upgrade from 1.8.2.2 to 1.8.3
if ($mysql_version == '1.8.2.2') {
$sql = "CREATE TABLE IF NOT EXISTS `202_rotators` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` int(11) NOT NULL,\r\n\t\t\t `tracker_id` int(11) NOT NULL,\r\n\t\t\t `name` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t `default_url` text NOT NULL,\r\n\t\t\t `redirect_url` text NOT NULL,\r\n\t\t\t `redirect_campaign` int(11) DEFAULT NULL,\r\n \t\t\t `default_campaign` int(11) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_rotator_rules` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `rotator_id` int(11) NOT NULL,\r\n\t\t\t `type` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `statement` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `value` text NOT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_rotator_clicks` (\r\n\t\t\t `click_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `rotator_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `click_time` int(10) unsigned NOT NULL,\r\n\t\t\t `redirects` int(1) unsigned NOT NULL,\r\n\t\t\t `defaults` int(1) unsigned NOT NULL,\r\n\t\t\t PRIMARY KEY (`click_id`),\r\n\t\t\t KEY `rotator_id` (`rotator_id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_rotators` (\r\n\t\t\t `sort_rotator_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `rotator_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_rotator_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_rotator_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_rotator_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_rotator_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_rotator_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_rotator_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_rotator_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_rotator_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_rotator_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_rotator_roi` decimal(10,2) NOT NULL,\r\n\t\t\t `type` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t PRIMARY KEY (`sort_rotator_id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks` ADD COLUMN `rotator_id` mediumint(0) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_sort_browsers, 202_sort_cities, 202_sort_countries, 202_sort_devices, 202_sort_ips, 202_sort_isps, 202_sort_keywords, 202_sort_keywords_lpctr, 202_sort_landing_pages, 202_sort_platforms, 202_sort_referers, 202_sort_referers_lpctr, 202_sort_regions, 202_sort_text_ads, 202_sort_text_ads_lpctr;";
$result = _mysqli_query($sql);
$sql = "UPDATE 202_version SET version='1.8.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3';
}
//upgrade from 1.8.3 to 1.8.3.1
if ($mysql_version == '1.8.3') {
$sql = "UPDATE 202_version SET version='1.8.3.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3.1';
}
//upgrade from 1.8.3.1 to 1.8.3.2
if ($mysql_version == '1.8.3.1') {
$sql = "UPDATE 202_version SET version='1.8.3.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3.2';
}
//upgrade from 1.8.3.2 to 1.8.3.3
if ($mysql_version == '1.8.3.2') {
$sql = "UPDATE 202_version SET version='1.8.3.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3.3';
}
//upgrade from 1.8.3.3 to 1.8.4
if ($mysql_version == '1.8.3.3') {
$sql = "ALTER TABLE `202_clicks` MODIFY `rotator_id` int(10) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks` ADD COLUMN `rule_id` int(10) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_trackers` ADD COLUMN `rotator_id` int(11) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_sort_rotators, 202_rotator_rules, 202_rotator_clicks, 202_rotators;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotators` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` int(11) NOT NULL,\r\n\t\t\t `name` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t `default_url` text,\r\n\t\t\t `default_campaign` int(11) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotator_rules` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `rotator_id` int(11) NOT NULL,\r\n\t\t\t `rule_name` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t `redirect_url` text,\r\n\t\t\t `redirect_campaign` int(11) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotator_rules_criteria` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `rotator_id` int(11) NOT NULL,\r\n\t\t\t `rule_id` int(11) NOT NULL,\r\n\t\t\t `type` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `statement` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `value` text NOT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements\r\n\t\t\tFROM information_schema.tables AS tb\r\n\t\t\tWHERE table_schema = '" . $dbname . "'\r\n\t\t\tAND `ENGINE` = 'MyISAM'\r\n\t\t\tAND `TABLE_TYPE` = 'BASE TABLE'\r\n\t\t\tORDER BY table_name DESC;";
$result = _mysqli_query($sql);
while ($row = $result->fetch_assoc()) {
$db->query($row['sql_statements']);
}
$sql = "UPDATE 202_version SET version='1.8.4'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.4';
}
//upgrade from 1.8.4 to 1.8.5
if ($mysql_version == '1.8.4') {
$sql = "UPDATE 202_version SET version='1.8.5'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.5';
}
//upgrade from 1.8.5 to 1.8.6
if ($mysql_version == '1.8.5') {
$sql = "UPDATE 202_version SET version='1.8.6'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.6';
}
//upgrade from 1.8.6 to 1.8.7
if ($mysql_version == '1.8.6') {
$sql = "UPDATE 202_version SET version='1.8.7'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.7';
}
//upgrade from 1.8.7 to 1.8.8
if ($mysql_version == '1.8.7') {
$sql = "UPDATE 202_version SET version='1.8.8'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.8';
}
//upgrade from 1.8.8 to 1.8.9
if ($mysql_version == '1.8.8') {
$sql = "UPDATE 202_version SET version='1.8.9'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.9';
}
//upgrade from 1.8.9 to 1.8.10
if ($mysql_version == '1.8.9') {
$sql = "UPDATE 202_version SET version='1.8.10'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.10';
}
//upgrade from 1.8.10 to 1.8.11
if ($mysql_version == '1.8.10') {
$sql = "UPDATE 202_version SET version='1.8.11'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.11';
}
//upgrade from 1.8.11 to 1.8.12
if ($mysql_version == '1.8.11') {
$sql = "ALTER TABLE 202_users_pref ADD COLUMN `user_daily_email` char(2) NOT NULL DEFAULT '07'";
$result = _mysqli_query($sql);
$sql = "SELECT user_timezone, install_hash, user_daily_email FROM 202_users LEFT JOIN 202_users_pref USING (user_id) WHERE user_id = 1";
$result = _mysqli_query($sql);
$row = $result->fetch_assoc();
registerDailyEmail($row['user_daily_email'], $row['user_timezone'], $row['install_hash']);
$sql = "UPDATE 202_version SET version='1.8.12'";
$result = _mysqli_query($sql);
$mysql_version = '1.8.12';
}
//upgrade from 1.8.12 to 1.8.13
if ($mysql_version == '1.8.12') {
$sql = "UPDATE 202_version SET version='1.8.13'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.13';
}
return true;
}
