real_escape_string($_GET['pci']);
if(isset($_GET['202vars'])){
$mysql['202vars'] = base64_decode($db->real_escape_string($_GET['202vars']));
}
$tracker_sql = "
SELECT
aff_campaign_name,
site_url_address,
user_pref_cloak_referer
FROM
202_clicks, 202_clicks_record, 202_clicks_site, 202_site_urls, 202_aff_campaigns,202_users_pref
WHERE
202_clicks.aff_campaign_id = 202_aff_campaigns.aff_campaign_id
AND 202_users_pref.user_id = 1
AND 202_clicks.click_id = 202_clicks_record.click_id
AND 202_clicks_record.click_id_public='".$mysql['click_id_public']."'
AND 202_clicks_record.click_id = 202_clicks_site.click_id
AND 202_clicks_site.click_redirect_site_url_id = 202_site_urls.site_url_id
";
$tracker_row = memcache_mysql_fetch_assoc($db, $tracker_sql);
$referrer = $tracker_row['user_pref_cloak_referer'];
if (!$tracker_row) {
$action_site_url = "/202-404.php";
$redirect_site_url = "/202-404.php";
} else {
$action_site_url = dirname($_SERVER['PHP_SELF'])."/cl2.php";
//modify the redirect site url to go through another cloaked link
$redirect_site_url = $tracker_row['site_url_address'];
}
$html['aff_campaign_name'] = $tracker_row['aff_campaign_name'];
if(isset($mysql['202vars'])&&$mysql['202vars']!=''){
//remove & at the end of the string
if(!parse_url ($redirect_site_url,PHP_URL_QUERY)){
//if there is no query url the add a ? to thecVars but before doing that remove case where there may be a ? at the end of the url and nothing else
$redirect_site_url = rtrim($redirect_site_url,'?');
//remove the & from thecVars and put a ? in front of it
$redirect_site_url .="?".$mysql['202vars'];
}
else {
$redirect_site_url .="&".$mysql['202vars'];
}}
?>
<?php echo $html['aff_campaign_name']; ?>