<span class="infotext">Select rotator, to add new rule. You can add as many rules as you want, for each rotator.</span>
</div>
</div>
<form class="form-inline" onsubmit="return false;" role="form" id="rule_form" method="post" action="">
<div class="row" style="margin-top:15px;">
<div class="col-xs-4">
<div class="form-group">
<img id="rules_loading" class="loading" src="/202-img/loader-small.gif" style="display:none;right: -20px;top: 10px;"/>
<label for="rotator_id" style="margin-right:5px;">Select rotator: </label>
<select class="form-control input-sm" name="rotator_id" style="min-width: 130px;">
<option value="0">--</option>
<?php
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$rotator_sql = "SELECT * FROM `202_rotators` WHERE `user_id`='" . $mysql['user_id'] . "' ORDER BY `name` ASC";
$rotator_result = _mysqli_query($rotator_sql);
while ($rotator_row = $rotator_result->fetch_array(MYSQL_ASSOC)) {
$html['rotator_name'] = htmlentities($rotator_row['name'], ENT_QUOTES, 'UTF-8');
$html['rotator_id'] = htmlentities($rotator_row['id'], ENT_QUOTES, 'UTF-8');
printf('<option value="%s">%s</option>', $html['rotator_id'], $html['rotator_name']);
}
?>
</select>
</div>
</div>
<div id="defaults_container" style="opacity:0.5">
<div class="col-xs-4">
<label for="default_type" class="col-xs-5 control-label">Defaults to: </label>
<label class="radio radio-inline">
<input type="radio" name="default_type" id="default_type1" value="campaign" data-toggle="radio" disabled checked="">
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
//set the timezone for the user, for entering their dates.
AUTH::set_timezone($_SESSION['user_timezone']);
//grab user time range preference
$time = grab_timeframe();
$mysql['to'] = $db->real_escape_string($time['to']);
$mysql['from'] = $db->real_escape_string($time['from']);
//show real or filtered clicks
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$user_sql = "SELECT user_pref_breakdown, user_pref_show, user_cpc_or_cpv FROM 202_users_pref WHERE user_id=" . $mysql['user_id'];
$user_result = _mysqli_query($user_sql, $dbGlobalLink);
//($user_sql);
$user_row = $user_result->fetch_assoc();
$breakdown = $user_row['user_pref_breakdown'];
if ($user_row['user_pref_show'] == 'all') {
$click_flitered = '';
}
if ($user_row['user_pref_show'] == 'real') {
$click_filtered = " AND click_filtered='0' ";
}
if ($user_row['user_pref_show'] == 'filtered') {
$click_filtered = " AND click_filtered='1' ";
}
if ($user_row['user_pref_show'] == 'filtered_bot') {
$click_filtered = " AND click_bot='1' ";
}
if ($user_row['user_pref_show'] == 'leads') {
$click_filtered = " AND click_lead='1' ";
function get_c4_id($c4)
{
global $memcacheWorking, $memcache;
//only grab the first 350 charactesr of c4
$c4 = substr($c4, 0, 350);
if ($memcacheWorking) {
//get from memcached
$getc4 = $memcache->get(md5("c4-id" . $c4 . systemHash()));
if ($getc4) {
return $getc4;
} else {
$database = DB::getInstance();
$db = $database->getConnection();
$mysql['c4'] = $db->real_escape_string($c4);
$c4_sql = "SELECT c4_id FROM 202_tracking_c4 WHERE c4='" . $mysql['c4'] . "'";
$c4_result = _mysqli_query($c4_sql);
$c4_row = $c4_result->fetch_assoc();
if ($c4_row) {
//if this already exists, return the id for it
$c4_id = $c4_row['c4_id'];
$setID = $memcache->set(md5("c4-id" . $c4 . systemHash()), $c4_id, false);
return $c4_id;
} else {
$c4_sql = "INSERT INTO 202_tracking_c4 SET c4='" . $mysql['c4'] . "'";
$c4_result = _mysqli_query($c4_sql);
//($c4_sql);
$c4_id = $db->insert_id;
$setID = $memcache->set(md5("c4-id" . $c4 . systemHash()), $c4_id, false);
return $c4_id;
}
}
} else {
$database = DB::getInstance();
$db = $database->getConnection();
$mysql['c4'] = $db->real_escape_string($c4);
$c4_sql = "SELECT c4_id FROM 202_tracking_c4 WHERE c4='" . $mysql['c4'] . "'";
$c4_result = _mysqli_query($c4_sql);
$c4_row = $c4_result->fetch_assoc();
if ($c4_row) {
//if this already exists, return the id for it
$c4_id = $c4_row['c4_id'];
return $c4_id;
} else {
//else if this ip doesn't exist, insert the row and grab the id for it
$c4_sql = "INSERT INTO 202_tracking_c4 SET c4='" . $mysql['c4'] . "'";
$c4_result = _mysqli_query($c4_sql);
//($c4_sql);
$c4_id = $db->insert_id;
return $c4_id;
}
}
}
$click_filtered = " AND click_lead='1' ";
}
if ($user_row['user_cpc_or_cpv'] == 'cpv') {
$cpv = true;
} else {
$cpv = false;
}
$info_sql = "\n\t\t\t\tSELECT \t202_aff_campaigns.aff_campaign_id,\n\t\t\t\t\t\t\taff_campaign_name,\n\t\t\t\t\t\t\taff_campaign_payout,\n\t\t\t\t\t\t\taff_network_name\n\t\t\t\t FROM \t202_summary_overview \n\t\t\t\t LEFT JOIN 202_aff_campaigns USING (aff_campaign_id) \n\t\t\t\t LEFT JOIN 202_aff_networks USING(aff_network_id) \n\t\t\t\t WHERE \t202_aff_networks.user_id='" . $mysql['user_id'] . "'\n\t\t\t\t AND \t202_aff_networks.aff_network_deleted = 0\n\t\t\t\t AND \t202_aff_campaigns.aff_campaign_deleted = 0 \n\t\t\t\t AND \t202_summary_overview.click_time >= " . $mysql['from'] . "\n\t\t\t\t AND \t202_summary_overview.click_time < " . $mysql['to'] . "\n\t\t\t\t AND \t\tlanding_page_id=0 \n\t\t\t\t GROUP BY aff_campaign_id \n\t\t\t\t ORDER BY 202_aff_networks.aff_network_name ASC,\n\t\t\t\t\t\t\t 202_aff_campaigns.aff_campaign_name ASC";
$info_result = _mysqli_query($info_sql);
//($info_sql);
while ($info_row = $info_result->fetch_array(MYSQL_ASSOC)) {
//mysql escape the vars
$mysql['aff_campaign_id'] = $db->real_escape_string($info_row['aff_campaign_id']);
$mysql['landing_page_id'] = $db->real_escape_string($info_row['landing_page_id']);
$click_sql = "\n\t\t\t\tSELECT\n\t\t\t\t\tCOUNT(*) AS clicks,\n\t\t\t\t\tAVG(2c.click_cpc) AS avg_cpc,\n\t\t\t\t\tSUM(2c.click_lead) AS leads,\n\t\t\t\t\tSUM(2c.click_payout*2c.click_lead) AS income\n\t\t\t\tFROM\n\t\t\t\t\t202_clicks AS 2c\n\t\t\t\tWHERE\n\t\t\t\t\t2c.user_id='" . $mysql['user_id'] . "'\n\t\t\t\t\t{$click_filtered}\n\t\t\t\t\tAND 2c.aff_campaign_id='" . $mysql['aff_campaign_id'] . "'\n\t\t\t\t\tAND 2c.click_time > " . $mysql['from'] . "\n\t\t\t\t\tAND 2c.click_time <= " . $mysql['to'] . "\n\t\t\t\t\tAND 2c.click_alp=0\n\t\t\t";
$click_result = _mysqli_query($click_sql);
//($click_sql);
$click_row = $click_result->fetch_assoc();
//get the stats
$clicks = 0;
$clicks = $click_row['clicks'];
$total_clicks = $total_clicks + $clicks;
//avg cpc and cost
$avg_cpc = 0;
$avg_cpc = $click_row['avg_cpc'];
$cost = 0;
$cost = $clicks * $avg_cpc;
$total_cost = $total_cost + $cost;
$total_avg_cpc = @round($total_cost / $total_clicks, 5);
//leads
$leads = 0;
$html['user_pref_group_2'] = htmlentities($user_row['user_pref_group_2'], ENT_QUOTES, 'UTF-8');
$html['user_pref_group_3'] = htmlentities($user_row['user_pref_group_3'], ENT_QUOTES, 'UTF-8');
$html['user_pref_group_4'] = htmlentities($user_row['user_pref_group_4'], ENT_QUOTES, 'UTF-8');
if ($user_row['user_cpc_or_cpv'] == 'cpv') {
$cpv = true;
} else {
$cpv = false;
}
$summary_form = new ReportSummaryForm();
$summary_form->setDetails(array($user_row['user_pref_group_1'], $user_row['user_pref_group_2'], $user_row['user_pref_group_3'], $user_row['user_pref_group_4']));
$summary_form->setDetailsSort(array(ReportBasicForm::SORT_NAME));
$summary_form->setDisplayType(array(ReportBasicForm::DISPLAY_TYPE_TABLE));
$summary_form->setStartTime($mysql['from']);
$summary_form->setEndTime($mysql['to']);
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$info_result = _mysqli_query($summary_form->getQuery($mysql['user_id'], $user_row));
while ($row = $info_result->fetch_assoc()) {
$summary_form->addReportData($row);
}
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"GroupOverviewReport" . date("mdy") . ".csv\"");
header("Expires: 0");
header("Pragma: no-cache");
ReportBasicForm::echoCell("Group Overview Report for " . date("m/d/Y", strtotime($summary_form->getStartDate())) . " to " . date("m/d/Y", strtotime($summary_form->getEndDate())));
ReportBasicForm::echoRow();
ReportBasicForm::echoCell($summary_form->getRanOn());
ReportBasicForm::echoRow();
ReportBasicForm::echoRow();
if (count($summary_form->getReportData()->getChildArrayBySort()) > 0) {
$summary_form->getExportRowHeaderHtml();
/* @var $summary_form_detail_1 Form */
}
if ($_POST['user_pass'] == '') {
$error['user_pass'] .= '<div class="error">You must type verify your password</div>';
}
if (strlen($_POST['user_pass']) < 6 or strlen($_POST['user_pass']) > 15) {
$error['user_pass'] .= '<div class="error">Passwords must be 6 to 15 characters long</div>';
}
if ($_POST['user_pass'] != $_POST['verify_user_pass']) {
$error['user_pass'] .= '<div class="error">Your passwords did not match, please try again</div>';
}
if (!$error) {
$user_pass = salt_user_pass($_POST['user_pass']);
$mysql['user_pass'] = $db->real_escape_string($user_pass);
$mysql['user_id'] = $db->real_escape_string($user_row['user_id']);
$user_sql = "UPDATE \t202_users\n\t\t\t\t\t\t SET\t\tuser_pass='******'user_pass'] . "',\n\t\t\t\t\t\t\t\t\tuser_pass_time='0'\n\t\t\t\t\t\t WHERE\tuser_id='" . $mysql['user_id'] . "'";
$user_result = _mysqli_query($user_sql);
$success = true;
}
}
$html['user_name'] = htmlentities($user_row['user_name'], ENT_QUOTES, 'UTF-8');
//if password was changed successfully
if ($success == true) {
_die("<center><small>Congratulations, your password has been reset.<br/>You can now <a href=\"/202-login.php\">login</a> with your new password.</small></center>");
}
if ($error['user_pass_key']) {
_die("<center><small>" . $error['user_pass_key'] . "<br/>Please use the <a href=\"/202-lost-pass.php\">password retrieval tool</a> to get a new password reset key.</small></center>");
}
//else if none of the above, show the code to reset!
?>
<?php
function upgrade_databases()
{
ini_set('max_execution_time', 60 * 10);
ini_set('max_input_time', 60 * 10);
//get the old version
$mysql_version = PROSPER202::mysql_version();
$php_version = PROSPER202::php_version();
//if the mysql is 1.0.2, upgrade to 1.0.3
if ($mysql_version == '1.0.2') {
//create the new mysql version table
$sql = "CREATE TABLE IF NOT EXISTS `202_version` (\r\n\t\t\t\t\t `version` varchar(50) NOT NULL\r\n\t\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//drop the old table
$sql = "DROP TABLE `202_sort_landings`";
$result = _mysqli_query($sql);
//create the new landing page sorting table
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_landing_pages` (\r\n\t\t\t\t `sort_landing_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `landing_page_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_click_throughs` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_ctr` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_landing_page_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_payout` decimal(6,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_epc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_avg_cpc` decimal(5,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_income` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_cost` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_net` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_landing_page_roi` decimal(10,2) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`sort_landing_id`),\r\n\t\t\t\t KEY `user_id` (`user_id`),\r\n\t\t\t\t KEY `landing_page_id` (`landing_page_id`),\r\n\t\t\t\t KEY `sort_landing_page_clicks` (`sort_landing_page_clicks`),\r\n\t\t\t\t KEY `sort_landing_page_click_throughs` (`sort_landing_page_click_throughs`),\r\n\t\t\t\t KEY `sort_landing_page_ctr` (`sort_landing_page_ctr`),\r\n\t\t\t\t KEY `sort_landing_page_leads` (`sort_landing_page_leads`),\r\n\t\t\t\t KEY `sort_landing_page_su_ratio` (`sort_landing_page_su_ratio`),\r\n\t\t\t\t KEY `sort_landing_page_payout` (`sort_landing_page_payout`),\r\n\t\t\t\t KEY `sort_landing_page_epc` (`sort_landing_page_epc`),\r\n\t\t\t\t KEY `sort_landing_page_avg_cpc` (`sort_landing_page_avg_cpc`),\r\n\t\t\t\t KEY `sort_landing_page_income` (`sort_landing_page_income`),\r\n\t\t\t\t KEY `sort_landing_page_cost` (`sort_landing_page_cost`),\r\n\t\t\t\t KEY `sort_landing_page_net` (`sort_landing_page_net`),\r\n\t\t\t\t KEY `sort_landing_page_roi` (`sort_landing_page_roi`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//this is now up to 1.0.3
$sql = "INSERT INTO 202_version SET version='1.0.3'";
$result = _mysqli_query($sql);
//now set the new mysql version
$mysql_version = '1.0.3';
}
//upgrade from 1.0.3 to 1.0.4
if ($mysql_version == '1.0.3') {
$sql = "UPDATE 202_version SET version='1.0.4'";
$result = _mysqli_query($sql);
$mysql_version = '1.0.4';
}
//upgrade from 1.0.4 to 1.0.5
if ($mysql_version == '1.0.4') {
$sql = "UPDATE 202_version SET version='1.0.5'";
$result = _mysqli_query($sql);
$mysql_version = '1.0.5';
}
//upgrade from 1.0.5 to 1.0.6
if ($mysql_version == '1.0.5') {
$sql = "UPDATE 202_version SET version='1.0.6'";
$result = _mysqli_query($sql);
$mysql_version = '1.0.6';
}
//upgrade from 1.0.6 to 1.1.0 - here we had some database modifications to make it scale better.
if ($mysql_version == '1.0.6') {
//this is upgrading things to BIGINT
$result = _mysqli_query("ALTER TABLE `202_clicks` \t\t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL");
$result = _mysqli_query("ALTER TABLE `202_clicks_advance` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL , \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL");
$result = _mysqli_query(" ALTER TABLE `202_clicks_counter` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_clicks_record` \tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_clicks_site` \t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_referer_site_url_id` `click_referer_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_landing_site_url_id` `click_landing_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_outbound_site_url_id` `click_outbound_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_cloaking_site_url_id` `click_cloaking_site_url_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `click_redirect_site_url_id` `click_redirect_site_url_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_clicks_spy` \t\tCHANGE `click_id` `click_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_ips` \t\t\tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_keywords` \t\tCHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_last_ips` \t\tCHANGE `ip_id` `ip_id` BIGINT NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_mysql_errors` \tCHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `site_id` `site_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_site_domains` \tCHANGE `site_domain_id` `site_domain_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ");
$result = _mysqli_query(" ALTER TABLE `202_site_urls` \t\tCHANGE `site_url_id` `site_url_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCHANGE `site_domain_id` `site_domain_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_sort_ips` CHANGE `ip_id` `ip_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_sort_keywords` CHANGE `keyword_id` `keyword_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_sort_referers` CHANGE `referer_id` `referer_id` BIGINT UNSIGNED NOT NULL ");
$result = _mysqli_query(" ALTER TABLE `202_users` CHANGE `user_last_login_ip_id` `user_last_login_ip_id` BIGINT UNSIGNED NOT NULL ");
//mysql version set to 1.1.0 now
$sql = "UPDATE 202_version SET version='1.1.0'";
$result = _mysqli_query($sql);
$mysql_version = '1.1.0';
}
//upgrade from 1.1.0 to 1.1.1
if ($mysql_version == '1.1.0') {
$sql = "UPDATE 202_version SET version='1.1.1'";
$result = _mysqli_query($sql);
$mysql_version = '1.1.1';
}
//upgrade from 1.1.1 to 1.1.2
if ($mysql_version == '1.1.1') {
$sql = "UPDATE 202_version SET version='1.1.2'";
$result = _mysqli_query($sql);
$mysql_version = '1.1.2';
}
//upgrade from 1.1.2 to 1.2.0
if ($mysql_version == '1.1.2') {
$result = _mysqli_query("\t CREATE TABLE IF NOT EXISTS `202_rotations` (\r\n\t\t\t\t\t\t\t\t\t\t `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `rotation_num` tinyint(4) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`aff_campaign_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MEMORY ; ");
$result = _mysqli_query("\tINSERT INTO 202_browsers SET browser_id = '9', browser_name = 'Chrome'");
$result = _mysqli_query("\tINSERT INTO 202_browsers SET browser_id = '10', browser_name = 'Mobile'");
$result = _mysqli_query("\tINSERT INTO 202_browsers SET browser_id = '11', browser_name = 'Console'");
$result = _mysqli_query(" \tALTER TABLE `202_clicks` CHANGE `click_cpc` `click_cpc` DECIMAL( 7, 5 ) NOT NULL ");
$result = _mysqli_query(" \tALTER TABLE `202_trackers` CHANGE `click_cpc` `click_cpc` DECIMAL( 7, 5 ) NOT NULL ");
$result = _mysqli_query(" \tALTER TABLE `202_users_pref` ADD `user_cpc_or_cpv` CHAR( 3 ) NOT NULL DEFAULT 'cpc' AFTER `user_pref_chart` ; ");
$result = _mysqli_query(" \tALTER TABLE `202_users_pref` ADD `user_keyword_searched_or_bidded` VARCHAR( 255 ) NOT NULL DEFAULT 'searched' AFTER `user_cpc_or_cpv` ; ");
$result = _mysqli_query(" \tALTER TABLE `202_aff_campaigns` ADD `aff_campaign_url_2` TEXT NOT NULL AFTER `aff_campaign_url` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_3` TEXT NOT NULL AFTER `aff_campaign_url_2` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_4` TEXT NOT NULL AFTER `aff_campaign_url_3` ,\r\n\t\t\t\t\t\t\t\t\t\tADD `aff_campaign_url_5` TEXT NOT NULL AFTER `aff_campaign_url_4` ;");
$result = _mysqli_query(" \tALTER TABLE `202_aff_campaigns` CHANGE `aff_campaign_url` `aff_campaign_url` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL");
$result = _mysqli_query(" \tALTER TABLE `202_aff_campaigns` ADD `aff_campaign_rotate` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `aff_campaign_time` ;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_breakdowns` CHANGE `sort_breakdown_avg_cpc` `sort_breakdown_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_breakdown_cost` `sort_breakdown_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_breakdown_net` `sort_breakdown_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_ips` CHANGE `sort_ip_avg_cpc` `sort_ip_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_ip_cost` `sort_ip_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_ip_net` `sort_ip_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_keywords` CHANGE `sort_keyword_avg_cpc` `sort_keyword_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_keyword_cost` `sort_keyword_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_keyword_net` `sort_keyword_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" ALTER TABLE`202_sort_landing_pages` CHANGE `sort_landing_page_avg_cpc` `sort_landing_page_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_landing_page_cost` `sort_landing_page_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_landing_page_net` `sort_landing_page_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_referers` CHANGE `sort_referer_avg_cpc` `sort_referer_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_referer_cost` `sort_referer_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_referer_net` `sort_referer_net` DECIMAL( 13, 5 ) NOT NULL;");
$result = _mysqli_query(" \tALTER TABLE`202_sort_text_ads` CHANGE `sort_text_ad_avg_cpc` `sort_text_ad_avg_cpc` DECIMAL( 7, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_text_ad_cost` `sort_text_ad_cost` DECIMAL( 13, 5 ) NOT NULL ,\r\n\t\t\t\t\t\t\t\t\t\tCHANGE `sort_text_ad_net` `sort_text_ad_net` DECIMAL( 13, 5 ) NOT NULL; ");
$sql = "UPDATE 202_version SET version='1.2.0'";
$result = _mysqli_query($sql);
$mysql_version = '1.2.0';
}
//upgrade from 1.2.0 to 1,2,1
if ($mysql_version == '1.2.0') {
$sql = "UPDATE 202_version SET version='1.2.1'";
$result = _mysqli_query($sql);
$mysql_version = '1.2.1';
}
//upgrade from 1.2.1 to 1.3.0
if ($mysql_version == '1.2.1') {
$result = _mysqli_query(" \tALTER TABLE `202_users` ADD `user_api_key` VARCHAR( 255 ) NOT NULL AFTER `user_pass_time` ; ");
$result = _mysqli_query(" \tALTER TABLE `202_users` ADD `user_stats202_app_key` VARCHAR( 255 ) NOT NULL AFTER `user_api_key` ; ");
$sql = "UPDATE 202_version SET version='1.3.0'";
$result = _mysqli_query($sql);
$mysql_version = '1.3.0';
}
//upgrade from 1.3.0 to 1.3.1
if ($mysql_version == '1.3.0') {
$result = _mysqli_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysqli_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.3.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.3.1';
}
//upgrade from 1.3.1 to 1.3.2
if ($mysql_version == '1.3.1') {
$result = _mysqli_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysqli_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.3.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.3.2';
}
//upgrade from 1.3.2 to 1.4
if ($mysql_version == '1.3.2') {
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_tracking_domain` varchar(255) NOT NULL DEFAULT '';");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_1` tinyint(3);");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_2` tinyint(3);");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_3` tinyint(3);");
$result = _mysqli_query("\tALTER TABLE 202_users_pref ADD COLUMN `user_pref_group_4` tinyint(3);");
$result = _mysqli_query("\tUPDATE 202_aff_campaigns SET aff_campaign_url=CONCAT(aff_campaign_url,'[[subid]]') ");
$result = _mysqli_query(" \tCREATE TABLE `202_clicks_tracking` (\r\n\t\t\t\t\t\t\t\t\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c1` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c2` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c3` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t `c4` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`click_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB ; ");
$sql = "UPDATE 202_version SET version='1.4'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4';
}
//upgrade from 1.4 to 1.4.1
if ($mysql_version == '1.4') {
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c1` (\r\n\t\t\t\t\t\t\t\t\t\t `c1_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c1` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c1_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c1` (`c1`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c2` (\r\n\t\t\t\t\t\t\t\t\t\t `c2_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c2` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c2_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c2` (`c2`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c3` (\r\n\t\t\t\t\t\t\t\t\t\t `c3_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c3` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c3_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c3` (`c3`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$result = _mysqli_query(" \tCREATE TABLE `202_tracking_c4` (\r\n\t\t\t\t\t\t\t\t\t\t `c4_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t `c4` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c4_id`),\r\n\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `c4` (`c4`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ; ");
$sql = "UPDATE 202_version SET version='1.4.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4.1';
}
//upgrade from 1.4.1 to 1.4.2
if ($mysql_version == '1.4.1') {
$result = _mysqli_query(" \t DROP TABLE `202_clicks_tracking`; ");
$result = _mysqli_query(" \t CREATE TABLE `202_clicks_tracking` (\r\n\t\t\t\t\t\t\t\t\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c1_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c2_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c3_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `c4_id` bigint(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`click_id`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB ; ");
$sql = "UPDATE 202_version SET version='1.4.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4.2';
}
//upgrade from 1.4.2 to 1.4.3
if ($mysql_version == '1.4.2') {
$result = _mysqli_query(" \tALTER TABLE `202_clicks_spy` ENGINE = MYISAM ");
$result = _mysqli_query(" \tALTER TABLE `202_last_ips` ENGINE = MYISAM ");
$sql = "UPDATE 202_version SET version='1.4.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.4.3';
}
//upgrade from 1.4.3 to 1.5
if ($mysql_version == '1.4.3') {
$sql = "UPDATE 202_version SET version='1.5'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.5';
}
//upgrade from 1.5 to 1.5.1
if ($mysql_version == '1.5') {
$sql = "UPDATE 202_version SET version='1.5.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.5.1';
}
//upgrade from 1.5.1 to 1.6
if ($mysql_version == '1.5.1') {
$result = _mysqli_query("CREATE TABLE IF NOT EXISTS `202_alerts` (\r\n\t\t\t `prosper_alert_id` int(11) NOT NULL,\r\n\t\t\t `prosper_alert_seen` tinyint(1) NOT NULL,\r\n\t\t\t UNIQUE KEY `prosper_alert_id` (`prosper_alert_id`)\r\n\t\t\t) ENGINE=InnoDB ;");
$result = _mysqli_query("CREATE TABLE IF NOT EXISTS `202_offers` (\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `offer_id` mediumint(10) unsigned NOT NULL,\r\n\t\t\t\t `offer_seen` tinyint(1) NOT NULL DEFAULT '1',\r\n\t\t\t\t UNIQUE KEY `user_id` (`user_id`,`offer_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;");
$result = _mysqli_query("ALTER TABLE `202_cronjobs` ENGINE = MYISAM;");
$sql = "UPDATE 202_version SET version='1.6'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.6';
}
//upgrade from 1.6 beta to 1.6.1 stable
if ($mysql_version == '1.6') {
$sql = "UPDATE 202_version SET version='1.6.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.6.1';
}
//upgrade from 1.6.1 to 1.6.2 beta
if ($mysql_version == '1.6.1') {
$sql = "UPDATE 202_version SET version='1.6.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.6.2';
}
//upgrade from 1.6.2 to 1.7 beta
if ($mysql_version == '1.6.2') {
$sql = "UPDATE 202_version SET version='1.7'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7';
$sql = "CREATE TABLE IF NOT EXISTS `202_pixel_types` (\r\n \t\t\t `pixel_type_id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT ,\r\n \t\t \t `pixel_type` VARCHAR(45) NULL ,\r\n \t\t\t PRIMARY KEY (`pixel_type_id`) ,\r\n \t\t UNIQUE INDEX `pixel_type_UNIQUE` (`pixel_type` ASC) \r\n \t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_ppc_account_pixels` (\r\n \t\t\t `pixel_id` mediumint(8) unsigned NOT NULL auto_increment,\r\n \t\t\t `pixel_code` text NOT NULL,\r\n \t\t\t `pixel_type_id` mediumint(8) unsigned NOT NULL,\r\n \t\t\t `ppc_account_id` mediumint(8) unsigned NOT NULL,\r\n \t\t\t PRIMARY KEY (`pixel_id`)\r\n \t\t\t ) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_clicks_total` (\r\n\t\t\t `click_count` int(20) unsigned NOT NULL default '0',\r\n \t\t\t PRIMARY KEY (`click_count`)\r\n\t\t\t ) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "INSERT IGNORE INTO `202_pixel_types` (`pixel_type`) VALUES \r\n\t\t\t ('Image'),\r\n\t\t\t ('Iframe'),\r\n\t\t\t ('Javascript'),\r\n\t\t\t ('Postback')";
$result = _mysqli_query($sql);
$sql = "INSERT IGNORE INTO `202_platforms` (`platform_name`) VALUES \r\n\t\t\t ('Mobile'),\r\n\t\t\t ('Tablet');";
$result = _mysqli_query($sql);
$sql = "INSERT IGNORE INTO `202_clicks_total` (`click_count`) VALUES\r\n\t\t(0);";
$result = _mysqli_query($sql);
}
//upgrade from 1.7 beta to 1.7.1 beta
if ($mysql_version == '1.7') {
$sql = "UPDATE 202_version SET version='1.7.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.1';
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_keywords_lpctr` (\r\n \t\t\t `sort_keyword_id` int(10) unsigned NOT NULL auto_increment,\r\n \t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n \t\t\t `keyword_id` bigint(20) unsigned NOT NULL,\r\n \t\t\t `sort_keyword_clicks` mediumint(8) unsigned NOT NULL,\r\n \t\t\t `sort_keyword_click_throughs` mediumint(8) unsigned NOT NULL,\r\n\t\t `sort_keyword_ctr` decimal(10,2) NOT NULL, \r\n \t\t `sort_keyword_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_keyword_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_keyword_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_keyword_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_keyword_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_keyword_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_keyword_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_keyword_net` decimal(13,5) NOT NULL,\r\n \t\t\t `sort_keyword_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_keyword_id`),\r\n\t\t\t KEY `user_id` (`user_id`),\r\n\t\t\t KEY `keyword_id` (`keyword_id`),\r\n\t\t\t KEY `sort_keyword_clicks` (`sort_keyword_clicks`)\r\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_text_ads_lpctr` (\r\n `sort_text_ad_id` int(10) unsigned NOT NULL auto_increment,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `text_ad_id` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_clicks` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_click_throughs` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_ctr` decimal(10,2) NOT NULL, \r\n `sort_text_ad_leads` mediumint(8) unsigned NOT NULL,\r\n `sort_text_ad_su_ratio` decimal(10,2) NOT NULL,\r\n `sort_text_ad_payout` decimal(6,2) NOT NULL,\r\n `sort_text_ad_epc` decimal(10,2) NOT NULL,\r\n `sort_text_ad_avg_cpc` decimal(7,5) NOT NULL,\r\n `sort_text_ad_income` decimal(10,2) NOT NULL,\r\n `sort_text_ad_cost` decimal(13,5) NOT NULL,\r\n `sort_text_ad_net` decimal(13,5) NOT NULL,\r\n `sort_text_ad_roi` decimal(10,2) NOT NULL,\r\n PRIMARY KEY (`sort_text_ad_id`),\r\n KEY `user_id` (`user_id`),\r\n KEY `keyword_id` (`text_ad_id`),\r\n KEY `sort_keyword_clicks` (`sort_text_ad_clicks`),\r\n KEY `sort_keyword_leads` (`sort_text_ad_leads`),\r\n KEY `sort_keyword_signup_ratio` (`sort_text_ad_su_ratio`),\r\n KEY `sort_keyword_payout` (`sort_text_ad_payout`),\r\n KEY `sort_keyword_epc` (`sort_text_ad_epc`),\r\n KEY `sort_keyword_cpc` (`sort_text_ad_avg_cpc`),\r\n KEY `sort_keyword_income` (`sort_text_ad_income`),\r\n KEY `sort_keyword_cost` (`sort_text_ad_cost`),\r\n KEY `sort_keyword_net` (`sort_text_ad_net`),\r\n KEY `sort_keyword_roi` (`sort_text_ad_roi`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=1 ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_referers_lpctr` (\r\n `sort_referer_id` int(10) unsigned NOT NULL auto_increment,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `referer_id` bigint(20) unsigned NOT NULL,\r\n `sort_referer_clicks` mediumint(8) unsigned NOT NULL,\r\n `sort_referer_click_throughs` mediumint(8) unsigned NOT NULL,\r\n `sort_referer_ctr` decimal(10,2) NOT NULL,\r\n `sort_referer_leads` mediumint(8) unsigned NOT NULL,\r\n `sort_referer_su_ratio` decimal(10,2) NOT NULL,\r\n `sort_referer_payout` decimal(6,2) NOT NULL,\r\n `sort_referer_epc` decimal(10,2) NOT NULL,\r\n `sort_referer_avg_cpc` decimal(7,5) NOT NULL,\r\n `sort_referer_income` decimal(10,2) NOT NULL,\r\n `sort_referer_cost` decimal(13,5) NOT NULL,\r\n `sort_referer_net` decimal(13,5) NOT NULL,\r\n `sort_referer_roi` decimal(10,2) NOT NULL,\r\n PRIMARY KEY (`sort_referer_id`),\r\n KEY `user_id` (`user_id`),\r\n KEY `keyword_id` (`referer_id`),\r\n KEY `sort_keyword_clicks` (`sort_referer_clicks`),\r\n KEY `sort_keyword_leads` (`sort_referer_leads`),\r\n KEY `sort_keyword_signup_ratio` (`sort_referer_su_ratio`),\r\n KEY `sort_keyword_payout` (`sort_referer_payout`),\r\n KEY `sort_keyword_epc` (`sort_referer_epc`),\r\n KEY `sort_keyword_cpc` (`sort_referer_avg_cpc`),\r\n KEY `sort_keyword_income` (`sort_referer_income`),\r\n KEY `sort_keyword_cost` (`sort_referer_cost`),\r\n KEY `sort_keyword_net` (`sort_referer_net`),\r\n KEY `sort_keyword_roi` (`sort_referer_roi`)\r\n) ENGINE=InnoDB;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c1` CHANGE COLUMN `c1` `c1` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c2` CHANGE COLUMN `c2` `c2` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c3` CHANGE COLUMN `c3` `c3` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_tracking_c4` CHANGE COLUMN `c4` `c4` VARCHAR(350) NOT NULL ;";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.1 to 1.7.2 beta
if ($mysql_version == '1.7.1') {
$sql = "UPDATE 202_version SET version='1.7.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.2';
}
//upgrade from 1.7.2 to 1.7.3
if ($mysql_version == '1.7.2') {
$sql = "UPDATE 202_version SET version='1.7.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.3';
$sql = "ALTER TABLE `202_users` MODIFY COLUMN `user_timezone` VARCHAR(50) NOT NULL default 'Pacific/Pitcairn';";
$result = _mysqli_query($sql);
$sql = "UPDATE `202_users` SET user_timezone='Pacific/Pitcairn' WHERE user_id=1";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_sort_breakdowns`" . " ADD `sort_breakdown_click_throughs` mediumint(8) unsigned NOT NULL AFTER `sort_breakdown_clicks`," . " ADD `sort_breakdown_ctr` decimal(10,2) NOT NULL AFTER `sort_breakdown_click_throughs`," . " ADD KEY `sort_breakdown_click_throughs` (`sort_breakdown_click_throughs`)," . " ADD KEY `sort_breakdown_ctr` (`sort_breakdown_ctr`)";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_spy` ADD INDEX (`click_id`)";
$result = _mysqli_query($sql);
$sql = "INSERT INTO `202_pixel_types` (`pixel_type`) VALUES ('Raw')";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `cache_time` VARCHAR(4) NOT NULL default '0';";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.3 to 1.7.4
if ($mysql_version == '1.7.3') {
$sql = "UPDATE 202_version SET version='1.7.4'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.4';
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `cb_key` VARCHAR(250) NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `cb_verified` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.4 to 1.7.5
if ($mysql_version == '1.7.4') {
$sql = "UPDATE 202_version SET version='1.7.5'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.5';
}
//upgrade from 1.7.5 to 1.7.6
if ($mysql_version == '1.7.5') {
$sql = "UPDATE 202_version SET version='1.7.6'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.7.6';
$sql = "ALTER TABLE `202_users` ADD COLUMN `clickserver_api_key` VARCHAR(250) NOT NULL;";
$result = _mysqli_query($sql);
}
//upgrade from 1.7.6 to 1.8.0
if ($mysql_version == '1.7.6') {
$sql = "UPDATE 202_version SET version='1.8.0'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.0';
}
//upgrade from 1.8.0 to 1.8.1
if ($mysql_version == '1.8.0') {
$sql = "UPDATE 202_version SET version='1.8.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.1';
}
//upgrade from 1.8.1 to 1.8.2
if ($mysql_version == '1.8.1') {
$sql = "UPDATE 202_version SET version='1.8.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.2';
}
//upgrade from 1.8.2 to 1.8.2.1
if ($mysql_version == '1.8.2') {
$sql = "DROP TABLE IF EXISTS 202_locations";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_country";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_city";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_block";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_coordinates";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_locations_region";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `country_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `city_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_locations_city` (\r\n\t\t\t\t `city_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `main_country_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `city_name` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t\t PRIMARY KEY (`city_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_locations_country` (\r\n\t\t\t\t `country_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `country_code` varchar(3) NOT NULL DEFAULT '',\r\n\t\t\t\t `country_name` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t\t PRIMARY KEY (`country_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_cities` (\r\n\t\t\t `sort_city_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `city_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `country_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_city_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_city_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_city_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_city_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_city_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_city_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_city_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_city_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_city_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_city_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_city_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_countries` (\r\n\t\t\t\t `sort_country_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `country_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t `sort_country_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_country_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_country_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_country_payout` decimal(6,2) NOT NULL,\r\n\t\t\t\t `sort_country_epc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_country_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t\t `sort_country_income` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_country_cost` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_country_net` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_country_roi` decimal(10,2) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`sort_country_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_locations_isp` (\r\n\t\t\t\t `isp_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `isp_name` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t\t PRIMARY KEY (`isp_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_isps` (\r\n\t\t\t\t `sort_isp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `isp_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t `sort_isp_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_isp_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `sort_isp_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_isp_payout` decimal(6,2) NOT NULL,\r\n\t\t\t\t `sort_isp_epc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_isp_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t\t `sort_isp_income` decimal(10,2) NOT NULL,\r\n\t\t\t\t `sort_isp_cost` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_isp_net` decimal(13,5) NOT NULL,\r\n\t\t\t\t `sort_isp_roi` decimal(10,2) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`sort_isp_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `isp_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `maxmind_isp` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_isp_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_device_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_browser_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_platform_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_api_keys` (\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `api_key` varchar(250) NOT NULL DEFAULT '',\r\n\t\t\t\t `created_at` int(10) NOT NULL\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "TRUNCATE TABLE 202_browsers;";
$result = _mysqli_query($sql);
$sql = "TRUNCATE TABLE 202_platforms;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_device_types` (\r\n\t\t\t `type_id` tinyint(1) unsigned NOT NULL,\r\n\t\t\t `type_name` varchar(50) NOT NULL,\r\n\t\t\t PRIMARY KEY (`type_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "INSERT INTO `202_device_types` (`type_id`, `type_name`)\r\n\t\t\t\tVALUES\r\n\t\t\t\t\t(1, 'Desktop'),\r\n\t\t\t\t\t(2, 'Mobile'),\r\n\t\t\t\t\t(3, 'Tablet'),\r\n\t\t\t\t\t(4, 'Bot');";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_device_models` (\r\n\t\t\t `device_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `device_name` varchar(50) NOT NULL,\r\n\t\t\t `device_type` tinyint(1) NOT NULL,\r\n\t\t\t PRIMARY KEY (`device_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `device_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks` ADD COLUMN `click_bot` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks_spy` ADD COLUMN `click_bot` tinyint(1) NOT NULL default '0';";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_sort_devices` (\r\n\t\t\t `sort_device_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `device_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_device_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_device_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_device_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_device_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_device_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_device_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_device_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_device_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_device_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_device_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_device_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_browsers` (\r\n\t\t\t `sort_browser_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `browser_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_browser_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_browser_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_browser_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_browser_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_browser_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_browser_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_browser_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_browser_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_browser_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_browser_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_browser_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_platforms` (\r\n\t\t\t `sort_platform_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `platform_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_platform_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_platform_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_platform_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_platform_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_platform_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_platform_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_platform_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_platform_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_platform_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_platform_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_platform_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users` ADD COLUMN `install_hash` varchar(255) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t ADD COLUMN `user_hash` varchar(255) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t ADD COLUMN `modal_status` int(1) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t ADD COLUMN `vip_perks_status` int(1) NOT NULL;";
$result = _mysqli_query($sql);
$hash = md5(uniqid(rand(), TRUE));
$user_hash = intercomHash($hash);
$sql = "UPDATE 202_users SET install_hash='" . $hash . "', user_hash='" . $user_hash . "' WHERE user_id='1'";
$result = _mysqli_query($sql);
$sql = "UPDATE 202_version SET version='1.8.2.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.2.1';
}
//upgrade from 1.8.2.1 to 1.8.2.2
if ($mysql_version == '1.8.2.1') {
$sql = "ALTER TABLE `202_clicks_advance` ADD COLUMN `region_id` bigint(20) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_locations_region` (\r\n\t\t\t\t `region_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `main_country_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `region_name` varchar(50) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`region_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_regions` (\r\n\t\t\t `sort_regions_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `region_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `country_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t `sort_region_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_region_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_region_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_region_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_region_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_region_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_region_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_region_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_region_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_region_roi` decimal(10,2) NOT NULL,\r\n\t\t\t PRIMARY KEY (`sort_regions_id`)\r\n\t\t\t) ENGINE=InnoDB;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_users_pref` ADD COLUMN `user_pref_region_id` tinyint(3) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "UPDATE 202_version SET version='1.8.2.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.2.2';
}
//upgrade from 1.8.2.2 to 1.8.3
if ($mysql_version == '1.8.2.2') {
$sql = "CREATE TABLE IF NOT EXISTS `202_rotators` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` int(11) NOT NULL,\r\n\t\t\t `tracker_id` int(11) NOT NULL,\r\n\t\t\t `name` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t `default_url` text NOT NULL,\r\n\t\t\t `redirect_url` text NOT NULL,\r\n\t\t\t `redirect_campaign` int(11) DEFAULT NULL,\r\n \t\t\t `default_campaign` int(11) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_rotator_rules` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `rotator_id` int(11) NOT NULL,\r\n\t\t\t `type` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `statement` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `value` text NOT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_rotator_clicks` (\r\n\t\t\t `click_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `rotator_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `click_time` int(10) unsigned NOT NULL,\r\n\t\t\t `redirects` int(1) unsigned NOT NULL,\r\n\t\t\t `defaults` int(1) unsigned NOT NULL,\r\n\t\t\t PRIMARY KEY (`click_id`),\r\n\t\t\t KEY `rotator_id` (`rotator_id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_rotators` (\r\n\t\t\t `sort_rotator_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `rotator_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_rotator_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_rotator_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `sort_rotator_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_rotator_payout` decimal(6,2) NOT NULL,\r\n\t\t\t `sort_rotator_epc` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_rotator_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t\t `sort_rotator_income` decimal(10,2) NOT NULL,\r\n\t\t\t `sort_rotator_cost` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_rotator_net` decimal(13,5) NOT NULL,\r\n\t\t\t `sort_rotator_roi` decimal(10,2) NOT NULL,\r\n\t\t\t `type` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t PRIMARY KEY (`sort_rotator_id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks` ADD COLUMN `rotator_id` mediumint(0) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_sort_browsers, 202_sort_cities, 202_sort_countries, 202_sort_devices, 202_sort_ips, 202_sort_isps, 202_sort_keywords, 202_sort_keywords_lpctr, 202_sort_landing_pages, 202_sort_platforms, 202_sort_referers, 202_sort_referers_lpctr, 202_sort_regions, 202_sort_text_ads, 202_sort_text_ads_lpctr;";
$result = _mysqli_query($sql);
$sql = "UPDATE 202_version SET version='1.8.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3';
}
//upgrade from 1.8.3 to 1.8.3.1
if ($mysql_version == '1.8.3') {
$sql = "UPDATE 202_version SET version='1.8.3.1'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3.1';
}
//upgrade from 1.8.3.1 to 1.8.3.2
if ($mysql_version == '1.8.3.1') {
$sql = "UPDATE 202_version SET version='1.8.3.2'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3.2';
}
//upgrade from 1.8.3.2 to 1.8.3.3
if ($mysql_version == '1.8.3.2') {
$sql = "UPDATE 202_version SET version='1.8.3.3'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.3.3';
}
//upgrade from 1.8.3.3 to 1.8.4
if ($mysql_version == '1.8.3.3') {
$sql = "ALTER TABLE `202_clicks` MODIFY `rotator_id` int(10) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_clicks` ADD COLUMN `rule_id` int(10) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "ALTER TABLE `202_trackers` ADD COLUMN `rotator_id` int(11) unsigned NOT NULL;";
$result = _mysqli_query($sql);
$sql = "DROP TABLE IF EXISTS 202_sort_rotators, 202_rotator_rules, 202_rotator_clicks, 202_rotators;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotators` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `user_id` int(11) NOT NULL,\r\n\t\t\t `name` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t `default_url` text,\r\n\t\t\t `default_campaign` int(11) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotator_rules` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `rotator_id` int(11) NOT NULL,\r\n\t\t\t `rule_name` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t `redirect_url` text,\r\n\t\t\t `redirect_campaign` int(11) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotator_rules_criteria` (\r\n\t\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t `rotator_id` int(11) NOT NULL,\r\n\t\t\t `rule_id` int(11) NOT NULL,\r\n\t\t\t `type` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `statement` varchar(50) NOT NULL DEFAULT '',\r\n\t\t\t `value` text NOT NULL,\r\n\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements\r\n\t\t\tFROM information_schema.tables AS tb\r\n\t\t\tWHERE table_schema = '" . $dbname . "'\r\n\t\t\tAND `ENGINE` = 'MyISAM'\r\n\t\t\tAND `TABLE_TYPE` = 'BASE TABLE'\r\n\t\t\tORDER BY table_name DESC;";
$result = _mysqli_query($sql);
while ($row = $result->fetch_assoc()) {
$db->query($row['sql_statements']);
}
$sql = "UPDATE 202_version SET version='1.8.4'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.4';
}
//upgrade from 1.8.4 to 1.8.5
if ($mysql_version == '1.8.4') {
$sql = "UPDATE 202_version SET version='1.8.5'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.5';
}
//upgrade from 1.8.5 to 1.8.6
if ($mysql_version == '1.8.5') {
$sql = "UPDATE 202_version SET version='1.8.6'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.6';
}
//upgrade from 1.8.6 to 1.8.7
if ($mysql_version == '1.8.6') {
$sql = "UPDATE 202_version SET version='1.8.7'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.7';
}
//upgrade from 1.8.7 to 1.8.8
if ($mysql_version == '1.8.7') {
$sql = "UPDATE 202_version SET version='1.8.8'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.8';
}
//upgrade from 1.8.8 to 1.8.9
if ($mysql_version == '1.8.8') {
$sql = "UPDATE 202_version SET version='1.8.9'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.9';
}
//upgrade from 1.8.9 to 1.8.10
if ($mysql_version == '1.8.9') {
$sql = "UPDATE 202_version SET version='1.8.10'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.10';
}
//upgrade from 1.8.10 to 1.8.11
if ($mysql_version == '1.8.10') {
$sql = "UPDATE 202_version SET version='1.8.11'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.11';
}
//upgrade from 1.8.11 to 1.8.12
if ($mysql_version == '1.8.11') {
$sql = "ALTER TABLE 202_users_pref ADD COLUMN `user_daily_email` char(2) NOT NULL DEFAULT '07'";
$result = _mysqli_query($sql);
$sql = "SELECT user_timezone, install_hash, user_daily_email FROM 202_users LEFT JOIN 202_users_pref USING (user_id) WHERE user_id = 1";
$result = _mysqli_query($sql);
$row = $result->fetch_assoc();
registerDailyEmail($row['user_daily_email'], $row['user_timezone'], $row['install_hash']);
$sql = "UPDATE 202_version SET version='1.8.12'";
$result = _mysqli_query($sql);
$mysql_version = '1.8.12';
}
//upgrade from 1.8.12 to 1.8.13
if ($mysql_version == '1.8.12') {
$sql = "UPDATE 202_version SET version='1.8.13'; ";
$result = _mysqli_query($sql);
$mysql_version = '1.8.13';
}
return true;
}
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
#grab alert items
$rss = fetch_rss(TRACKING202_RSS_URL . '/prosper202/alerts');
if (isset($rss->items) && 0 != count($rss->items)) {
$rss->items = array_slice($rss->items, 0, 3);
}
foreach ($rss->items as $item) {
//check if this alert is already marked as seen
$mysql['prosper_alert_id'] = $db->real_escape_string($item['prosper_alert_id']);
$sql = "SELECT COUNT(*) AS count FROM 202_alerts WHERE prosper_alert_id='{$mysql['prosper_alert_id']}' AND prosper_alert_seen='1'";
$result = _mysqli_query($sql);
$row = $result->fetch_assoc();
if ($row['count']) {
#echo 'dont show';
$dontShow[$item['prosper_alert_id']] = true;
} else {
#echo 'show alerts';
$showAlerts = true;
}
}
#echo $showAlerts;
if (!$showAlerts) {
die;
}
#if items display the table
if ($rss->items) {
foreach ($rss->items as $item) {
if ($dontShow[$item['prosper_alert_id']] == false) {
function getCampaignID($db, $campaign, $user)
{
$mysql['user_id'] = $db->real_escape_string($user);
$mysql['campaign_id'] = $db->real_escape_string($campaign);
$key_sql = "SELECT \t*\n\t\t\t\tFROM \t`202_aff_campaigns` \n\t\t\t\tWHERE \t`user_id`='" . $mysql['user_id'] . "' AND `aff_campaign_id`='" . $mysql['campaign_id'] . "'";
$key_result = _mysqli_query($db, $key_sql);
$key_row = $key_result->fetch_assoc();
if ($key_result->num_rows > 0) {
return true;
} else {
$json = json_encode(array('msg' => 'Campaign not found', 'error' => true, 'status' => 404), true);
print_r(pretty_json($json));
die;
}
}
$user_row = $user_result->fetch_assoc();
if (!$user_row) {
$error['user'] = '******';
}
//i there isn't any error, give this user, a new password, and email it to them!
if (!$error) {
$mysql['user_id'] = $db->real_escape_string($user_row['user_id']);
//generate random key
$user_pass_key = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
$user_pass_key = substr(str_shuffle($user_pass_key), 0, 40) . time();
$mysql['user_pass_key'] = $db->real_escape_string($user_pass_key);
//set the user pass time
$mysql['user_pass_time'] = time();
//insert this verification key into the database, and the timestamp of inserting it
$update_sql = "\tUPDATE \t202_users \n\t\t\t\t\t\t\tSET \t\tuser_pass_key='" . $mysql['user_pass_key'] . "',\n\t\t\t\t\t\t\t\t\t\tuser_pass_time='" . $mysql['user_pass_time'] . "'\n\t\t\t\t\t\t\tWHERE\t\tuser_id='" . $mysql['user_id'] . "'";
$update_result = _mysqli_query($update_sql);
//now email the user the script to reset their email
$to = $_POST['user_email'];
$subject = "[Propser202 on " . $_SERVER['SERVER_NAME'] . "] Password Reset";
$message = "\n<p>Someone has asked to reset the password for the following site and username.</p>\n\n<p><a href=\"http://" . $_SERVER['SERVER_NAME'] . "\">http://" . $_SERVER['SERVER_NAME'] . "</a></p>\n\n<p>Username: "******"</p>\n\n<p>To reset your password visit the following address, otherwise just ignore this email and nothing will happen.</p>\n\n<p><a href=\"http://" . $_SERVER['SERVER_NAME'] . "/202-pass-reset.php?key={$user_pass_key}\">http://" . $_SERVER['SERVER_NAME'] . "/202-pass-reset.php?key={$user_pass_key}</a></p>";
$from = "propser202@" . $_SERVER['SERVER_NAME'];
$header = "From: Propser202<" . $from . "> \r\n";
$header .= "Reply-To: " . $from . " \r\n";
$header .= "To: " . $to . " \r\n";
$header .= "Content-Type: text/html; charset=\"iso-8859-1\" \r\n";
$header .= "Content-Transfer-Encoding: 8bit \r\n";
$header .= "MIME-Version: 1.0 \r\n";
mail($to, $subject, $message, $header);
$success = true;
}
$html['user_name'] = htmlentities($_POST['user_name'], ENT_QUOTES, 'UTF-8');
function RunSecondsCronjob()
{
$database = DB::getInstance();
$db = $database->getConnection();
//check to run the 1minute cronjob, change this to every minute
$now = time();
$everySeconds = 20;
//check to run the 1minute cronjob, change this to every minute
$now = time();
$today_second = date('s', time());
$today_minute = date('i', time());
$today_hour = date('G', time());
$today_day = date('j', time());
$today_month = date('n', time());
$today_year = date('Y', time());
$today_second = ceil($today_second / $everySeconds);
if ($today_second == 0) {
$today_second++;
}
//the click_time is recorded in the middle of the day
$cronjob_time = mktime($today_hour, $today_minute, $today_second, $today_month, $today_day, $today_year);
$mysql['cronjob_time'] = $db->real_escape_string($cronjob_time);
$mysql['cronjob_type'] = $db->real_escape_string('secon');
//check to make sure this click_summary doesn't already exist
$check_sql = "SELECT * FROM 202_cronjobs WHERE cronjob_type='" . $mysql['cronjob_type'] . "' AND cronjob_time='" . $mysql['cronjob_time'] . "'";
$check_result = $db->query($check_sql) or record_mysql_error($check_sql);
$check_count = $check_result->num_rows;
if ($check_count == 0) {
//if a cronjob hasn't run today, record it now.
$insert_sql = "INSERT INTO 202_cronjobs SET cronjob_type='" . $mysql['cronjob_type'] . "', cronjob_time='" . $mysql['cronjob_time'] . "'";
$insert_result = $db->query($insert_sql);
/* -------- THIS RUNS THE DELAYED QUERIES --------- */
$delayed_sql = "\n\t\t\tSELECT delayed_sql\n\t\t\tFROM 202_delayed_sqls\n\t\t\tWHERE delayed_time <=" . time() . "\n\t\t";
$delayed_result = _mysqli_query($delayed_sql);
while ($delayed_row = $delayed_result->fetch_assoc()) {
//run each sql
$update_sql = $delayed_row['delayed_sql'];
$update_result = _mysqli_query($update_sql);
}
//delete all old delayed sqls
$delayed_sql = "DELETE FROM 202_delayed_sqls WHERE delayed_time <=" . time();
$delayed_result = _mysqli_query($delayed_sql);
return true;
} else {
return false;
}
}
function install_databases()
{
$database = DB::getInstance();
$db = $database->getConnection();
$php_version = PROSPER202::php_version();
//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);
//now add the what version this software is
$sql = "INSERT INTO 202_version SET version='{$php_version}'";
$result = _mysqli_query($sql);
//create sessions table
$sql = "CREATE TABLE IF NOT EXISTS `202_sessions` (\r\n\t\t\t\t `session_id` varchar(100) NOT NULL DEFAULT '',\r\n\t\t\t\t `session_data` text NOT NULL,\r\n\t\t\t\t `expires` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t PRIMARY KEY (`session_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_cronjobs` (\r\n\t\t\t\t `cronjob_type` char(5) NOT NULL,\r\n\t\t\t\t `cronjob_time` int(11) NOT NULL,\r\n\t\t\t\t KEY `cronjob_type` (`cronjob_type`,`cronjob_time`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_mysql_errors` (\r\n `mysql_error_id` mediumint(8) unsigned NOT NULL auto_increment,\r\n `mysql_error_text` text NOT NULL,\r\n `mysql_error_sql` text NOT NULL,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `ip_id` bigint(20) unsigned NOT NULL,\r\n `mysql_error_time` int(10) unsigned NOT NULL,\r\n `site_id` bigint(20) unsigned NOT NULL,\r\n PRIMARY KEY (`mysql_error_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_users_log` (\r\n\t\t\t `login_id` mediumint(9) NOT NULL auto_increment,\r\n\t\t\t `user_name` varchar(255) NOT NULL,\r\n\t\t\t `user_pass` varchar(255) NOT NULL,\r\n\t\t\t `ip_address` varchar(255) NOT NULL,\r\n\t\t\t `login_time` int(10) unsigned NOT NULL,\r\n\t\t\t `login_success` tinyint(1) NOT NULL,\r\n\t\t\t `login_error` text NOT NULL,\r\n\t\t\t `login_server` text NOT NULL,\r\n\t\t\t `login_session` text NOT NULL,\r\n\t\t\t PRIMARY KEY (`login_id`),\r\n\t\t\t KEY `login_pass` (`login_success`),\r\n\t\t\t KEY `ip_address` (`ip_address`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//create users table
$sql = "CREATE TABLE IF NOT EXISTS `202_users` (\r\n `user_id` mediumint(8) unsigned NOT NULL auto_increment,\r\n `user_name` varchar(50) NOT NULL,\r\n `user_pass` char(32) NOT NULL,\r\n `user_email` varchar(100) NOT NULL,\r\n `user_timezone` varchar(50) NOT NULL default 'Pacific/Pitcairn',\r\n `user_time_register` int(10) unsigned NOT NULL,\r\n `user_pass_key` varchar(255) NOT NULL,\r\n `user_pass_time` int(10) unsigned NOT NULL,\r\n `user_api_key` varchar(255) NOT NULL,\r\n `user_stats202_app_key` varchar(255) NOT NULL,\r\n `user_last_login_ip_id` bigint(20) unsigned NOT NULL,\r\n `clickserver_api_key` varchar(255) NOT NULL,\r\n `install_hash` varchar(255) NOT NULL,\r\n `user_hash` varchar(255) NOT NULL,\r\n `modal_status` int(1) NOT NULL,\r\n `vip_perks_status` int(1) NOT NULL,\r\n PRIMARY KEY (`user_id`),\r\n KEY `user_name` (`user_name`,`user_pass`),\r\n KEY `user_pass_key` (`user_pass_key`(5)),\r\n KEY `user_last_login_ip_id` (`user_last_login_ip_id`)\r\n) ENGINE=InnoDB ;\r\n";
$result = _mysqli_query($sql);
//create users table
$sql = "CREATE TABLE IF NOT EXISTS `202_users_pref` (\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `user_pref_limit` tinyint(3) unsigned NOT NULL DEFAULT '50',\r\n `user_pref_show` varchar(25) NOT NULL,\r\n `user_pref_time_from` int(10) unsigned NOT NULL,\r\n `user_pref_time_to` int(10) unsigned NOT NULL,\r\n `user_pref_time_predefined` varchar(25) NOT NULL DEFAULT 'today',\r\n `user_pref_adv` tinyint(1) NOT NULL,\r\n `user_pref_ppc_network_id` mediumint(8) unsigned NOT NULL,\r\n `user_pref_ppc_account_id` mediumint(8) unsigned NOT NULL,\r\n `user_pref_aff_network_id` mediumint(8) unsigned NOT NULL,\r\n `user_pref_aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n `user_pref_text_ad_id` mediumint(8) unsigned NOT NULL,\r\n `user_pref_method_of_promotion` varchar(25) NOT NULL,\r\n `user_pref_landing_page_id` mediumint(8) unsigned NOT NULL,\r\n `user_pref_country_id` tinyint(3) unsigned NOT NULL,\r\n `user_pref_region_id` tinyint(3) unsigned NOT NULL,\r\n `user_pref_device_id` tinyint(3) unsigned NOT NULL,\r\n `user_pref_browser_id` tinyint(3) unsigned NOT NULL,\r\n `user_pref_platform_id` tinyint(3) unsigned NOT NULL,\r\n `user_pref_isp_id` tinyint(3) unsigned NOT NULL,\r\n `user_pref_ip` varchar(100) NOT NULL,\r\n `user_pref_referer` varchar(100) NOT NULL,\r\n `user_pref_keyword` varchar(100) NOT NULL,\r\n `user_pref_breakdown` varchar(100) NOT NULL DEFAULT 'day',\r\n `user_pref_chart` varchar(255) NOT NULL DEFAULT 'net',\r\n `user_cpc_or_cpv` char(3) NOT NULL DEFAULT 'cpc',\r\n `user_keyword_searched_or_bidded` varchar(255) NOT NULL DEFAULT 'searched',\r\n `user_tracking_domain` varchar(255) NOT NULL DEFAULT '',\r\n `user_pref_group_2` tinyint(3) NOT NULL,\r\n `user_pref_group_3` tinyint(3) NOT NULL,\r\n `user_pref_group_4` tinyint(3) NOT NULL,\r\n `user_pref_group_1` tinyint(3) NOT NULL,\r\n `cache_time` VARCHAR(4) NOT NULL DEFAULT '0',\r\n `cb_key` VARCHAR(250) NOT NULL,\r\n `cb_verified` tinyint(1) NOT NULL default '0',\r\n `maxmind_isp` tinyint(1) NOT NULL default '0',\r\n `user_daily_email` char(2) NOT NULL DEFAULT '07',\r\n PRIMARY KEY (`user_id`)\r\n) ENGINE=InnoDB ;\r\n";
$result = _mysqli_query($sql);
//create clicks_tracking table
$sql = "CREATE TABLE IF NOT EXISTS `202_clicks_tracking` (\r\n\t\t\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t\t\t `c1_id` bigint(20) NOT NULL,\r\n\t\t\t\t `c2_id` bigint(20) NOT NULL,\r\n\t\t\t\t `c3_id` bigint(20) NOT NULL,\r\n\t\t\t\t `c4_id` bigint(20) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`click_id`)\r\n\t\t\t\t) ENGINE=InnoDB \r\n\t\t";
$result = _mysqli_query($sql);
//create c1 table
$sql = "CREATE TABLE IF NOT EXISTS `202_tracking_c1` (\r\n\t\t `c1_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `c1` varchar(50) NOT NULL,\r\n\t\t PRIMARY KEY (`c1_id`)\r\n\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ;\r\n\t\t";
$result = _mysqli_query($sql);
//create c2 table
$sql = "CREATE TABLE IF NOT EXISTS `202_tracking_c2` (\r\n\t\t `c2_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `c2` varchar(50) NOT NULL,\r\n\t\t PRIMARY KEY (`c2_id`)\r\n\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ;\r\n\t\t";
$result = _mysqli_query($sql);
//create c3 table
$sql = "CREATE TABLE IF NOT EXISTS `202_tracking_c3` (\r\n\t\t `c3_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `c3` varchar(50) NOT NULL,\r\n\t\t PRIMARY KEY (`c3_id`)\r\n\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ;\r\n\t\t";
$result = _mysqli_query($sql);
//create c4 table
$sql = "CREATE TABLE IF NOT EXISTS `202_tracking_c4` (\r\n\t\t `c4_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `c4` varchar(50) NOT NULL,\r\n\t\t PRIMARY KEY (`c4_id`)\r\n\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 ;\r\n\t\t";
$result = _mysqli_query($sql);
//export202 - information schema
$sql = " CREATE TABLE IF NOT EXISTS `202_export_adgroups` (\r\n\t\t\t\t `export_session_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_adgroup_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `export_adgroup_name` varchar(255) NOT NULL,\r\n\t\t\t\t `export_adgroup_status` tinyint(1) NOT NULL,\r\n\t\t\t\t `export_adgroup_max_search_cpc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `export_adgroup_max_content_cpc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `export_adgroup_search` tinyint(1) NOT NULL,\r\n\t\t\t\t `export_adgroup_content` tinyint(1) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`export_adgroup_id`),\r\n\t\t\t\t KEY `export_campaign_id` (`export_campaign_id`),\r\n\t\t\t\t KEY `export_session_id` (`export_session_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_export_campaigns` (\r\n\t\t\t\t `export_session_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_campaign_id` mediumint(9) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `export_campaign_name` varchar(255) NOT NULL,\r\n\t\t\t\t `export_campaign_status` tinyint(1) NOT NULL,\r\n\t\t\t\t `export_campaign_daily_budget` decimal(10,2) unsigned NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`export_campaign_id`),\r\n\t\t\t\t KEY `export_session_id` (`export_session_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_export_keywords` (\r\n\t\t\t\t `export_session_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_adgroup_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_keyword_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `export_keyword_status` tinyint(1) NOT NULL,\r\n\t\t\t\t `export_keyword` varchar(255) NOT NULL,\r\n\t\t\t\t `export_keyword_match` varchar(10) NOT NULL,\r\n\t\t\t\t `export_keyword_watchlist` tinyint(1) NOT NULL,\r\n\t\t\t\t `export_keyword_max_cpc` decimal(10,2) NOT NULL,\r\n\t\t\t\t `export_keyword_destination_url` varchar(255) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`export_keyword_id`),\r\n\t\t\t\t KEY `export_session_id` (`export_session_id`),\r\n\t\t\t\t KEY `export_campaign_id` (`export_campaign_id`),\r\n\t\t\t\t KEY `export_adgroup_id` (`export_adgroup_id`),\r\n\t\t\t\t KEY `export_keyword_match` (`export_keyword_match`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_export_sessions` (\r\n\t\t\t\t `export_session_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `export_session_id_public` varchar(255) NOT NULL,\r\n\t\t\t\t `export_session_time` int(10) unsigned NOT NULL,\r\n\t\t\t\t `export_session_ip` varchar(255) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`export_session_id`),\r\n\t\t\t\t KEY `session_id_public` (`export_session_id_public`(5))\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_export_textads` (\r\n\t\t\t\t `export_session_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_adgroup_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `export_textad_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `export_textad_name` varchar(255) NOT NULL,\r\n\t\t\t\t `export_textad_title` varchar(255) NOT NULL,\r\n\t\t\t\t `export_textad_description_full` varchar(255) NOT NULL,\r\n\t\t\t\t `export_textad_description_line1` varchar(255) NOT NULL,\r\n\t\t\t\t `export_textad_description_line2` varchar(255) NOT NULL,\r\n\t\t\t\t `export_textad_display_url` varchar(255) NOT NULL,\r\n\t\t\t\t `export_textad_destination_url` varchar(255) NOT NULL,\r\n\t\t\t\t `export_textad_status` tinyint(1) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`export_textad_id`),\r\n\t\t\t\t KEY `export_session_id` (`export_session_id`),\r\n\t\t\t\t KEY `export_campaign_id` (`export_campaign_id`),\r\n\t\t\t\t KEY `export_adgroup_id` (`export_adgroup_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//tracking202 schema
$sql = "CREATE TABLE IF NOT EXISTS `202_aff_campaigns` (\r\n\t\t\t\t `aff_campaign_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `aff_campaign_id_public` int(10) unsigned NOT NULL,\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `aff_network_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `aff_campaign_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n\t\t\t\t `aff_campaign_name` varchar(50) NOT NULL,\r\n\t\t\t\t `aff_campaign_url` text NOT NULL,\r\n\t\t\t\t `aff_campaign_url_2` text NOT NULL,\r\n\t\t\t\t `aff_campaign_url_3` text NOT NULL,\r\n\t\t\t\t `aff_campaign_url_4` text NOT NULL,\r\n\t\t\t\t `aff_campaign_url_5` text NOT NULL,\r\n\t\t\t\t `aff_campaign_payout` decimal(5,2) NOT NULL,\r\n\t\t\t\t `aff_campaign_cloaking` tinyint(1) NOT NULL DEFAULT '0',\r\n\t\t\t\t `aff_campaign_time` int(10) unsigned NOT NULL,\r\n\t\t\t\t `aff_campaign_rotate` tinyint(1) NOT NULL DEFAULT '0',\r\n\t\t\t\t PRIMARY KEY (`aff_campaign_id`),\r\n\t\t\t\t KEY `aff_network_id` (`aff_network_id`),\r\n\t\t\t\t KEY `aff_campaign_deleted` (`aff_campaign_deleted`),\r\n\t\t\t\t KEY `user_id` (`user_id`),\r\n\t\t\t\t KEY `aff_campaign_name` (`aff_campaign_name`(5)),\r\n\t\t\t\t KEY `aff_campaign_id_public` (`aff_campaign_id_public`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_aff_networks` (\r\n `aff_network_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `aff_network_name` varchar(50) NOT NULL,\r\n `aff_network_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `aff_network_time` int(10) unsigned NOT NULL,\r\n PRIMARY KEY (`aff_network_id`),\r\n KEY `user_id` (`user_id`),\r\n KEY `aff_network_deleted` (`aff_network_deleted`),\r\n KEY `aff_network_name` (`aff_network_name`(5))\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_browsers` (\r\n `browser_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n `browser_name` varchar(50) NOT NULL,\r\n PRIMARY KEY (`browser_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_charts` (\r\n `chart_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n `chart_xml` mediumtext NOT NULL,\r\n PRIMARY KEY (`chart_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//this is partitioned from 2012-01-01 to 2014-12-31 for mysql 5.1 users
//create the click table
$sql = "CREATE TABLE `202_clicks` (\r\n\t\t `click_id` bigint(20) unsigned NOT NULL,\r\n\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t `landing_page_id` mediumint(8) unsigned NOT NULL,\r\n\t\t `ppc_account_id` mediumint(8) unsigned NOT NULL,\r\n\t\t `click_cpc` decimal(7,5) NOT NULL,\r\n\t\t `click_payout` decimal(10,5) NOT NULL,\r\n\t\t `click_lead` tinyint(1) NOT NULL DEFAULT '0',\r\n\t\t `click_filtered` tinyint(1) NOT NULL DEFAULT '0',\r\n\t\t `click_bot` tinyint(1) NOT NULL DEFAULT '0',\r\n\t\t `click_alp` tinyint(1) NOT NULL DEFAULT '0',\r\n\t\t `click_time` int(10) unsigned NOT NULL,\r\n\t\t `rotator_id` int(10) unsigned NOT NULL,\r\n\t\t `rule_id` int(10) unsigned NOT NULL,\r\n\t\t KEY `aff_campaign_id` (`aff_campaign_id`),\r\n\t\t KEY `ppc_account_id` (`ppc_account_id`),\r\n\t\t KEY `click_lead` (`click_lead`),\r\n\t\t KEY `click_filtered` (`click_filtered`),\r\n\t\t KEY `click_id` (`click_id`),\r\n\t\t KEY `overview_index` (`user_id`,`click_filtered`,`aff_campaign_id`,`ppc_account_id`),\r\n\t\t KEY `user_id` (`user_id`,`click_lead`),\r\n\t\t KEY `click_alp` (`click_alp`),\r\n\t\t KEY `landing_page_id` (`landing_page_id`),\r\n\t\t KEY `overview_index2` (`user_id`,`click_filtered`,`landing_page_id`,`aff_campaign_id`),\r\n\t\t KEY `rotator_id` (`rotator_id`)\r\n\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
//run the alter table to setup partioning if they have mysql 5.1 or greater
$sql = "/*!50100 ALTER TABLE `202_clicks`\r\n\t\t\t\t\tPARTITION BY RANGE (click_time) (\r\n\t\t\t\t\tPARTITION p32 VALUES LESS THAN (1326578400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p33 VALUES LESS THAN (1327788000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p34 VALUES LESS THAN (1328997600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p35 VALUES LESS THAN (1330207200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p36 VALUES LESS THAN (1331416800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p37 VALUES LESS THAN (1332626400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p38 VALUES LESS THAN (1333832400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p39 VALUES LESS THAN (1335042000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p40 VALUES LESS THAN (1336251600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p41 VALUES LESS THAN (1337461200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p42 VALUES LESS THAN (1338670800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p43 VALUES LESS THAN (1339880400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p44 VALUES LESS THAN (1341090000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p45 VALUES LESS THAN (1342299600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p46 VALUES LESS THAN (1343509200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p47 VALUES LESS THAN (1344718800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p48 VALUES LESS THAN (1345928400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p49 VALUES LESS THAN (1347138000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p50 VALUES LESS THAN (1348347600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p51 VALUES LESS THAN (1349557200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p52 VALUES LESS THAN (1350766800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p53 VALUES LESS THAN (1351980000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p54 VALUES LESS THAN (1353189600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p55 VALUES LESS THAN (1354399200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p56 VALUES LESS THAN (1355608800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p57 VALUES LESS THAN (1356818400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p58 VALUES LESS THAN (1358028000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p59 VALUES LESS THAN (1359237600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p60 VALUES LESS THAN (1360447200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p70 VALUES LESS THAN (1361656800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p71 VALUES LESS THAN (1362866400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p72 VALUES LESS THAN (1364076000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p73 VALUES LESS THAN (1365282000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p74 VALUES LESS THAN (1366491600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p75 VALUES LESS THAN (1367701200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p76 VALUES LESS THAN (1368910800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p77 VALUES LESS THAN (1370120400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p78 VALUES LESS THAN (1371330000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p79 VALUES LESS THAN (1372539600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p80 VALUES LESS THAN (1373749200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p81 VALUES LESS THAN (1374958800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p82 VALUES LESS THAN (1376168400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p83 VALUES LESS THAN (1377378000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p84 VALUES LESS THAN (1378587600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p85 VALUES LESS THAN (1379797200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p86 VALUES LESS THAN (1381006800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p87 VALUES LESS THAN (1382216400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p88 VALUES LESS THAN (1383429600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p89 VALUES LESS THAN (1384639200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p90 VALUES LESS THAN (1385848800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p91 VALUES LESS THAN (1387058400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p92 VALUES LESS THAN (1388268000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p93 VALUES LESS THAN (1389477600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p94 VALUES LESS THAN (1390687200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p95 VALUES LESS THAN (1391896800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p96 VALUES LESS THAN (1393106400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p97 VALUES LESS THAN (1394316000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p98 VALUES LESS THAN (1395525600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p99 VALUES LESS THAN (1396731600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p100 VALUES LESS THAN (1397941200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p101 VALUES LESS THAN (1399150800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p102 VALUES LESS THAN (1400360400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p103 VALUES LESS THAN (1401570000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p104 VALUES LESS THAN (1402779600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p105 VALUES LESS THAN (1403989200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p106 VALUES LESS THAN (1405198800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p107 VALUES LESS THAN (1406408400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p108 VALUES LESS THAN (1407618000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p109 VALUES LESS THAN (1408827600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p110 VALUES LESS THAN (1410037200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p111 VALUES LESS THAN (1411246800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p112 VALUES LESS THAN (1412456400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p113 VALUES LESS THAN (1413666000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p114 VALUES LESS THAN (1414879200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p115 VALUES LESS THAN (1416088800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p116 VALUES LESS THAN (1417298400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p117 VALUES LESS THAN (1418508000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p118 VALUES LESS THAN (1419717600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p119 VALUES LESS THAN (1420927200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p120 VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */;";
$result = $db->query($sql);
#don't throw error if the partitioning doesn't work
$sql = "CREATE TABLE IF NOT EXISTS `202_clicks_advance` (\r\n `click_id` bigint(20) unsigned NOT NULL,\r\n `text_ad_id` mediumint(8) unsigned NOT NULL,\r\n `keyword_id` bigint(20) unsigned NOT NULL,\r\n `ip_id` bigint(20) unsigned NOT NULL,\r\n `country_id` bigint(20) unsigned NOT NULL,\r\n `region_id` bigint(20) unsigned NOT NULL,\r\n `city_id` bigint(20) unsigned NOT NULL,\r\n `platform_id` bigint(20) unsigned NOT NULL,\r\n `browser_id` bigint(20) unsigned NOT NULL,\r\n `device_id` bigint(20) unsigned NOT NULL,\r\n `isp_id` bigint(20) unsigned NOT NULL,\r\n PRIMARY KEY (`click_id`),\r\n KEY `text_ad_id` (`text_ad_id`),\r\n KEY `keyword_id` (`keyword_id`),\r\n KEY `ip_id` (`ip_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_clicks_counter` (\r\n `click_id` bigint(20) unsigned NOT NULL auto_increment,\r\n PRIMARY KEY (`click_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_clicks_record` (\r\n `click_id` bigint(20) unsigned NOT NULL,\r\n `click_id_public` bigint(20) unsigned NOT NULL,\r\n `click_cloaking` tinyint(1) NOT NULL default '0',\r\n `click_in` tinyint(1) NOT NULL default '0',\r\n `click_out` tinyint(1) NOT NULL default '0',\r\n `click_reviewed` tinyint(1) NOT NULL default '0',\r\n PRIMARY KEY (`click_id`),\r\n KEY `click_id_public` (`click_id_public`),\r\n KEY `click_in` (`click_in`),\r\n KEY `click_out` (`click_out`),\r\n KEY `click_cloak` (`click_cloaking`),\r\n KEY `click_reviewed` (`click_reviewed`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_clicks_site` (\r\n `click_id` bigint(20) unsigned NOT NULL,\r\n `click_referer_site_url_id` bigint(20) unsigned NOT NULL,\r\n `click_landing_site_url_id` bigint(20) unsigned NOT NULL,\r\n `click_outbound_site_url_id` bigint(20) unsigned NOT NULL,\r\n `click_cloaking_site_url_id` bigint(20) unsigned NOT NULL,\r\n `click_redirect_site_url_id` bigint(20) unsigned NOT NULL,\r\n PRIMARY KEY (`click_id`),\r\n KEY `click_referer_site_url_id` (`click_referer_site_url_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_clicks_spy` (\r\n `click_id` bigint(20) unsigned NOT NULL,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n `landing_page_id` mediumint(8) unsigned NOT NULL,\r\n `ppc_account_id` mediumint(8) unsigned NOT NULL,\r\n `click_cpc` decimal(4,2) NOT NULL,\r\n `click_payout` decimal(6,2) NOT NULL,\r\n `click_lead` tinyint(1) NOT NULL default '0',\r\n `click_filtered` tinyint(1) NOT NULL default '0',\r\n `click_bot` tinyint(1) NOT NULL default '0',\r\n `click_alp` tinyint(1) NOT NULL default '0',\r\n `click_time` int(10) unsigned NOT NULL, \r\n KEY `ppc_account_id` (`ppc_account_id`),\r\n KEY `click_lead` (`click_lead`),\r\n KEY `click_filtered` (`click_filtered`),\r\n KEY `click_id` (`click_id`),\r\n KEY `aff_campaign_id` (`aff_campaign_id`),\r\n KEY `overview_index` (`user_id`,`click_filtered`,`aff_campaign_id`,`ppc_account_id`,`click_lead`),\r\n KEY `user_lead` (`user_id`,`click_lead`),\r\n KEY `click_alp` (`click_alp`),\r\n KEY `landing_page_id` (`landing_page_id`),\r\n KEY `overview_index2` (`user_id`,`click_filtered`,`landing_page_id`,`aff_campaign_id`),\r\n INDEX (click_id)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_delayed_sqls` (\r\n `delayed_sql` text NOT NULL,\r\n `delayed_time` int(10) unsigned NOT NULL\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_ips` (\r\n `ip_id` bigint(20) unsigned NOT NULL auto_increment,\r\n `ip_address` varchar(15) NOT NULL,\r\n `location_id` mediumint(8) unsigned NOT NULL,\r\n PRIMARY KEY (`ip_id`),\r\n KEY `ip_address` (`ip_address`),\r\n KEY `location_id` (`location_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_keywords` (\r\n `keyword_id` bigint(20) unsigned NOT NULL auto_increment,\r\n `keyword` varchar(50) NOT NULL,\r\n PRIMARY KEY (`keyword_id`),\r\n KEY `keyword` (`keyword`(10))\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_landing_pages` (\r\n `landing_page_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `landing_page_id_public` int(10) unsigned NOT NULL,\r\n `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n `landing_page_nickname` varchar(50) NOT NULL,\r\n `landing_page_url` varchar(255) NOT NULL,\r\n `landing_page_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `landing_page_time` int(10) unsigned NOT NULL,\r\n `landing_page_type` tinyint(1) NOT NULL DEFAULT '0',\r\n PRIMARY KEY (`landing_page_id`),\r\n KEY `landing_page_id_public` (`landing_page_id_public`),\r\n KEY `aff_campaign_id` (`aff_campaign_id`),\r\n KEY `landing_page_deleted` (`landing_page_deleted`),\r\n KEY `user_id` (`user_id`),\r\n KEY `landing_page_type` (`landing_page_type`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "\r\nCREATE TABLE IF NOT EXISTS `202_last_ips` (\r\n `user_id` mediumint(9) NOT NULL,\r\n `ip_id` bigint(20) NOT NULL,\r\n `time` int(10) unsigned NOT NULL,\r\n KEY `ip_index` (`user_id`,`ip_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_locations_city` (\r\n `city_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n `main_country_id` mediumint(8) unsigned NOT NULL,\r\n `city_name` varchar(50) NOT NULL,\r\n PRIMARY KEY (`city_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_locations_country` (\r\n `country_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n `country_code` varchar(3) NOT NULL,\r\n `country_name` varchar(50) NOT NULL,\r\n PRIMARY KEY (`country_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_locations_region` (\r\n `region_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n `main_country_id` mediumint(8) unsigned NOT NULL,\r\n `region_name` varchar(50) NOT NULL,\r\n PRIMARY KEY (`region_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_locations_isp` (\r\n\t `isp_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t `isp_name` varchar(50) NOT NULL DEFAULT '',\r\n\t PRIMARY KEY (`isp_id`)\r\n\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_platforms` (\r\n `platform_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n `platform_name` varchar(50) NOT NULL,\r\n PRIMARY KEY (`platform_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_device_types` (\r\n `type_id` tinyint(1) unsigned NOT NULL,\r\n `type_name` varchar(50) NOT NULL,\r\n PRIMARY KEY (`type_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_device_models` (\r\n\t\t `device_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `device_name` varchar(50) NOT NULL,\r\n\t\t `device_type` tinyint(1) NOT NULL,\r\n\t\t PRIMARY KEY (`device_id`)\r\n\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_ppc_accounts` (\r\n `ppc_account_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `ppc_network_id` mediumint(8) unsigned NOT NULL,\r\n `ppc_account_name` varchar(50) NOT NULL,\r\n `ppc_account_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `ppc_account_time` int(10) unsigned NOT NULL,\r\n PRIMARY KEY (`ppc_account_id`),\r\n KEY `ppc_network_id` (`ppc_network_id`),\r\n KEY `ppc_account_deleted` (`ppc_account_deleted`),\r\n KEY `user_id` (`user_id`),\r\n KEY `ppc_account_name` (`ppc_account_name`(5))\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_ppc_networks` (\r\n `ppc_network_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `ppc_network_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `ppc_network_name` varchar(50) NOT NULL,\r\n `ppc_network_time` int(10) unsigned NOT NULL,\r\n PRIMARY KEY (`ppc_network_id`),\r\n KEY `user_id` (`user_id`),\r\n KEY `ppc_network_deleted` (`ppc_network_deleted`),\r\n KEY `ppc_network_name` (`ppc_network_name`(5))\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_site_domains` (\r\n `site_domain_id` bigint(20) unsigned NOT NULL auto_increment,\r\n `site_domain_host` varchar(100) NOT NULL,\r\n PRIMARY KEY (`site_domain_id`),\r\n KEY `site_domain_host` (`site_domain_host`(10))\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_site_urls` (\r\n `site_url_id` bigint(20) unsigned NOT NULL auto_increment,\r\n `site_domain_id` bigint(20) unsigned NOT NULL,\r\n `site_url_address` text NOT NULL,\r\n PRIMARY KEY (`site_url_id`),\r\n KEY `site_domain_id` (`site_domain_id`),\r\n KEY `site_url_address` (`site_url_address`(75))\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_sort_breakdowns` (\r\n\t\t `sort_breakdown_id` int(10) unsigned NOT NULL auto_increment,\r\n\t\t `sort_breakdown_from` int(10) unsigned NOT NULL,\r\n\t\t `sort_breakdown_to` int(10) unsigned NOT NULL,\r\n\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t `sort_breakdown_clicks` mediumint(8) unsigned NOT NULL,\r\n\t\t `sort_breakdown_click_throughs` mediumint(8) unsigned NOT NULL,\r\n\t\t `sort_breakdown_ctr` decimal(10,2) NOT NULL,\r\n\t\t `sort_breakdown_leads` mediumint(8) unsigned NOT NULL,\r\n\t\t `sort_breakdown_su_ratio` decimal(10,2) NOT NULL,\r\n\t\t `sort_breakdown_payout` decimal(6,2) NOT NULL,\r\n\t\t `sort_breakdown_epc` decimal(10,2) NOT NULL,\r\n\t\t `sort_breakdown_avg_cpc` decimal(7,5) NOT NULL,\r\n\t\t `sort_breakdown_income` decimal(10,2) NOT NULL,\r\n\t\t `sort_breakdown_cost` decimal(13,5) NOT NULL,\r\n\t\t `sort_breakdown_net` decimal(13,5) NOT NULL,\r\n\t\t `sort_breakdown_roi` decimal(10,2) NOT NULL,\r\n\t\t PRIMARY KEY (`sort_breakdown_id`),\r\n\t\t KEY `user_id` (`user_id`),\r\n\t\t KEY `sort_keyword_clicks` (`sort_breakdown_clicks`),\r\n\t\t KEY `sort_breakdown_click_throughs` (`sort_breakdown_click_throughs`),\r\n\t\t KEY `sort_breakdown_ctr` (`sort_breakdown_ctr`),\r\n\t\t KEY `sort_keyword_leads` (`sort_breakdown_leads`),\r\n\t\t KEY `sort_keyword_signup_ratio` (`sort_breakdown_su_ratio`),\r\n\t\t KEY `sort_keyword_payout` (`sort_breakdown_payout`),\r\n\t\t KEY `sort_keyword_epc` (`sort_breakdown_epc`),\r\n\t\t KEY `sort_keyword_cpc` (`sort_breakdown_avg_cpc`),\r\n\t\t KEY `sort_keyword_income` (`sort_breakdown_income`),\r\n\t\t KEY `sort_keyword_cost` (`sort_breakdown_cost`),\r\n\t\t KEY `sort_keyword_net` (`sort_breakdown_net`),\r\n\t\t KEY `sort_keyword_roi` (`sort_breakdown_roi`)\r\n\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
//this is partitioned from 2009-07-01 to 2011-07-01 for mysql 5.1 users
$sql = "CREATE TABLE IF NOT EXISTS `202_summary_overview` (\r\n\t\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `aff_campaign_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 `ppc_account_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t\t `click_time` int(10) unsigned NOT NULL,\r\n\t\t\t\t KEY `aff_campaign_id` (`aff_campaign_id`),\r\n\t\t\t\t KEY `user_id` (`user_id`),\r\n\t\t\t\t KEY `ppc_account_id` (`ppc_account_id`),\r\n\t\t\t\t KEY `landing_page_id` (`landing_page_id`),\r\n\t\t\t\t KEY `click_time` (`click_time`)\r\n\t\t\t\t) ENGINE=InnoDB ";
$result = _mysqli_query($sql);
$sql = "/*!50100 ALTER TABLE `202_summary_overview`\r\n\t\t\t\t\tPARTITION BY RANGE (click_time) (\r\n\t\t\t\t\tPARTITION p32 VALUES LESS THAN (1247641200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p33 VALUES LESS THAN (1248850800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p34 VALUES LESS THAN (1250060400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p35 VALUES LESS THAN (1251270000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p36 VALUES LESS THAN (1252479600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p37 VALUES LESS THAN (1253689200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p38 VALUES LESS THAN (1254898800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p39 VALUES LESS THAN (1256108400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p40 VALUES LESS THAN (1257318000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p41 VALUES LESS THAN (1258527600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p42 VALUES LESS THAN (1259737200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p43 VALUES LESS THAN (1260946800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p44 VALUES LESS THAN (1262156400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p45 VALUES LESS THAN (1263366000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p46 VALUES LESS THAN (1264575600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p47 VALUES LESS THAN (1265785200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p48 VALUES LESS THAN (1266994800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p49 VALUES LESS THAN (1268204400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p50 VALUES LESS THAN (1269414000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p51 VALUES LESS THAN (1270623600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p52 VALUES LESS THAN (1271833200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p53 VALUES LESS THAN (1273042800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p54 VALUES LESS THAN (1274252400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p55 VALUES LESS THAN (1275462000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p56 VALUES LESS THAN (1276671600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p57 VALUES LESS THAN (1277881200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p58 VALUES LESS THAN (1279090800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p59 VALUES LESS THAN (1280300400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p60 VALUES LESS THAN (1281510000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p61 VALUES LESS THAN (1282719600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p62 VALUES LESS THAN (1283929200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p63 VALUES LESS THAN (1285138800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p64 VALUES LESS THAN (1286348400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p65 VALUES LESS THAN (1287558000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p66 VALUES LESS THAN (1288767600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p67 VALUES LESS THAN (1289977200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p68 VALUES LESS THAN (1291186800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p69 VALUES LESS THAN (1292396400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p70 VALUES LESS THAN (1293606000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p71 VALUES LESS THAN (1294815600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p72 VALUES LESS THAN (1296025200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p73 VALUES LESS THAN (1297234800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p74 VALUES LESS THAN (1298444400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p75 VALUES LESS THAN (1299654000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p76 VALUES LESS THAN (1300863600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p77 VALUES LESS THAN (1302073200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p78 VALUES LESS THAN (1303282800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p79 VALUES LESS THAN (1304492400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p80 VALUES LESS THAN (1305702000) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p81 VALUES LESS THAN (1306911600) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p82 VALUES LESS THAN (1308121200) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p83 VALUES LESS THAN (1309330800) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p84 VALUES LESS THAN (1310540400) ENGINE = MyISAM,\r\n\t\t\t\t\tPARTITION p85 VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */;";
$result = $db->query($sql);
#dont throw error if this doesn't work
$sql = "CREATE TABLE IF NOT EXISTS `202_text_ads` (\r\n `text_ad_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n `landing_page_id` mediumint(8) unsigned NOT NULL,\r\n `text_ad_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `text_ad_name` varchar(100) NOT NULL,\r\n `text_ad_headline` varchar(100) NOT NULL,\r\n `text_ad_description` varchar(100) NOT NULL,\r\n `text_ad_display_url` varchar(100) NOT NULL,\r\n `text_ad_time` int(10) unsigned NOT NULL,\r\n `text_ad_type` tinyint(1) NOT NULL DEFAULT '0',\r\n PRIMARY KEY (`text_ad_id`),\r\n KEY `aff_campaign_id` (`aff_campaign_id`),\r\n KEY `text_ad_deleted` (`text_ad_deleted`),\r\n KEY `user_id` (`user_id`),\r\n KEY `text_ad_type` (`text_ad_type`),\r\n KEY `landing_page_id` (`landing_page_id`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_trackers` (\r\n `tracker_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `tracker_id_public` bigint(20) unsigned NOT NULL,\r\n `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n `text_ad_id` mediumint(8) unsigned NOT NULL,\r\n `ppc_account_id` mediumint(8) unsigned NOT NULL,\r\n `landing_page_id` mediumint(8) unsigned NOT NULL,\r\n `rotator_id` int(11) unsigned NOT NULL,\r\n `click_cpc` decimal(7,5) NOT NULL,\r\n `click_cloaking` tinyint(1) NOT NULL,\r\n `tracker_time` int(10) unsigned NOT NULL,\r\n PRIMARY KEY (`tracker_id`),\r\n KEY `tracker_id_public` (`tracker_id_public`)\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_rotations` (\r\n\t\t\t `aff_campaign_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `rotation_num` tinyint(4) NOT NULL,\r\n\t\t\t PRIMARY KEY (`aff_campaign_id`)\r\n\t\t\t) ENGINE=MEMORY ;\r\n\t\t\t";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_alerts` (\r\n\t\t\t\t `prosper_alert_id` int(11) NOT NULL,\r\n\t\t\t\t `prosper_alert_seen` tinyint(1) NOT NULL,\r\n\t\t\t\t UNIQUE KEY `prosper_alert_id` (`prosper_alert_id`)\r\n\t\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE IF NOT EXISTS `202_offers` (\r\n\t\t\t `user_id` mediumint(8) unsigned NOT NULL,\r\n\t\t\t `offer_id` mediumint(10) unsigned NOT NULL,\r\n\t\t\t `offer_seen` tinyint(1) NOT NULL DEFAULT '1',\r\n\t\t\t UNIQUE KEY `user_id` (`user_id`,`offer_id`)\r\n\t\t\t) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$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 IF NOT EXISTS `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\t('Image'),\r\n\t\t\t\t('Iframe'),\r\n\t\t\t\t('Javascript'),\r\n\t\t\t\t('Postback'),\r\n\t\t\t\t('Raw');";
$result = _mysqli_query($sql);
$sql = "INSERT IGNORE 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 = "INSERT IGNORE INTO `202_clicks_total` (`click_count`) VALUES\r\n\t\t\t (0);";
$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);
$sql = "CREATE TABLE IF NOT EXISTS `202_api_keys` (\r\n `user_id` mediumint(8) unsigned NOT NULL,\r\n `api_key` varchar(250) NOT NULL DEFAULT '',\r\n `created_at` int(10) NOT NULL\r\n) ENGINE=InnoDB ;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotators` (\r\n `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n `user_id` int(11) NOT NULL,\r\n `name` varchar(255) NOT NULL DEFAULT '',\r\n `default_url` text,\r\n `default_campaign` int(11) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotator_rules` (\r\n `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n `rotator_id` int(11) NOT NULL,\r\n `rule_name` varchar(255) NOT NULL DEFAULT '',\r\n `status` int(11) DEFAULT NULL,\r\n `redirect_url` text,\r\n `redirect_campaign` int(11) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
$sql = "CREATE TABLE `202_rotator_rules_criteria` (\r\n `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n `rotator_id` int(11) NOT NULL,\r\n `rule_id` int(11) NOT NULL,\r\n `type` varchar(50) NOT NULL DEFAULT '',\r\n `statement` varchar(50) NOT NULL DEFAULT '',\r\n `value` text NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$result = _mysqli_query($sql);
}
?>
<li>You have not added any networks.</li>
<?php
}
while ($ppc_network_row = $ppc_network_result->fetch_array(MYSQL_ASSOC)) {
//print out the PPC networks
$html['ppc_network_name'] = htmlentities($ppc_network_row['ppc_network_name'], ENT_QUOTES, 'UTF-8');
$url['ppc_network_id'] = urlencode($ppc_network_row['ppc_network_id']);
printf('<li>%s - <a href="?edit_ppc_network_id=%s">edit</a> - <a href="#" class="upgradeToProNeeded">variables</a> - <a href="?delete_ppc_network_id=%s" onclick="return confirmSubmit(\'Are You Sure You Want To Delete This Traffic Source?\');">remove</a></li>', $html['ppc_network_name'], $url['ppc_network_id'], $url['ppc_network_id']);
?>
<ul style="margin-top: 0px;">
<?php
//print out the individual accounts per each PPC network
$mysql['ppc_network_id'] = $db->real_escape_string($ppc_network_row['ppc_network_id']);
$ppc_account_sql = "SELECT * FROM `202_ppc_accounts` WHERE `ppc_network_id`='" . $mysql['ppc_network_id'] . "' AND `ppc_account_deleted`='0' ORDER BY `ppc_account_name` ASC";
$ppc_account_result = _mysqli_query($ppc_account_sql);
//($ppc_account_sql);
while ($ppc_account_row = $ppc_account_result->fetch_array(MYSQL_ASSOC)) {
$html['ppc_account_name'] = htmlentities($ppc_account_row['ppc_account_name'], ENT_QUOTES, 'UTF-8');
$url['ppc_account_id'] = urlencode($ppc_account_row['ppc_account_id']);
printf('<li>%s - <a href="?edit_ppc_account_id=%s">edit</a> - <a href="?delete_ppc_account_id=%s" onclick="return confirmSubmit(\'Are You Sure You Want To Delete This Account?\');">remove</a></li>', $html['ppc_account_name'], $url['ppc_account_id'], $url['ppc_account_id']);
}
?>
</ul>
<?php
}
?>
</ul>
</div>
</div>
</div>
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
$mysql['prosper_alert_id'] = $db->real_escape_string($_POST['prosper_alert_id']);
$alert_sql = "INSERT INTO 202_alerts SET prosper_alert_seen='1', prosper_alert_id='{$mysql['prosper_alert_id']}'";
$alert_sql = _mysqli_query($alert_sql);
</div>
</div>
<div class="row form_seperator">
<div class="col-xs-12"></div>
</div>
<div class="row account">
<div class="col-xs-12">
<h6>Last 50 Login Attempts</h6>
</div>
<div class="col-xs-12">
<?php
//show the last 20 logins failed or pass
$user_log_sql = "SELECT * FROM 202_users_log ORDER BY login_id DESC LIMIT 50";
$user_log_result = _mysqli_query($user_log_sql);
?>
<table class="table table-bordered">
<thead>
<tr>
<th>Time</th>
<th>Username</th>
<th>IP Address</th>
<th>Attempt</th>
</tr>
</thead>
<tbody>
<?php
while ($user_log_row = $user_log_result->fetch_assoc()) {
$html['user_name'] = htmlentities($user_log_row['user_name'], ENT_QUOTES, 'UTF-8');
