connect_error) { die("Connection failed: " . $conn->connect_error); } function query_as_result($conn, $sql) { $result = $conn->query($sql); if ($result->num_rows < 1) { return -1; } $row = $result->fetch_assoc(); return $row['result']; } function sw_errors($conn, $id, $maxAgeSeconds) { $sql = "select count(id) as result from log_realtime where zkl=$id and (sw3000_state & 0x0f0) != 0 and t > unix_timestamp()-$maxAgeSeconds"; return query_as_result($conn, $sql); } function sw_mem($conn, $id, $maxAgeSeconds) { $sql = "select count(id) as result from log_realtime where zkl=$id and (sw3000_state & 0xff00) != 0x8f00 and t > unix_timestamp()-$maxAgeSeconds"; return query_as_result($conn, $sql); } function connects($conn, $id, $maxAgeSeconds) { $sql = "select count(t) as result from log_tcp where zkl=$id and event=\"connect\" and t > unix_timestamp()-$maxAgeSeconds"; return query_as_result($conn, $sql); } function conn_errors($conn, $id, $maxAgeSeconds) { $sql = "select count(t) as result from log_tcp where zkl=$id and event=\"error\" and t > unix_timestamp()-$maxAgeSeconds"; return query_as_result($conn, $sql); } function samples($conn, $id) { $sql = "select count(*) as result from log_realtime where zkl=$id"; return query_as_result($conn, $sql); } function remarks($conn, $id) { $sql = "select rtstatus as result from zkl where id=$id"; return query_as_result($conn, $sql); } function pcm_found($conn, $id) { $sql = "select mcu_persistent & 0x00200000 as result from log_realtime where zkl=$id order by id desc limit 1"; $result = query_as_result($conn, $sql); if ($result < 0) return "NoPCM"; return "PCM"; } function phonenr($conn, $id) { $sql = "select telefoonnr as result from zkl where id=$id"; return query_as_result($conn, $sql); } ?> Checkconfig Filter set to $hours hours

"; ?> query($sql); if ($result->num_rows < 1) { continue; } $zkl = $result->fetch_assoc(); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
SerieNR IDcode MCU WCPU Drive Measure Wavecom Wavrev SWMEM PCB BOM RTStatus APN TCP SMS Language ServiceDate Status SwErrors SwMemErrors Connects ConErrors Samples PhoneNr Remarks PCMfound
".$zkl['serienr']."".$zkl['idcode']."".$zkl['mcu_versie']."".$zkl['wcpu_versie']."".$zkl['sw3000_dversie']."".$zkl['sw3000_mversie']."".$zkl['wavecom_versie']."".$zkl['wavecom_revisie']."".$zkl['sw3000_onderhoud']."".$zkl['pcb_versie']."".$zkl['mech_versie']."".$zkl['capabilities']."".$zkl['gprs_apn']."".$zkl['tcp_server']."".$zkl['sms_server']."".$zkl['i18n']."".$zkl['onderhoud']."".$zkl['lans_status']."".sw_errors($conn, $id, $maxAgeSeconds)."".sw_mem($conn, $id, $maxAgeSeconds)."".connects($conn, $id, $maxAgeSeconds)."".conn_errors($conn, $id, $maxAgeSeconds)."".samples($conn, $id)."".phonenr($conn, $id)."".remarks($conn, $id)."".pcm_found($conn, $id)."

Go back to the form

Check device configuration

Hour filter
Quick search