function checkandadd(&$uPOST) { $a = 0; while (isset($uPOST["varn" . $a])) { if (isset($uPOST["varv" . $a])) { if (extExists($uPOST["varn" . $a], 1)) { db_connect(); $query = "SELECT `value` from `ext` WHERE `data`='" . $uPOST["varn" . $a] . "' AND `maxmin`='1' LIMIT 1"; sanitize($uPOST["varn" . $a]); $result = mysql_query($query) or die("query failed"); db_disconnect(); $c_row = mysql_fetch_assoc($result); if ($uPOST["varv" . $a] > $c_row['value']) { //echo "highest"; extInsert($uPOST["varn" . $a], 1, $uPOST["varv" . $a], $uPOST['uts']); } } } if (isset($uPOST["varv" . $a])) { if (extExists($uPOST["varn" . $a], 0)) { db_connect(); $query = "SELECT `value` from `ext` WHERE `data`='" . $uPOST["varn" . $a] . "' AND `maxmin`='0' LIMIT 1"; sanitize($uPOST["varn" . $a]); $result = mysql_query($query) or die("query failed"); db_disconnect(); $c_row = mysql_fetch_assoc($result); if ($uPOST["varv" . $a] < $c_row['value']) { //echo "lowest"; extInsert($uPOST["varn" . $a], 0, $uPOST["varv" . $a], $uPOST['uts']); } } } $a++; } }
array_push($arr_xticks, $row['uts']); } // get maxs list($max_temp, $max_temp_uts) = getArrEXTUTS($Temp_data, $arr_xticks, 1); list($max_prss, $max_prss_uts) = getArrEXTUTS($Prss_data, $arr_xticks, 1); list($max_wnds, $max_wnds_uts) = getArrEXTUTS($WndS_data, $arr_xticks, 1); list($max_batt, $max_batt_uts) = getArrEXTUTS($Batt_data, $arr_xticks, 1); // get mins list($min_temp, $min_temp_uts) = getArrEXTUTS($Temp_data, $arr_xticks, 0, true); list($min_prss, $min_prss_uts) = getArrEXTUTS($Prss_data, $arr_xticks, 0, true); //extInsert(data, maxmin, value, uts) extInsert("temp", 1, $max_temp, $max_temp_uts); extInsert("temp", 0, $min_temp, $min_temp_uts); extInsert("pressure", 1, $max_prss, $max_prss_uts); extInsert("pressure", 0, $min_prss, $min_prss_uts); extInsert("wind_spd", 1, $max_wnds, $max_wnds_uts); extInsert("batt", 1, $max_batt, $max_batt_uts); // and debug function dPrint($data, $value, $uts, $maxmin, $units) { echo $maxmin == 1 ? "max" : "min"; echo " " . $data . " was: " . $value . $units . " at " . date("G:i, F j Y", $uts) . ".<br>"; } if ($DEBUG) { dPrint("temp", $max_temp, $max_temp_uts, 1, "C"); dPrint("temp", $min_temp, $min_temp_uts, 0, "C"); dPrint("prss", $max_prss, $max_prss_uts, 1, "mb"); dPrint("prss", $min_prss, $min_prss_uts, 0, "mb"); dPrint("WndS", $max_wnds, $max_wnds_uts, 1, " rpm"); dPrint("batt", $max_batt, $max_batt_uts, 1, "V"); }