if ($_POST['user_pass'] != $_POST['verify_user_pass']) {
$error['user_pass'] .= '<div class="error">Your passwords did not match, please try again</div>';
}
//if no error occured, lets create the user account
if (!$error) {
//no error, so now setup all of the mysql database structures
INSTALL::install_databases();
$mysql['user_email'] = $db->real_escape_string($_POST['user_email']);
$mysql['user_name'] = $db->real_escape_string($_POST['user_name']);
$mysql['user_timezone'] = $db->real_escape_string($_POST['user_timezone']);
$mysql['user_time_register'] = $db->real_escape_string(time());
//md5 the user pass with salt
$user_pass = salt_user_pass($_POST['user_pass']);
$mysql['user_pass'] = $db->real_escape_string($user_pass);
$hash = md5(uniqid(rand(), TRUE));
$user_hash = intercomHash($hash);
//insert this user
$user_sql = " \tINSERT INTO \t202_users\n\t\t\t\t\t \tSET\t\t\t\tuser_email='" . $mysql['user_email'] . "',\n\t\t\t\t\t \t\t \t\t\tuser_name='" . $mysql['user_name'] . "',\n\t\t\t\t\t \t\t\t\t\tuser_pass='******'user_pass'] . "',\n\t\t\t\t\t \t\t\t\t\tuser_timezone='" . $mysql['user_timezone'] . "',\n\t\t\t\t\t \t\t\t\t\tuser_time_register='" . $mysql['user_time_register'] . "',\n\t\t\t\t\t \t\t\t\t\tinstall_hash='" . $hash . "',\n\t\t\t\t\t \t\t\t\t\tuser_hash='" . $user_hash . "'";
$user_result = _mysqli_query($user_sql);
$user_id = $db->insert_id;
$mysql['user_id'] = $db->real_escape_string($user_id);
//update user preference table
$user_sql = "INSERT INTO 202_users_pref SET user_id='" . $mysql['user_id'] . "'";
$user_result = _mysqli_query($user_sql);
registerDailyEmail('07', $mysql['user_timezone'], $hash);
//if this worked, show them the succes screen
$success = true;
}
$html['user_email'] = htmlentities($_POST['user_email'], ENT_QUOTES, 'UTF-8');
$html['user_name'] = htmlentities($_POST['user_name'], ENT_QUOTES, 'UTF-8');
$html['user_pass'] = htmlentities($_POST['user_pass'], ENT_QUOTES, 'UTF-8');
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;
}
