get(md5('lp_'.$lpip.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); } if (isset ( $urlvars ) && $urlvars != '') { // remove & at the end of the string $urlvars = rtrim ( $urlvars, '&' ); if (! parse_url ( $new_url, PHP_URL_QUERY )) { // if there is no query url the add a ? to url but before doing that remove case where there may be a ? at the end of the url and nothing else $new_url = rtrim ( $new_url, '?' ); // remove the & from url and put a ? in fron t of it $new_url .= "?" . $urlvars; } else { $new_url .= "&" . $urlvars; } } header('location: '. $new_url); die(); } } die("

Error establishing a database connection - please contact the webhost

"); } $mysql['landing_page_id_public'] = $db->real_escape_string($lpip); $tracker_sql = "SELECT 202_landing_pages.user_id, 202_landing_pages.landing_page_id, 202_landing_pages.landing_page_id_public, 202_landing_pages.aff_campaign_id, 202_aff_campaigns.aff_campaign_rotate, 202_aff_campaigns.aff_campaign_url, 202_aff_campaigns.aff_campaign_url_2, 202_aff_campaigns.aff_campaign_url_3, 202_aff_campaigns.aff_campaign_url_4, 202_aff_campaigns.aff_campaign_url_5, 202_aff_campaigns.aff_campaign_payout, 202_aff_campaigns.aff_campaign_cloaking FROM 202_landing_pages, 202_aff_campaigns WHERE 202_landing_pages.landing_page_id_public='".$mysql['landing_page_id_public']."' AND 202_aff_campaigns.aff_campaign_id = 202_landing_pages.aff_campaign_id"; $tracker_row = memcache_mysql_fetch_assoc($db, $tracker_sql); if (!$tracker_row) { die(); } if ($memcacheWorking) { $url = $tracker_row['aff_campaign_url']."&subid=p202"; $tid = $lpip; $getKey = $memcache->get(md5('lp_'.$tid.systemHash())); if($getKey === false){ $setUrl = setCache(md5('lp_'.$tid.systemHash()), $url, 0); } } //grab the GET variables from the LANDING PAGE $landing_page_site_url_address_parsed = parse_url($_SERVER['HTTP_REFERER']); parse_str($landing_page_site_url_address_parsed['query'], $_GET); if ($_GET['t202id']) { //grab tracker data if avaliable $mysql['tracker_id_public'] = $db->real_escape_string($_GET['t202id']); $tracker_sql2 = "SELECT text_ad_id, ppc_account_id, click_cpc, click_cloaking FROM 202_trackers WHERE tracker_id_public='".$mysql['tracker_id_public']."'"; $tracker_row2 = memcache_mysql_fetch_assoc($db, $tracker_sql2); if ($tracker_row2) { $tracker_row = array_merge($tracker_row,$tracker_row2); } } //INSERT THIS CLICK BELOW, if this click doesn't already exisit //get mysql variables $mysql['user_id'] = $db->real_escape_string($tracker_row['user_id']); $mysql['aff_campaign_id'] = $db->real_escape_string($tracker_row['aff_campaign_id']); $mysql['ppc_account_id'] = $db->real_escape_string($tracker_row['ppc_account_id']); $mysql['click_cpc'] = $db->real_escape_string($tracker_row['click_cpc']); $mysql['click_payout'] = $db->real_escape_string($tracker_row['aff_campaign_payout']); $mysql['click_time'] = time(); $mysql['landing_page_id'] = $db->real_escape_string($tracker_row['landing_page_id']); $mysql['text_ad_id'] = $db->real_escape_string($tracker_row['text_ad_id']); //now gather variables for the clicks record db //lets determine if cloaking is on if (($tracker_row['click_cloaking'] == 1) or //if tracker has overrided cloaking on (($tracker_row['click_cloaking'] == -1) and ($tracker_row['aff_campaign_cloaking'] == 1)) or ((!isset($tracker_row['click_cloaking'])) and ($tracker_row['aff_campaign_cloaking'] == 1)) //if no tracker but but by default campaign has cloaking on ) { $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 = $strProtocol.'://'.$_SERVER['SERVER_NAME'] . dirname($_SERVER['PHP_SELF']).'/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 = " UPDATE 202_clicks_record SET click_out='".$mysql['click_out']."', click_cloaking='".$mysql['click_cloaking']."' WHERE click_id='".$mysql['click_id']."'"; $click_result = $db->query($update_sql) or record_mysql_error($db, $update_sql); //delay_sql($db, $update_sql); //set dirty hour $de = new DataEngine(); $data=($de->setDirtyHour($mysql['click_id'])); $redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url,$mysql['click_id'],$mysql); $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();