Regenerating charts "; } //******************************************************************** // DO NOT EDIT BELOW THIS LINE //******************************************************************** // Swith to test table on test installation if (strstr($_SERVER['PHP_SELF'],'test-frewe-server.php')) $db_table = 'test_frewe_history'; // Check server key //if (!isset($_GET["serverkey"]) || $_GET["serverkey"]!=$serverkey || $_GET["serverkey"]=="") // error('Frewe ERROR: wrong or empty server key'); // Open mySQL $link = mysql_connect($db_host, $db_user, $db_pass); if (!$link) error('Frewe ERROR: mySQL fault: ' . mysql_error()); $db_selected = mysql_select_db($db_name, $link); if (!$db_selected) error('Frewe ERROR: Database selection fault: ' . mysql_error()); $query = "SELECT CONVERT_TZ(`datetime`,'+00:00','+02:00') as datetime FROM $db_table ORDER BY `datetime` ASC LIMIT 1"; #$query = "SELECT datetime FROM $db_table ORDER BY `datetime` ASC LIMIT 1"; $result = mysql_query($query,$link); if (!$result) error('Frewe ERROR dabase query fault: ' . mysql_error(). ' query: '. $query); $lastrow = mysql_fetch_assoc($result); if ($lastrow) $firsttimestamp = strtotime($lastrow['datetime']); else $firsttimestamp = NULL; // Get last datetime $query = "SELECT CONVERT_TZ(`datetime`,'+00:00','+02:00') as datetime FROM $db_table ORDER BY `datetime` DESC LIMIT 1"; #$query = "SELECT datetime FROM $db_table ORDER BY `datetime` DESC LIMIT 1"; $result = mysql_query($query,$link); if (!$result) error('Frewe ERROR dabase query fault: ' . mysql_error(). ' query: '. $query); $lastrow = mysql_fetch_assoc($result); if ($lastrow){ $lasttime = $lastrow['datetime']; $lasttimestamp = strtotime($lastrow['datetime']); }else{ $lasttime = NULL; $lasttimestamp = NULL; } $lasttimestamp=strtotime($lasttime); $starttimestamp=0; if($fromdate & $todate){ $starttimestamp=strtotime($fromdate." 00:00:00"); $stoptimestamp=strtotime($todate." 23:59:59"); } else { if($start=='-1d') $starttimestamp=$lasttimestamp-24*60*60; else if($start=='-7d') $starttimestamp=$lasttimestamp-7*24*60*60; else if($start=='-28d') $starttimestamp=$lasttimestamp-28*24*60*60; else if($start=='all') $starttimestamp=$firsttimestamp; $stoptimestamp=$lasttimestamp; } $starttimestamp=max($firsttimestamp,$starttimestamp); /* echo "

";
print_r($starttimestamp);
print_r($stoptimestamp);
echo "

	";
	print_r($timestamp);
	echo "
	

	";
	print_r($tempout);
	echo "
	

Files written.

Continue ... "; } else { if($chart=="temp"){ // create the chart (default - linear transformations for both axes) $chartT = new TimeChart('Temperatur (°C)', null, null, false); // add the data to chart $chartT->addData('aussen (aktuell '.round($tempout[$lasttimestamp],1).'°C)', $tempout, $c[0], TimeChart::SQUARE); $chartT->addData('innen (aktuell '.round($tempin[$lasttimestamp],1).'°C)', $tempin, $c[1], TimeChart::SQUARE); //$chartT->addData('tempchill', $tempchill, $c[2], TimeChart::SQUARE); $chartT->addData('Taupunkt (aktuell '.round($tempdew[$lasttimestamp],1).'°C)', $tempdew, $c[3], TimeChart::SQUARE); // render the chart header("Content-type: image/png"); $chartT->output(1100, 600, null, null); /* header("Content-type: text/html"); echo "

	";
	print_r($query);
	print_r($timestamp);
	print_r($tempout);
	echo "
	

	";
	print_r($query);
	print_r($timestamp);
	print_r($winddeg);
	echo "