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

AUTH::require_user();

AUTH::set_timezone($_SESSION[&#039;user_timezone&#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;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]); 

if ($_SERVER[&#039;REQUEST_METHOD&#039;] == &#039;POST&#039;) {
	
	if ($_POST[&#039;chart_time_range&#039;]) {
		header(&quot;Content-type: text/json&quot;);
		$data = array();
		$range = array();
		$de = new DataEngine();

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

		$sql = &quot;UPDATE 202_charts SET chart_time_range = &#039;&quot;.$mysql[&#039;chart_time_range&#039;].&quot;&#039;&quot;;
		$result = $db-&gt;query($sql);

		$sql = &quot;SELECT * FROM 202_charts WHERE user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;&quot;;
		$result = $db-&gt;query($sql);
		$user_row = $result-&gt;fetch_assoc();  

		$start = new DateTime(&#039;@&#039; . $mysql[&#039;from&#039;]);
		$end = new DateTime(&#039;@&#039; . $mysql[&#039;to&#039;]);

		switch ($user_row[&#039;chart_time_range&#039;]) {
		    case &#039;hours&#039;:
		        $rangeOutputFormat = &#039;M d g:iA&#039;;
		    break;
		            
		    case &#039;days&#039;:
		        $rangeOutputFormat = &#039;M d y&#039;;
		    break;
		}
		
		

		$user_row[&#039;user_chart_data&#039;] = unserialize($user_row[&#039;data&#039;]);
		$rangePeriod = returnRanges($start, $end, $user_row[&#039;chart_time_range&#039;]);
		$chart = $de-&gt;getChart($mysql[&#039;from&#039;], $mysql[&#039;to&#039;], $user_row[&#039;user_chart_data&#039;], $user_row[&#039;chart_time_range&#039;], $rangeOutputFormat, $rangePeriod);

		$data[&#039;json&#039;] = $chart;
		foreach ($rangePeriod as $r) {
			$range[] = $r-&gt;format($rangeOutputFormat);
		}
		$data[&#039;categories&#039;] = $range;
		$data[&#039;title&#039;] = &quot;From &quot;.date(&#039;d/m/Y&#039;, $mysql[&#039;from&#039;]).&quot; to &quot;.date(&#039;d/m/Y&#039;, $mysql[&#039;to&#039;]);

		echo json_encode($data, JSON_NUMERIC_CHECK);

	} else {

		$data = array();
		$keys = array_keys($_POST[&#039;levels&#039;]);

		foreach ($keys as $key) {
			$data[] = array(&#039;campaign_id&#039; =&gt; $_POST[&#039;levels&#039;][$key][&#039;id&#039;], &#039;value_type&#039; =&gt; $_POST[&#039;types&#039;][$key][&#039;type&#039;]);
		}

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

		$sql = &quot;UPDATE 202_charts SET data = &#039;&quot;.$mysql[&#039;serialize&#039;].&quot;&#039; WHERE user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;&quot;;
		$result = $db-&gt;query($sql); 
	}

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