<h2>File Contents: /home/planet5/.trash/tracking202/visitors/download/index.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/visitors/download/index.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
include_once(str_repeat(&quot;../&quot;, 3).&#039;202-config/connect.php&#039;);
	
//make sure user is logged in or die
	AUTH::require_user();
	
//start displaying the data     
	header(&quot;Content-type: application/octet-stream&quot;);
	
# replace excelfile.xls with whatever you want the filename to default to
	header(&quot;Content-Disposition: attachment; filename=T202_visitors_&quot;.time().&quot;.xls&quot;);
	header(&quot;Pragma: no-cache&quot;);
	header(&quot;Expires: 0&quot;);  
		
	
//get stuff
	$command = &quot;SELECT 2c.click_id, 2c.click_time, 2c.click_alp, 2c.income, 2up.user_account_currency, text_ad_name, aff_campaign_name, aff_campaign_id_public, landing_page_nickname, ppc_network_name, ppc_account_name, ip_address, keyword, 2c.click_out, click_lead, click_filtered, click_id_public, click_cloaking, 2c.click_referer_site_url_id, click_landing_site_url_id, click_outbound_site_url_id, click_cloaking_site_url_id, click_redirect_site_url_id,	2b.browser_name, 2p.platform_name, 2d.device_name, 202_device_types.type_name, 2cy.country_name, 2cy.country_code, 2rg.region_name, 202_locations_city.city_name, 2is.isp_name, 
2su.site_url_address AS referer,2sd.site_domain_host AS referer_host,
2cl.site_url_address AS landing,2cld.site_domain_host AS landing_host,
2co.site_url_address AS outbound,2cod.site_domain_host AS outbound_host,
2cc.site_url_address AS cloaking,2ccd.site_domain_host AS cloaking_host,
2credir.site_url_address AS redirect,2credird.site_domain_host AS redirect_host,
gclid,
2uca.utm_campaign,2uco.utm_content,2um.utm_medium,2us.utm_source,2ut.utm_term
FROM 202_dataengine AS 2c
LEFT JOIN 202_users_pref AS 2up ON (2c.user_id = 2up.user_id)
LEFT JOIN 202_clicks_record USING (click_id) 
LEFT JOIN 202_clicks_site AS 2cs ON (2c.click_id = 2cs.click_id) 
LEFT JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id) 
LEFT JOIN 202_ppc_accounts AS 2pa ON (2c.ppc_account_id = 2pa.ppc_account_id)
LEFT JOIN 202_ppc_networks AS 2pn ON (2pa.ppc_network_id = 2pn.ppc_network_id) 
LEFT JOIN 202_landing_pages ON (202_landing_pages.landing_page_id = 2c.landing_page_id) 
LEFT JOIN 202_text_ads ON (202_text_ads.text_ad_id = 2c.text_ad_id) 
LEFT JOIN 202_ips AS 2i ON (2c.ip_id = 2i.ip_id) 
LEFT JOIN 202_keywords AS 2k ON (2c.keyword_id = 2k.keyword_id) 
LEFT JOIN 202_browsers AS 2b ON (2c.browser_id = 2b.browser_id) 
LEFT JOIN 202_platforms AS 2p ON (2c.platform_id = 2p.platform_id) 
LEFT JOIN 202_device_models AS 2d ON (2c.device_id = 2d.device_id) 
LEFT JOIN 202_device_types ON (202_device_types.type_id = 2d.device_type) 
LEFT JOIN 202_locations_country AS 2cy ON (2c.country_id = 2cy.country_id) 
LEFT JOIN 202_locations_region AS 2rg ON (2c.region_id = 2rg.region_id) 
LEFT JOIN 202_locations_city ON (202_locations_city.city_id = 2c.city_id) 
LEFT JOIN 202_locations_isp AS 2is ON (2c.isp_id = 2is.isp_id)
LEFT JOIN 202_site_urls AS 2su ON (2c.click_referer_site_url_id = 2su.site_url_id) 
LEFT JOIN 202_site_urls as 2cl ON (click_landing_site_url_id = 2cl.site_url_id) 
LEFT JOIN 202_site_urls as 2co ON (click_outbound_site_url_id = 2co.site_url_id) 
LEFT JOIN 202_site_urls as 2cc ON (click_cloaking_site_url_id = 2cc.site_url_id) 
LEFT JOIN 202_site_urls as 2credir ON (click_redirect_site_url_id = 2credir.site_url_id) 
LEFT JOIN 202_site_domains AS 2sd ON (2su.site_domain_id = 2sd.site_domain_id) 
LEFT JOIN 202_site_domains as 2cld ON (2cld.site_domain_id = 2cl.site_domain_id) 
LEFT JOIN 202_site_domains as 2cod ON (2cod.site_domain_id = 2co.site_domain_id) 
LEFT JOIN 202_site_domains as 2ccd ON (2ccd.site_domain_id = 2cc.site_domain_id) 
LEFT JOIN 202_site_domains as 2credird ON (2credird.site_domain_id = 2credir.site_domain_id) 
LEFT JOIN 202_google as 2g ON (2g.click_id = 2c.click_id )
LEFT JOIN 202_utm_campaign AS 2uca ON (2g.utm_campaign_id = 2uca.utm_campaign_id) 
LEFT JOIN 202_utm_content AS 2uco ON (2g.utm_content_id = 2uco.utm_content_id) 
LEFT JOIN 202_utm_medium AS 2um ON (2g.utm_medium_id = 2um.utm_medium_id) 
LEFT JOIN 202_utm_source AS 2us ON (2g.utm_source_id = 2us.utm_source_id) 
LEFT JOIN 202_utm_term AS 2ut ON (2g.utm_term_id = 2ut.utm_term_id) &quot;;
	$db_table = &quot;2c&quot;;
	$query = query($command, $db_table, true, true, true, &#039;  ORDER BY 2c.click_id DESC &#039;, $_POST[&#039;offset&#039;], false, false);
	

//run query
	$click_sql = $query[&#039;click_sql&#039;];
	$click_result = $db-&gt;query($click_sql) or record_mysql_error($click_sql); 
	//echo $click_sql;	
//html escape vars
	$html[&#039;from&#039;] = htmlentities($query[&#039;from&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
	$html[&#039;to&#039;] = htmlentities($query[&#039;to&#039;], ENT_QUOTES, &#039;UTF-8&#039;); 
	$html[&#039;rows&#039;] = htmlentities($query[&#039;rows&#039;], ENT_QUOTES, &#039;UTF-8&#039;); 

//set the timezone for the user, to display dates in their timezone
	AUTH::set_timezone($_SESSION[&#039;user_timezone&#039;]);
	
	echo 	&quot;Subid&quot; . &quot;\t&quot; .
			&quot;Revenue&quot; . &quot;\t&quot; .  
			&quot;Date&quot; . &quot;\t&quot; . 
			&quot;Browser&quot; . &quot;\t&quot; . 
			&quot;OS&quot;  . &quot;\t&quot; . 
			&quot;PPC Network&quot;  . &quot;\t&quot; . 
			&quot;PPC account&quot;  . &quot;\t&quot; . 
			&quot;Click Real/Filtered&quot;  . &quot;\t&quot; . 
			&quot;IP Address&quot;  . &quot;\t&quot; .
			&quot;ISP/Carrier&quot;  . &quot;\t&quot; .
			&quot;Country&quot;  . &quot;\t&quot; .
			&quot;Country Code&quot;  . &quot;\t&quot; .
			&quot;City&quot;  . &quot;\t&quot; . 
			&quot;Offer/LP&quot;  . &quot;\t&quot; . 
			&quot;Text Ad&quot;  . &quot;\t&quot; . 
			&quot;Referer&quot; . &quot;\t&quot; . 
			&quot;Landing&quot; . &quot;\t&quot; . 
			&quot;Outbound&quot; . &quot;\t&quot; . 
			&quot;Cloaked Referer&quot; . &quot;\t&quot; . 
			&quot;Redirect&quot; . &quot;\t&quot; . 
			&quot;Keyword&quot; . &quot;\t&quot; .
	        &quot;gclid&quot; . &quot;\t&quot; .
	        &quot;utm_campaign&quot; . &quot;\t&quot; .
	        &quot;utm_content&quot; . &quot;\t&quot; .
	        &quot;utm_medium&quot; . &quot;\t&quot; .
	        &quot;utm_source&quot; . &quot;\t&quot; .
	        &quot;utm_term&quot; . &quot;\n&quot;;
	
//now display all the clicks
	while ($click_row = $click_result-&gt;fetch_array(MYSQLI_ASSOC)) {   
								
			$mysql[&#039;click_id&#039;] = $db-&gt;real_escape_string($click_row[&#039;click_id&#039;]);
		
			//Country GEO data

			$html[&#039;location_country_code&#039;] = htmlentities($click_row[&#039;country_code&#039;], ENT_QUOTES, &#039;UTF-8&#039;);   
			$html[&#039;location_country_name&#039;] = htmlentities($click_row[&#039;country_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
			
			//City GEO data
			$html[&#039;location_city_name&#039;] = htmlentities($click_row[&#039;city_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);

			$html[&#039;referer&#039;] = htmlentities($click_row[&#039;referer&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
			$html[&#039;referer_host&#039;] = htmlentities($click_row[&#039;referer_host&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
			
			$html[&#039;landing&#039;] = htmlentities($click_row[&#039;landing&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
			$html[&#039;landing_host&#039;] = htmlentities($click_row[&#039;landing_host&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
			
			$html[&#039;outbound&#039;] = htmlentities($click_row[&#039;outbound&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
			$html[&#039;outbound_host&#039;] = htmlentities($click_row[&#039;outbound_host&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
			
//this is alittle different
		if ($click_row[&#039;click_cloaking&#039;]) {
			
			//if not a landing page
			if (!$click_row[&#039;click_alp&#039;]) { 
				$html[&#039;cloaking&#039;] = htmlentities( &#039;http://&#039; .$_SERVER[&#039;SERVER_NAME&#039;] . get_absolute_url().&#039;tracking202/redirect/cl.php?pci=&#039; . $click_row[&#039;click_id_public&#039;] );
				$html[&#039;cloaking_host&#039;] = htmlentities( $_SERVER[&#039;SERVER_NAME&#039;] );   
			} else { 
				//advanced lander
				$html[&#039;cloaking&#039;] = htmlentities( &#039;http://&#039; .$_SERVER[&#039;SERVER_NAME&#039;] . get_absolute_url().&#039;tracking202/redirect/off.php?acip=&#039;. $click_row[&#039;aff_campaign_id_public&#039;] . &#039;&amp;pci=&#039; . $click_row[&#039;click_id_public&#039;] );
				$html[&#039;cloaking_host&#039;] = htmlentities( $_SERVER[&#039;SERVER_NAME&#039;] );   
			}
		} else {
			$html[&#039;cloaking&#039;] = &#039;&#039;;
			$html[&#039;cloaking_host&#039;] = &#039;&#039;;	
		}

		$html[&#039;redirect&#039;] = htmlentities($click_row[&#039;redirect&#039;], ENT_QUOTES, &#039;UTF-8&#039;);   
		$html[&#039;redirect_host&#039;] = htmlentities($click_row[&#039;redirect_host&#039;], ENT_QUOTES, &#039;UTF-8&#039;);  
		   

		
		$html[&#039;aff_campaign_id&#039;] = htmlentities($click_row[&#039;aff_campaign_id&#039;], ENT_QUOTES, &#039;UTF-8&#039;);   
		$html[&#039;landing_page_nickname&#039;] = htmlentities($click_row[&#039;landing_page_nickname&#039;], ENT_QUOTES, &#039;UTF-8&#039;);   
		$html[&#039;ppc_account_id&#039;] = htmlentities($click_row[&#039;ppc_account_id&#039;], ENT_QUOTES, &#039;UTF-8&#039;);   
		$html[&#039;text_ad_id&#039;] = htmlentities($click_row[&#039;text_ad_id&#039;], ENT_QUOTES, &#039;UTF-8&#039;);   
		$html[&#039;text_ad_name&#039;] = htmlentities($click_row[&#039;text_ad_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;); 
		$html[&#039;aff_campaign_name&#039;] = htmlentities($click_row[&#039;aff_campaign_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;aff_network_name&#039;] = htmlentities($click_row[&#039;aff_network_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;ppc_network_name&#039;] = htmlentities($click_row[&#039;ppc_network_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;ppc_account_name&#039;] = htmlentities($click_row[&#039;ppc_account_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;ip_address&#039;] = htmlentities($click_row[&#039;ip_address&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;isp_name&#039;] = htmlentities($click_row[&#039;isp_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;click_cpc&#039;] = htmlentities(dollar_format($click_row[&#039;click_cpc&#039;]), ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;keyword&#039;] = htmlentities($click_row[&#039;keyword&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;click_lead&#039;] = htmlentities($click_row[&#039;click_lead&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;click_filtered&#039;] = htmlentities($click_row[&#039;click_filtered&#039;], ENT_QUOTES, &#039;UTF-8&#039;);      
		$html[&#039;browser_name&#039;] = htmlentities($click_row[&#039;browser_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;platform_name&#039;] = htmlentities($click_row[&#039;platform_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);      
				
		$html[&#039;location&#039;] = &#039;&#039;;
		if ($click_row[&#039;location_country_name&#039;]) {
			if ($click_row[&#039;location_country_name&#039;]) { 
				$origin = $click_row[&#039;location_country_name&#039;]; 
			} if (($click_row[&#039;location_region_code&#039;]) and (!is_numeric($click_row[&#039;location_region_code&#039;]))) { 
				$origin = $click_row[&#039;location_region_code&#039;] . &#039;, &#039; . $origin; 
			} if ($click_row[&#039;location_city_name&#039;]) { 
				$origin = $click_row[&#039;location_city_name&#039;] . &#039;, &#039; . $origin;  
			}
			
			$html[&#039;origin&#039;] = htmlentities($origin, ENT_QUOTES, &#039;UTF-8&#039;);  
		}  
		
		if ($click_row[&#039;click_filtered&#039;] == &#039;1&#039;) { 
			$click_filtered = &#039;filtered&#039;;
		} elseif ($click_row[&#039;click_lead&#039;] == &#039;1&#039;) {
			$click_filtered = &#039;conversion&#039;;
		} else {
			$click_filtered = &#039;real&#039;;
		}
		
	echo 	$click_row[&#039;click_id&#039;] . &quot;\t&quot; .
			dollar_format($click_row[&#039;income&#039;], $click_row[&#039;user_account_currency&#039;]) . &quot;\t&quot; . 
			date(&#039;m/d/y g:ia&#039;,$click_row[&#039;click_time&#039;]) . &quot;\t&quot; . 
			$html[&#039;browser_name&#039;] . &quot;\t&quot; . 
			$html[&#039;platform_name&#039;]  . &quot;\t&quot; . 
			$html[&#039;ppc_network_name&#039;]  . &quot;\t&quot; . 
			$html[&#039;ppc_account_name&#039;]  . &quot;\t&quot; . 
			$click_filtered  . &quot;\t&quot; . 
			$html[&#039;ip_address&#039;]  . &quot;\t&quot; .
			$html[&#039;isp_name&#039;]  . &quot;\t&quot; .
			$html[&#039;location_country_name&#039;]  . &quot;\t&quot; .
			$html[&#039;location_country_code&#039;]  . &quot;\t&quot; .
			$html[&#039;location_city_name&#039;]  . &quot;\t&quot; .
			$html[&#039;aff_campaign_name&#039;]  . &quot;\t&quot; . 
			$html[&#039;text_ad_name&#039;]  . &quot;\t&quot; . 
			$html[&#039;referer&#039;] . &quot;\t&quot; . 
			$html[&#039;landing&#039;] . &quot;\t&quot; . 
			$html[&#039;outbound&#039;] . &quot;\t&quot; . 
			$html[&#039;cloaking&#039;] . &quot;\t&quot; . 
			$html[&#039;redirect&#039;] . &quot;\t&quot; . 
			$html[&#039;keyword&#039;] . &quot;\t&quot; .
			$click_row[&#039;gclid&#039;] . &quot;\t&quot; .
			$click_row[&#039;utm_campaign&#039;] . &quot;\t&quot; .
			$click_row[&#039;utm_content&#039;] . &quot;\t&quot; .
			$click_row[&#039;utm_medium&#039;] . &quot;\t&quot; .
			$click_row[&#039;utm_source&#039;] . &quot;\t&quot; .
			$click_row[&#039;utm_term&#039;] . &quot;\n&quot;;
			
	}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fvisitors%2Fdownload'>⬅ Back to Directory</a>