<h2>File Contents: /home/planet5/.trash/tracking202/ajax/copy_of_conversion_logs.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/ajax/copy_of_conversion_logs.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();
$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);

if ($_SERVER[&#039;REQUEST_METHOD&#039;] == &#039;POST&#039;) {
	
	$time = grab_timeframe(); 
	$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;]); 
	$mysql[&#039;click_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;logs_subid&#039;]);
	$mysql[&#039;campaign_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;logs_campaign&#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&#039;].&quot; AND 2l.click_time &gt;= &quot;.$mysql[&#039;from&#039;].&quot; AND 2l.click_time &lt; &quot;.$mysql[&#039;to&#039;];
	
	if ($_POST[&#039;logs_campaign&#039;]) {
		$logs_sql .= &quot; AND campaign_id = &#039;&quot;.$mysql[&#039;campaign_id&#039;].&quot;&#039;&quot;;
	}

	if ($_POST[&#039;logs_subid&#039;]) {
		$logs_sql .= &quot; AND click_id = &#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;&quot;;
	}

	if ($_POST[&#039;user_pref_time_predefined&#039;] != &#039;&#039;) {
	    switch ($_POST[&#039;user_pref_time_predefined&#039;]) {
	        case &#039;today&#039;:
	        case &#039;yesterday&#039;:
	        case &#039;last7&#039;:
	        case &#039;last14&#039;:
	        case &#039;last30&#039;:
	        case &#039;thismonth&#039;:
	        case &#039;lastmonth&#039;:
	        case &#039;thisyear&#039;:
	        case &#039;lastyear&#039;:
	        case &#039;alltime&#039;:
	            $mysql[&#039;user_pref_time_predefined&#039;] = $db-&gt;real_escape_string($_POST[&#039;user_pref_time_predefined&#039;]);
	            break;
	    }
	} else {
	    
	    $from = explode(&#039;/&#039;, $_POST[&#039;from&#039;]);
	    $from_month = trim($from[0]);
	    $from_day = trim($from[1]);
	    $from_year = trim($from[2]);
	    
	    $to = explode(&#039;/&#039;, $_POST[&#039;to&#039;]);
	    $to_month = trim($to[0]);
	    $to_day = trim($to[1]);
	    $to_year = trim($to[2]);
	    
	    $mysql[&#039;user_pref_time_from&#039;] = mktime(0, 00, 0, $from_month, $from_day, $from_year);
	    $mysql[&#039;user_pref_time_to&#039;] = mktime(23, 59, 59, $to_month, $to_day, $to_year);			
	}

	$user_sql = &quot;UPDATE  `202_users_pref`
					 SET `user_pref_time_predefined`=&#039;&quot; . $mysql[&#039;user_pref_time_predefined&#039;] . &quot;&#039;,
					`user_pref_time_from`=&#039;&quot; . $mysql[&#039;user_pref_time_from&#039;] . &quot;&#039;,
					`user_pref_time_to`=&#039;&quot; . $mysql[&#039;user_pref_time_to&#039;] . &quot;&#039;
					WHERE   `user_id`=&#039;&quot; . $mysql[&#039;user_id&#039;] . &quot;&#039;&quot;;
	_mysqli_query($user_sql);

	$logs_result = _mysqli_query($logs_sql);

} ?&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;;
						  } 
					?&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; </textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fajax'>⬅ Back to Directory</a>