real_escape_string($_GET['click_id']);
}elseif(null !== (getCookie202('tracking202subid'))) { //if there's a cookie use it
$click_id =getCookie202('tracking202subid');
}else { //if not find the list clicks id of the ip within a 30 day range
$mysql['user_id'] = 1;
$mysql['ip_address'] = $db->real_escape_string($_SERVER['REMOTE_ADDR']);
$daysago = time() - 86400; // 24 hours
$click_sql1 = " SELECT 202_clicks.click_id,ppc_account_id,click_id_public
FROM 202_clicks
LEFT JOIN 202_clicks_advance USING (click_id)
LEFT JOIN 202_ips USING (ip_id)
LEFT JOIN 202_clicks_record USING (click_id)
WHERE 202_ips.ip_address='".$mysql['ip_address']."'
AND 202_clicks.user_id='".$mysql['user_id']."'
AND 202_clicks.click_time >= '".$daysago."'
ORDER BY 202_clicks.click_id DESC
LIMIT 1";
$click_result1 = $db->query($click_sql1) or record_mysql_error($click_sql1);
$click_row1 = $click_result1->fetch_assoc();
$click_id = $db->real_escape_string($click_row1['click_id']);
$mysql['ppc_account_id'] = $db->real_escape_string($click_row1['ppc_account_id']);
$mysql['click_id_public'] = $db->real_escape_string($click_row1['click_id_public']);
$pci=$mysql['click_id_public'];
}
$mysql['click_id'] = $click_id;
$usedCachedRedirect = false;
if (! $db)
$usedCachedRedirect = true;
// the mysql server is down, use the txt cached redirect
if ($usedCachedRedirect == true) {
$acip = $_GET['acip'];
// if a cached key is found for this acip, redirect to that url
if ($memcacheWorking) {
$getUrl = $memcache->get(md5('ac_' . $acip . systemHash()));
if ($getUrl) {
$new_url = str_replace("[[subid]]", "p202", $getUrl);
// c1 sring replace for cached redirect
if (isset($_GET['c1']) && $_GET['c1'] != '') {
$new_url = str_replace("[[c1]]", $_GET['c1'], $new_url);
} else {
$new_url = str_replace("[[c1]]", "p202c1", $new_url);
}
// c2 sring replace for cached redirect
if (isset($_GET['c2']) && $_GET['c2'] != '') {
$new_url = str_replace("[[c2]]", $_GET['c2'], $new_url);
} else {
$new_url = str_replace("[[c2]]", "p202c2", $new_url);
}
// c3 sring replace for cached redirect
if (isset($_GET['c3']) && $_GET['c3'] != '') {
$new_url = str_replace("[[c3]]", $_GET['c3'], $new_url);
} else {
$new_url = str_replace("[[c3]]", "p202c3", $new_url);
}
// c4 sring replace for cached redirect
if (isset($_GET['c4']) && $_GET['c4'] != '') {
$new_url = str_replace("[[c4]]", $_GET['c4'], $new_url);
} else {
$new_url = str_replace("[[c4]]", "p202c4", $new_url);
}
$urlvars = getPrePopVars($urlvarslist);
$new_url = setPrePopVars($urlvars, $redirect_site_url, false);
header('location: ' . $new_url);
die();
}
}
die("Error establishing a database connection - please contact the webhost
");
}
/* OK FIRST IF THERE IS NO PUBLIC CLICK_ID, JUST REDIRECT TO THE NORMAL CAMPAIGN */
if (!isset($vars[1]) && $pci == '') {
$mysql['aff_campaign_id_public'] = $db->real_escape_string($acip);
$aff_campaign_sql = "SELECT aff_campaign_rotate,
aff_campaign_url,
aff_campaign_url_2,
aff_campaign_url_3,
aff_campaign_url_4,
aff_campaign_url_5,
aff_campaign_name,
aff_campaign_cloaking
FROM 202_aff_campaigns
WHERE aff_campaign_id_public='" . $mysql['aff_campaign_id_public'] . "'
AND 202_aff_campaigns.user_id=1";
$aff_campaign_row = memcache_mysql_fetch_assoc($db, $aff_campaign_sql);
if (empty($aff_campaign_row['aff_campaign_url'])) {
die();
} // if there is no aff_url to redirect to DIE!
$redirect_site_url = rotateTrackerUrl($db, $aff_campaign_row);
$redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url, $click_id, $mysql);
$urlvars = getPrePopVars($urlvarslist);
if (isset($urlvars)) {
$redirect_site_url = setPrePopVars($urlvars, $redirect_site_url, false);
}
// ok if there is a url that exists, if redirect php style, or if its cloaked, redirect meta refresh style.
if ($aff_campaign_row['aff_campaign_cloaking'] == 0) {
// cloaking OFF, so do a php header redirect
header('location: ' . $redirect_site_url);
die();
} else {
// cloaking ON, so do a meta REFRESH
$html['aff_campaign_name'] = $aff_campaign_row['aff_campaign_name'];
?>
<?php echo $html['aff_campaign_name']; ?>
You are being automatically redirected to .
Page Stuck?
Click
Here.
You are being automatically redirected to .
Page Stuck?
Click
Here.