$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;
}
if ($cloaking_on == true) {
$cloaking_site_url = 'http://' . $_SERVER['SERVER_NAME'] . '/tracking202/redirect/lpc.php?lpip=' . $tracker_row['landing_page_id_public'];
$click_cloaking_site_url_id = INDEXES::get_site_url_id($db, $cloaking_site_url);
$mysql['click_cloaking_site_url_id'] = $db->real_escape_string($click_cloaking_site_url_id);
}
$redirect_site_url = rotateTrackerUrl($db, $tracker_row);
$click_id = $_COOKIE['tracking202subid_a_' . $tracker_row['aff_campaign_id']];
$mysql['click_id'] = $db->real_escape_string($click_id);
$mysql['click_out'] = 1;
$update_sql = "\n\tUPDATE\n\t\t202_clicks_record\n\tSET\n\t\tclick_out='" . $mysql['click_out'] . "',\n\t\tclick_cloaking='" . $mysql['click_cloaking'] . "'\n\tWHERE\n\t\tclick_id='" . $mysql['click_id'] . "'";
delay_sql($db, $update_sql);
$redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url, $mysql['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);
//get and prep extra stuff for pre-pop or data passing
$urlvars = getPrePopVars($vars);
if ($cloaking_on == true) {
//if cloaked, redirect them to the cloaked site.
header('location: ' . setPrePopVars($urlvars, $cloaking_site_url, true));
} else {
header('location: ' . setPrePopVars($urlvars, $redirect_site_url, false));
}
die;
//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 {
header('location: ' . setPrePopVars($urlvars, $redirect_site_url, false));
}
$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 landing_page_id='" . $mysql['landing_page_id'] . "'\n\t\t\t\t AND aff_campaign_id='" . $mysql['aff_campaign_id'] . "'\n\t\t\t\t AND click_time='" . $mysql['click_time'] . "'";
$check_result = $db->query($check_sql) or record_mysql_error($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 \tSET user_id='" . $mysql['user_id'] . "',\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 aff_campaign_id='" . $mysql['aff_campaign_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']);
// NOW LETS REDIRECT
$urlvars = getPrePopVars($urlvarslist);
$redirect_site_url = setPrePopVars($urlvars, $redirect_site_url, false);
if ($cloaking_on == true) {
// if cloaking is turned on, meta refresh out
?>
<html>
<head>
<title><?php
echo $html['aff_campaign_name'];
?>
</title>
<meta name="robots" content="noindex">
<meta http-equiv="refresh"
content="1; url=<?php
echo $redirect_site_url;
?>
