<h2>File Contents: /home/planet5/public_html/tracking/tracking202/logs/index.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/public_html/tracking/tracking202/logs/index.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php 
include_once(str_repeat(&quot;../&quot;, 2).&#039;202-config/connect.php&#039;);

AUTH::require_user();


//set the timezone for the user, for entering their dates.
AUTH::set_timezone($_SESSION[&#039;user_timezone&#039;]);

$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);
$user_sql = &quot;SELECT user_time_register FROM 202_users WHERE user_id=&quot;.$mysql[&#039;user_id&#039;];
$user_result = _mysqli_query($user_sql);
$user_row = $user_result-&gt;fetch_assoc();

if($_SESSION[&#039;publisher&#039;]==false){ //user is able to see all campaigns
    $mysql[&#039;user_id_query&#039;] = &quot; != &#039;0&#039; &quot;;
}
else{
    $mysql[&#039;user_id_query&#039;] = &quot; = &#039;&quot; . $_SESSION[&#039;user_own_id&#039;] . &quot;&#039; &quot;; //user can only see thier campaigns
}


$campaign_sql = &quot;SELECT aff_campaign_id, aff_campaign_name FROM 202_aff_campaigns WHERE user_id&quot;.$mysql[&#039;user_id_query&#039;].&quot; AND aff_campaign_deleted = &#039;0&#039;&quot;;

$campaign_result = _mysqli_query($campaign_sql);

$time = grab_timeframe();   
$html[&#039;from&#039;] = date(&#039;m/d/Y - G:i&#039;, $time[&#039;from&#039;]);
$html[&#039;to&#039;] = date(&#039;m/d/Y - G:i&#039;, $time[&#039;to&#039;]);
$mysql[&#039;to&#039;] = $db-&gt;real_escape_string($time[&#039;to&#039;]);
$mysql[&#039;from&#039;] = $db-&gt;real_escape_string($time[&#039;from&#039;]);

$logs_sql = &quot;SELECT 2ca.aff_campaign_name, 2l.click_id, 2l.transaction_id, 2l.click_payout, 2l.click_time, 2l.conv_time, 2l.time_difference, 2l.ip, 2l.pixel_type, 2l.user_agent, 2l.deleted FROM 202_conversion_logs AS 2l LEFT JOIN 202_aff_campaigns AS 2ca ON (2l.campaign_id = 2ca.aff_campaign_id) WHERE 2l.user_id&quot;.$mysql[&#039;user_id_query&#039;].&quot; AND 2l.click_time &gt;= &quot;.$mysql[&#039;from&#039;].&quot; AND 2l.click_time &lt; &quot;.$mysql[&#039;to&#039;];


$logs_result = _mysqli_query($logs_sql);

//show the template
template_top(&#039;Conversion Logs&#039;,NULL,NULL,NULL); ?&gt;
&lt;div class=&quot;row&quot; style=&quot;margin-bottom: 15px;&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;
		&lt;h6&gt;Conversion Logs&lt;/h6&gt;
	&lt;/div&gt;
&lt;/div&gt; 

&lt;div class=&quot;row&quot; style=&quot;margin-bottom: 15px;&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;
	&lt;div id=&quot;preferences-wrapper&quot;&gt;
		&lt;span style=&quot;position: absolute; font-size:12px;&quot;&gt;&lt;span class=&quot;fui-search&quot;&gt;&lt;/span&gt; Refine your search: &lt;/span&gt;
		&lt;form id=&quot;logs_from&quot; onsubmit=&quot;return false;&quot; class=&quot;form-inline text-right&quot; role=&quot;form&quot;&gt;
		&lt;div class=&quot;row&quot;&gt;
			&lt;div class=&quot;col-xs-12&quot;&gt;
				&lt;label for=&quot;from&quot;&gt;Start date: &lt;/label&gt;
				&lt;div class=&quot;form-group datepicker&quot; style=&quot;margin-right: 5px;&quot;&gt;
				    &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; name=&quot;from&quot; id=&quot;from&quot; value=&quot;&lt;?php echo $html[&#039;from&#039;]; ?&gt;&quot;&gt;
				&lt;/div&gt;

				&lt;label for=&quot;to&quot;&gt;End date: &lt;/label&gt;
				&lt;div class=&quot;form-group datepicker&quot;&gt;
				    &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; name=&quot;to&quot; id=&quot;to&quot; value=&quot;&lt;?php echo $html[&#039;to&#039;]; ?&gt;&quot;&gt;
				&lt;/div&gt;

				&lt;div class=&quot;form-group&quot;&gt;
					&lt;label class=&quot;sr-only&quot; for=&quot;user_pref_time_predefined&quot;&gt;Date&lt;/label&gt;
					&lt;select class=&quot;form-control input-sm&quot; name=&quot;user_pref_time_predefined&quot; id=&quot;user_pref_time_predefined&quot; onchange=&quot;set_user_pref_time_predefined();&quot;&gt;
					    &lt;option value=&quot;&quot;&gt;Custom Date&lt;/option&gt;                                       
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;today&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;today&quot;&gt;Today&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;yesterday&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;yesterday&quot;&gt;Yesterday&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;last7&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;last7&quot;&gt;Last 7 Days&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;last14&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;last14&quot;&gt;Last 14 Days&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;last30&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;last30&quot;&gt;Last 30 Days&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;thismonth&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;thismonth&quot;&gt;This Month&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;lastmonth&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;lastmonth&quot;&gt;Last Month&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;thisyear&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;thisyear&quot;&gt;This Year&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;lastyear&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;lastyear&quot;&gt;Last Year&lt;/option&gt;
						&lt;option &lt;?php if ($time[&#039;user_pref_time_predefined&#039;] == &#039;alltime&#039;) { echo &#039;selected=&quot;&quot;&#039;; } ?&gt; value=&quot;alltime&quot;&gt;All Time&lt;/option&gt;
					&lt;/select&gt;
				&lt;/div&gt;
			&lt;/div&gt;
		&lt;/div&gt;

		&lt;div class=&quot;form_seperator&quot; style=&quot;margin:5px 0px; padding:1px&quot;&gt;
			&lt;div class=&quot;col-xs-12&quot;&gt;&lt;/div&gt;
		&lt;/div&gt;

		&lt;div class=&quot;row&quot;&gt;
			&lt;div class=&quot;col-xs-12&quot;&gt;
				&lt;label for=&quot;to&quot;&gt;SubID: &lt;/label&gt;
				&lt;div class=&quot;form-group&quot;&gt;
				    &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; name=&quot;logs_subid&quot; id=&quot;logs_subid&quot;&gt;
				&lt;/div&gt;

				&lt;label for=&quot;to&quot;&gt;Campaign: &lt;/label&gt;
				&lt;select class=&quot;form-control input-sm&quot; name=&quot;logs_campaign&quot; id=&quot;logs_campaign&quot;&gt;
					&lt;option value=&quot;0&quot;&gt; -- &lt;/option&gt;
					&lt;?php while ($campaign_row = $campaign_result-&gt;fetch_assoc()) { ?&gt;
						&lt;option value=&quot;&lt;?php echo $campaign_row[&#039;aff_campaign_id&#039;];?&gt;&quot;&gt;&lt;?php echo $campaign_row[&#039;aff_campaign_name&#039;];?&gt;&lt;/option&gt;
					&lt;?php } ?&gt;
				&lt;/select&gt;
				&lt;button id=&quot;get-logs&quot; style=&quot;width: 130px;&quot; type=&quot;submit&quot; class=&quot;btn btn-xs btn-info&quot;&gt;Get Logs&lt;/button&gt;
			&lt;/div&gt;
		&lt;/div&gt;
		&lt;/form&gt;
	&lt;/div&gt;	   
&lt;/div&gt;
&lt;/div&gt;

&lt;div id=&quot;logs_table&quot;&gt;
&lt;div class=&quot;row&quot; style=&quot;margin-top: 10px; margin-bottom: 10px;&quot;&gt;
	&lt;div class=&quot;col-xs-6&quot;&gt;
		&lt;span class=&quot;infotext&quot;&gt;&lt;?php printf(&#039;&lt;div class=&quot;results&quot;&gt;Results &lt;b&gt;%s&lt;/b&gt;&lt;/div&gt;&#039;,$logs_result-&gt;num_rows);  ?&gt;&lt;/span&gt;
	&lt;/div&gt;
&lt;/div&gt;

&lt;div class=&quot;row&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;
	&lt;table class=&quot;table table-bordered&quot; id=&quot;stats-table&quot;&gt;
		&lt;thead&gt;
		    &lt;tr style=&quot;background-color: #f2fbfa;&quot;&gt;
		        &lt;th&gt;SubID&lt;/th&gt;
		        &lt;th&gt;TxID&lt;/th&gt;
		        &lt;th&gt;Campaign&lt;/th&gt;
		        &lt;th&gt;Payout&lt;/th&gt;
		        &lt;th&gt;Click Time&lt;/th&gt;
		        &lt;th&gt;Conversion Time&lt;/th&gt;
		        &lt;th&gt;Time Difference&lt;/th&gt;
		        &lt;th&gt;IP Address&lt;/th&gt;
		        &lt;th&gt;Pixel Type&lt;/th&gt;
		    &lt;/tr&gt;
		&lt;/thead&gt;
		&lt;tbody&gt;
		&lt;?php while ($logs_row = $logs_result-&gt;fetch_assoc()) { ?&gt;
			&lt;tr&gt;
				&lt;td&gt;&lt;?php echo $logs_row[&#039;click_id&#039;];?&gt; &lt;?php if ($logs_row[&#039;deleted&#039;] == true) { ?&gt;&lt;span class=&quot;label label-danger&quot;&gt;deleted&lt;/span&gt;&lt;?php } ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo $logs_row[&#039;transaction_id&#039;];?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo $logs_row[&#039;aff_campaign_name&#039;];?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo dollar_format($logs_row[&#039;click_payout&#039;]);?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo date(&#039;m/d/y g:ia&#039;, $logs_row[&#039;click_time&#039;]);?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo date(&#039;m/d/y g:ia&#039;, $logs_row[&#039;conv_time&#039;]);?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo $logs_row[&#039;time_difference&#039;];?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo $logs_row[&#039;ip&#039;];?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php if ($logs_row[&#039;pixel_type&#039;] == &#039;1&#039;) { 
							  echo &quot;Pixel&quot;;
						  } else if ($logs_row[&#039;pixel_type&#039;] == &#039;2&#039;) {
						  	  echo &quot;Postback&quot;;
						  } else if ($logs_row[&#039;pixel_type&#039;] == &#039;3&#039;) {
						  	  echo &quot;Universal Pixel&quot;;
						  } else if ($logs_row[&#039;pixel_type&#039;] == &#039;4&#039;) {
							echo &quot;API Integration&quot;;
					  	  } else if ($logs_row[&#039;pixel_type&#039;] == &#039;0&#039;) {
						      echo &quot;Manual Upload&quot;;
						  }
					?&gt;
				&lt;/td&gt;
				&lt;tr&gt;
					&lt;td colspan=&quot;2&quot;&gt;User agent:&lt;/td&gt;
					&lt;td colspan=&quot;8&quot;&gt;&lt;code style=&quot;white-space: inherit;&quot;&gt;&lt;?php echo $logs_row[&#039;user_agent&#039;];?&gt;&lt;/code&gt;&lt;/td&gt;
				&lt;/tr&gt;
			&lt;/tr&gt;
		&lt;?php } ?&gt;
		&lt;/tbody&gt;
	&lt;/table&gt;
	&lt;/div&gt;
&lt;/div&gt;						
&lt;/div&gt;

&lt;script type=&quot;text/javascript&quot;&gt;
	
function set_user_pref_time_predefined() {

	var element = $(&#039;#user_pref_time_predefined&#039;);

	if (element.val() == &#039;today&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time()));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time())); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;yesterday&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()-86400),date(&#039;d&#039;,time()-86400),date(&#039;Y&#039;,time()-86400));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()-86400),date(&#039;d&#039;,time()-86400),date(&#039;Y&#039;,time()-86400)); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;last7&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()-86400*7),date(&#039;d&#039;,time()-86400*7),date(&#039;Y&#039;,time()-86400*7));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time())); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;last14&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()-86400*14),date(&#039;d&#039;,time()-86400*14),date(&#039;Y&#039;,time()-86400*14));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time())); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;last30&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()-86400*30),date(&#039;d&#039;,time()-86400*30),date(&#039;Y&#039;,time()-86400*30));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time())); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;thismonth&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()),1,date(&#039;Y&#039;,time()));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time())); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;lastmonth&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()-2629743),1,date(&#039;Y&#039;,time()-2629743));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()-2629743),getLastDayOfMonth(date(&#039;m&#039;,time()-2629743), date(&#039;Y&#039;,time()-2629743)),date(&#039;Y&#039;,time()-2629743)); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;thisyear&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,1,1,date(&#039;Y&#039;,time()));
			$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time())); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}

	if (element.val() == &#039;lastyear&#039;) {
		&lt;?php $time[&#039;from&#039;] = mktime(0,0,0,1,1,date(&#039;Y&#039;,time()-31556926));
			$time[&#039;to&#039;] = mktime(0,0,0,12,getLastDayOfMonth(date(&#039;m&#039;,time()-31556926), date(&#039;Y&#039;,time()-31556926)),date(&#039;Y&#039;,time()-31556926)); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}
			
	if (element.val() == &#039;alltime&#039;) {
		&lt;?php  
		$time[&#039;from&#039;] = $user_row[&#039;user_time_register&#039;];
				
		$time[&#039;from&#039;] = mktime(0,0,0,date(&#039;m&#039;,$time[&#039;from&#039;]),date(&#039;d&#039;,$time[&#039;from&#039;]),date(&#039;Y&#039;,$time[&#039;from&#039;]));  
		$time[&#039;to&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time())); ?&gt;

		$(&#039;#from&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;from&#039;]); ?&gt;&#039;);
		$(&#039;#to&#039;).val(&#039;&lt;?php echo date(&#039;m/d/y - G:i&#039;,$time[&#039;to&#039;]); ?&gt;&#039;);
	}
}
&lt;/script&gt; 
&lt;?php template_bottom($server_row);
    </textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fpublic_html%2Ftracking%2Ftracking202%2Flogs'>⬅ Back to Directory</a>