<h2>File Contents: /home/planet5/.trash/tracking202/static/record_adv.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/static/record_adv.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php header(&quot;Pragma: no-cache&quot;);
header(&quot;Expires: -1&quot;); 

include_once(substr(dirname( __FILE__ ), 0,-19) . &#039;/202-config/connect2.php&#039;); 
include_once(substr(dirname( __FILE__ ), 0,-19) . &#039;/202-config/class-dataengine-slim.php&#039;);

$landing_page_id_public = $_GET[&#039;lpip&#039;];
$mysql[&#039;landing_page_id_public&#039;] = $db-&gt;real_escape_string($landing_page_id_public);
$tracker_sql = &quot;SELECT  202_landing_pages.user_id,
						  202_landing_pages.landing_page_id,
                          202_landing_pages.leave_behind_page_url 
				FROM     202_landing_pages
				WHERE  202_landing_pages.landing_page_id_public=&#039;&quot;.$mysql[&#039;landing_page_id_public&#039;].&quot;&#039;&quot;;   
$tracker_row = memcache_mysql_fetch_assoc($db, $tracker_sql);    

//set the timezone to the users timezone
$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;user_id&#039;]);
$user_sql = &quot;SELECT 		user_timezone, 
							user_keyword_searched_or_bidded,
                            user_pref_referer_data,
                            user_pref_dynamic_bid,
							maxmind_isp 
			   FROM 		202_users 
			   LEFT JOIN	202_users_pref USING (user_id)
			   WHERE 		202_users.user_id=&#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;&quot;;
$user_row = memcache_mysql_fetch_assoc($db, $user_sql);
$mysql[&#039;user_pref_dynamic_bid&#039;] = $db-&gt;real_escape_string($user_row[&#039;user_pref_dynamic_bid&#039;]);

//now this sets it
AUTH::set_timezone($user_row[&#039;user_timezone&#039;]);

if (!$tracker_row) { die(); }

// get publisher id
if (isset($_GET[&#039;t202pubid&#039;])) {
    $mysql[&#039;public_pub_id&#039;] = $db-&gt;real_escape_string($_GET[&#039;t202pubid&#039;]);

    $mysql[&#039;pub_id&#039;] = getPublisher($mysql[&#039;public_pub_id&#039;]);
    if (isset($mysql[&#039;pub_id&#039;]) &amp;&amp; $mysql[&#039;pub_id&#039;] != &#039;1&#039;) {
        $mysql[&#039;user_id&#039;] = $mysql[&#039;pub_id&#039;];

    }
}


if ($_GET[&#039;t202id&#039;]) { 
	//grab tracker data if avaliable
	$mysql[&#039;tracker_id_public&#039;] = $db-&gt;real_escape_string($_GET[&#039;t202id&#039;]);

	$tracker_sql2 = &quot;
		SELECT
			tr.text_ad_id,
			tr.ppc_account_id,
			tr.click_cpc,
			tr.click_cloaking,
			tr.aff_campaign_id,
			2cv.ppc_variable_ids,
			2cv.parameters
		FROM
			202_trackers AS tr
			LEFT JOIN 202_ppc_accounts AS 2ppc USING (ppc_account_id)
			LEFT JOIN (SELECT ppc_network_id, GROUP_CONCAT(ppc_variable_id) AS ppc_variable_ids, GROUP_CONCAT(parameter) AS parameters FROM 202_ppc_network_variables GROUP BY ppc_network_id) AS 2cv USING (ppc_network_id)		
		WHERE
			tr.tracker_id_public=&#039;&quot;.$mysql[&#039;tracker_id_public&#039;].&quot;&#039;&quot;;   
	$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&#039;t already exisit

//get mysql variables 
//$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;user_id&#039;]);
$mysql[&#039;aff_campaign_id&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;aff_campaign_id&#039;]);
if($tracker_row[&#039;ppc_account_id&#039;]==&#039;&#039;){
	$default_account_sql = &quot;SELECT `ppc_account_id` from 202_ppc_accounts where ppc_account_default = 1&quot;;
	$default_account_row = memcache_mysql_fetch_assoc($db, $default_account_sql);
	$mysql[&#039;ppc_account_id&#039;] = $db-&gt;real_escape_string($default_account_row[&#039;ppc_account_id&#039;]);
}
else{
	$mysql[&#039;ppc_account_id&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;ppc_account_id&#039;]);
}

// set cpc use dynamic variable if set or the default if not
if (isset ( $_GET [&#039;t202b&#039;] ) &amp;&amp; $mysql[&#039;user_pref_dynamic_bid&#039;] == &#039;1&#039;) {
    $_GET [&#039;t202b&#039;]=ltrim($_GET [&#039;t202b&#039;],&#039;$&#039;);
    if(is_numeric ( $_GET [&#039;t202b&#039;] )){
        $bid = number_format ( $_GET [&#039;t202b&#039;], 5, &#039;.&#039;, &#039;&#039; );
        $mysql [&#039;click_cpc&#039;] = $db-&gt;real_escape_string ( $bid );
    }
    else{
        $mysql [&#039;click_cpc&#039;] = $db-&gt;real_escape_string ( $tracker_row [&#039;click_cpc&#039;] );
    }
} else

$mysql[&#039;click_cpc&#039;] = $db-&gt;real_escape_string ( $tracker_row [&#039;click_cpc&#039;] );

$mysql[&#039;landing_page_id&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;landing_page_id&#039;]);
$mysql[&#039;text_ad_id&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;text_ad_id&#039;]);

/* ok, if $_GET[&#039;OVRAW&#039;] that is a yahoo keyword, if on the REFER, there is a $_GET[&#039;q], that is a GOOGLE keyword... */
//so this is going to check the REFERER URL, for a ?q=, which is the ACUTAL KEYWORD searched.
$referer_url_parsed = @parse_url($_GET[&#039;referer&#039;]);
$referer_url_query = $referer_url_parsed[&#039;query&#039;];
 
@parse_str($referer_url_query, $referer_query);

switch ($user_row[&#039;user_keyword_searched_or_bidded&#039;]) { 
	
	case &quot;bidded&quot;:
	      #try to get the bidded keyword first
		if ($_GET[&#039;OVKEY&#039;]) { //if this is a Y! keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;OVKEY&#039;]);   
		} elseif ($_GET[&#039;t202kw&#039;]) { 
			$keyword = $db-&gt;real_escape_string($_GET[&#039;t202kw&#039;]);  
		} elseif ($_GET[&#039;target_passthrough&#039;]) { //if this is a mediatraffic! keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;target_passthrough&#039;]);   
		} else { //if this is a zango, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;keyword&#039;]);   
		} 
		break;
	case &quot;searched&quot;:
		#try to get the searched keyword
		if ($referer_query[&#039;q&#039;]) { 
			$keyword = $db-&gt;real_escape_string($referer_query[&#039;q&#039;]);
		} elseif ($_GET[&#039;OVRAW&#039;]) { //if this is a Y! keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;OVRAW&#039;]);   
		} elseif ($_GET[&#039;target_passthrough&#039;]) { //if this is a mediatraffic! keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;target_passthrough&#039;]);   
		} elseif ($_GET[&#039;keyword&#039;]) { //if this is a zango, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;keyword&#039;]);   
		} elseif ($_GET[&#039;search_word&#039;]) { //if this is a eniro, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;search_word&#039;]);   
		} elseif ($_GET[&#039;query&#039;]) { //if this is a naver, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;query&#039;]);   
		} elseif ($_GET[&#039;encquery&#039;]) { //if this is a aol, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;encquery&#039;]);   
		} elseif ($_GET[&#039;terms&#039;]) { //if this is a about.com, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;terms&#039;]);   
		} elseif ($_GET[&#039;rdata&#039;]) { //if this is a viola, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;rdata&#039;]);   
		} elseif ($_GET[&#039;qs&#039;]) { //if this is a virgilio, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;qs&#039;]);   
		} elseif ($_GET[&#039;wd&#039;]) { //if this is a baidu, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;wd&#039;]);   
		} elseif ($_GET[&#039;text&#039;]) { //if this is a yandex, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;text&#039;]);   
		} elseif ($_GET[&#039;szukaj&#039;]) { //if this is a wp.pl, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;szukaj&#039;]);   
		} elseif ($_GET[&#039;qt&#039;]) { //if this is a O*net, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;qt&#039;]);   
		} elseif ($_GET[&#039;k&#039;]) { //if this is a yam, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;k&#039;]);   
		} elseif ($_GET[&#039;words&#039;]) { //if this is a Rambler, or more keyword
			$keyword = $db-&gt;real_escape_string($_GET[&#039;words&#039;]);   
		} else { 
			$keyword = $db-&gt;real_escape_string($_GET[&#039;t202kw&#039;]);
		}
		break;
}

if (substr($keyword, 0, 8) == &#039;t202var_&#039;) {
	$t202var = substr($keyword, strpos($keyword, &quot;_&quot;) + 1);

	if (isset($_GET[$t202var])) {
		$keyword = $_GET[$t202var];
	}
}

$keyword = str_replace(&#039;%20&#039;,&#039; &#039;,$keyword);  
$keyword_id = INDEXES::get_keyword_id($db, $keyword); 
$mysql[&#039;keyword_id&#039;] = $db-&gt;real_escape_string($keyword_id); 

$c1 = $db-&gt;real_escape_string($_GET[&#039;c1&#039;]);
$c1 = str_replace(&#039;%20&#039;,&#039; &#039;,$c1);  
$c1_id = INDEXES::get_c1_id($db, $c1); 
$mysql[&#039;c1_id&#039;] = $db-&gt;real_escape_string($c1_id);

$c2 = $db-&gt;real_escape_string($_GET[&#039;c2&#039;]);
$c2 = str_replace(&#039;%20&#039;,&#039; &#039;,$c2);
$c2_id = INDEXES::get_c2_id($db, $c2);
$mysql[&#039;c2_id&#039;] = $db-&gt;real_escape_string($c2_id);

$c3 = $db-&gt;real_escape_string($_GET[&#039;c3&#039;]);
$c3 = str_replace(&#039;%20&#039;,&#039; &#039;,$c3);  
$c3_id = INDEXES::get_c3_id($db, $c3); 
$mysql[&#039;c3_id&#039;] = $db-&gt;real_escape_string($c3_id);

$c4 = $db-&gt;real_escape_string($_GET[&#039;c4&#039;]);
$c4 = str_replace(&#039;%20&#039;,&#039; &#039;,$c4);
$c4_id = INDEXES::get_c4_id($db, $c4);
$mysql[&#039;c4_id&#039;] = $db-&gt;real_escape_string($c4_id);

$mysql[&#039;gclid&#039;]= $db-&gt;real_escape_string($_GET[&#039;gclid&#039;]);


$custom_var_ids = array();

$ppc_variable_ids = explode(&#039;,&#039;, $tracker_row[&#039;ppc_variable_ids&#039;]);
$parameters = explode(&#039;,&#039;, $tracker_row[&#039;parameters&#039;]);

foreach ($parameters as $key =&gt; $value) {
	$variable = $db-&gt;real_escape_string($_GET[$value]);

	if (isset($variable) &amp;&amp; $variable != &#039;&#039;) {
		$variable = str_replace(&#039;%20&#039;,&#039; &#039;,$variable);
		$variable_id = INDEXES::get_variable_id($db, $variable, $ppc_variable_ids[$key]);
		$custom_var_ids[] = $variable_id;
	} 
}

//utm_source
$utm_source = $db-&gt;real_escape_string($_GET[&#039;utm_source&#039;]);
if(isset($utm_source) &amp;&amp; $utm_source != &#039;&#039;)
{
    $utm_source = str_replace(&#039;%20&#039;,&#039; &#039;,$utm_source);
    $utm_source_id = INDEXES::get_utm_id($db, $utm_source, &#039;utm_source&#039;);
}
else{
    $utm_source_id=0;
}
$mysql[&#039;utm_source_id&#039;]=$db-&gt;real_escape_string($utm_source_id);

//utm_medium
$utm_medium = $db-&gt;real_escape_string($_GET[&#039;utm_medium&#039;]);
if(isset($utm_medium) &amp;&amp; $utm_medium != &#039;&#039;)
{
    $utm_medium = str_replace(&#039;%20&#039;,&#039; &#039;,$utm_medium);
    $utm_medium_id = INDEXES::get_utm_id($db, $utm_medium, &#039;utm_medium&#039;);
}
else{
    $utm_medium_id=0;
}
$mysql[&#039;utm_medium_id&#039;]=$db-&gt;real_escape_string($utm_medium_id);

//utm_campaign
$utm_campaign = $db-&gt;real_escape_string($_GET[&#039;utm_campaign&#039;]);
if(isset($utm_campaign) &amp;&amp; $utm_campaign != &#039;&#039;)
{
    $utm_campaign = str_replace(&#039;%20&#039;,&#039; &#039;,$utm_campaign);
    $utm_campaign_id = INDEXES::get_utm_id($db, $utm_campaign, &#039;utm_campaign&#039;);
}
else{
    $utm_campaign_id=0;
}
$mysql[&#039;utm_campaign_id&#039;]=$db-&gt;real_escape_string($utm_campaign_id);

//utm_term
$utm_term = $db-&gt;real_escape_string($_GET[&#039;utm_term&#039;]);
if(isset($utm_term) &amp;&amp; $utm_term != &#039;&#039;)
{
    $utm_term = str_replace(&#039;%20&#039;,&#039; &#039;,$utm_term);
    $utm_term_id = INDEXES::get_utm_id($db, $utm_term, &#039;utm_term&#039;);
}
else{
    $utm_term_id=0;
}
$mysql[&#039;utm_term_id&#039;]=$db-&gt;real_escape_string($utm_term_id);

//utm_content
$utm_content = $db-&gt;real_escape_string($_GET[&#039;utm_content&#039;]);
if(isset($utm_content) &amp;&amp; $utm_content != &#039;&#039;)
{
    $utm_content = str_replace(&#039;%20&#039;,&#039; &#039;,$utm_content);
    $utm_content_id = INDEXES::get_utm_id($db, $utm_content, &#039;utm_content&#039;);
}
else{
    $utm_content_id=0;
}
$mysql[&#039;utm_content_id&#039;]=$db-&gt;real_escape_string($utm_content_id);

$ip_id = INDEXES::get_ip_id($db, $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;]);
$mysql[&#039;ip_id&#039;] = $db-&gt;real_escape_string($ip_id);     

//$device_id = PLATFORMS::get_device_info($db);
$device_id = PLATFORMS::get_device_info($db,$detect,$_GET[&#039;ua&#039;]);
$mysql[&#039;platform_id&#039;] = $db-&gt;real_escape_string($device_id[&#039;platform&#039;]); 
$mysql[&#039;browser_id&#039;] = $db-&gt;real_escape_string($device_id[&#039;browser&#039;]);
$mysql[&#039;device_id&#039;] = $db-&gt;real_escape_string($device_id[&#039;device&#039;]);

if ($device_id[&#039;type&#039;] == &#039;4&#039;) {
	$mysql[&#039;click_bot&#039;] = &#039;1&#039;;
} else {
	$mysql[&#039;click_bot&#039;] = &#039;0&#039;;
}

$mysql[&#039;click_in&#039;] = 1;
$mysql[&#039;click_out&#039;] = 0;

// if user wants to use t202ref from url variable use that first if it&#039;s not set try and get it from the ref url
if ($user_row[&#039;user_pref_referer_data&#039;] == &#039;t202ref&#039;) {
    if (isset($_GET[&#039;t202ref&#039;]) &amp;&amp; $_GET[&#039;t202ref&#039;] != &#039;&#039;) { //check for t202ref value
        $mysql[&#039;t202ref&#039;]= $db-&gt;real_escape_string($_GET[&#039;t202ref&#039;]);
        $click_referer_site_url_id = INDEXES::get_site_url_id($db, $mysql[&#039;t202ref&#039;]);
    } else { //if not found revert to what we usually do
        if ($referer_query[&#039;url&#039;]) {
            $click_referer_site_url_id = INDEXES::get_site_url_id($db, $referer_query[&#039;url&#039;]);
        } else {
            $click_referer_site_url_id = INDEXES::get_site_url_id($db, $_GET[&#039;referer&#039;]);
        }
    }
} else { //user wants the real referer first

    // now lets get variables for clicks site
    // so this is going to check the REFERER URL, for a ?url=, which is the ACUTAL URL, instead of the google content, pagead2.google....
    if ($referer_query[&#039;url&#039;]) {
        $click_referer_site_url_id = INDEXES::get_site_url_id($db, $referer_query[&#039;url&#039;]);
    } else {
        $click_referer_site_url_id = INDEXES::get_site_url_id($db, $_GET[&#039;referer&#039;]);
    }
}

$mysql[&#039;click_referer_site_url_id&#039;] = $db-&gt;real_escape_string($click_referer_site_url_id); 


 //see if this click should be filtered
$ip_address = $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;];
$user_id = $tracker_row[&#039;user_id&#039;];

//GEO Lookup
$GeoData = getGeoData($ip_address);

$country_id = INDEXES::get_country_id($db, $GeoData[&#039;country&#039;], $GeoData[&#039;country_code&#039;]);
$mysql[&#039;country_id&#039;] = $db-&gt;real_escape_string($country_id);

$region_id = INDEXES::get_region_id($db, $GeoData[&#039;region&#039;], $mysql[&#039;country_id&#039;]);
$mysql[&#039;region_id&#039;] = $db-&gt;real_escape_string($region_id);

$city_id = INDEXES::get_city_id($db, $GeoData[&#039;city&#039;], $mysql[&#039;country_id&#039;]);
$mysql[&#039;city_id&#039;] = $db-&gt;real_escape_string($city_id);


if ($user_row[&#039;maxmind_isp&#039;] == &#039;1&#039;) {
	$IspData = getIspData($ip_address);
	$isp_id = INDEXES::get_isp_id($db, $IspData);
	$mysql[&#039;isp_id&#039;] = $db-&gt;real_escape_string($isp_id);
} else {
	$mysql[&#039;isp_id&#039;] = &#039;0&#039;;
}

if ($device_id[&#039;type&#039;] == &#039;4&#039;) {
	$mysql[&#039;click_filtered&#039;] = &#039;1&#039;;
} else {
	$click_filtered = FILTER::startFilter($db, $click_id,$ip_id,$ip_address,$user_id);
	$mysql[&#039;click_filtered&#039;] = $db-&gt;real_escape_string($click_filtered);
}

if (isset($_COOKIE[&#039;tracking202rlp_&#039; . $landing_page_id_public])) {
    $click_id = substr($_COOKIE[&#039;tracking202rlp_&#039; . $landing_page_id_public], 1, - 1);
    $click_id_public = $_COOKIE[&#039;tracking202rlp_&#039; . $landing_page_id_public];
    $click_sql=&quot;Select click_time from 202_clicks where click_id=&quot;.$click_id.&quot; order by click_time limit 1&quot;;
    $click_row = memcache_mysql_fetch_assoc($db, $click_sql);
    $mysql[&#039;click_time&#039;]=$db-&gt;real_escape_string($click_row[&#039;click_time&#039;]);
} else {
  //ok we have the main data, now insert this row
$click_sql = &quot;INSERT INTO 202_clicks_counter SET click_id=DEFAULT&quot;; 
$click_result = $db-&gt;query($click_sql);
$mysql[&#039;click_time&#039;] = time();

//now gather the info for the advance click insert
$click_id = $db-&gt;insert_id;
$click_id_public = rand(1,9) . $click_id . rand(1,9);
}

$mysql[&#039;click_id&#039;] = $db-&gt;real_escape_string($click_id);
$mysql[&#039;click_id_public&#039;] = $db-&gt;real_escape_string($click_id_public);


//because this is a simple landing page, set click_alp (which stands for click advanced landing page, equal to 0)
$mysql[&#039;click_alp&#039;] = 1;

//ok we have the main data, now insert this row
$click_sql = &quot;INSERT INTO   202_clicks
			  SET           	click_id=&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;,
							user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;,   
							landing_page_id=&#039;&quot;.$mysql[&#039;landing_page_id&#039;].&quot;&#039;,
							ppc_account_id = &#039;&quot;.$mysql[&#039;ppc_account_id&#039;].&quot;&#039;,   
							click_cpc = &#039;&quot;.$mysql[&#039;click_cpc&#039;].&quot;&#039;,   
							click_filtered = &#039;&quot;.$mysql[&#039;click_filtered&#039;].&quot;&#039;,
							click_bot = &#039;&quot;.$mysql[&#039;click_bot&#039;].&quot;&#039;,   
							click_alp = &#039;&quot;.$mysql[&#039;click_alp&#039;].&quot;&#039;,   
							click_time = &#039;&quot;.$mysql[&#039;click_time&#039;].&quot;&#039;
							ON DUPLICATE KEY UPDATE
							 click_alp = &#039;&quot;.$mysql[&#039;click_alp&#039;].&quot;&#039;&quot;;
					 
$click_result = $db-&gt;query($click_sql) or record_mysql_error($db, $click_sql);

$total_vars = count($custom_var_ids);

if ($total_vars &gt; 0) {

	$variables = implode (&quot;,&quot;, $custom_var_ids);
	$variable_set_id = INDEXES::get_variable_set_id($db, $variables);

	$mysql[&#039;variable_set_id&#039;] = $db-&gt;real_escape_string($variable_set_id);  

	$var_sql = &quot;INSERT INTO 202_clicks_variable (click_id, variable_set_id) VALUES (&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;, &#039;&quot;.$mysql[&#039;variable_set_id&#039;].&quot;&#039;)&quot;;
	$var_result = $db-&gt;query($var_sql) or record_mysql_error($db, $var_sql);
} else {
	$var_sql = &quot;INSERT INTO 202_clicks_variable (click_id, variable_set_id) VALUES (&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;,0)&quot;;
	$var_result = $db-&gt;query($var_sql) or record_mysql_error($db, $var_sql);
}


// insert gclid and utm vars
$click_sql = &quot;INSERT IGNORE INTO   202_google
			  SET           	click_id=&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;,
							gclid = &#039;&quot;.$mysql[&#039;gclid&#039;].&quot;&#039;,
                            utm_source_id = &#039;&quot;.$mysql[&#039;utm_source_id&#039;].&quot;&#039;,
                            utm_medium_id = &#039;&quot;.$mysql[&#039;utm_medium_id&#039;].&quot;&#039;,
utm_campaign_id = &#039;&quot;.$mysql[&#039;utm_campaign_id&#039;].&quot;&#039;,
utm_term_id = &#039;&quot;.$mysql[&#039;utm_term_id&#039;].&quot;&#039;,
utm_content_id = &#039;&quot;.$mysql[&#039;utm_content_id&#039;].&quot;&#039;&quot;;
$click_result = $db-&gt;query($click_sql) or record_mysql_error($db, $click_sql);

//now we have the click&#039;s advance data, now insert this row
$click_sql = &quot;INSERT IGNORE INTO  202_clicks_advance
			  SET           	click_id=&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;,
							text_ad_id=&#039;&quot;.$mysql[&#039;text_ad_id&#039;].&quot;&#039;,
							keyword_id=&#039;&quot;.$mysql[&#039;keyword_id&#039;].&quot;&#039;,
							ip_id=&#039;&quot;.$mysql[&#039;ip_id&#039;].&quot;&#039;,
							country_id=&#039;&quot;.$mysql[&#039;country_id&#039;].&quot;&#039;,
							region_id=&#039;&quot;.$mysql[&#039;region_id&#039;].&quot;&#039;,
							isp_id=&#039;&quot;.$mysql[&#039;isp_id&#039;].&quot;&#039;,
							city_id=&#039;&quot;.$mysql[&#039;city_id&#039;].&quot;&#039;,
							platform_id=&#039;&quot;.$mysql[&#039;platform_id&#039;].&quot;&#039;,
							browser_id=&#039;&quot;.$mysql[&#039;browser_id&#039;].&quot;&#039;,
							device_id=&#039;&quot;.$mysql[&#039;device_id&#039;].&quot;&#039;&quot;;
$click_result = $db-&gt;query($click_sql) or record_mysql_error($db, $click_sql);  

//insert the tracking data
$click_sql = &quot;
	INSERT IGNORE INTO
		202_clicks_tracking
	SET
		click_id=&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;,
		c1_id = &#039;&quot;.$mysql[&#039;c1_id&#039;].&quot;&#039;,
		c2_id = &#039;&quot;.$mysql[&#039;c2_id&#039;].&quot;&#039;,
		c3_id = &#039;&quot;.$mysql[&#039;c3_id&#039;].&quot;&#039;,
		c4_id = &#039;&quot;.$mysql[&#039;c4_id&#039;].&quot;&#039;&quot;;
$click_result = $db-&gt;query($click_sql) or record_mysql_error($db, $click_sql);

if (!$tracker_row[&#039;click_cloaking&#039;]) { 
	$mysql[&#039;click_cloaking&#039;] = -1; 
} else {
	$mysql[&#039;click_cloaking&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;click_cloaking&#039;]); 	
}


//ok we have our click recorded table, now lets insert theses
$click_sql = &quot;INSERT IGNORE INTO   202_clicks_record
			  SET           	click_id=&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;,
							click_id_public=&#039;&quot;.$mysql[&#039;click_id_public&#039;].&quot;&#039;,
							click_cloaking=&#039;&quot;.$mysql[&#039;click_cloaking&#039;].&quot;&#039;,
							click_in=&#039;&quot;.$mysql[&#039;click_in&#039;].&quot;&#039;,
							click_out=&#039;&quot;.$mysql[&#039;click_out&#039;].&quot;&#039;&quot;; 
$click_result = $db-&gt;query($click_sql) or record_mysql_error($db, $click_sql);
							

$landing_site_url = $_SERVER[&#039;HTTP_REFERER&#039;];
$click_landing_site_url_id = INDEXES::get_site_url_id($db, $landing_site_url); 
$mysql[&#039;click_landing_site_url_id&#039;] = $db-&gt;real_escape_string($click_landing_site_url_id);

$old_lp_site_url = &#039;http://&#039;.$_SERVER[&#039;REDIRECT_SERVER_NAME&#039;].&#039;/lp/&#039;.$landing_page_id_public;  

//insert this
$click_sql = &quot;INSERT INTO   202_clicks_site
			  SET           	click_id=&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;,
							click_referer_site_url_id=&#039;&quot;.$mysql[&#039;click_referer_site_url_id&#039;].&quot;&#039;,
							click_landing_site_url_id=&#039;&quot;.$mysql[&#039;click_landing_site_url_id&#039;].&quot;&#039;,
							click_outbound_site_url_id=&#039;0&#039;,
							click_cloaking_site_url_id=&#039;0&#039;,
							click_redirect_site_url_id=&#039;0&#039;
							ON DUPLICATE KEY UPDATE
							click_referer_site_url_id = &#039;&quot;.$mysql[&#039;click_referer_site_url_id&#039;].&quot;&#039;,
							click_landing_site_url_id=&#039;&quot;.$mysql[&#039;click_landing_site_url_id&#039;].&quot;&#039;&quot;;
$click_result = $db-&gt;query($click_sql) or record_mysql_error($db, $click_sql);


//set the cookie
setClickIdCookie($mysql[&#039;click_id&#039;],$mysql[&#039;aff_campaign_id&#039;]);
//set the PCI Cookie
setPCIdCookie($mysql[&#039;click_id_public&#039;]);

//set dirty hour
$de = new DataEngine();
$data=($de-&gt;setDirtyHour($mysql[&#039;click_id&#039;]));

if (isset($_COOKIE[&#039;p202_ipx&#039;])) {
	$mysql[&#039;p202_ipx&#039;] = $db-&gt;real_escape_string($_COOKIE[&#039;p202_ipx&#039;]);
	$db-&gt;query(&quot;UPDATE 202_clicks_impressions SET click_id = &#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039; WHERE impression_id = &#039;&quot;.$mysql[&#039;p202_ipx&#039;].&quot;&#039;&quot;);
}

?&gt;
 &lt;?php

if ($tracker_row[&#039;leave_behind_page_url&#039;]) {
    ?&gt;
var lb_url =&#039;&lt;?php echo $tracker_row[&#039;leave_behind_page_url&#039;]; ?&gt;&#039;;
function leavebehind202() {

this.target=&quot;_blank&quot;;
	setTimeout(&#039;window.location.href =lb_url&#039;, 200);
return true;
}

var _202links = document.links;
var txt = &quot;&quot;;
var i;
for (i = 0; i &lt; _202links.length; i++) {
    txt = _202links[i].href;
    if((txt.search(&quot;acip=&quot;)!==-1) || (_202links[i].dataset.lb202 ===&#039;1&#039;)){
    _202links[i].addEventListener(&quot;click&quot;, leavebehind202);}
}
var el = document.getElementById(&quot;202_lb&quot;);
if(el)
    el.addEventListener(&quot;click&quot;, leavebehind202);
 &lt;?php

}
?&gt;
function t202initB() { 

	var subid =&#039;&lt;?php echo $click_id; ?&gt;&#039;;
	createCookie(&#039;tracking202subid&#039;,subid,0);
	
	var pci = &#039;&lt;?php echo $click_id_public; ?&gt;&#039;;
	createCookie(&#039;tracking202pci&#039;,pci,0);

}

t202initB(); </textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fstatic'>⬅ Back to Directory</a>