| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/rasinweb/isvtg/ |
Upload File : |
<?php
/******************************
Project: IS VetroIng, 2024.
Version: 24-04-25
Author : TIM/M.Kukic
Note :
******************************/
//MIN - MAX
if ($vap==5) {
//
$sql = "SELECT * FROM vtg_meteo WHERE awsid='".$aws[$loc]."' ORDER BY ".$par_db." ASC LIMIT 1";
$result = mysql_query($sql, $dbh) or die(mysql_error($dbh));
$row = mysql_fetch_array($result);
$par=round($row[$par_db],1);
$par0=$par;
$vre=$row['dattime'];
$go=substr($vre,0,4);
$me0=substr($vre,5,2);
$da0=substr($vre,8,2);
$vr0=substr($vre,11,5);
$sql = "SELECT * FROM vtg_meteo WHERE awsid='".$aws[$loc]."' ORDER BY ".$par_db." DESC LIMIT 1";
$result = mysql_query($sql, $dbh) or die(mysql_error($dbh));
$row = mysql_fetch_array($result);
$par=round($row[$par_db],1);
$par1=$par;
$vre=$row['dattime'];
$go=substr($vre,0,4);
$me1=substr($vre,5,2);
$da1=substr($vre,8,2);
$vr1=substr($vre,11,5);
$sql = "SELECT AVG(".$par_db.") FROM vtg_meteo WHERE awsid='".$aws[$loc]."'";
$result = mysql_query($sql, $dbh) or die(mysql_error($dbh));
$row = mysql_fetch_array($result);
$par=round($row[0],1);
$par2=$par;
// Trend 1h
$sql = "SELECT * FROM vtg_meteo WHERE awsid='".$aws[$loc]."' ORDER BY dattime DESC LIMIT 4";
$result = mysql_query($sql, $dbh) or die(mysql_error($dbh));
//
$row = mysql_fetch_array($result);
$y4=$row[$par_db];
$row = mysql_fetch_array($result);
$y3=$row[$par_db];
$row = mysql_fetch_array($result);
$y2=$row[$par_db];
$row = mysql_fetch_array($result);
$y1=$row[$par_db];
//
$dy=round(($y4-$y1),1);
}else{
//
$sql = "SELECT * FROM vtg_meteo WHERE awsid='".$aws[$loc]."' ORDER BY ".$par_db." ASC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$par=round($row[$par_db],1);
$par0=$par;
$vre=$row['dattime'];
$go=substr($vre,0,4);
$me0=substr($vre,5,2);
$da0=substr($vre,8,2);
$vr0=substr($vre,11,5);
$sql = "SELECT * FROM vtg_meteo WHERE awsid='".$aws[$loc]."' ORDER BY ".$par_db." DESC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$par=round($row[$par_db],1);
$par1=$par;
$vre=$row['dattime'];
$go=substr($vre,0,4);
$me1=substr($vre,5,2);
$da1=substr($vre,8,2);
$vr1=substr($vre,11,5);
$sql = "SELECT AVG(".$par_db.") FROM vtg_meteo WHERE awsid='".$aws[$loc]."'";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$par=round($row[0],1);
$par2=$par;
// Trend 1h
$sql = "SELECT * FROM vtg_meteo WHERE awsid='".$aws[$loc]."' ORDER BY dattime DESC LIMIT 4";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
//
$row = mysqli_fetch_array($result);
$y4=$row[$par_db];
$row = mysqli_fetch_array($result);
$y3=$row[$par_db];
$row = mysqli_fetch_array($result);
$y2=$row[$par_db];
$row = mysqli_fetch_array($result);
$y1=$row[$par_db];
//
$dy=round(($y4-$y1),1);
}
//
if ($vap==5) {
mysql_close($dbh);
}else{
mysqli_close($dbh);
}
//
echo "Min: <b>".$par0."</b> (".$da0."/".$me0." - ".$vr0.")";
echo str_repeat(' ', 5);
echo "Max: <b>".$par1."</b> (".$da1."/".$me1." - ".$vr1.")";
echo str_repeat(' ', 5);
echo "AVG: <b>".$par2."</b>";
//
if ($dy>0.0) {
$trend="+";
}
if ($dy<0.0) {
$trend="-";
}
if ($dy==0.0){
$trend="=";
}
//
echo str_repeat(' ', 5);
echo "Trend: <b>(".$trend.")</b>";
?>