//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)); }
$mysql['202vars'] = base64_decode($db->real_escape_string($_GET['202vars'])); } $tracker_sql = "SELECT aff_campaign_name,\n\t\t\t\t\t\t aff_campaign_rotate,\n\t\t\t\t\t\t aff_campaign_url,\n\t\t\t\t\t\t aff_campaign_url_2,\n\t\t\t\t\t\t aff_campaign_url_3,\n\t\t\t\t\t\t aff_campaign_url_4,\n\t\t\t\t\t\t aff_campaign_url_5\n\t\t\t\tFROM 202_landing_pages LEFT JOIN 202_aff_campaigns USING (aff_campaign_id)\n\t\t\t\tWHERE landing_page_id_public='" . $mysql['landing_page_id_public'] . "'"; $tracker_row = memcache_mysql_fetch_assoc($db, $tracker_sql); if (!$tracker_row) { die; } //DONT ESCAPE THE DESITNATIONL URL IT TOTALLY SCREWS UP $html['aff_campaign_name'] = htmlentities($tracker_row['aff_campaign_name'], ENT_QUOTES, 'UTF-8'); //modify the redirect site url to go through another cloaked link $redirect_site_url = rotateTrackerUrl($db, $tracker_row); // get the click id $click_id = $_COOKIE['tracking202subid']; $redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url, $click_id); if (isset($mysql['202vars'])) { $redirect_site_url = setPrePopVars($mysql['202vars'], $redirect_site_url, false); } ?> <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; ?> "> </head>
$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; ?> ">