public static function recordLogin()
{
//RECORD THIS USER LOGIN, into user_logs
$mysql['login_server'] = db::escape(serialize($_SERVER));
$mysql['login_session'] = db::escape(serialize($_SESSION));
$mysql['login_error'] = db::escape(serialize($error));
$mysql['ip_address'] = db::escape($_SERVER['REMOTE_ADDR']);
$mysql['login_time'] = time();
if ($error) {
$mysql['login_success'] = 0;
} else {
$mysql['login_success'] = 1;
}
//record everything that happend during this crime scene.
$user_log_sql = "INSERT INTO 202_users_log\r\n\t\t\t\t\t\t\t\t SET user_name='" . $mysql['user_name'] . "',\r\n\t\t\t\t\t\t\t\t\t\tuser_pass='******'user_pass'] . "',\r\n\t\t\t\t\t\t\t\t\t\tip_address='" . $mysql['ip_address'] . "',\r\n\t\t\t\t\t\t\t\t\t\tlogin_time='" . $mysql['login_time'] . "',\r\n\t\t\t\t\t\t\t\t\t\tlogin_success = '" . $mysql['login_success'] . "',\r\n\t\t\t\t\t\t\t\t\t\tlogin_error='" . $mysql['login_error'] . "',\r\n\t\t\t\t\t\t\t\t\t\tlogin_server='" . $mysql['login_server'] . "',\r\n\t\t\t\t\t\t\t\t\t\tlogin_session='" . $mysql['login_session'] . "'";
$user_log_result = mysql_query($user_log_sql) or record_mysql_error($user_log_sql);
if (!$error) {
$ip_id = INDEXES::get_ip_id($_SERVER['HTTP_X_FORWARDED_FOR']);
$mysql['ip_id'] = mysql_real_escape_string($ip_id);
//update this users last login_ip_address
$user_sql = "\tUPDATE \t202_users\r\n SET\t\t\tuser_last_login_ip_id='" . $mysql['ip_id'] . "'\r\n WHERE \tuser_name='" . $mysql['user_name'] . "'\r\n AND \t\tuser_pass='******'user_pass'] . "'";
$user_result = _mysql_query($user_sql);
}
}
$campaigns_sql = "SELECT aff_campaign_id, aff_campaign_name FROM 202_aff_campaigns LEFT JOIN 202_aff_networks using(aff_network_id) WHERE 202_aff_campaigns.user_id = '" . $mysql['user_id'] . "' AND `aff_campaign_deleted`=0 AND `aff_network_deleted`=0 AND 202_aff_networks.user_id = 202_aff_campaigns.user_id";
$campaigns_result = $db->query($campaigns_sql);
$campaigns = array();
if ($campaigns_result->num_rows > 0) {
while ($campaigns_row = $campaigns_result->fetch_assoc()) {
$campaigns[] = array('id' => $campaigns_row['aff_campaign_id'], 'name' => $campaigns_row['aff_campaign_name']);
}
}
if (isset($_POST['get_rotators']) && isset($_POST['rotator_id']) && $_POST['get_rotators'] == true) {
?>
<select class="form-control input-sm" name="tracker_rotator">
<option value=""> -- </option>
<?php
$rotator_sql = "SELECT *\n\t FROM 202_rotators\n\t WHERE user_id='" . $mysql['user_id'] . "'\n\t ORDER BY `id` ASC";
$rotator_result = $db->query($rotator_sql) or record_mysql_error($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');
if ($_POST['rotator_id'] == $rotator_row['id']) {
$selected = 'selected=""';
} else {
$selected = '';
}
printf('<option %s value="%s">%s</option>', $selected, $html['rotator_id'], $html['rotator_name']);
}
?>
</select>
<?php
}
?>
">
<div class="form-group" style="margin-bottom: 7px;">
<div class="col-xs-6 col-xs-offset-5">
<select class="form-control input-sm" name="aff_campaign_id_<?php
echo $count;
?>
" id="aff_campaign_id_<?php
echo $count;
?>
">
<option value="0"> -- </option>
<?php
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$aff_campaign_sql = "SELECT aff_campaign_id, aff_campaign_name, aff_network_name FROM 202_aff_campaigns LEFT JOIN 202_aff_networks USING (aff_network_id) WHERE 202_aff_campaigns.user_id='" . $mysql['user_id'] . "' AND aff_campaign_deleted='0' AND aff_network_deleted=0 ORDER BY aff_network_name ASC";
$aff_campaign_result = $db->query($aff_campaign_sql) or record_mysql_error($aff_campaign_sql);
while ($aff_campaign_row = $aff_campaign_result->fetch_assoc()) {
$html['aff_campaign_id'] = htmlentities($aff_campaign_row['aff_campaign_id'], ENT_QUOTES, 'UTF-8');
$html['aff_campaign_name'] = htmlentities($aff_campaign_row['aff_campaign_name'], ENT_QUOTES, 'UTF-8');
$html['aff_network_name'] = htmlentities($aff_campaign_row['aff_network_name'], ENT_QUOTES, 'UTF-8');
printf('<option value="%s">%s: %s</option>', $html['aff_campaign_id'], $html['aff_network_name'], $html['aff_campaign_name']);
}
?>
</select>
</div>
<div class="col-xs-1 remove-offer-grid">
<span class="fui-cross remove-offer" onclick="remove_new_campaign(<?php
echo $count;
?>
)"></span>
</div>
$mysql['order'] = 'ORDER BY `sort_breakdown_net` ASC';
}
$html['sort_breakdown_roi_order'] = 'sort_breakdown_roi asc';
if ($_POST['order'] == 'sort_breakdown_roi asc') {
$html['sort_breakdown_roi_order'] = 'sort_breakdown_roi desc';
$mysql['order'] = 'ORDER BY `sort_breakdown_roi` DESC';
} elseif ($_POST['order'] == 'sort_breakdown_roi desc') {
$html['sort_breakdown_roi_order'] = 'sort_breakdown_roi asc';
$mysql['order'] = 'ORDER BY `sort_breakdown_roi` ASC';
}
if (empty($mysql['order'])) {
$mysql['order'] = ' ORDER BY sort_breakdown_from ASC';
}
//grab breakdown report
$breakdown_sql = "SELECT * FROM 202_sort_breakdowns WHERE user_id='" . $mysql['user_id'] . "' " . $mysql['order'];
$breakdown_result = mysql_query($breakdown_sql) or record_mysql_error($breakdown_sql);
?>
<table cellpadding="0" cellspacing="1" class="m-stats">
<tr>
<th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<?php
echo $html['sort_breakdown_order'];
?>
');">Time</a></th>
<th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<?php
echo $html['sort_breakdown_clicks_order'];
?>
');">Clicks</a></th>
<th><a class="onclick_color" onclick="loadContent('/ajax/sort_hourly.php','','<?php
echo $html['sort_breakdown_leads_order'];
?>
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/xtracks-app/bootstrap.php';
//get the aff_camapaign_id
$mysql['user_id'] = 1;
//see if it has the cookie, do whatever we can to grab to grab SOMETHING to tie this lead to
if ($_COOKIE['tracking202subid']) {
$mysql['click_id'] = mysql_real_escape_string($_COOKIE['tracking202subid']);
} else {
//ok grab the last click from this ip_id
$mysql['ip_address'] = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
$daysago = time() - 2592000;
// 30 days ago
$click_sql1 = "\tSELECT \t202_clicks.click_id \n\t\t\t\t\tFROM \t\t202_clicks\n\t\t\t\t\tLEFT JOIN\t202_clicks_advance USING (click_id)\n\t\t\t\t\tLEFT JOIN \t202_ips USING (ip_id) \n\t\t\t\t\tWHERE \t202_ips.ip_address='" . $mysql['ip_address'] . "'\n\t\t\t\t\tAND\t\t202_clicks.user_id='" . $mysql['user_id'] . "' \n\t\t\t\t\tAND\t\t202_clicks.click_time >= '" . $daysago . "'\n\t\t\t\t\tORDER BY \t202_clicks.click_id DESC \n\t\t\t\t\tLIMIT \t\t1";
$click_result1 = mysql_query($click_sql1) or record_mysql_error($click_sql1);
$click_row1 = mysql_fetch_assoc($click_result1);
$mysql['click_id'] = mysql_real_escape_string($click_row1['click_id']);
}
if ($mysql['click_id']) {
if ($_GET['amount']) {
$mysql['click_payout'] = mysql_real_escape_string($_GET['amount']);
}
$click_sql = "\tUPDATE \t\t\t\t\t202_clicks \n\t\t\t\t\tSET \t\t\t\t\t\tclick_lead='1', \n\t\t\t\t\t\t\t\t\t\t\t\tclick_filtered='0' ";
if ($mysql['click_payout']) {
$click_sql .= " , \tclick_payout='" . $mysql['click_payout'] . "' ";
}
$click_sql .= "\tWHERE \tclick_id='" . $mysql['click_id'] . "' ";
delay_sql($click_sql);
$click_sql = "\tUPDATE \t\t\t\t\t202_clicks_spy \n\t\t\t\t\tSET \t\t\t\t\t\tclick_lead='1', \n\t\t\t\t\t\t\t\t\t\t\t\tclick_filtered='0' ";
if ($mysql['click_payout']) {
$click_sql .= " , \tclick_payout='" . $mysql['click_payout'] . "' ";
}
$html['sort_referer_roi_order'] = 'sort_referer_roi asc';
if ($_POST['order'] == 'sort_referer_roi asc') {
$html['sort_referer_roi_order'] = 'sort_referer_roi desc';
$mysql['order'] = 'ORDER BY `sort_referer_roi` DESC';
} elseif ($_POST['order'] == 'sort_referer_roi desc') {
$html['sort_referer_roi_order'] = 'sort_referer_roi asc';
$mysql['order'] = 'ORDER BY `sort_referer_roi` ASC';
}
if (empty($mysql['order'])) {
$mysql['order'] = ' ORDER BY sort_referer_clicks DESC';
}
$db_table = '202_sort_referers';
$query = query('SELECT * FROM 202_sort_referers LEFT JOIN 202_site_domains ON (202_sort_referers.referer_id=202_site_domains.site_domain_id)', $db_table, false, false, false, $mysql['order'], $_POST['offset'], true, true);
$referer_sql = $query['click_sql'];
$referer_result = mysql_query($referer_sql) or record_mysql_error($referer_sql);
$html['from'] = htmlentities($query['from'], ENT_QUOTES, 'UTF-8');
$html['to'] = htmlentities($query['to'], ENT_QUOTES, 'UTF-8');
$html['rows'] = htmlentities($query['rows'], ENT_QUOTES, 'UTF-8');
?>
<table cellspacing="0" cellpadding="0" style="width: 100%; font-size: 12px;">
<tr>
<td width="100%;">
<a target="_new" href="/analyze/referers_download.php">
<strong>Download to excel</strong>
<img src="/xtracks-img/icons/16x16/page_white_excel.png" style="margin: 0px 0px -3px 3px;"/>
</a>
</td>
<td>
<li>You have not added any rotator.</li><?php
}
while ($row = $result->fetch_array(MYSQL_ASSOC)) {
$html['name'] = htmlentities($row['name'], ENT_QUOTES, 'UTF-8');
$html['id'] = htmlentities($row['id'], ENT_QUOTES, 'UTF-8');
printf('<li>%s - <a href="?delete_rotator_id=%s">remove</a></li>', $html['name'], $html['id']);
$rule_sql = "SELECT * FROM `202_rotator_rules` WHERE `rotator_id`='" . $row['id'] . "' ORDER BY `id` ASC";
$rule_result = $db->query($rule_sql) or record_mysql_error($rule_sql);
if ($rule_result->num_rows == 0) {
?>
<ul><li>You have not added any rules.</li></ul><?php
} else {
echo "<ul>";
while ($rule_row = $rule_result->fetch_array()) {
$criteria_sql = "SELECT * FROM `202_rotator_rules_criteria` WHERE `rule_id`='" . $rule_row['id'] . "' ORDER BY `id` ASC";
$criteria_result = $db->query($criteria_sql) or record_mysql_error($criteria_sql);
if ($criteria_result->num_rows > 0) {
$criteria = "You have " . $criteria_result->num_rows . " criteria added";
} else {
$criteria = "No criteria added";
}
?>
<li><?php
echo $rule_row['rule_name'] . " - " . $criteria;
?>
(<a href="" id="rule_details" data-id="<?php
echo $rule_row['id'];
?>
" data-toggle="modal" data-target="#rule_values_modal">Details</a>)</li>
<?php
}
<?php include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php'; $mysql['chart_id'] = mysql_real_escape_string($_GET['chart_id']); $chart_sql = "SELECT chart_xml FROM 202_charts WHERE chart_id='" . $mysql['chart_id'] . "'"; $chart_result = mysql_query($chart_sql) or record_mysql_error($chart_sql); $chart_row = mysql_fetch_assoc($chart_result); echo $chart_row['chart_xml'];
}
$html['sort_ip_roi_order'] = 'sort_ip_roi asc';
if ($_POST['order'] == 'sort_ip_roi asc') {
$html['sort_ip_roi_order'] = 'sort_ip_roi desc';
$mysql['order'] = 'ORDER BY `sort_ip_roi` DESC';
} elseif ($_POST['order'] == 'sort_ip_roi desc') {
$html['sort_ip_roi_order'] = 'sort_ip_roi asc';
$mysql['order'] = 'ORDER BY `sort_ip_roi` ASC';
}
if (empty($mysql['order'])) {
$mysql['order'] = ' ORDER BY sort_ip_clicks DESC';
}
$db_table = '202_sort_ips';
$query = query('SELECT * FROM 202_sort_ips LEFT JOIN 202_ips USING (ip_id)', $db_table, false, false, false, $mysql['order'], $_POST['offset'], true, true);
$ip_sql = $query['click_sql'];
$ip_result = mysql_query($ip_sql) or record_mysql_error($ip_sql);
$html['from'] = htmlentities($query['from'], ENT_QUOTES, 'UTF-8');
$html['to'] = htmlentities($query['to'], ENT_QUOTES, 'UTF-8');
$html['rows'] = htmlentities($query['rows'], ENT_QUOTES, 'UTF-8');
?>
<table cellspacing="0" cellpadding="0" style="width: 100%; font-size: 12px;">
<tr>
<td width="100%;">
<a target="_new" href="/analyze/ips_download.php">
<strong>Download to excel</strong>
<img src="/xtracks-img/icons/16x16/page_white_excel.png" style="margin: 0px 0px -3px 3px;"/>
</a>
</td>
<td>
<?php
$from_day = trim($from[1]);
$from_year = trim($from[2]);
$to = explode('-', $_POST['to']);
$to = explode(':', $to[1]);
$to_hour = $to[0];
$to_minute = $to[1];
$to = explode('-', $_POST['to']);
$to = explode('/', $to[0]);
$to_month = trim($to[0]);
$to_day = trim($to[1]);
$to_year = trim($to[2]);
//if from or to, validate, and if validated, set it accordingly
if ($from != '' and (checkdate($from_month, $from_day, $from_year) == false or ($from_hour < 0 or $from_hour > 59 or !is_numeric($from_hour) or ($from_minute < 0 or $from_minute > 59 or !is_numeric($from_minute))))) {
$error['date'] = '<div class="error">Wrong date format, you must use the following military time format: <strong>mm/dd/yyyy - hh:mms</strong></div>';
} else {
$clean['user_pref_time_from'] = mktime($from_hour, $from_minute, 0, $from_month, $from_day, $from_year);
}
if ($to != '' and (checkdate($to_month, $to_day, $to_year) == false or ($to_hour < 0 or $to_hour > 59 or !is_numeric($to_hour) or ($to_minute < 0 or $to_minute > 59 or !is_numeric($to_minute))))) {
$error['date'] = '<div class="error">Wrong date format, you must use the following military time format: <strong>mm/dd/yyyy - hh:mm</strong></div>';
} else {
$clean['user_pref_time_to'] = mktime($to_hour, $to_minute, 59, $to_month, $to_day, $to_year);
}
}
echo $error['date'] . $error['user_pref_time_predefined'] . $error['user_pref_limit'] . $error['user_pref_show'];
if (!$error) {
$mysql['user_pref_time_predefined'] = mysql_real_escape_string($clean['user_pref_time_predefined']);
$mysql['user_pref_time_from'] = mysql_real_escape_string($clean['user_pref_time_from']);
$mysql['user_pref_time_to'] = mysql_real_escape_string($clean['user_pref_time_to']);
$user_sql = " UPDATE `202_users_pref`\n\t\t\t\t\tSET `user_pref_adv`='" . $mysql['user_pref_adv'] . "',\n\t\t\t\t\t\t\t`user_pref_ppc_network_id`='" . $mysql['user_pref_ppc_network_id'] . "',\n\t\t\t\t\t\t\t`user_pref_ppc_account_id`='" . $mysql['user_pref_ppc_account_id'] . "',\n\t\t\t\t\t\t\t`user_pref_aff_network_id`='" . $mysql['user_pref_aff_network_id'] . "',\n\t\t\t\t\t\t\t`user_pref_aff_campaign_id`='" . $mysql['user_pref_aff_campaign_id'] . "',\n\t\t\t\t\t\t\t`user_pref_text_ad_id`='" . $mysql['user_pref_text_ad_id'] . "',\n\t\t\t\t\t\t\t`user_pref_method_of_promotion`='" . $mysql['user_pref_method_of_promotion'] . "',\n\t\t\t\t\t\t\t`user_pref_landing_page_id`='" . $mysql['user_pref_landing_page_id'] . "',\n\t\t\t\t\t\t\t`user_pref_country_id`='" . $mysql['user_pref_country_id'] . "',\n\t\t\t\t\t\t\t`user_pref_ip`='" . $mysql['user_pref_ip'] . "',\n\t\t\t\t\t\t\t`user_pref_referer`='" . $mysql['user_pref_referer'] . "',\n\t\t\t\t\t\t\t`user_pref_keyword`='" . $mysql['user_pref_keyword'] . "',\n\t\t\t\t\t\t\t`user_pref_limit`='" . $mysql['user_pref_limit'] . "',\n\t\t\t\t\t\t\t`user_pref_show`='" . $mysql['user_pref_show'] . "',\n\t\t\t\t\t\t\t`user_pref_breakdown`='" . $mysql['user_pref_breakdown'] . "',\n\t\t\t\t\t\t\t`user_pref_chart`='" . $mysql['user_pref_chart'] . "',\n\t\t\t\t\t\t\t`user_cpc_or_cpv`='" . $mysql['user_cpc_or_cpv'] . "',\n\t\t\t\t\t\t\t`user_pref_time_predefined`='" . $mysql['user_pref_time_predefined'] . "',\n\t\t\t\t\t\t\t`user_pref_time_from`='" . $mysql['user_pref_time_from'] . "',\n\t\t\t\t\t\t\t`user_pref_time_to`='" . $mysql['user_pref_time_to'] . "',\n\t\t\t\t\t\t\t`user_pref_group_1`='" . $mysql['user_pref_group_1'] . "',\n\t\t\t\t\t\t\t`user_pref_group_2`='" . $mysql['user_pref_group_2'] . "',\n\t\t\t\t\t\t\t`user_pref_group_3`='" . $mysql['user_pref_group_3'] . "',\n\t\t\t\t\t\t\t`user_pref_group_4`='" . $mysql['user_pref_group_4'] . "'\n\t\t\t\t\tWHERE `user_id`='" . $mysql['user_id'] . "'";
$user_result = mysql_query($user_sql) or record_mysql_error($user_sql);
}
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
?>
<select class="form-control input-sm" name="platform_id" id="platform_id">
<option value="0"> -- </option>
<?php
$platform_sql = "SELECT *\n FROM 202_platforms\n GROUP BY `platform_name` ORDER BY `platform_name` ASC";
$platform_result = $db->query($platform_sql) or record_mysql_error($platform_sql);
while ($platform_row = $platform_result->fetch_array(MYSQL_ASSOC)) {
$html['platform_name'] = htmlentities($platform_row['platform_name'], ENT_QUOTES, 'UTF-8');
$html['platform_id'] = htmlentities($platform_row['platform_id'], ENT_QUOTES, 'UTF-8');
if ($_POST['platform_id'] == $platform_row['platform_id']) {
$selected = 'selected=""';
} else {
$selected = '';
}
printf('<option %s value="%s">%s</option>', $selected, $html['platform_id'], $html['platform_name']);
}
?>
</select>
printf('<li>%s</li>', $html['aff_network_name']);
?>
<ul style="margin-top: 0px;"><?php
//print out the individual accounts per each PPC network
$mysql['aff_network_id'] = mysql_real_escape_string($aff_network_row['aff_network_id']);
$aff_campaign_sql = "\n\t\t\t\t\t\t SELECT *\n\t\t\t\t\t\t FROM `202_aff_campaigns`\n\t\t\t\t\t\t WHERE `aff_network_id`='" . $mysql['aff_network_id'] . "'\n\t\t\t\t\t\t AND `aff_campaign_deleted`='0'\n\t\t\t\t\t\t ORDER BY `aff_campaign_name` ASC\n\t\t\t\t\t\t";
$aff_campaign_result = mysql_query($aff_campaign_sql) or record_mysql_error($aff_campaign_sql);
while ($aff_campaign_row = mysql_fetch_array($aff_campaign_result, MYSQL_ASSOC)) {
$html['aff_campaign_name'] = htmlentities($aff_campaign_row['aff_campaign_name'], ENT_QUOTES, 'UTF-8');
$html['aff_campaign_payout'] = htmlentities($aff_campaign_row['aff_campaign_payout'], ENT_QUOTES, 'UTF-8');
printf('<li>%s · $%s</li>', $html['aff_campaign_name'], $html['aff_campaign_payout']);
?>
<ul style="margin-top: 0px;"><?php
$mysql['aff_campaign_id'] = mysql_real_escape_string($aff_campaign_row['aff_campaign_id']);
$landing_page_sql = "\n\t\t\t\t\t\t\t\t SELECT *\n\t\t\t\t\t\t\t\t FROM `202_landing_pages`\n\t\t\t\t\t\t\t\t WHERE `aff_campaign_id`='" . $mysql['aff_campaign_id'] . "'\n\t\t\t\t\t\t\t\t AND `landing_page_deleted`='0'\n\t\t\t\t\t\t\t\t AND landing_page_type='0'\n\t\t\t\t\t\t\t\t";
$landing_page_result = mysql_query($landing_page_sql) or record_mysql_error($landing_page_sql);
while ($landing_page_row = mysql_fetch_array($landing_page_result, MYSQL_ASSOC)) {
$html['landing_page_nickname'] = htmlentities($landing_page_row['landing_page_nickname'], ENT_QUOTES, 'UTF-8');
$html['landing_page_id'] = htmlentities($landing_page_row['landing_page_id'], ENT_QUOTES, 'UTF-8');
printf('<li>%s - <a href="?edit_landing_page_id=%s" style="font-size: 9px;">edit</a> - <a href="?delete_landing_page_id=%s" style="font-size: 9px;">remove</a></li>', $html['landing_page_nickname'], $html['landing_page_id'], $html['landing_page_id']);
}
?>
</ul><?php
}
?>
</ul><?php
}
?>
</ul>
</td>
</tr>
function Run1MinCronjob()
{
//check to run the 1minute cronjob, change this to every minute
$now = 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_minute = ceil($today_minute / 1);
$today_minute = $today_minute * 1;
if ($today_minute == 60) {
$today_minute = 0;
$today_hour++;
if ($today_hour == 24) {
$today_hour = 0;
}
}
//the click_time is recorded in the middle of the day
$cronjob_time = mktime($today_hour, $today_minute, 0, $today_month, $today_day, $today_year);
$mysql['cronjob_time'] = mysql_real_escape_string($cronjob_time);
$mysql['cronjob_type'] = mysql_real_escape_string('1min');
//check to make sure this click_summary doesn't already exist
$check_sql = "SELECT COUNT(*) FROM 202_cronjobs WHERE cronjob_type='" . $mysql['cronjob_type'] . "' AND cronjob_time='" . $mysql['cronjob_time'] . "'";
$check_result = mysql_query($check_sql) or record_mysql_error($check_sql);
$check_count = mysql_result($check_result, 0, 0);
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 = mysql_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 = _mysql_query($delayed_sql);
while ($delayed_row = mysql_fetch_assoc($delayed_result)) {
//run each sql
$update_sql = $delayed_row['delayed_sql'];
$update_result = _mysql_query($update_sql);
}
//delete all old delayed sqls
$delayed_sql = "DELETE FROM 202_delayed_sqls WHERE delayed_time <=" . time();
$delayed_result = _mysql_query($delayed_sql);
return true;
} else {
return false;
}
}
public static function query($sql)
{
if (!($ret = self::$_link->query($sql))) {
record_mysql_error($sql);
return false;
}
self::$_lastRowCount = $ret->rowCount();
self::$_queryLog[] = array('query' => $sql, 'rows' => $ret->rowCount());
return $ret;
}
}
//echo error
echo $error['time'] . $error['user'];
//if there was an error terminate, or else just continue to run
if ($error) {
die;
}
// update regular clicks
$sql = "UPDATE 202_clicks LEFT JOIN 202_clicks_advance USING (click_id) \n\t\t\t\t\t\t LEFT JOIN 202_clicks_site USING (click_id) \n\t\t\t\t\t\t LEFT JOIN 202_aff_campaigns ON (202_clicks.aff_campaign_id = 202_aff_campaigns.aff_campaign_id)\n\t\t\t\t\t\t LEFT JOIN 202_aff_networks ON (202_aff_campaigns.aff_network_id = 202_aff_networks.aff_network_id)\n\t\t\t\t\t\t LEFT JOIN 202_ppc_accounts ON (202_ppc_accounts.ppc_account_id = 202_clicks.ppc_account_id)\n\t\t\t\t\t\t LEFT JOIN 202_ppc_networks ON (202_ppc_networks.ppc_network_id = 202_ppc_accounts.ppc_network_id)\n\t\t\tSET click_cpc='" . $mysql['click_cpc'] . "'\n\t\t\tWHERE 202_clicks.user_id='" . $mysql['user_id'] . "'";
if ($mysql['aff_network_id']) {
$sql .= " AND 202_aff_networks.aff_network_id='" . $mysql['aff_network_id'] . "' ";
}
if ($mysql['aff_campaign_id']) {
$sql .= " AND 202_clicks.aff_campaign_id='" . $mysql['aff_campaign_id'] . "' ";
}
if ($mysql['text_ad_id']) {
$sql .= " AND 202_clicks_advance.text_ad_id='" . $mysql['text_ad_id'] . "' ";
}
if ($mysql['landing_page_id']) {
$sql .= " AND 202_clicks.landing_page_id='" . $mysql['landing_page_id'] . "' ";
}
if ($mysql['ppc_network_id']) {
$sql .= " AND 202_ppc_networks.ppc_network_id='" . $mysql['ppc_network_id'] . "' ";
}
if ($mysql['ppc_account_id']) {
$sql .= " AND 202_clicks.ppc_account_id='" . $mysql['ppc_account_id'] . "' ";
}
$sql .= $mysql['method_of_promotion'];
$sql .= " AND click_time >=' " . $mysql['from'] . "' AND click_time <= '" . $mysql['to'] . "'";
$result = $db->query($sql) or record_mysql_error($sql);
echo '<p style="text-align: center; font-weight: bold;">' . $db->affected_rows . ' clicks updated.</p>';
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
$mysql['aff_network_id'] = mysql_real_escape_string($_POST['aff_network_id']);
$mysql['user_id'] = mysql_real_escape_string($_SESSION['user_id']);
$aff_campaign_sql = "SELECT * \n FROM `202_aff_campaigns` \n\t\t\t\t\t\t\t WHERE `user_id`='" . $mysql['user_id'] . "' \n AND `aff_network_id`='" . $mysql['aff_network_id'] . "' \n\t\t\t\t\t\t\t AND `aff_campaign_deleted`='0' \n ORDER BY `aff_campaign_name` ASC";
$aff_campaign_result = mysql_query($aff_campaign_sql) or record_mysql_error($aff_campaign_sqlql);
if (mysql_num_rows($aff_campaign_result) == 0) {
// echo '<div class="error">You have not added any campaigns for this affiliate network yet.</div>';
} else {
?>
<select name="aff_campaign_id" id="aff_campaign_id" onchange="load_text_ad_id(this.value); if($('landing_page_style_type')){load_landing_page( $('aff_campaign_id').value, 0, $('landing_page_style_type').getValue());}; if($('unsecure_pixel')) { pixel_data_changed(); }">
<option value="0"> -- </option> <?php
while ($aff_campaign_row = mysql_fetch_array($aff_campaign_result, MYSQL_ASSOC)) {
$html['aff_campaign_id'] = htmlentities($aff_campaign_row['aff_campaign_id'], ENT_QUOTES, 'UTF-8');
$html['aff_campaign_name'] = htmlentities($aff_campaign_row['aff_campaign_name'], ENT_QUOTES, 'UTF-8');
$html['aff_campaign_payout'] = htmlentities($aff_campaign_row['aff_campaign_payout'], ENT_QUOTES, 'UTF-8');
if ($_POST['aff_campaign_id'] == $aff_campaign_row['aff_campaign_id']) {
$selected = 'selected=""';
} else {
$selected = '';
}
printf('<option %s value="%s">%s · $%s</option>', $selected, $html['aff_campaign_id'], $html['aff_campaign_name'], $html['aff_campaign_payout']);
}
?>
</select>
<?php
}
}
//echo error
echo $error['time'] . $error['user'];
//if there was an error terminate, or else just continue to run
if ($error) {
die;
}
// update regular clicks
$sql = "UPDATE 202_clicks LEFT JOIN 202_clicks_advance USING (click_id) \n\t\t\t\t\t\t LEFT JOIN 202_clicks_site USING (click_id) \n\t\t\t\t\t\t LEFT JOIN 202_aff_campaigns ON (202_clicks.aff_campaign_id = 202_aff_campaigns.aff_campaign_id)\n\t\t\t\t\t\t LEFT JOIN 202_aff_networks ON (202_aff_campaigns.aff_network_id = 202_aff_networks.aff_network_id)\n\t\t\t\t\t\t LEFT JOIN 202_ppc_accounts ON (202_ppc_accounts.ppc_account_id = 202_clicks.ppc_account_id)\n\t\t\t\t\t\t LEFT JOIN 202_ppc_networks ON (202_ppc_networks.ppc_network_id = 202_ppc_accounts.ppc_network_id)\n\t\t\tSET click_cpc='" . $mysql['click_cpc'] . "'\n\t\t\tWHERE 202_clicks.user_id='" . $mysql['user_id'] . "'";
if ($mysql['aff_network_id']) {
$sql .= " AND 202_aff_networks.aff_network_id='" . $mysql['aff_network_id'] . "' ";
}
if ($mysql['aff_campaign_id']) {
$sql .= " AND 202_clicks.aff_campaign_id='" . $mysql['aff_campaign_id'] . "' ";
}
if ($mysql['text_ad_id']) {
$sql .= " AND 202_clicks_advance.text_ad_id='" . $mysql['text_ad_id'] . "' ";
}
if ($mysql['landing_page_id']) {
$sql .= " AND 202_clicks.landing_page_id='" . $mysql['landing_page_id'] . "' ";
}
if ($mysql['ppc_network_id']) {
$sql .= " AND 202_ppc_networks.ppc_network_id='" . $mysql['ppc_network_id'] . "' ";
}
if ($mysql['ppc_account_id']) {
$sql .= " AND 202_clicks.ppc_account_id='" . $mysql['ppc_account_id'] . "' ";
}
$sql .= $mysql['method_of_promotion'];
$sql .= " AND click_time >=' " . $mysql['from'] . "' AND click_time <= '" . $mysql['to'] . "'";
$result = mysql_query($sql) or record_mysql_error($sql);
echo '<p style="text-align: center; font-weight: bold;">' . mysql_affected_rows() . ' clicks updated.</p>';
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
?>
<select class="form-control input-sm" name="region_id" id="region_id">
<option value="0"> -- </option>
<?php
$region_sql = "SELECT *\n FROM 202_locations_region\n GROUP BY `region_name` ORDER BY `region_name` ASC";
$region_result = $db->query($region_sql) or record_mysql_error($region_sql);
while ($region_row = $region_result->fetch_array(MYSQL_ASSOC)) {
$html['region_name'] = htmlentities($region_row['region_name'], ENT_QUOTES, 'UTF-8');
$html['region_id'] = htmlentities($region_row['region_id'], ENT_QUOTES, 'UTF-8');
if ($_POST['region_id'] == $region_row['region_id']) {
$selected = 'selected=""';
} else {
$selected = '';
}
printf('<option %s value="%s">%s</option>', $selected, $html['region_id'], $html['region_name']);
}
?>
</select>
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$mysql['aff_campaign_id'] = $db->real_escape_string($_POST['aff_campaign_id']);
$mysql['text_ad_id'] = $db->real_escape_string($_POST['text_ad_id']);
$mysql['ppc_account_id'] = $db->real_escape_string($_POST['ppc_account_id']);
$mysql['click_cloaking'] = $db->real_escape_string($_POST['click_cloaking']);
$mysql['landing_page_id'] = $db->real_escape_string($landing_page_row['landing_page_id']);
$mysql['rotator_id'] = $db->real_escape_string($_POST['tracker_rotator']);
$mysql['tracker_time'] = time();
$tracker_sql = "INSERT INTO `202_trackers`\n\t\t\t\t\tSET\t\t\t`user_id`='" . $mysql['user_id'] . "',\n\t\t\t\t\t\t\t\t`aff_campaign_id`='" . $mysql['aff_campaign_id'] . "',\n\t\t\t\t\t\t\t\t`text_ad_id`='" . $mysql['text_ad_id'] . "',\n\t\t\t\t\t\t\t\t`ppc_account_id`='" . $mysql['ppc_account_id'] . "',\n\t\t\t\t\t\t\t\t`click_cpc`='" . $mysql['click_cpc'] . "',\n\t\t\t\t\t\t\t\t`landing_page_id`='" . $mysql['landing_page_id'] . "',\n\t\t\t\t\t\t\t\t`rotator_id`='" . $mysql['rotator_id'] . "',\n\t\t\t\t\t\t\t\t`click_cloaking`='" . $mysql['click_cloaking'] . "',\n\t\t\t\t\t\t\t\t`tracker_time`='" . $mysql['tracker_time'] . "'";
$tracker_result = $db->query($tracker_sql) or record_mysql_error($tracker_sql);
$tracker_row['tracker_id'] = $db->insert_id;
$tracker_id_public = rand(1, 9) . $tracker_row['tracker_id'] . rand(1, 9);
$mysql['tracker_id_public'] = $db->real_escape_string($tracker_id_public);
$mysql['tracker_id'] = $db->real_escape_string($tracker_row['tracker_id']);
$tracker_sql = "UPDATE \t\t`202_trackers`\n\t\t\t\t\tSET\t\t\t`tracker_id_public`='" . $mysql['tracker_id_public'] . "'\n\t\t\t\t\tWHERE\t\t`tracker_id`='" . $mysql['tracker_id'] . "'";
$tracker_result = $db->query($tracker_sql) or record_mysql_error($tracker_sql);
$parsed_url = parse_url($landing_page_row['landing_page_url']);
$html['c1'] = $db->real_escape_string($_POST['c1']);
$html['c2'] = $db->real_escape_string($_POST['c2']);
$html['c3'] = $db->real_escape_string($_POST['c3']);
$html['c4'] = $db->real_escape_string($_POST['c4']);
$tracking_variable_string = '&';
if ($html['c1']) {
$tracking_variable_string .= 'c1=' . $html['c1'] . '&';
}
if ($html['c2']) {
$tracking_variable_string .= 'c2=' . $html['c2'] . '&';
}
if ($html['c3']) {
$tracking_variable_string .= 'c3=' . $html['c3'] . '&';
}
$ppc_network_sql = "SELECT * FROM 202_ppc_networks WHERE ppc_network_id='" . $mysql['ppc_network_id'] . "' AND user_id='" . $mysql['user_id'] . "'";
$ppc_network_result = mysql_query($ppc_network_sql) or record_mysql_error($ppc_network_sql);
$ppc_network_row = mysql_fetch_assoc($ppc_network_result);
if (!$ppc_network_row) {
$error['user'] = '******';
} else {
$html['ppc_network_name'] = htmlentities($ppc_network_row['ppc_network_name'], ENT_QUOTES, 'UTF-8');
}
} else {
$html['ppc_network_name'] = 'ALL your PPC networks';
}
//check ppc_account id, that you own
if ($_POST['ppc_account_id']) {
$mysql['ppc_account_id'] = mysql_real_escape_string($_POST['ppc_account_id']);
$ppc_account_sql = "SELECT * FROM 202_ppc_accounts WHERE ppc_account_id='" . $mysql['ppc_account_id'] . "' AND user_id='" . $mysql['user_id'] . "'";
$ppc_account_result = mysql_query($ppc_account_sql) or record_mysql_error($ppc_account_sql);
$ppc_account_row = mysql_fetch_assoc($ppc_account_result);
if (!$ppc_account_row) {
$error['user'] = '******';
} else {
$html['ppc_account_name'] = htmlentities($ppc_account_row['ppc_account_name'], ENT_QUOTES, 'UTF-8');
}
} else {
$html['ppc_account_name'] = 'ALL your PPC accounts in these PPC networks';
}
if (!is_numeric($_POST['cpc_dollars']) or !is_numeric($_POST['cpc_cents'])) {
$error['cpc'] = '<div class="error">You did not input a numeric max CPC.</div>';
} else {
$click_cpc = $_POST['cpc_dollars'] . '.' . $_POST['cpc_cents'];
$html['click_cpc'] = htmlentities(dollar_format($click_cpc), ENT_QUOTES, 'UTF-8');
$mysql['click_cpc'] = mysql_real_escape_string($click_cpc);
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$mysql['text_ad_id'] = $db->real_escape_string($_POST['text_ad_id']);
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$text_ad_sql = "SELECT * FROM `202_text_ads` WHERE `text_ad_id`='" . $mysql['text_ad_id'] . "' AND `user_id`='" . $mysql['user_id'] . "'";
$text_ad_result = $db->query($text_ad_sql) or record_mysql_error($text_ad_sql);
$text_ad_row = $text_ad_result->fetch_assoc();
if ($text_ad_result->num_rows == 0) {
?>
<div class="panel panel-default" style="opacity:0.5; border-color: #3498db; margin-bottom:0px">
<div class="panel-body">
<span id="ad-preview-headline">Luxury Cruise to Mars</span><br/>
<span id="ad-preview-body">Visit the Red Planet in style. Low-gravity fun for everyone!</span><br/>
<span id="ad-preview-url">www.example.com</span>
</div>
</div>
<?php
}
if ($text_ad_result->num_rows > 0) {
$html['text_ad_headline'] = htmlentities($text_ad_row['text_ad_headline'], ENT_QUOTES, 'UTF-8');
$html['text_ad_description'] = htmlentities($text_ad_row['text_ad_description'], ENT_QUOTES, 'UTF-8');
$html['text_ad_display_url'] = htmlentities($text_ad_row['text_ad_display_url'], ENT_QUOTES, 'UTF-8');
?>
<div class="panel panel-default" style="border-color: #3498db; margin-bottom:0px">
<div class="panel-body">
function redirect_process($db, $rule, $ppc_account, $cpc, $rotator_id, $GeoData, $ip_address, $user_id, $IspData, $keyword_type)
{
$mysql['aff_campaign_id'] = $db->real_escape_string($rule['aff_campaign_id']);
$mysql['click_cpc'] = $db->real_escape_string($rule['click_cpc']);
$mysql['click_payout'] = $db->real_escape_string($rule['aff_campaign_payout']);
$mysql['rule_id'] = $db->real_escape_string($rule['rule_id']);
$mysql['ppc_account'] = $db->real_escape_string($ppc_account);
$mysql['cpc'] = $db->real_escape_string($cpc);
$mysql['click_time'] = time();
/* ok, if $_GET['OVRAW'] that is a yahoo keyword, if on the REFER, there is a $_GET['q], that is a GOOGLE keyword... */
//so this is going to check the REFERER URL, for a ?q=, which is the ACUTAL KEYWORD searched.
$referer_url_parsed = @parse_url($_SERVER['HTTP_REFERER']);
$referer_url_query = $referer_url_parsed['query'];
@parse_str($referer_url_query, $referer_query);
switch ($keyword_type) {
case "bidded":
#try to get the bidded keyword first
if ($_GET['OVKEY']) {
//if this is a Y! keyword
$keyword = $db->real_escape_string($_GET['OVKEY']);
} elseif ($_GET['utm_source']) {
$keyword = $db->real_escape_string($_GET['utm_source']);
} elseif ($_GET['t202kw']) {
$keyword = $db->real_escape_string($_GET['t202kw']);
} elseif ($referer_query['p']) {
$keyword = $db->real_escape_string($referer_query['p']);
} elseif ($_GET['target_passthrough']) {
//if this is a mediatraffic! keyword
$keyword = $db->real_escape_string($_GET['target_passthrough']);
} else {
//if this is a zango, or more keyword
$keyword = $db->real_escape_string($_GET['keyword']);
}
break;
case "searched":
#try to get the searched keyword
if ($referer_query['q']) {
$keyword = $db->real_escape_string($referer_query['q']);
} elseif ($referer_query['p']) {
$keyword = $db->real_escape_string($referer_query['p']);
} elseif ($_GET['OVRAW']) {
//if this is a Y! keyword
$keyword = $db->real_escape_string($_GET['OVRAW']);
} elseif ($_GET['target_passthrough']) {
//if this is a mediatraffic! keyword
$keyword = $db->real_escape_string($_GET['target_passthrough']);
} elseif ($_GET['keyword']) {
//if this is a zango, or more keyword
$keyword = $db->real_escape_string($_GET['keyword']);
} elseif ($_GET['search_word']) {
//if this is a eniro, or more keyword
$keyword = $db->real_escape_string($_GET['search_word']);
} elseif ($_GET['query']) {
//if this is a naver, or more keyword
$keyword = $db->real_escape_string($_GET['query']);
} elseif ($_GET['encquery']) {
//if this is a aol, or more keyword
$keyword = $db->real_escape_string($_GET['encquery']);
} elseif ($_GET['terms']) {
//if this is a about.com, or more keyword
$keyword = $db->real_escape_string($_GET['terms']);
} elseif ($_GET['rdata']) {
//if this is a viola, or more keyword
$keyword = $db->real_escape_string($_GET['rdata']);
} elseif ($_GET['qs']) {
//if this is a virgilio, or more keyword
$keyword = $db->real_escape_string($_GET['qs']);
} elseif ($_GET['wd']) {
//if this is a baidu, or more keyword
$keyword = $db->real_escape_string($_GET['wd']);
} elseif ($_GET['text']) {
//if this is a yandex, or more keyword
$keyword = $db->real_escape_string($_GET['text']);
} elseif ($_GET['szukaj']) {
//if this is a wp.pl, or more keyword
$keyword = $db->real_escape_string($_GET['szukaj']);
} elseif ($_GET['qt']) {
//if this is a O*net, or more keyword
$keyword = $db->real_escape_string($_GET['qt']);
} elseif ($_GET['k']) {
//if this is a yam, or more keyword
$keyword = $db->real_escape_string($_GET['k']);
} elseif ($_GET['words']) {
//if this is a Rambler, or more keyword
$keyword = $db->real_escape_string($_GET['words']);
} else {
$keyword = $db->real_escape_string($_GET['t202kw']);
}
break;
}
$keyword = str_replace('%20', ' ', $keyword);
$keyword_id = INDEXES::get_keyword_id($db, $keyword);
$mysql['keyword_id'] = $db->real_escape_string($keyword_id);
$c1 = $db->real_escape_string($_GET['c1']);
$c1 = str_replace('%20', ' ', $c1);
$c1_id = INDEXES::get_c1_id($db, $c1);
$mysql['c1_id'] = $db->real_escape_string($c1_id);
$c2 = $db->real_escape_string($_GET['c2']);
$c2 = str_replace('%20', ' ', $c2);
$c2_id = INDEXES::get_c2_id($db, $c2);
$mysql['c2_id'] = $db->real_escape_string($c2_id);
$c3 = $db->real_escape_string($_GET['c3']);
$c3 = str_replace('%20', ' ', $c3);
$c3_id = INDEXES::get_c3_id($db, $c3);
$mysql['c3_id'] = $db->real_escape_string($c3_id);
$c4 = $db->real_escape_string($_GET['c4']);
$c4 = str_replace('%20', ' ', $c4);
$c4_id = INDEXES::get_c4_id($db, $c4);
$mysql['c4_id'] = $db->real_escape_string($c4_id);
$device_id = PLATFORMS::get_device_info($db, $detect, $_GET['ua']);
$mysql['platform_id'] = $db->real_escape_string($device_id['platform']);
$mysql['browser_id'] = $db->real_escape_string($device_id['browser']);
$mysql['device_id'] = $db->real_escape_string($device_id['device']);
if ($device_id['type'] == '4') {
$mysql['click_bot'] = '1';
}
$mysql['click_in'] = 1;
$mysql['click_out'] = 1;
$ip_id = INDEXES::get_ip_id($db, $ip_address);
$mysql['ip_id'] = $db->real_escape_string($ip_id);
$country_id = INDEXES::get_country_id($db, $GeoData['country'], $GeoData['country_code']);
$mysql['country_id'] = $db->real_escape_string($country_id);
$region_id = INDEXES::get_region_id($db, $GeoData['region'], $mysql['country_id']);
$mysql['region_id'] = $db->real_escape_string($region_id);
$city_id = INDEXES::get_city_id($db, $GeoData['city'], $mysql['country_id']);
$mysql['city_id'] = $db->real_escape_string($city_id);
if ($IspData != null) {
$isp_id = INDEXES::get_isp_id($db, $IspData);
$mysql['isp_id'] = $db->real_escape_string($isp_id);
}
if ($device_id['type'] == '4') {
$mysql['click_filtered'] = '1';
} else {
$click_filtered = FILTER::startFilter($db, $click_id, $ip_id, $ip_address, $user_id);
$mysql['click_filtered'] = $db->real_escape_string($click_filtered);
}
if ($_GET[lpr] != '') {
$click_sql1 = "\tSELECT \t202_clicks.click_id,keyword,keyword_id\n\t\t\t\t\tFROM \t\t202_clicks\n\t\t\t\t\tLEFT JOIN\t202_clicks_advance USING (click_id)\n\t\t\t\t\tLEFT JOIN \t202_ips USING (ip_id) \n\t\t\t\t\tLEFT JOIN \t202_keywords USING (keyword_id) \n\t\t\t\t\tWHERE \t202_ips.ip_address='" . $ip_address . "'\n\t\t\t\t\tAND\t\t202_clicks.user_id='" . $user_id . "' \n\t\t\t\t\tAND\t\t202_clicks.click_time >= '30'\n\t\t\t\t\tORDER BY \t202_clicks.click_id DESC \n\t\t\t\t\tLIMIT \t\t1";
$click_result1 = $db->query($click_sql1) or record_mysql_error($click_sql1);
$click_row1 = $click_result1->fetch_assoc();
$mysql['click_id'] = $db->real_escape_string($click_row1['click_id']);
$keyword = $db->real_escape_string($keyword);
$keyword_id = $db->real_escape_string($click_row1['keyword_id']);
$mysql['keyword_id'] = $db->real_escape_string($keyword_id);
} else {
//ok we have the main data, now insert this row
$click_sql = "INSERT INTO 202_clicks_counter SET click_id=DEFAULT";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//now gather the info for the advance click insert
$click_id = $db->insert_id;
$mysql['click_id'] = $db->real_escape_string($click_id);
}
$mysql['click_alp'] = 0;
$mysql['rotator_id'] = $db->real_escape_string($rotator_id);
$mysql['user_id'] = $db->real_escape_string($user_id);
//ok we have the main data, now insert this row
$click_sql = "REPLACE INTO 202_clicks\n\t\t\t SET \tclick_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tuser_id = '" . $mysql['user_id'] . "', \n\t\t\t\t\t\t\taff_campaign_id = '" . $mysql['aff_campaign_id'] . "', \n\t\t\t\t\t\t\tppc_account_id = '" . $mysql['ppc_account'] . "', \n\t\t\t\t\t\t\tclick_cpc = '" . $mysql['cpc'] . "', \n\t\t\t\t\t\t\tclick_payout = '" . $mysql['click_payout'] . "', \n\t\t\t\t\t\t\tclick_alp = '" . $mysql['click_alp'] . "',\n\t\t\t\t\t\t\tclick_filtered = '" . $mysql['click_filtered'] . "',\n\t\t\t\t\t\t\tclick_bot = '" . $mysql['click_bot'] . "',\n\t\t\t\t\t\t\tclick_time = '" . $mysql['click_time'] . "',\n\t\t\t\t\t\t\trotator_id = '" . $mysql['rotator_id'] . "',\n\t\t\t\t\t\t\trule_id = '" . $mysql['rule_id'] . "'";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//ok we have the main data, now insert this row
$click_sql = "REPLACE INTO 202_clicks_spy\n\t\t\t\t SET \tclick_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\t\tuser_id = '" . $mysql['user_id'] . "', \n\t\t\t\t\t\t\t\taff_campaign_id = '" . $mysql['aff_campaign_id'] . "', \n\t\t\t\t\t\t\t\tppc_account_id = '" . $mysql['ppc_account'] . "', \n\t\t\t\t\t\t\t\tclick_cpc = '" . $mysql['cpc'] . "', \n\t\t\t\t\t\t\t\tclick_payout = '" . $mysql['click_payout'] . "', \n\t\t\t\t\t\t\t\tclick_filtered = '" . $mysql['click_filtered'] . "',\n\t\t\t\t\t\t\t\tclick_bot = '" . $mysql['click_bot'] . "',\n\t\t\t\t\t\t\t\tclick_alp = '" . $mysql['click_alp'] . "',\n\t\t\t\t\t\t\t\tclick_time = '" . $mysql['click_time'] . "'";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//now we have the click's advance data, now insert this row
$click_sql = "REPLACE INTO 202_clicks_advance\n\t\t\t SET click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\ttext_ad_id='" . $mysql['text_ad_id'] . "',\n\t\t\t\t\t\t\tkeyword_id='" . $mysql['keyword_id'] . "',\n\t\t\t\t\t\t\tip_id='" . $mysql['ip_id'] . "',\n\t\t\t\t\t\t\tcountry_id='" . $mysql['country_id'] . "',\n\t\t\t\t\t\t\tregion_id='" . $mysql['region_id'] . "',\n\t\t\t\t\t\t\tisp_id='" . $mysql['isp_id'] . "',\n\t\t\t\t\t\t\tcity_id='" . $mysql['city_id'] . "',\n\t\t\t\t\t\t\tplatform_id='" . $mysql['platform_id'] . "',\n\t\t\t\t\t\t\tbrowser_id='" . $mysql['browser_id'] . "',\n\t\t\t\t\t\t\tdevice_id='" . $mysql['device_id'] . "'";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//insert the tracking data
$click_sql = "\n\tREPLACE INTO\n\t\t202_clicks_tracking\n\tSET\n\t\tclick_id='" . $mysql['click_id'] . "',\n\t\tc1_id = '" . $mysql['c1_id'] . "',\n\t\tc2_id = '" . $mysql['c2_id'] . "',\n\t\tc3_id = '" . $mysql['c3_id'] . "',\n\t\tc4_id = '" . $mysql['c4_id'] . "'";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//now gather variables for the clicks record db
//lets determine if cloaking is on
if ($rule['aff_campaign_cloaking'] == 1) {
$cloaking_on = true;
$mysql['click_cloaking'] = 1;
//if cloaking is on, add in a click_id_public, because we will be forwarding them to a cloaked /cl/xxxx link
$click_id_public = rand(1, 9) . $click_id . rand(1, 9);
$mysql['click_id_public'] = $db->real_escape_string($click_id_public);
} else {
$mysql['click_cloaking'] = 0;
}
//ok we have our click recorded table, now lets insert theses
$click_sql = "REPLACE INTO 202_clicks_record\n\t\t\t SET click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tclick_id_public='" . $mysql['click_id_public'] . "',\n\t\t\t\t\t\t\tclick_cloaking='" . $mysql['click_cloaking'] . "',\n\t\t\t\t\t\t\tclick_in='" . $mysql['click_in'] . "',\n\t\t\t\t\t\t\tclick_out='" . $mysql['click_out'] . "'";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//now lets get variables for clicks site
//so this is going to check the REFERER URL, for a ?url=, which is the ACUTAL URL, instead of the google content, pagead2.google....
if ($referer_query['url']) {
$click_referer_site_url_id = INDEXES::get_site_url_id($db, $referer_query['url']);
} else {
$click_referer_site_url_id = INDEXES::get_site_url_id($db, $_SERVER['HTTP_REFERER']);
}
$mysql['click_referer_site_url_id'] = $db->real_escape_string($click_referer_site_url_id);
$outbound_site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$click_outbound_site_url_id = INDEXES::get_site_url_id($db, $outbound_site_url);
$mysql['click_outbound_site_url_id'] = $db->real_escape_string($click_outbound_site_url_id);
if ($cloaking_on == true) {
$cloaking_site_url = 'http://' . $_SERVER['SERVER_NAME'] . '/tracking202/redirect/cl.php?pci=' . $click_id_public;
}
if ($rule['aff_campaign_id'] != null) {
//rotate the urls
$redirect_site_url = rotateTrackerUrl($db, $rule);
} else {
if ($rule['default_url'] != null) {
$redirect_site_url = $rule['default_url'];
} elseif ($rule['redirect_url'] != null) {
$redirect_site_url = $rule['redirect_url'];
}
}
$redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url, $click_id);
$click_redirect_site_url_id = INDEXES::get_site_url_id($db, $redirect_site_url);
$mysql['click_redirect_site_url_id'] = $db->real_escape_string($click_redirect_site_url_id);
//insert this
$click_sql = "REPLACE INTO 202_clicks_site\n\t\t\t SET click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tclick_referer_site_url_id='" . $mysql['click_referer_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_outbound_site_url_id='" . $mysql['click_outbound_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_redirect_site_url_id='" . $mysql['click_redirect_site_url_id'] . "'";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//update the click summary table
$now = time();
$today_day = date('j', time());
$today_month = date('n', time());
$today_year = date('Y', time());
//the click_time is recorded in the middle of the day
$click_time = mktime(12, 0, 0, $today_month, $today_day, $today_year);
$mysql['click_time'] = $db->real_escape_string($click_time);
//check to make sure this click_summary doesn't already exist
$check_sql = "SELECT *\n\t\t\t\t FROM 202_summary_overview\n\t\t\t\t WHERE user_id='" . $mysql['user_id'] . "'\n\t\t\t\t AND aff_campaign_id='" . $mysql['aff_campaign_id'] . "'\n\t\t\t\t AND ppc_account_id='" . $mysql['ppc_account'] . "'\n\t\t\t\t AND click_time='" . $mysql['click_time'] . "'";
$check_result = $db->query($check_sql) or record_mysql_error($db, $check_sql);
$check_count = $check_result->num_rows;
//if this click summary hasn't been recorded do this now
if ($check_count == 0) {
$insert_sql = "INSERT INTO 202_summary_overview\n\t\t\t\t\t SET user_id='" . $mysql['user_id'] . "',\n\t\t\t\t\t\t\t\t aff_campaign_id='" . $mysql['aff_campaign_id'] . "',\n\t\t\t\t\t\t\t\t ppc_account_id='" . $mysql['ppc_account'] . "',\n\t\t\t\t\t\t\t\t click_time='" . $mysql['click_time'] . "'";
$insert_result = $db->query($insert_sql);
}
if ($rule['aff_campaign_id'] != null) {
//set the cookie
setClickIdCookie($mysql['click_id'], $rule['aff_campaign_id']);
}
//now we've recorded, now lets redirect them
if ($cloaking_on == true) {
//if cloaked, redirect them to the cloaked site.
return $cloaking_site_url;
} else {
return $redirect_site_url;
}
}
$mysql['user_id'] = mysql_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 = _mysql_query($user_sql, $dbGlobalLink);
//($user_sql);
$user_row = mysql_fetch_assoc($user_result);
$breakdown = $user_row['user_pref_breakdown'];
if ($user_row['user_cpc_or_cpv'] == 'cpv') {
$cpv = true;
} else {
$cpv = false;
}
//keywords already set in the table, just just download them
if (empty($mysql['order'])) {
$mysql['order'] = ' ORDER BY sort_text_ad_clicks DESC';
}
$db_table = '202_sort_text_ads';
$query = query('SELECT * FROM 202_sort_text_ads LEFT JOIN 202_text_ads USING (text_ad_id)', $db_table, false, false, false, $mysql['order'], false, false, true);
$keyword_sql = $query['click_sql'];
$keyword_result = mysql_query($keyword_sql) or record_mysql_error($keyword_sql);
header("Content-type: application/octet-stream");
# replace excelfile.xls with whatever you want the filename to default to
header("Content-Disposition: attachment; filename=T202_textads_" . time() . ".xls");
header("Pragma: no-cache");
header("Expires: 0");
echo "Text Ad" . "\t" . "Clicks" . "\t" . "Leads" . "\t" . "S/U" . "\t" . "Payout" . "\t" . "EPC" . "\t" . "Avg CPC" . "\t" . "Income" . "\t" . "Cost" . "\t" . "Net" . "\t" . "ROI" . "\n";
while ($keyword_row = mysql_fetch_array($keyword_result, MYSQL_ASSOC)) {
if (!$keyword_row['text_ad_name']) {
$keyword_row['text_ad_name'] = '[no text ad recorded]';
}
echo $keyword_row['text_ad_name'] . "\t" . $keyword_row['sort_text_ad_clicks'] . "\t" . $keyword_row['sort_text_ad_leads'] . "\t" . $keyword_row['sort_text_ad_su_ratio'] . '%' . "\t" . dollar_format($keyword_row['sort_text_ad_payout']) . "\t" . dollar_format($keyword_row['sort_text_ad_epc']) . "\t" . dollar_format($keyword_row['sort_text_ad_avg_cpc'], $cpv) . "\t" . dollar_format($keyword_row['sort_text_ad_income']) . "\t" . dollar_format($keyword_row['sort_text_ad_cost'], $cpv) . "\t" . dollar_format($keyword_row['sort_text_ad_net'], $cpv) . "\t" . $keyword_row['sort_text_ad_roi'] . '%' . "\n";
}
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
?>
<select class="form-control input-sm" name="country_id" id="country_id">
<option value="0"> -- </option>
<?php
$country_sql = "SELECT *\n FROM 202_locations_country\n GROUP BY `country_name` ORDER BY `country_name` ASC";
$country_result = $db->query($country_sql) or record_mysql_error($country_sql);
while ($country_row = $country_result->fetch_array(MYSQL_ASSOC)) {
$html['country_name'] = htmlentities($country_row['country_name'], ENT_QUOTES, 'UTF-8');
$html['country_id'] = htmlentities($country_row['country_id'], ENT_QUOTES, 'UTF-8');
if ($_POST['country_id'] == $country_row['country_id']) {
$selected = 'selected=""';
} else {
$selected = '';
}
printf('<option %s value="%s">%s</option>', $selected, $html['country_id'], $html['country_name']);
}
?>
</select>
$site_url_row = memcache_mysql_fetch_assoc($site_url_sql); $html['landing'] = htmlentities($site_url_row['site_url_address'], ENT_QUOTES, 'UTF-8'); $html['landing_host'] = htmlentities($site_url_row['site_domain_host'], ENT_QUOTES, 'UTF-8'); $mysql['click_outbound_site_url_id'] = mysql_real_escape_string($click_row['click_outbound_site_url_id']); $site_url_sql = "SELECT * FROM 202_site_urls LEFT JOIN 202_site_domains USING (site_domain_id) \n\t\t\t\t\t\t WHERE 202_site_urls.site_url_id = '" . $mysql['click_outbound_site_url_id'] . "'\n\t\t\t\t\t\t AND 202_site_urls.site_domain_id = 202_site_domains.site_domain_id"; $site_url_row = memcache_mysql_fetch_assoc($site_url_sql); $html['outbound'] = htmlentities($site_url_row['site_url_address'], ENT_QUOTES, 'UTF-8'); $html['outbound_host'] = htmlentities($site_url_row['site_domain_host'], ENT_QUOTES, 'UTF-8'); $mysql['click_cloaking_site_url_id'] = mysql_real_escape_string($click_row['click_cloaking_site_url_id']); $site_url_sql = "SELECT * FROM 202_site_urls LEFT JOIN 202_site_domains USING (site_domain_id) \n\t\t\t\t\t\t WHERE 202_site_urls.site_url_id = '" . $mysql['click_cloaking_site_url_id'] . "'\n\t\t\t\t\t\t AND 202_site_urls.site_domain_id = 202_site_domains.site_domain_id"; $site_url_row = memcache_mysql_fetch_assoc($site_url_sql); $html['cloaking'] = htmlentities($site_url_row['site_url_address'], ENT_QUOTES, 'UTF-8'); $html['cloaking_host'] = htmlentities($site_url_row['site_domain_host'], ENT_QUOTES, 'UTF-8'); $mysql['click_redirect_site_url_id'] = mysql_real_escape_string($click_row['click_redirect_site_url_id']); $site_url_sql = "SELECT * FROM 202_site_urls LEFT JOIN 202_site_domains USING (site_domain_id) \n\t\t\t\t\t\t WHERE 202_site_urls.site_url_id = '" . $mysql['click_redirect_site_url_id'] . "'\n\t\t\t\t\t\t AND 202_site_urls.site_domain_id = 202_site_domains.site_domain_id"; $site_url_result = mysql_query($site_url_sql) or record_mysql_error($site_url_sql); $site_url_row = mysql_fetch_assoc($site_url_result); $html['redirect'] = htmlentities($site_url_row['site_url_address'], ENT_QUOTES, 'UTF-8'); $html['redirect_host'] = htmlentities($site_url_row['site_domain_host'], ENT_QUOTES, 'UTF-8'); $html['aff_campaign_id'] = htmlentities($click_row['aff_campaign_id'], ENT_QUOTES, 'UTF-8'); $html['landing_page_nickname'] = htmlentities($click_row['landing_page_nickname'], ENT_QUOTES, 'UTF-8'); $html['ppc_account_id'] = htmlentities($click_row['ppc_account_id'], ENT_QUOTES, 'UTF-8'); $html['text_ad_id'] = htmlentities($click_row['text_ad_id'], ENT_QUOTES, 'UTF-8'); $html['text_ad_name'] = htmlentities($click_row['text_ad_name'], ENT_QUOTES, 'UTF-8'); $html['aff_campaign_name'] = htmlentities($click_row['aff_campaign_name'], ENT_QUOTES, 'UTF-8'); $html['aff_network_name'] = htmlentities($click_row['aff_network_name'], ENT_QUOTES, 'UTF-8'); $html['ppc_network_name'] = htmlentities($click_row['ppc_network_name'], ENT_QUOTES, 'UTF-8'); $html['ppc_account_name'] = htmlentities($click_row['ppc_account_name'], ENT_QUOTES, 'UTF-8'); $html['ip_address'] = htmlentities($click_row['ip_address'], ENT_QUOTES, 'UTF-8'); $html['click_cpc'] = htmlentities(dollar_format($click_row['click_cpc']), ENT_QUOTES, 'UTF-8'); $html['keyword'] = htmlentities($click_row['keyword'], ENT_QUOTES, 'UTF-8');
function grab_timeframe()
{
AUTH::set_timezone($_SESSION['user_timezone']);
$database = DB::getInstance();
$db = $database->getConnection();
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$user_sql = "SELECT user_pref_time_predefined, user_pref_time_from, user_pref_time_to FROM 202_users_pref WHERE user_id='" . $mysql['user_id'] . "'";
$user_result = _mysqli_query($user_sql);
//($user_sql);
$user_row = $user_result->fetch_assoc();
if ($user_row['user_pref_time_predefined'] == 'today' or $user_row['pref_time_from'] != '') {
$time['from'] = mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time()));
$time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time()));
}
if ($user_row['user_pref_time_predefined'] == 'yesterday') {
$time['from'] = mktime(0, 0, 0, date('m', time() - 86400), date('d', time() - 86400), date('Y', time() - 86400));
$time['to'] = mktime(23, 59, 59, date('m', time() - 86400), date('d', time() - 86400), date('Y', time() - 86400));
}
if ($user_row['user_pref_time_predefined'] == 'last7') {
$time['from'] = mktime(0, 0, 0, date('m', time() - 86400 * 7), date('d', time() - 86400 * 7), date('Y', time() - 86400 * 7));
$time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time()));
}
if ($user_row['user_pref_time_predefined'] == 'last14') {
$time['from'] = mktime(0, 0, 0, date('m', time() - 86400 * 14), date('d', time() - 86400 * 14), date('Y', time() - 86400 * 14));
$time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time()));
}
if ($user_row['user_pref_time_predefined'] == 'last30') {
$time['from'] = mktime(0, 0, 0, date('m', time() - 86400 * 30), date('d', time() - 86400 * 30), date('Y', time() - 86400 * 30));
$time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time()));
}
if ($user_row['user_pref_time_predefined'] == 'thismonth') {
$time['from'] = mktime(0, 0, 0, date('m', time()), 1, date('Y', time()));
$time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time()));
}
if ($user_row['user_pref_time_predefined'] == 'lastmonth') {
$time['from'] = mktime(0, 0, 0, date('m', time() - 2629743), 1, date('Y', time() - 2629743));
$time['to'] = mktime(23, 59, 59, date('m', time() - 2629743), getLastDayOfMonth(date('m', time() - 2629743), date('Y', time() - 2629743)), date('Y', time() - 2629743));
}
if ($user_row['user_pref_time_predefined'] == 'thisyear') {
$time['from'] = mktime(0, 0, 0, 1, 1, date('Y', time()));
$time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time()));
}
if ($user_row['user_pref_time_predefined'] == 'lastyear') {
$time['from'] = mktime(0, 0, 0, 1, 1, date('Y', time() - 31556926));
$time['to'] = mktime(0, 0, 0, 12, getLastDayOfMonth(date('m', time() - 31556926), date('Y', time() - 31556926)), date('Y', time() - 31556926));
}
if ($user_row['user_pref_time_predefined'] == 'alltime') {
//for the time from, do something special select the exact date this user was registered and use that :)
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$user2_sql = "SELECT user_time_register FROM 202_users WHERE user_id='" . $mysql['user_id'] . "'";
$user2_result = $db->query($user2_sql) or record_mysql_error($user2_sql);
$user2_row = $user2_result->fetch_assoc();
$time['from'] = $user2_row['user_time_register'];
$time['from'] = mktime(0, 0, 0, date('m', $time['from']), date('d', $time['from']), date('Y', $time['from']));
$time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time()));
}
if ($user_row['user_pref_time_predefined'] == '') {
$time['from'] = $user_row['user_pref_time_from'];
$time['to'] = $user_row['user_pref_time_to'];
}
$time['user_pref_time_predefined'] = $user_row['user_pref_time_predefined'];
return $time;
}
SELECT
2ta.text_ad_name,
COUNT(*) AS clicks,
SUM(2cr.click_out) AS click_out,
SUM(2c.click_lead) AS leads,
2ac.aff_campaign_payout AS payout,
SUM(2c.click_payout*2c.click_lead) AS income,
SUM(2c.click_cpc) AS cost
FROM 202_clicks AS 2c
LEFT OUTER JOIN 202_clicks_record AS 2cr ON (2c.click_id = 2cr.click_id)
LEFT OUTER JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id)
LEFT OUTER JOIN 202_clicks_advance AS 2ca ON (2c.click_id = 2ca.click_id)
LEFT OUTER JOIN 202_text_ads AS 2ta ON (2ca.text_ad_id = 2ta.text_ad_id)
', $db_table, true, true, false, " {$click_filtered} GROUP BY 2ta.text_ad_id ORDER BY clicks DESC", $_POST['offset'], true, true);
$info_sql = $query['click_sql'];
$info_result = $db->query($info_sql) or record_mysql_error($info_sql);
$total_rows = $info_result->num_rows;
$html['from'] = htmlentities($query['from'], ENT_QUOTES, 'UTF-8');
$html['to'] = htmlentities($query['to'], ENT_QUOTES, 'UTF-8');
$html['rows'] = htmlentities($query['rows'], ENT_QUOTES, 'UTF-8');
?>
<div class="row" style="margin-top: 10px;">
<div class="col-xs-6">
<span class="infotext"><?php
printf('<div class="results">Results <b>%s - %s</b> of <b>%s</b></div>', $html['from'], $html['to'], $html['rows']);
?>
</span>
</div>
<div class="col-xs-6 text-right" style="top: -10px;">
<img style="margin-bottom:2px;" src="/202-img/icons/16x16/page_white_excel.png"/>
$click_redirect_site_url_id = INDEXES::get_site_url_id($db, $redirect_site_url);
$mysql['click_redirect_site_url_id'] = $db->real_escape_string($click_redirect_site_url_id);
//insert this
$click_sql = "INSERT INTO 202_clicks_site\n\t\t\t SET click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tclick_referer_site_url_id='" . $mysql['click_referer_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_outbound_site_url_id='" . $mysql['click_outbound_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_redirect_site_url_id='" . $mysql['click_redirect_site_url_id'] . "'";
$click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
//update the click summary table
$now = time();
$today_day = date('j', time());
$today_month = date('n', time());
$today_year = date('Y', time());
//the click_time is recorded in the middle of the day
$click_time = mktime(12, 0, 0, $today_month, $today_day, $today_year);
$mysql['click_time'] = $db->real_escape_string($click_time);
//check to make sure this click_summary doesn't already exist
$check_sql = "SELECT *\n\t\t\t\t FROM 202_summary_overview\n\t\t\t\t WHERE user_id='" . $mysql['user_id'] . "'\n\t\t\t\t AND aff_campaign_id='" . $mysql['aff_campaign_id'] . "'\n\t\t\t\t AND ppc_account_id='" . $mysql['ppc_account_id'] . "'\n\t\t\t\t AND click_time='" . $mysql['click_time'] . "'";
$check_result = $db->query($check_sql) or record_mysql_error($db, $check_sql);
$check_count = $check_result->num_rows;
//if this click summary hasn't been recorded do this now
if ($check_count == 0) {
$insert_sql = "INSERT INTO 202_summary_overview\n\t\t\t\t\t SET user_id='" . $mysql['user_id'] . "',\n\t\t\t\t\t\t\t\t aff_campaign_id='" . $mysql['aff_campaign_id'] . "',\n\t\t\t\t\t\t\t\t ppc_account_id='" . $mysql['ppc_account_id'] . "',\n\t\t\t\t\t\t\t\t click_time='" . $mysql['click_time'] . "'";
$insert_result = $db->query($insert_sql);
}
//set the cookie
setClickIdCookie($mysql['click_id'], $mysql['aff_campaign_id']);
//get and prep extra stuff for pre-pop or data passing
$urlvars = getPrePopVars($_GET);
//now we've recorded, now lets redirect them
if ($cloaking_on == true) {
//if cloaked, redirect them to the cloaked site.
header('location: ' . setPrePopVars($urlvars, $cloaking_site_url, true));
} else {
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
?>
<select class="form-control input-sm" name="aff_network_id" id="aff_network_id" onchange="load_aff_campaign_id($(this).val(), 0); load_landing_page(this.value); load_text_ad_id(this.value);">
<option value="0"> -- </option>
<?php
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$aff_network_sql = "SELECT * FROM `202_aff_networks` WHERE `user_id`='" . $mysql['user_id'] . "' AND `aff_network_deleted`='0' ORDER BY `aff_network_name` ASC";
$aff_network_result = $db->query($aff_network_sql) or record_mysql_error($aff_network_sql);
while ($aff_network_row = $aff_network_result->fetch_array(MYSQL_ASSOC)) {
$html['aff_network_name'] = htmlentities($aff_network_row['aff_network_name'], ENT_QUOTES, 'UTF-8');
$html['aff_network_id'] = htmlentities($aff_network_row['aff_network_id'], ENT_QUOTES, 'UTF-8');
if ($_POST['aff_network_id'] == $aff_network_row['aff_network_id']) {
$selected = 'selected=""';
} else {
$selected = '';
}
printf('<option %s value="%s">%s</option>', $selected, $html['aff_network_id'], $html['aff_network_name']);
}
?>
</select>
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php';
AUTH::require_user();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$mysql['user_id'] = mysql_real_escape_string($_SESSION['user_id']);
$mysql['click_update_type'] = 'upload';
$mysql['click_update_time'] = time();
$subids = $_POST['subids'];
$subids = trim($subids);
$subids = explode("\r", $subids);
$subids = str_replace("\n", '', $subids);
foreach ($subids as $key => $click_id) {
$mysql['click_id'] = mysql_real_escape_string($click_id);
$click_sql = "\n\t\t\tSELECT 2c.click_id \n\t\t\tFROM\n\t\t\t\t202_clicks AS 2c\n\t\t\tWHERE\n\t\t\t\t2c.click_id ='" . $mysql['click_id'] . "'\n\t\t\t\tAND 2c.user_id='" . $mysql['user_id'] . "' \n\t\t";
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql);
$click_row = mysql_fetch_assoc($click_result);
$mysql['click_id'] = mysql_real_escape_string($click_row['click_id']);
if (is_numeric($mysql['click_id'])) {
$update_sql = "\n\t\t\t\tUPDATE\n\t\t\t\t\t202_clicks\n\t\t\t\tSET\n\t\t\t\t\tclick_lead='1',\n\t\t\t\t\t`click_filtered`='0'\n\t\t\t\tWHERE\n\t\t\t\t\tclick_id='" . $mysql['click_id'] . "'\n\t\t\t\t\tAND user_id='" . $mysql['user_id'] . "'\n\t\t\t";
$update_result = mysql_query($update_sql) or die(mysql_error());
$update_sql = "\n\t\t\t\tUPDATE\n\t\t\t\t\t202_clicks_spy\n\t\t\t\tSET\n\t\t\t\t\tclick_lead='1',\n\t\t\t\t\t`click_filtered`='0'\n\t\t\t\tWHERE\n\t\t\t\t\tclick_id='" . $mysql['click_id'] . "'\n\t\t\t\t\tAND user_id='" . $mysql['user_id'] . "'\n\t\t\t";
$update_result = mysql_query($update_sql) or die(mysql_error());
}
}
$success = true;
//this deletes all this users cached data to the old result sets, we want new stuff because they just updated old clicks
//memcache_delete_user_keys();
}
//show the template
template_top('Update Subids');
