cfgReadChar('gpsdatabase.host'); $gps_db_port = $savvyext->cfgReadLong('gpsdatabase.port'); $gps_db_name = $savvyext->cfgReadChar('gpsdatabase.name'); $gps_db_user = $savvyext->cfgReadChar('gpsdatabase.user'); $gps_db_pass = $savvyext->cfgReadChar('gpsdatabase.pass'); $conn_string_gps = "host=${gps_db_host} port=${gps_db_port} dbname=${gps_db_name} user=${gps_db_user} password=${gps_db_pass}"; $pgconn_gps = pg_connect($conn_string_gps); $res = []; $min_lat = PHP_INT_MAX; $min_lng = PHP_INT_MAX; $max_lat = PHP_INT_MIN; $max_lng = PHP_INT_MIN; $center_lat = 0; $center_lng = 0; $q = "select * from members_tracking where member_id=13 and id>1961278 and id<1961766 order by created"; $q = "select a.*,extract(epoch from a.ttime-b.ttime) as seconds from members_tracking a left join members_tracking b on (b.id=a.previous_id) "; $q.= "where a.member_id=13 and a.id>1961278 and a.id<1961766 order by a.ttime"; $r = pg_query($pgconn_gps, $q); while ($f=pg_fetch_assoc($r)) { $res[] = $f; if ($f["lat"]<$min_lat) $min_lat = $f["lat"]; if ($f["lng"]<$min_lng) $min_lng = $f["lng"]; if ($f["lat"]>$max_lat) $max_lat = $f["lat"]; if ($f["lng"]>$max_lng) $max_lng = $f["lng"]; } $center_lat = ($min_lat+$max_lat)/2; $center_lng = ($min_lng+$max_lng)/2; pg_close($pgconn_gps); ?> GPS speed test
ID GPS Duration Seconds Speed Syn.speed Distance Time
, 0?sprintf("%0.02f",$f["distance"]/$f["seconds"]):0?>