Prosellers Shell V2.0

Editing: lp.php

Cancel

<?php 
$vars=$_GET;
#only allow numeric t202ids
$lpip = $_GET['lpip']; 
if (!is_numeric($lpip)) die();

# check to see if mysql connection works, if not fail over to cached stored redirect urls
include_once(str_repeat("../", 2).'202-config/connect2.php'); 
include_once(str_repeat("../", 2).'202-config/class-dataengine-slim.php');

if ( isset( $_SERVER["HTTPS"] ) && strtolower( $_SERVER["HTTPS"] ) == "on" ) {
    $strProtocol = 'https';
} else {
    $strProtocol = 'http';
}
$usedCachedRedirect = false; 
if (!$db) $usedCachedRedirect = true;

#the mysql server is down, use the txt cached redirect
if ($usedCachedRedirect==true) {

$lpip = $_GET['lpip'];

//if a cached key is found for this lpip, redirect to that url
		if ($memcacheWorking) {
			$getUrl = $memcache->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("<h2>Error establishing a database connection - please contact the webhost</h2>");
}

$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(); }

//get click id
$click_id = $_GET['click_id'];

if($click_id=='' || !is_numeric($click_id)){ 
    $mysql['ip_address'] = $ip_address->address;
    $daysago = time() - 86400 * 2; // past 48 hours
    $subid_sql="SELECT MAX(click_id) as click_id,click_id_public,202_ips.ip_address,202_ips.ip_id
	FROM 202_clicks_record
	LEFT JOIN 202_clicks USING (click_id)
	LEFT JOIN 202_clicks_advance USING (click_id)
	LEFT JOIN 202_ips USING (ip_id)
	LEFT JOIN 202_ips_v6 AS 2i6 ON (2i6.ip_id=202_ips.ip_address)
	WHERE 202_ips.ip_id='".INDEXES::get_ip_id($db,$ip_address)."'
	AND 202_clicks.click_time >= '".$daysago."'
	 AND click_id_public != '0'";
    $result = $db->query($subid_sql);
    $row = $result->fetch_assoc();
    $click_id=$row['click_id'];
}
else if($click_id=='' || !is_numeric($click_id)){
	if(null !== (getCookie202('tracking202subid_a_'.$tracker_row['aff_campaign_id']))) {
	$click_id = getCookie202('tracking202subid_a_'.$tracker_row['aff_campaign_id']);
	}
}

$mysql['click_id']=$db->real_escape_string($click_id);

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 = getClickIdPublic($click_id);
	$mysql['click_id_public'] = $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);

$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();

Editing: lp.php

Upload Files

Create New

Change Permissions

Change Date

Rename Item

Confirm Delete