<h2>File Contents: /home/planet5/public_html/tracking/tracking202/static/check_conversion.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/public_html/tracking/tracking202/static/check_conversion.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
include_once(substr(dirname( __FILE__ ), 0,-19) . &#039;/202-config/connect2.php&#039;);

header(&quot;Access-Control-Allow-Origin: *&quot;);
header(&#039;Cache-Control: no-cache&#039;);

if(null !== (getCookie202(&#039;t202defpix&#039;))) {
    $defpixels= unserialize(base64_decode(getCookie202(&#039;t202defpix&#039;)));   
}else{
    $defpixels= []; 
}

if(isset($_REQUEST[&#039;t202subid&#039;])){
    $mysql[&#039;click_id&#039;] = $db-&gt;real_escape_string($_REQUEST[&#039;t202subid&#039;]);
    
    if (!in_array($mysql[&#039;click_id&#039;], $defpixels)) {
        $notfound = true;
    }else{
        $payout = $memcache-&gt;get(md5($mysql[&#039;click_id&#039;].&#039;payout&#039;));
        if($payout){
            echo $payout;
        }else{
             getPayout($mysql);
             echo $mysql[&#039;click_payout&#039;];
        }
       header(&#039;HTTP/1.1 202 Moved Permanently&#039;);
        die();
    }
	if (is_numeric($mysql[&#039;click_id&#039;]) &amp;&amp; $notfound) {
		$site_urls=&quot; LEFT JOIN `202_clicks_site` AS 2cs ON (2c.click_id=2cs.click_id)
                 LEFT JOIN `202_site_urls` AS 2su ON (2cs.click_referer_site_url_id=2su.site_url_id) &quot;;
		
		//get c1-c4 values etc
		        $cvar_sql =&quot;
        SELECT 
            2cid.click_id,
            2c.user_id,
            2c.aff_campaign_id,
            2c.click_payout,
            2c.click_cpc,
            2c.click_lead,
            2c.click_time,
            2c.ppc_account_id,
            2pap.pixel_code,
            2pap.pixel_type_id,
            2c1.c1,
            2c2.c2,
            2c3.c3,
            2c4.c4,
            2kw.keyword,
            2g.gclid,
            2b.msclkid,
            2f.fbclid,
            2us.utm_source,
            2um.utm_medium,
            2uca.utm_campaign,
            2ut.utm_term,
            2uco.utm_content,
            2trc.click_cpa,
            2su.site_url_address,
            202_aff_campaigns.aff_campaign_payout
        FROM `202_clicks_tracking` AS 2cid
        LEFT JOIN `202_clicks_advance` AS 2ca USING (`click_id`)
        LEFT JOIN `202_google` AS 2g USING (`click_id`)
        LEFT JOIN `202_bing` AS 2b USING (`click_id`)
        LEFT JOIN `202_facebook` AS 2f USING (`click_id`)
        LEFT JOIN `202_clicks` AS 2c USING (`click_id`)
        LEFT JOIN 202_aff_campaigns ON (202_aff_campaigns.aff_campaign_id =  2c.aff_campaign_id) 
        LEFT JOIN 202_ppc_account_pixels 2pap USING (ppc_account_id)
        LEFT JOIN `202_tracking_c1` AS 2c1 USING (`c1_id`)
        LEFT JOIN `202_tracking_c2` AS 2c2 USING (`c2_id`)
        LEFT JOIN `202_tracking_c3` AS 2c3 USING (`c3_id`)
        LEFT JOIN `202_tracking_c4` AS 2c4 USING (`c4_id`)
        LEFT JOIN `202_utm_source` AS 2us ON (2g.`utm_source_id` = 2us.`utm_source_id` AND 2b.`utm_source_id` = 2us.`utm_source_id`)
        LEFT JOIN `202_utm_medium` AS 2um ON (2g.`utm_medium_id` = 2um.`utm_medium_id` AND 2b.`utm_medium_id` = 2um.`utm_medium_id` )
        LEFT JOIN `202_utm_campaign` AS 2uca ON (2g.`utm_campaign_id` = 2uca.`utm_campaign_id` AND 2b.`utm_campaign_id` = 2uca.`utm_campaign_id`)
        LEFT JOIN `202_utm_term` AS 2ut ON (2g.`utm_term_id` = 2ut.`utm_term_id` AND 2b.`utm_term_id` = 2ut.`utm_term_id`)
        LEFT JOIN `202_utm_content` AS 2uco ON (2g.`utm_content_id` = 2uco.`utm_content_id` AND 2b.`utm_content_id` = 2uco.`utm_content_id`)
        LEFT JOIN `202_keywords` AS 2kw ON (2ca.`keyword_id` = 2kw.`keyword_id`)
        LEFT JOIN `202_cpa_trackers` AS 2cpa USING (`click_id`)
        LEFT JOIN `202_trackers` AS 2trc ON (2cpa.`tracker_id_public` = 2trc.`tracker_id_public`)&quot;.$site_urls.&quot;
        WHERE 2c.`click_id` = {$mysql[&#039;click_id&#039;]}
        LIMIT 1&quot;;
		$cvar_sql_result = $db-&gt;query($cvar_sql);
		
		$cvar_sql_row = $cvar_sql_result-&gt;fetch_assoc();
				
		$mysql[&#039;original_click_payout&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;click_payout&#039;]);
		$mysql[&#039;t202kw&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;keyword&#039;]);
		$mysql[&#039;c1&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;c1&#039;]);
		$mysql[&#039;c2&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;c2&#039;]);
		$mysql[&#039;c3&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;c3&#039;]);
		$mysql[&#039;c4&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;c4&#039;]);
		$mysql[&#039;gclid&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;gclid&#039;]);
		$mysql[&#039;msclkid&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;msclkid&#039;]);
		$mysql[&#039;fbclid&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;fbclid&#039;]);
		$mysql[&#039;utm_source&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;utm_source&#039;]);
		$mysql[&#039;utm_medium&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;utm_medium&#039;]);
		$mysql[&#039;utm_campaign&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;utm_campaign&#039;]);
		$mysql[&#039;utm_term&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;utm_term&#039;]);
		$mysql[&#039;utm_content&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;utm_content&#039;]);
		$mysql[&#039;click_user_id&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;user_id&#039;]);
		$mysql[&#039;campaign_id&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;aff_campaign_id&#039;]);
        $mysql[&#039;payout&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;click_payout&#039;]);
        $mysql[&#039;click_payout&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;click_payout&#039;]);
        $mysql[&#039;click_payout_added&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;aff_campaign_payout&#039;]);
		$mysql[&#039;cpc&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;click_cpc&#039;]);
		$mysql[&#039;click_cpa&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;click_cpa&#039;]);
		$mysql[&#039;click_lead&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;click_lead&#039;]);
		$mysql[&#039;click_time&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;click_time&#039;]);
        $mysql[&#039;referer&#039;] = urlencode($db-&gt;real_escape_string($cvar_sql_row[&#039;site_url_address&#039;]));
        $mysql[&#039;pixel_code&#039;] = stripslashes(($cvar_sql_row[&#039;pixel_code&#039;]));
        $mysql[&#039;pixel_type_id&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;pixel_type_id&#039;]);
       
        
        if($mysql[&#039;pixel_code&#039;] == &#039;&#039; ){
		
            header(&#039;HTTP/1.1 202 Moved Permanently&#039;);
            die();
        }
        
		if($cvar_sql_row[&#039;ppc_account_id&#039;] == &#039;0&#039;){
			$mysql[&#039;ppc_account_id&#039;] = &#039;&#039;;
		}
		else{
			$mysql[&#039;ppc_account_id&#039;] = $db-&gt;real_escape_string($cvar_sql_row[&#039;ppc_account_id&#039;]);
		}
		
			$tokens = getTokens($mysql);

            if(isset($mysql[&#039;click_lead&#039;]) &amp;&amp; $mysql[&#039;click_lead&#039;]==1 &amp;&amp; isset($mysql[&#039;pixel_code&#039;]) &amp;&amp; $mysql[&#039;pixel_code&#039;] != &#039;&#039; ){
		
                header(&#039;HTTP/1.1 202 Moved Permanently&#039;);
                
                
            
                if($_GET[&#039;show&#039;] == 1){
                    if (!in_array($mysql[&#039;click_id&#039;], $defpixels)) {
                        $defpixels[] = $mysql[&#039;click_id&#039;];
                    }
                
                    //set the cookie for the PIXEL to fire, expire in 30 days
           $expire = 0;
           $expire_header = 0;
           $path = &#039;/&#039;;
           $domain = $_SERVER[&#039;HTTP_HOST&#039;];
           $secure = TRUE;
           $httponly = FALSE;
           
           //legacy cookies
           setcookie(&#039;t202defpix-legacy&#039;, base64_encode(serialize($defpixels)), $expire, &#039;/&#039;, $domain);
 
          //samesite=none secure cookies
          if (PHP_VERSION_ID &lt; 70300) {
              header(&#039;Set-Cookie: t202defpix=&#039;.base64_encode(serialize($defpixels)).&#039;;max-age=&#039;.$expire_header.&#039;;Path=/;Domain=&#039;.$domain.&#039;;SameSite=None; Secure&#039;);        
          }
          else {
              setcookie(&#039;t202defpix&#039; , base64_encode(serialize($defpixels)), [&#039;expires&#039; =&gt; $expire,&#039;path&#039; =&gt; &#039;/&#039;,&#039;domain&#039; =&gt; $domain,&#039;secure&#039; =&gt; $secure,&#039;httponly&#039; =&gt; $httponly,&#039;samesite&#039; =&gt; &#039;None&#039;]);
          }

                    if($mysql[&#039;pixel_type_id&#039;] == 5){
                        echo replaceTokens($mysql[&#039;pixel_code&#039;],$tokens); 
                        die();               
                    }
                }

                echo $mysql[&#039;payout&#039;]; //this payout is for the js pixel
                if ($memcacheWorking) {
                    setCache(md5($mysql[&#039;click_id&#039;].&#039;payout&#039;), $mysql[&#039;click_payout&#039;]);                                     
                } 
                die();
                
            }
		}
    
}
else{
    header(&#039;HTTP/1.1 202 Moved Permanently&#039;);
        die();
}

</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fpublic_html%2Ftracking%2Ftracking202%2Fstatic'>⬅ Back to Directory</a>