$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'); } //only show install setup, if it, of course, isn't install already. if (!$success) { $mysqlversion = $db->server_info; $html['mysqlversion'] = htmlentities($mysqlversion, ENT_QUOTES, 'UTF-8'); $phpversion = phpversion(); if ($phpversion < 5.3) { $version_error['phpversion'] = 'Prosper202 requires PHP 5.3, or newer.'; }
break; } if (!$error) { $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $mysql['user_timezone'] = $db->real_escape_string($_POST['user_timezone']); $mysql['cache_time'] = $db->real_escape_string($_POST['user_cached_reports']); $mysql['user_keyword_searched_or_bidded'] = $db->real_escape_string($_POST['user_keyword_searched_or_bidded']); $mysql['user_tracking_domain'] = $db->real_escape_string($_POST['user_tracking_domain']); $mysql['user_daily_email'] = $db->real_escape_string($_POST['user_daily_email']); $user_sql = "\n\t\t\t\tUPDATE\n\t\t\t\t\t`202_users` \n\t\t\t\tSET\n\t\t\t\t\t`user_email`='" . $mysql['user_email'] . "',\n\t\t\t\t\t`user_timezone`='" . $mysql['user_timezone'] . "'\n\t\t\t\tWHERE\n\t\t\t\t\t`user_id`='" . $mysql['user_id'] . "'\n\t\t\t"; $user_result = $db->query($user_sql); $user_sql = "\n\t\t\t\tUPDATE\n\t\t\t\t\t`202_users_pref`\n\t\t\t\tSET\n\t\t\t\t\t`user_keyword_searched_or_bidded`='" . $mysql['user_keyword_searched_or_bidded'] . "',\n\t\t\t\t\t`user_tracking_domain`='" . $mysql['user_tracking_domain'] . "',\n\t\t\t\t\t`cache_time`='" . $mysql['cache_time'] . "',\n\t\t\t\t\t`user_daily_email`='" . $mysql['user_daily_email'] . "'\n\t\t\t\tWHERE\n\t\t\t\t\t`user_id`='" . $mysql['user_id'] . "'\n\t\t\t"; $user_result = $db->query($user_sql); $html['cache_time'] = $mysql['cache_time']; $update_profile = true; registerDailyEmail($mysql['user_daily_email'], $mysql['user_timezone'], $html['install_hash']); //set the session's user_timezone $_SESSION['user_timezone'] = $_POST['user_timezone']; } } if ($_POST['update_clickserver_api_key'] == '1') { if ($_POST['token'] != $_SESSION['token']) { $error['token'] = 'You must use our forms to submit data.'; } if (!preg_match('/\\*/', $_POST['clickserver_api_key'])) { if (!clickserver_api_key_validate($_POST['clickserver_api_key'])) { $error['clickserver_api_key'] = 'This API Key appears invalid.'; } if (!$error) { $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $mysql['clickserver_api_key'] = $db->real_escape_string($_POST['clickserver_api_key']);
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; }