Пример #1
0
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++;
    }
}
Пример #2
0
    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");
}