From f0d4f9de581b1f579608cbc3f5165c0b14317993 Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Sat, 10 Nov 2012 16:14:17 +1300 Subject: Added reverse geocoding --- opengts.cfg | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/opengts.cfg b/opengts.cfg index b5f00aafd..dcfae9c19 100644 --- a/opengts.cfg +++ b/opengts.cfg @@ -37,8 +37,8 @@ START TRANSACTION; UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:time), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = :device_id; SELECT @accountID := accountID, @deviceID := deviceID FROM Device WHERE imeiNumber = :device_id; - INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime) - VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :course, :altitude, '', UNIX_TIMESTAMP(NOW())); + INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime, address) + VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address); COMMIT; @@ -46,6 +46,9 @@ true 8082 + + true + true [LOG] -- cgit v1.2.3