aboutsummaryrefslogtreecommitdiff
path: root/opengts.cfg
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2013-11-09 23:52:13 +1300
committerAnton Tananaev <anton.tananaev@gmail.com>2013-11-09 23:52:13 +1300
commit81f568a2b63f0a882db0b0ba23ac5d173cd30465 (patch)
tree377e4c422288700964268ef35eba48a2a3ce0c8a /opengts.cfg
parentfa260aad4a99772e1b116474dd702849f6ee5727 (diff)
downloadtrackermap-server-81f568a2b63f0a882db0b0ba23ac5d173cd30465.tar.gz
trackermap-server-81f568a2b63f0a882db0b0ba23ac5d173cd30465.tar.bz2
trackermap-server-81f568a2b63f0a882db0b0ba23ac5d173cd30465.zip
Update OpenGTS config
Diffstat (limited to 'opengts.cfg')
-rw-r--r--opengts.cfg2
1 files changed, 1 insertions, 1 deletions
diff --git a/opengts.cfg b/opengts.cfg
index 03976c297..520a7b3b8 100644
--- a/opengts.cfg
+++ b/opengts.cfg
@@ -22,7 +22,7 @@
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, address)
- VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address);
+ VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed * 1.852, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address);
COMMIT;
</entry>