GpsTracker / servers / php /
@Nick Fox Nick Fox authored on 11 Sep 2014
..
css changed to single styles.css file 10 years ago
images changed to single styles.css file 10 years ago
js completed change to PDO and prepared statements 10 years ago
mysql updated leaflet to 0.7.3 and fixed zoom button problem in php server 10 years ago
README.md added stored procedure to readme file 10 years ago
dbconnect.php changed db 10 years ago
deleteroute.php completed change to PDO and prepared statements 10 years ago
displaymap-blue.php changed to single styles.css file 10 years ago
displaymap-dark.php changed to single styles.css file 10 years ago
displaymap.php changed to single styles.css file 10 years ago
getallroutesformap.php completed change to PDO and prepared statements 10 years ago
getrouteformap.php completed change to PDO and prepared statements 10 years ago
getroutes.php completed change to PDO and prepared statements 10 years ago
updatelocation.php completed change to PDO and prepared statements 10 years ago
README.md

gpstrackerGps Tracker v3.2.4

Google Map Gps Cell Phone Tracker

Just a quick note, Aug 26, 2014

There is a responsive front-end using bootstrap in the bootstrap branch. This will be brought into the master branch as soon as I am done making it. You are free to use it now. I am using it on websmithing.com as my test pages and they are working fine.

The dark theme is displaymap.php and the light theme is displaymap-light.php.

If you want to use that branch, you need to add this stored procedure to your database:

DROP PROCEDURE IF EXISTS prcGetAllRoutesForMap; DELIMITER // CREATE PROCEDURE prcGetAllRoutesForMap() BEGIN SELECT distinct(sessionId), max(gpsTime) gpsTime, CONCAT('{ "latitude":"', CAST(latitude AS CHAR),'", "longitude":"', CAST(longitude AS CHAR), '", "speed":"', CAST(speed AS CHAR), '", "direction":"', CAST(direction AS CHAR), '", "distance":"', CAST(distance AS CHAR), '", "locationMethod":"', locationMethod, '", "gpsTime":"', DATE_FORMAT(gpsTime, '%b %e %Y %h:%i%p'), '", "phoneNumber":"', phoneNumber, '", "sessionID":"', CAST(sessionID AS CHAR), '", "accuracy":"', CAST(accuracy AS CHAR), '", "extraInfo":"', extraInfo, '" }') json FROM gpslocations WHERE sessionID != '0' && CHAR_LENGTH(sessionID) != 0 GROUP BY sessionID; END// DELIMITER ;


This project allows you to track cell phones periodically. For instance every minute or every five minutes. You can watch the cell phone being tracked in real time using google maps and you can store and reload routes easily.

You have the choice of two server stacks. Either using asp.net and sql server or using php and mysql. Both are now in the same download but you only need to use one.

If you need help, please go to:

https://www.websmithing.com/gps-tracker/

Here is a quick start guide to help you set up Gps Tracker:

https://www.websmithing.com/2014/01/20/quick-start-guide-for-gpstracker-3/


Changelog


Jun 12, 2014 - v3.2.4

Fixed android intervals not working above one minute and removed adsense ads publisher id.


Jun 6, 2014 - v3.2.3

This version fixes the zoom buttons on the google map which was causing the app to freeze and updates leaflet to version 0.7.3. This version is now free from all known errors.


May 5, 2014 - v3.2.2

This version fixes the total distance traveled in the android app.


May 1, 2014 - v3.2.1

This version changes the UI of the android app from two buttons (Save and Track) to one button (Track).

gpstrackerandroid

and the android version is now in Google Play:

https://play.google.com/store/apps/details?id=com.websmithing.gpstracker


Apr 20, 2014 - v3.2.0

Some pretty major changes here. The android app now has google play location services running in a background service. Also updates will restart if phone is rebooted. The servers are both now using json and jquery. Xml is gone forever. Both servers now support multiple map types. It's currently set up for google maps, bing maps and OpenStreetMaps.


Feb 11, 2014 - v3.1.0

Version 3.1.0 updates the php server code from google maps 2 to 3 and now uses jquery. There was a bug in the delete route stored procedure (the sessionID parameter was to small and was causing the delete to fail silently).


Jan 14, 2014 - v3.0.0

Version 3.0.0 of Gps Tracker is complete. This was a very big change from the last version. It's been updated with ios, android, windowsPhone and java me/j2me phone clients and the servers have all been updated as well. Please let me know how it works, good or bad and create an issue if you find a problem. Thanks and enjoy the software, Nick.

ps. I will be writing tutorials and documentation shortly.