*TrackMe* GPS/CellID Tracking tool for Google Earth & Google Maps *UPDATED 10/22/08*

[staryon]

good. That looks much better, so you don't have to use that str_replace function.

[MPIIIMan]

Correct :)

[staryon]

****Important for people that are using their own servers!!****

I found an error that causes that first time that you make a query to your server is still using mine instead of the one that you have specified in the config.

I will upload a new version tomorrow.

Sorry about that.

[powerppc]

jcleek, the code you provided to work with Google Maps is great. I got my own api keys from google, paste your code onto my own server, enter in my own kml file, and voila. It worked.

How do you change it so it goes to Hybrid rather than Map? Or Satellite?

Ok Staryon, a couple of things:

1) You put a copyright notice on every GPS plotted point. So now those of us who are using this in any form other than on your server in the manner in which you developed are in violation of that copyright, including doughcom. Any customizations of the output are in conflict with your copyright. Certainly it is within your rights to copyright your work but is it necessary to copyright the output?

2) I spent most of the morning figuring out how to do something that really was pretty simple. Using the Google maps API I got a little mashup going. Check this out:

My custom tracking web page (http://track.getcis.com/)

All you need to do is get a Google Maps API key (http://www.google.com/apis/maps/signup.html) and then you can use this code to set up your own page:



You need to change two things: the path to the kml file and the API key entries. Other than that upload it to your site and customize away.

Comments?

[powerppc]

****Important for people that are using their own servers!!****

I found an error that causes that first time that you make a query to your server is still using mine instead of the one that you have specified in the config.

I will upload a new version tomorrow.

Sorry about that.

Luis, this has been a great improvements. I could use this program for multi-purpose now. To see where I've been in google earth by downloading the kml after my trip, or have it to track me live. On my BlackBerry 8800, I had to use two different programs to do what your software do. So it's nice. However, I'm still looking for the same results as what I can get from Reperion, Accutracking or even Mologogo and that is, to have the speed I was driving, battery of my phone, satellite and signal strength. This is all through Googlemaps of course. Just a thought.

Great job btw, this has been a great community working together to make this even better.

[jcleek]

How do you change it so it goes to Hybrid rather than Map? Or Satellite?

Click the SATELLITE or HYBRID buttons in the upper right hand corner of the map. Was that a trick question?

[jcleek]

But again just like the original PHP files you need to declare POST and GET variables!!!

The changes you suggested have been made and the new version of the zip is below. Thanks for the help!

[grizzley]

Ok Staryon, a couple of things:

1) You put a copyright notice on every GPS plotted point. So now those of us who are using this in any form other than on your server in the manner in which you developed are in violation of that copyright, including doughcom. Any customizations of the output are in conflict with your copyright. Certainly it is within your rights to copyright your work but is it necessary to copyright the output?

2) I spent most of the morning figuring out how to do something that really was pretty simple. Using the Google maps API I got a little mashup going. Check this out:

My custom tracking web page (http://track.getcis.com/)

All you need to do is get a Google Maps API key (http://www.google.com/apis/maps/signup.html) and then you can use this code to set up your own page:



You need to change two things: the path to the kml file and the API key entries. Other than that upload it to your site and customize away.

Comments?



Maybe I am blind, but how can link to different maps using this? If I have map1
map2
map3
how can I link to ONLY map1?

Would that be the path setting and have to upload 3 seperate PHP files?

What am I missing here?

[VOODOOS!L]

Click the SATELLITE or HYBRID buttons in the upper right hand corner of the map. Was that a trick question?
I guess he want's to change the default view setting. so it goes to hybrid without having to click the buttons...

[staryon]

Luis, this has been a great improvements. I could use this program for multi-purpose now. To see where I've been in google earth by downloading the kml after my trip, or have it to track me live. On my BlackBerry 8800, I had to use two different programs to do what your software do. So it's nice. However, I'm still looking for the same results as what I can get from Reperion, Accutracking or even Mologogo and that is, to have the speed I was driving, battery of my phone, satellite and signal strength. This is all through Googlemaps of course. Just a thought.

Great job btw, this has been a great community working together to make this even better.

Yes, I plan to add all those features. Thanks for your feedback!

Regards

[VOODOOS!L]

Yes, I plan to add all those features. Thanks for your feedback!

Regards
nice, but I hope they will be configurable, so you can easily chose what data you want to upload...

btw, what is the traffic that will be used while uploading during a trip? as I don't have an unlimited data account...

[odie3]

****Important for people that are using their own servers!!****

I found an error that causes that first time that you make a query to your server is still using mine instead of the one that you have specified in the config.

I will upload a new version tomorrow.

Sorry about that.

I thought that was happening and I meant to report it last night.

[jcleek]

I guess he want's to change the default view setting. so it goes to hybrid without having to click the buttons...


In that case edit the index.php file. Find this line:

map.setCenter(new GLatLng(0,0),0);

And change it to:

map.setCenter(new GLatLng(0,0),0,G_HYBRID_MAP);

or

map.setCenter(new GLatLng(0,0),0,G_SATELLITE_MAP);

[jcleek]

****Important for people that are using their own servers!!****

I found an error that causes that first time that you make a query to your server is still using mine instead of the one that you have specified in the config.

I will upload a new version tomorrow.

Sorry about that.


Not sure if it is the same thing but when you try to export and select remote for the destination it uses information from and to your server and not the user selected server.

[staryon]

nice, but I hope they will be configurable, so you can easily chose what data you want to upload...

btw, what is the traffic that will be used while uploading during a trip? as I don't have an unlimited data account...

Basically I just make a HTTP request with this:
http://luisespinosa.com/trackme/requests.php?action=upload&username=USER&password=PASS&lat=20.2482086166667&long=28.2732949&dateadded=2007-10-30 9:57:10&dateoccurred=2007-10-30 9:57:10&tripname=mytrip

And I get back a response that looks like:

Result:1

[staryon]

Not sure if it is the same thing but when you try to export and select remote for the destination it uses information from and to your server and not the user selected server.

Yes, probably was the same problem.

[planetibo]

This is funny!!

How i can to make a "real time" google map?

I want that my website with my track show in real time the KML track.

Is it possible?

Thanks!

[jcleek]

This is funny!!

How i can to make a "real time" google map?

I want that my website with my track show in real time the KML track.

Is it possible?

Thanks!

Check out post 217 (http://forum.xda-developers.com/showpost.php?p=1663140&postcount=217)...

[planetibo]

Check out post #217...

I haven't find the code on the post #217 to make a google map with real-time tracking...

[jcleek]

I haven't find the code on the post #217 to make a google map with real-time tracking...

You mean you didn't see this CODE section in the middle of that post?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
<title>Google Maps JavaScript API Example</title>
<script src="http://maps.google.com/maps?file=api&v=2.x&key=Insert your key here" type="text/javascript">
</script>
<script type="text/javascript">
//<![CDATA[
var map;
var geoXml = new GGeoXml("http://path.to.your.kml.file");


function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById("map"));


map.setCenter(new GLatLng(0,0),0);
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.enableScrollWheelZoom();
map.addOverlay(geoXml);
map.setCenter(geoXml.getDefaultCenter());
geoXml.gotoDefaultViewport(map);
}
}



//]]>
</script>
</head>
<body onload="load()" onunload="GUnload()">
<div align=center>
<div id="map" style="width: 600px; height: 400px"></div>
<br>
Tracking information provided by <a href="http://forum.xda-developers.com/showthread.php?t=340667" target="_blank">TrackMe</a>
</div>
</body>
</html>

Seriously, I know the search is broken but....

[staryon]

New version ready.

- Notification of errors have been improved.
- When started, the program was always using the default server instead
of the one specified in Config->Remote.

[pennywisdom]

New version ready.

- Notification of errors have been improved.
- When started, the program was always using the default server instead
of the one specified in Config->Remote.
Wonderful, the program works great except I am having problems getting it to connect to my server. I have succeeded in setting up the map on my site and I just need to get it to upload in order to have the tracking online.

[staryon]

Wonderful, the program works great except I am having problems getting it to connect to my server. I have succeeded in setting up the map on my site and I just need to get it to upload in order to have the tracking online.

What errors are you getting? Maybe if you provide some extra information we can help you with that.

Regards

[pennywisdom]

What errors are you getting? Maybe if you provide some extra information we can help you with that.

Regards
I set up the MySQL just like jcleek explained, installed the php, my page even shows the route that I manually uploaded to my server.

http://www.underweargoesinsidethepants.com/track/index.php

The only problem is for uploading the positions to the server. Here is what my config looks like

Account
Username: *what was used for the MySQL setup*
Password: *what was used for the MySQL setup*

Server
ID: http://www.underweargoesinsidethepants.com
Port: 80
Root Folder: /track/
Files Extension: php

You can see that the index.php is located in the /track/ folder of the main site. Did I enter that information properly into the settings?

Thanks in advance!

[planetibo]

You mean you didn't see this CODE section in the middle of that post?



Seriously, I know the search is broken but....

I have an html page with this code! but, when i run with my car and "trackme", i have a friend see my page, and see my track. After, 10 or 50 second, they aren't new point. He must reload the page for see the new point from kml. How i can make a page whith point in real time= i want that my google map page load kml in "stream"?

[powerppc]

I have an html page with this code! but, when i run with my car and "trackme", i have a friend see my page, and see my track. After, 10 or 50 second, they aren't new point. He must reload the page for see the new point from kml. How i can make a page whith point in real time= i want that my google map page load kml in "stream"?

Put this on top of the page, just like what I did. <meta http-equiv="REFRESH" CONTENT="60" "content-type" content="text/html; charset=utf-8"/>

Content = 60 is 60 seconds.

[powerppc]

In that case edit the index.php file. Find this line:

map.setCenter(new GLatLng(0,0),0);

And change it to:

map.setCenter(new GLatLng(0,0),0,G_HYBRID_MAP);

or

map.setCenter(new GLatLng(0,0),0,G_SATELLITE_MAP);

Thanks JCleek. I wasn't too sure about the G_, I had only put in Hybrid_map, but didn't put G_ in front of it. Close, but no cigar for me. :)

[jcleek]

Sorry folks, there was a problem with the last zip I uploaded. Staryon can you use this one on your link?

[jcleek]

I set up the MySQL just like jcleek explained, installed the php, my page even shows the route that I manually uploaded to my server.

http://www.underweargoesinsidethepants.com/track/index.php

The only problem is for uploading the positions to the server. Here is what my config looks like

Account
Username: *what was used for the MySQL setup*
Password: *what was used for the MySQL setup*

Server
ID: http://www.underweargoesinsidethepants.com
Port: 80
Root Folder: /track/
Files Extension: php

You can see that the index.php is located in the /track/ folder of the main site. Did I enter that information properly into the settings?

Thanks in advance!

So are you getting data put into your MySQL tables by the application? If not, your problem is in your configuration of the application, or the php files did not get updated corrrectly. Look at the php files and see if in teh first few lines of code you see:

if(!@mysql_connect("DBIP","DBUSER","DBPASS"))

If you see that then the installer didn't work right for you and you need to edit those files manually. The lines you need to change are:

if(!@mysql_connect("DBIP","DBUSER","DBPASS"))

and

mysql_select_db("DBNAME");

If you are getting data then try deleting the manual kml file you uploaded...

[pennywisdom]

Sorry folks, there was a problem with the last zip I uploaded. Staryon can you use this one on your link?

I think I might have encountered it. Despite entering in my own Google API, it said the API was incorrect for my site. I edited the php file and all was well.

If you would, please see my previous post a few posts up and tell me if I am entering any of the information in TrackMe on my phone incorrectly. The site is set up and works, the problem seems to be the communication between TrackMe and my site.

Thanks!

[jcleek]

New version ready.

- Notification of errors have been improved.
- When started, the program was always using the default server instead
of the one specified in Config->Remote.


It says it is updating and says successful, but no KML file is generated. Here are some screen caps from the application:

[jcleek]

I think I might have encountered it. Despite entering in my own Google API, it said the API was incorrect for my site. I edited the php file and all was well.

If you would, please see my previous post a few posts up and tell me if I am entering any of the information in TrackMe on my phone incorrectly. The site is set up and works, the problem seems to be the communication between TrackMe and my site.

Thanks!

You also need to change the KML file line. Just search for "Slacker" and change it to our user ID as well. Sorry about that!

[staryon]

It says it is updating and says successful, but no KML file is generated. Here are some screen caps from the application:

uhmm... could you double check that your trips have no name associated?
If you select <None> you are exporting only those trips. Maybe all your trips have a name.

[pennywisdom]

You also need to change the KML file line. Just search for "Slacker" and change it to our user ID as well. Sorry about that!

I did see that the path to the KML file was off so I had fixed that as well. I checked the DBID, DBUSER, DBPASS as you said in the last post but all of those were correct in the php file.

I tried to set my settings in the Config for Trackme to mimic your screenshots but it still won't connect properly. For some reason I can't even get a local track to store properly. The kml appears in the Program Files\TrackMe but there was only one position in it from a track I tried yesterday and none from today will work.

[odie3]

I tried the new website files and made more manual edits (after seeing some more posts). However, I get this error when trying to up load (error from website).

[14-Nov-2007 13:25:21] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/xxx/xxx/requests.php on line 12
[14-Nov-2007 13:25:21] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/xxx/xxx/requests.php on line 19

[jcleek]

Well nothing is working now. I can't get a kml file generated on my server at all despite many messages saying the file was created successfully....

The program runs, and entries are successfully being made in my POSITIONS table so I know the program and web server pieces are working correctly. But no matter what I do there are no KML files generated at all on my server, either automatically or by forcing an export.

[Eitel]

I did see that the path to the KML file was off so I had fixed that as well. I checked the DBID, DBUSER, DBPASS as you said in the last post but all of those were correct in the php file.

I tried to set my settings in the Config for Trackme to mimic your screenshots but it still won't connect properly. For some reason I can't even get a local track to store properly. The kml appears in the Program Files\TrackMe but there was only one position in it from a track I tried yesterday and none from today will work.


I have the same problem. If I upload a kml file manually (FTP it) to the folder, it works fine. But I can't get the program to upload any file at all. Always get a "Unable to upload position"

[jcleek]

Ok somehow I have hosed my folder for trackme... I installed to a new folder and it works.

[pennywisdom]

Ok somehow I have hosed my folder for trackme... I installed to a new folder and it works.as in, on your website?

[odie3]

Okay, I am using the http link that was posted some pages back. I have entered my username/password/trip name. In firefox I get this:

Result:3

Which I believe means:
// User not specified

Ideas?

[jcleek]

as in, on your website?

Yes, my problem was all me and my attempts to streamline a server install. Found a little problem and here is the current version...

[daesimps]

Yes, my problem was all me and my attempts to streamline a server install. Found a little problem and here is the current version...

jcleek - what's new in this release?

I have just got everything working together and don't want to risk it if there's nothing worth upgrading for

Thanks
Dae

[grizzley]

Can someone help?

I am using the PHP script / Google API
http://forum.xda-developers.com/showpost.php?p=1661333&postcount=217
that was posted a few pages back. The problem is that I don't know how to define WHICH map to view or how to view a particular map.

$tripname = urldecode($_GET["tripname"]);

That would seem to work, but it's nowhere in the page. I am uploading to the default server (http://luisespinosa.com/trackme/routes/) and I have about 5-6 "routs" uploaded but all I can pull using maps.google.com is the most recent map.

How can I define a particular map using this code:?
http://forum.xda-developers.com/showpost.php?p=1661333&postcount=217


Thanks



.

[jcleek]

jcleek - what's new in this release?

I have just got everything working together and don't want to risk it if there's nothing worth upgrading for

Thanks
Dae

fixed a bug in the install. If yours works, leave it.

[jcleek]

Can someone help?

I am using the PHP script / Google API
http://forum.xda-developers.com/showpost.php?p=1661333&postcount=217
that was posted a few pages back. The problem is that I don't know how to define WHICH map to view or how to view a particular map.

$tripname = urldecode($_GET["tripname"]);

That would seem to work, but it's nowhere in the page. I am uploading to the default server (http://luisespinosa.com/trackme/routes/) and I have about 5-6 "routs" uploaded but all I can pull using maps.google.com is the most recent map.

How can I define a particular map using this code:?
http://forum.xda-developers.com/showpost.php?p=1661333&postcount=217


Thanks



.

That map code shows whatever is in your KML file on the server in the routes folder. It is not to display a particular saved trip.

[odie3]

okay, I created a php.ini that enables globals in my directory for these files. Now I am getting "Result:0" and my DB is finally getting filled out. However, my *.kml file is not getting generated.

[daesimps]

I think a cool feature would be if you could choose the name of the kml file when you did an export. If we could then modify the index.php to show a drop down list of auto detected *.kml files we could choose which trip to display in google maps.

Just an idea.:)

EDIT: Just had a better idea. Could we modify index.php to do a SQL query for the trip names, and then based on the trip name selected build a .kml file for that trip (either itself or call export.php) so we could choose which of our trips to show a map of? Unfortunately I am not a PHP (or any web language) developer otherwise I would have a go myself.

[grizzley]

That map code shows whatever is in your KML file on the server in the routes folder. It is not to display a particular saved trip.

Maybe I do not understand you.

In the PHP page, this is in there:
var geoXml = new GGeoXml("http://luisespinosa.com/trackme/routes/mymaps.kml");
(it really points to my username - I edited that to "mymaps)

Now, when I upload that page to my own server and then view it via a web browser, it displays my last trip in a Google map.

Notice that I said the LAST trip.... What I want to do is display "whatever map" I want to display; not always the last one I uploaded.

[pennywisdom]

jcleek, I don't understand why there are 2 different usernames. Am I using them properly?

In your install script, you ask for the username and password that go with the MySQL login. Those are what I can use to log into the MySQL on my site. That I understand, but you ask for a second username at the bottom of the install script as well. What is that username for? Am I supposed to use that name in TrackMe on my phone? If so, what is the password I am supposed to use as well?

[odie3]

Bah, had to use the PDA to get the *.kml file to get *exported*. However, there is no push pin on my map (and no errors either).

Man, this is driving me crazy! Suggestions?

NM, missed the web link to jcleek site on the index.php... I have been editing the files manually since I could never get the installer to work (last night).

All Is Well with this php web site now!

[odie3]

BTW, the time on the web page is off by one hour (+1). There a way to correct that?

[grizzley]

I think a cool feature would be if you could choose the name of the kml file when you did an export. If we could then modify the index.php to show a drop down list of auto detected *.kml files we could choose which trip to display in google maps.

Just an idea.:)

EDIT: Just had a better idea. Could we modify index.php to do a SQL query for the trip names, and then based on the trip name selected build a .kml file for that trip (either itself or call export.php) so we could choose which of our trips to show a map of? Unfortunately I am not a PHP (or any web language) developer otherwise I would have a go myself.

BINGO! Great IDEA! Just pull ID from the MySQL database.
Perfect.

[spamenigma]

not sure why. I haven't been able to test it there. I know some people are using the program with bluetooth GPS and Smartphones and it's working fine.

Maybe it should something easy to fix but I don't know how to test it... could you try this program that Sherpa wrote?
http://forum.xda-developers.com/showthread.php?t=337076

Basically it will try to connect to your GPS.
Please let me know what results you get with that.

Thanks

Hi, I've just tested that gps program and it kills my phone to a painful crawl, its perceived to have locked up but with patience its realised its just going incredebly slowly, like 2mins to gradually draw a menu...once I killed GPSInit the phone returned to normal speeds. hmmmm

for reference googlemaps and tomtom are both working with the GPS on this phone.. (the o2 orbit)

[kiwikenji]

I just found this program and I have to say its much better than some other progs I've been using. I have a question in regards to dispalying real time tracks with Google Earth? Once I download the kbl file to my PC, will it dynamically show new tracking points? Or will I have to download a new KBL file with the new tracking points. Basically what im asking is if someone can sit down and see me real time on Google Earth. I tried refreshing my earth Google, but it only shows what had been download to the .kbl file. Many thanks again.....will be donating for this great program.

[jcleek]

jcleek, I don't understand why there are 2 different usernames. Am I using them properly?

In your install script, you ask for the username and password that go with the MySQL login. Those are what I can use to log into the MySQL on my site. That I understand, but you ask for a second username at the bottom of the install script as well. What is that username for? Am I supposed to use that name in TrackMe on my phone? If so, what is the password I am supposed to use as well?

Your MySQL server needs a user name and password.

The application on your WM device needs a different user name and password. The second user name on the install page is the user name you use on your WM device.

[staryon]

I just found this program and I have to say its much better than some other progs I've been using. I have a question in regards to dispalying real time tracks with Google Earth? Once I download the kbl file to my PC, will it dynamically show new tracking points? Or will I have to download a new KBL file with the new tracking points. Basically what im asking is if someone can sit down and see me real time on Google Earth. I tried refreshing my earth Google, but it only shows what had been download to the .kbl file. Many thanks again.....will be donating for this great program.

The best way of doing that (at least is how I do it) is storing the points remotely. By doing that, every time that the KML file is generated (you can create it automatically with every new point uploaded), you can have access to the KML using a URL. Something like http://luisespinosa.com/trackme/routes/USER.kml
(click on 'Show Generated filenames' to see the exact URL)

Once you have that, go to Google Earth and click on 'Add network link'. Enter the URL, check 'Fly on refresh' and specify a time period (I usually enter 30 seconds).

And you're done!

PS: I plan to write a manual this weekend for the program... so stay tuned!

Regards

[grizzley]

Wait....
Why is there a database? What is the use? The script reads from the KLM file, not the database where the routes are stored.

What am I missing?

When you go to index.php, that page just reads the /routes/user.klm file, NOT the database. So, you have a big old database full of routes, but how do you access them?

[staryon]

Wait....
Why is there a database? What is the use? The script reads from the KLM file, not the database where the routes are stored.

What am I missing?

When you go to index.php, that page just reads the /routes/user.klm file, NOT the database. So, you have a big old database full of routes, but how do you access them?

The KML files are like subsets of the database. You decide how to generate the KML files. You can generate a KML file using all your points from any trips, for a given trip, or for trips with no names. You can also specify a date range.

By having a database you have ALL your data stored, from all your trips. You will never lose that data.

When you choose 'Realtime tracking' what it really does is to create a KML file using the last 6 hours of data that you have in the database.

Hope it helps.

[grizzley]

Sorry, I still dont get it.....

Tell me this, maybe this will help me understand.....

I have a database of routes. How do you access any of those via the web?

In order to access them, you have to manually create a new PHP page to view "trip 1" and another page for "trip 2".

I don't know. There just donset seem to be any of the pages (index mainly) that selects or pulls the database, in ONLY gets /routes/my.klm

If it referenced the database, or had a way to select them, or anything, I might understand....

Are you saying that the klm files on the server are pulling data from the database?

sorry.

[kiwikenji]

Staryon, your the man! I was not aware of the 'Add network link' on Google Earth. I was just placing the URL under >FILE>OPEN. I will give this a try tomorrow. Good idea on writing a guide for newbies....when i first set this up I was completely lost. Again "buen trabajo"!

[jcleek]

Sorry, I still dont get it.....

Tell me this, maybe this will help me understand.....

I have a database of routes. How do you access any of those via the web?

In order to access them, you have to manually create a new PHP page to view "trip 1" and another page for "trip 2".

I don't know. There just donset seem to be any of the pages (index mainly) that selects or pulls the database, in ONLY gets /routes/my.klm

If it referenced the database, or had a way to select them, or anything, I might understand....

Are you saying that the klm files on the server are pulling data from the database?

sorry.

You are correct. The index.php file I wrote does not access any databases. You need the databases for the WM application to have a place to store data. The index page displays the KML file you tell it to. It can be a KML produced by the WM application or one you downloaded from your sister Lucy's web server. It doesn't matter. I wrote the page for the specific task of displaying the contents of the KML file. If you want the page to read data directly from the database, change the code and make it do that and then come back here and share what you made just like Staryon, Doughtcom and I have done. Unfortunately it is impossible to give everyone everything they want with a single solution....

[grizzley]

You are correct. The index.php file I wrote does not access any databases. You need the databases for the WM application to have a place to store data. The index page displays the KML file you tell it to. It can be a KML produced by the WM application or one you downloaded from your sister Lucy's web server. It doesn't matter. I wrote the page for the specific task of displaying the contents of the KML file. If you want the page to read data directly from the database, change the code and make it do that and then come back here and share what you made just like Staryon, Doughtcom and I have done. Unfortunately it is impossible to give everyone everything they want with a single solution....

OK, I understand. I just didn't know what it was doing. So it appears that your script does two things. I am going on vacation and upon my return I will try to add a page that reads the database and allows selection of which database to display. I wont redo what you did, just add to it.

[staryon]

Yes, what jcleek mentions in correct. Just one more thing for making more clear.

If you don't want to have your own server to store the GPS positions and you don't want to store them on your PDA either, you can just use my server. When you run the program for the first time is already configured with that. You just need to enter a username and password (whatever you want) and start uploading data.

Once you are doing that you can generate KML files automatically if you need realtime tracking. If you don't care about this and you just want to see your trip later today or any other day, just forget about the 'Realtime tracking' tab, and go to Tools->Export Data when you are ready to create your KML file.

Regards

[jcleek]

OK, I understand. I just didn't know what it was doing. So it appears that your script does two things. I am going on vacation and upon my return I will try to add a page that reads the database and allows selection of which database to display. I wont redo what you did, just add to it.

Awesome! Can't wait to see what you come up with.

You guys can check this out:

Selectable KML files (http://www.getcis.com/trackme/test.php)

Is that what some of you are looking for?

[odie3]

Awesome! Can't wait to see what you come up with.

You guys can check this out:

Selectable KML files (http://www.getcis.com/trackme/test.php)

Is that what some of you are looking for?

What we looking at, I am not seeing anything Selectable... :(

Okay, I am getting a drop down now - that is SWEET! I want that! :) :)

[jcleek]

What we looking at, I am not seeing anything Selectable... :(

Click the link again. You are too fast. About 2 seconds after I posted it I changed it... sorry! It just lists all KML files in the routes folder.

[odie3]

Click the link again. You are too fast. About 2 seconds after I posted it I changed it... sorry! It just lists all KML files in the routes folder.

LOL - sorry :( I had just refreshed the page thinking that might have been the issue. I see the drop down, I was hoping something like that would happen!

Look forward to that release!

[jcleek]

Here you go. Rename it to index.php. Search for GOOGLEAPIKEY and put in your API key. That should be all you need to change.

[jcleek]

Ok, found information on getting data from a MySQL database and here is what I am thinking. A page comes up with a form pre-populated with the user names in the database in a drop-down list. You select a name (Slacker) and the next drop-down is auto-populated with trip names for that user. You select the trip you want for that user and hit submit and a map page loads with the information relating to the trip you selected. Is that what you guys think you are asking for?

[daesimps]

Ok, found information on getting data from a MySQL database and here is what I am thinking. A page comes up with a form pre-populated with the user names in the database in a drop-down list. You select a name (Slacker) and the next drop-down is auto-populated with trip names for that user. You select the trip you want for that user and hit submit and a map page loads with the information relating to the trip you selected. Is that what you guys think you are asking for?

Absolutely spot on. It's the idea I posted a while back, but with the addition of the username section. That would be perfect.

Please don't take this as an ungreatful please for further work. I appreciate everything you guys have done and the result is awesome. It was just an idea on how it could be expanded a bit. If I knew anything about web design or PHP I would have had a go myself.

Keep up the good work.

[licht77]

Sorry - i am blind :)

[pennywisdom]

Your MySQL server needs a user name and password.

The application on your WM device needs a different user name and password. The second user name on the install page is the user name you use on your WM device.What do I put in the password on my WM device then?

[jcleek]

As Staryon previously posted, you can use any user name and password combo. If that user name/password combo isn't already on the server an account will be created for you automatically.

[staryon]

As Staryon previously posted, you can use any user name and password combo. If that user name/password combo isn't already on the server an account will be created for you automatically.

hey jcleek,

it's being a little bit difficult to keep up with all the updates that you are doing and the different tools. Do you think you can write a short description of every tool and include a link where to get the latest? So I can put all that in the main page.

Thanks a lot for your work!!

[mbritten]

can anyone recommend a good free hosting site that will allow me to set this up. I tried 007ihost.com but can't upload .kml files for some reason.

[laakness]

can anyone recommend a good free hosting site that will allow me to set this up. I tried 007ihost.com but can't upload .kml files for some reason.

I've used phpwebhosting.com in the past and they were always great to deal with.

[staryon]

can anyone recommend a good free hosting site that will allow me to set this up. I tried 007ihost.com but can't upload .kml files for some reason.

why don't you use the one that comes by default? I don't charge anything for using it.

[mbritten]

because im trying to set up the google maps server with selectable maps. does each user have their own folder on your server or all the kml file for everyone put in the same routes folder?

[jcleek]

Staryon,

The only real tool I did was included in the install zip file which hasn't been changed. But to make things easier I have put the zip file here (www.getcis.com/trackme/TrackMe_Server.zip) and you can link directly to that so it will always lead to the latest version.

The test file I am working on isn't finished so that isn't really ready to be included.

[staryon]

because im trying to set up the google maps server with selectable maps. does each user have their own folder on your server or all the kml file for everyone put in the same routes folder?

oh... I understand. Yes, all the kml files are placed in the same folder.

[jcleek]

Database Test Page

Ok guys, I got a rough (emphasis on rough) database thing going.

Test database page (http://www.getcis.com/trackme/test.php)

Instead of loading a KML click the LOAD FROM DATABASE link. I am pretty sure you can figure the rest of it out. Let me know what you think!

[AndyInFl]

Thanks to everyone working on this project.

I installed this on my stock rom Tilt. (v2.0.9.24)

When I press start I get th following:

Position added correctly.
Generating local .kml file...
The data type is not valid for the boolean operation.[Data type if known =...
Stroring xx.xxx ......

(Repeat)

(Repeat)

Do I have something set wrong? I have done an install, a removal, and a reinstall and get the same thing.

Thank you.

[staryon]

{edited}

Please check next post.

[staryon]

AndyInFl,

Could you try the following?

Go to Tools->Export GPS Positions.

Once you are there, select source=LOCAL and destination=LOCAL.
After that try exporting data with Trip=<None>, Trip=<Any>, and Trip = a trip that you have. Don't select a date range.

Let me know if at least one those tests work fine.

Thanks

[daesimps]

Database Test Page

Ok guys, I got a rough (emphasis on rough) database thing going.

Test database page (http://www.getcis.com/trackme/test.php)

Instead of loading a KML click the LOAD FROM DATABASE link. I am pretty sure you can figure the rest of it out. Let me know what you think!

Perfect!!!:D

[p25o1]

does track me store the speed and time of the trip at each point,,,

i would like to have that since we go gokarting and this way i can track may lap time and speed :-) i'm sure other will like this option.


please add it in the new version.

[jcleek]

I won't keep posting the link but the test page is going to be updated until I get all the kinks worked out. I figured out how to center based on all points in the trip on the database query and standardized the page looks.

Test database page (http://www.getcis.com/trackme/test.php)

If you have ideas on how to make it better let me know. If nobody has any changes I will upload the code so everyone can have it.

[odie3]

does track me store the speed and time of the trip at each point,,,

i would like to have that since we go gokarting and this way i can track may lap time and speed :-) i'm sure other will like this option.


Yes, speed on each bubble would be very nice, I was thinking the same thing last night.


I won't keep posting the link but the test page is going to be updated until I get all the kinks worked out. I figured out how to center based on all points in the trip on the database query and standardized the page looks.

Test database page (http://www.getcis.com/trackme/test.php)

If you have ideas on how to make it better let me know. If nobody has any changes I will upload the code so everyone can have it.
Looks very nice and I am looking forward to a release!

[daesimps]

I won't keep posting the link but the test page is going to be updated until I get all the kinks worked out. I figured out how to center based on all points in the trip on the database query and standardized the page looks.

Test database page (http://www.getcis.com/trackme/test.php)

If you have ideas on how to make it better let me know. If nobody has any changes I will upload the code so everyone can have it.

I could be wrong, but I am sure that the first time I tried it (earlier today before your changes) the DB query presented a list of trips from the DB. This doesn't seem to be an option now. Have you removed it? (or am I being stupid and it didn't exist to start with?;) )

[jcleek]

Try it again guys. If you get an error or some weirdness wait 60 seconds and refresh. I am working on it as you are looking at it. Got any ideas for improvements?

[staryon]

I could be wrong, but I am sure that the first time I tried it (earlier today before your changes) the DB query presented a list of trips from the DB. This doesn't seem to be an option now. Have you removed it? (or am I being stupid and it didn't exist to start with?;) )

Did you click on 'Get Existing'? (don't forget the source, 'local' or 'remote)

[staryon]

hey guys,

Today I have been researching about displaying maps inside the application, so I can show where you are located every time a GPS position is received.

However, I have no luck finding the right tool. In my application I can place a Pocket IE component, so I can browse web pages.
Unfortunately it doesn't work if I try to open a web page containing a Google Map or a Virtual Earth map.

If I try these 2:

http://luisespinosa.com/temp/google.html
http://luisespinosa.com/temp/virtualearth.html

They work fine on my desktop, but not with PocketIE. I think it's because PIE uses a simplified javascript subset.

I also found that I can use a MapPoint web service. The problem is this service is not free and rather expensive.

Do you guys know any other options that I can try?

Thanks

[jcleek]

My only question is why? Google Maps works great on WM devices. Why reinvent the wheel? You can run Google Maps or Windows Local Mobile at the same time TrackMe is running if you need realtime mapping. What benefit would it give?

[jcleek]

Also a request Staryon, can you fix the trip autoname to specify:

Trip_YY.MM.DD_HH.MM.SS_PM

vs

Trip_MM.DD.YY_HH.MM.SS_PM

It would make sorting the trip names much easier if the year were in front of the month.

[daesimps]

Did you click on 'Get Existing'? (don't forget the source, 'local' or 'remote)

Ignore my previous post. Jcleek must have been modifying his page as I was trying it.

[staryon]

My only question is why? Google Maps works great on WM devices. Why reinvent the wheel? You can run Google Maps or Windows Local Mobile at the same time TrackMe is running if you need realtime mapping. What benefit would it give?

That's true too... I just thought it could be easier in having integrated all together, so it's easier to swap between TrackMe and GoogleMaps.
Anyway, maybe it's not needed....

[staryon]

Also a request Staryon, can you fix the trip autoname to specify:

Trip_YY.MM.DD_HH.MM.SS_PM

vs

Trip_MM.DD.YY_HH.MM.SS_PM

It would make sorting the trip names much easier if the year were in front of the month.

jcleek, I prefer to use a more international format. Having MM.DD.YY can be confusing for some countries. Maybe I can create the names based on the regional settings...

[daesimps]

That's true too... I just thought it could be easier in having integrated all together, so it's easier to swap between TrackMe and GoogleMaps.
Anyway, maybe it's not needed....

I'd have to agree. I think by adding in too much functionality it would be loosing two of the best things about the program - its simplicity and the fact that it's not bloatware.

Keep it simple (yet functional) is my motto.

[jcleek]

Ok guys, test.php is gone. The live page is now the complete package.

Click here (http://track.getcis.com)

DO NOT download this file!!! I hosed it. Look in the next post...

[jcleek]

I wish this board would let you delete attachments...

Click here (http://www.getcis.com/trackme/index.zip) to get the current index.php file. I will be updating the install package later.

[daesimps]

Ok guys, test.php is gone. The live page is now the complete package.

Click here (http://www.getcis.com/trackme)

DO NOT download this file!!! I hosed it. Look in the next post...

That seems ideal. Just one quick question - are you getting the trip names from the DB or are you naming them yourself? The only reason I ask is that the date is the wrong way round for me. Today is 15/11 here in the UK.

Good work.

[jcleek]

I get the trip names directly from the trips table in teh database. Those are named by the WM application directly.

[staryon]

by the way, just for fun I added an option to show on the map your last uploaded position (using a MapPoint web service) .
It works fine but it adds like 60KB to the executable.
Since you guys don't like this, I will take it out.

[AndyInFl]

AndyInFl,

Could you try the following?

Go to Tools->Export GPS Positions.

Once you are there, select source=LOCAL and destination=LOCAL.
After that try exporting data with Trip=<None>, Trip=<Any>, and Trip = a trip that you have. Don't select a date range.

Let me know if at least one those tests work fine.

Thanks

Staryon,

I did as you asked and got mixed results. Exported data with Trip = NONE creates the route.kml file but it only creates what appears to be the header info. The other two exports create what seems to be normal data filled files.

The messages I typed in the previous post occur on screen as soon as I press start. The same 4 lines appear in a repetitive loop.

What should I try next?

Thank you.

[staryon]

Could you try to click on START and run it for a while but disabling the Realtime tracking?
I want to see if at least all the GPS positions are stored correctly.

Thanks

[AndyInFl]

Could you try to click on START and run it for a while but disabling the Realtime tracking?
I want to see if at least all the GPS positions are stored correctly.

Thanks

Staryon,

I think you are on to something. Two lines now appear:

Storing 26.xxx,-80.xxx...
Position added correctly.

(Repeat)
(Repeat)...

[staryon]

Thanks AndyInFl

hmm... so the error is in the Export function (it's called when you do Realtime Tracking). However I don't understand why it doesn't fail when you call the Export function directly...

[staryon]

Staryon,

I think you are on to something. Two lines now appear:

Storing 26.xxx,-80.xxx...
Position added correctly.

(Repeat)
(Repeat)...


Andy, I sent you a PM. Could you try that version?

Thanks

[AndyInFl]

Andy, I sent you a PM. Could you try that version?

Thanks

I removed the previous version and installed the one you sent. You have corrected the boolean error message.

After pressing START, Four lines appear now in repetition:

Storing 26.xxx,-80.xxx...
Position added correctly.
Generating local .kml file.
.kml file generated correctly.

(Repeat)
(Repeat)

Thank you.

[AndyInFl]

Great job!

I was able to open the file and watch the neighborhood appear!

Thanks to all for the work so far and keep going! As a boater and a person who enjoys traveling off the beaten path with the four wheeler, I can leave a trail for someone to "come to the rescue" if one day I don't make it "home for dinner."

Thanks again.

[staryon]

I removed the previous version and installed the one you sent. You have corrected the boolean error message.

After pressing START, Four lines appear now in repetition:

Storing 26.xxx,-80.xxx...
Position added correctly.
Generating local .kml file.
.kml file generated correctly.

(Repeat)
(Repeat)

Thank you.

Good. But only use that version temporarily. Date Ranges are not working with that version. At least I know where is the problem. I will release a new version tomorrow with that problem fixed.

Thanks for your help!

[staryon]

By the way, I'm already working on adding information about the speed and altitude.

[odie3]

By the way, I'm already working on adding information about the speed and altitude.


Sweet, I wonder if it will work the next time I fly? :eek:

[odie3]

I wish this board would let you delete attachments...

Click here (http://www.getcis.com/trackme/index.zip) to get the current index.php file. I will be updating the install package later.


Okay I get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource ... on line 113

and

Warning: filemtime() [function.filemtime (http://odie3.com/trackme/function.filemtime)]: stat failed for routes/.kml in ... on line 138

[staryon]

Sweet, I wonder if it will work the next time I fly? :eek:

yeah... it should :D

[p25o1]

man this app is getting better and better,

i requested this some pages back,

cn you add the speed on the track points information, it will be very useful for me, and i hope others,,, may be an option to enable it ?


thanks again, and keep up the amazing work.

[daesimps]

I have tried the new index.php, but neither of the buttons appear to do anything. They simply return me back to the initial screen.

Does anyone have any ideas?

EDIT: I have resolved this on my server. I think it is to do with variables not being declared. I know nothing about PHP and just used a combination of Google and other programming knowledge from years ago (most of it forgotten now!).

[jcleek]

Okay I get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource ... on line 113

and

Warning: filemtime() [function.filemtime (http://odie3.com/trackme/function.filemtime)]: stat failed for routes/.kml in ... on line 138

Did you modify the top section and replace the DBIP, DBUSER, DBPASS, DBNAME and GOOGLEAPIKEY fields with the appropriate information for your server? The reason it can not find a KML file is that it didn't get a name from the database to load.

EDIT: I have resolved this on my server. I think it is to do with variables not being declared. I know nothing about PHP and just used a combination of Google and other programming knowledge from years ago (most of it forgotten now!).

Both of you please download the file again (http://www.getcis.com/trackme/index.zip) and try it. I made some more changes last night including auto-loading the most current trip on database selection and I declared all of the variables up front (I think). Daesimps if you find any other undeclared variable problems with this version let me know and I will fix them.

I have trimmed the code down as much as I think I can. If you know php have a look at it and tell me what I can do to improve it.

[jcleek]

jcleek, I prefer to use a more international format. Having MM.DD.YY can be confusing for some countries. Maybe I can create the names based on the regional settings...

I don't know why I didn't think of this sooner but all I needed to do was sort the trips on the ID field. Since that field is set to autoincrement it will always be in chronological order. On the trip page I just ORDER BY ID DESC and get them listed in most recent trips first regardless of the name you give the trip.

[daesimps]

Did you modify the top section and replace the DBIP, DBUSER, DBPASS, DBNAME and GOOGLEAPIKEY fields with the appropriate information for your server? The reason it can not find a KML file is that it didn't get a name from the database to load.



Both of you please download the file again (http://www.getcis.com/trackme/index.zip) and try it. I made some more changes last night including auto-loading the most current trip on database selection and I declared all of the variables up front (I think). Daesimps if you find any other undeclared variable problems with this version let me know and I will fix them.

I have trimmed the code down as much as I think I can. If you know php have a look at it and tell me what I can do to improve it.

I have just download it again, but I noticed that kml_data and database_data are not declared. I needed to declare these two on my machine as well. I haven't actually tried it, I just had to declare these two on the previous version to get it to work. I could be wrong though, as I said earlier I know nothing about PHP!:D

[jcleek]

I have just download it again, but I noticed that kml_data and database_data are not declared. I needed to declare these two on my machine as well. I haven't actually tried it, I just had to declare these two on the previous version to get it to work. I could be wrong though, as I said earlier I know nothing about PHP!:D

Correct, they are not declared. If you declare them at the top the page will not work! When necessary I test for their existence with $_POST[] in this new version. If yours doesn't work without you declaring those up front let me know, but it should be fine.

[daesimps]

Correct, they are not declared. If you declare them at the top the page will not work! When necessary I test for their existence with $_POST[] in this new version. If yours doesn't work without you declaring those up front let me know, but it should be fine.

Excellent. As I said - I know nothing! I will give it a try later on today. I appreciate the work you are doing on this project - it is really useful.

[jcleek]

I have made some changes... again. I pulled the MySQL information from all of the files and created a config file to store them. This includes Staryons php files. The zip linked below contains a new install.php, index.php, export.php, requests.php and upload.php. If you install any of it, install it ALL. Re-running the installation will not touch your data in the database, and as long as you do not delete your KML files they will be fine as well.

Staryon, the zip contains replacements for your files. All I did was add

require_once('config.inc');

At the top of each file, and I changed the placeholder text to variables:

DBIP changed to $DBIP
DBUSER changed to $DBUSER
DBPASS changed to $DBPASS
DBNAME changed to $DBNAME

That way your files do not need to be changed ever, just the database information in config.inc. Makes the install creation much much easier.

[odie3]

Did you modify the top section and replace the DBIP, DBUSER, DBPASS, DBNAME and GOOGLEAPIKEY fields with the appropriate information for your server? The reason it can not find a KML file is that it didn't get a name from the database to load.



Both of you please download the file again (http://www.getcis.com/trackme/index.zip) and try it. I made some more changes last night including auto-loading the most current trip on database selection and I declared all of the variables up front (I think). Daesimps if you find any other undeclared variable problems with this version let me know and I will fix them.

I have trimmed the code down as much as I think I can. If you know php have a look at it and tell me what I can do to improve it.

Okay, used your link from your above post, all is well now! Nice!

Also, does not this link need to be changed to fit the site where the files are installed? (that is what I been doing)
var geoXml = new GGeoXml(\"http://www.getcis.com/trackme/routes/$username.kml\"); \n";

[odie3]

What zip? Changes again? ;)

I have made some changes... again. I pulled the MySQL information from all of the files and created a config file to store them. This includes Staryons php files. The zip linked below contains a new install.php, index.php, export.php, requests.php and upload.php. If you install any of it, install it ALL. Re-running the installation will not touch your data in the database, and as long as you do not delete your KML files they will be fine as well.

Staryon, the zip contains replacements for your files. All I did was add

require_once('config.inc');

At the top of each file, and I changed the placeholder text to variables:

DBIP changed to $DBIP
DBUSER changed to $DBUSER
DBPASS changed to $DBPASS
DBNAME changed to $DBNAME

That way your files do not need to be changed ever, just the database information in config.inc. Makes the install creation much much easier.

[jcleek]

Also, does not this link need to be changed to fit the site where the files are installed? (that is what I been doing)
var geoXml = new GGeoXml(\"http://www.getcis.com/trackme/routes/$username.kml\"); \n";

Right you are, thanks for the catch. I have updated the Zip file. You can simply use the new index.php from the zip or manually replace that line above with

$html .= " var geoXml = new GGeoXml(\"http://" . $_SERVER['SERVER_NAME'] . str_replace("index.php", "", $_SERVER['SCRIPT_NAME']) . "routes/$username.kml\"); \n";

Easiest option is replace index.zip of you updated your install to get the MySQL stuff from config.inc. If you replace the index you need to make no other changes.

[odie3]

Where is your master link to get the new files and thank you for creating a Config file, I been meaning to request that (makes life so much easier for new users of your php code).

@ staryon:
When you start supporting Speed/Alt it would be cool if you could add a way to force a update and with that update have it so you can tag a custom pin on the map. Say, a user stops somewhere, you force a update with a food icon/pin (showing on the map you stopped here to get a bite to eat). Perhaps that is a silly idea but thought of it last night when I stopped to get some food.

[staryon]

I have made some changes... again. I pulled the MySQL information from all of the files and created a config file to store them. This includes Staryons php files. The zip linked below contains a new install.php, index.php, export.php, requests.php and upload.php. If you install any of it, install it ALL. Re-running the installation will not touch your data in the database, and as long as you do not delete your KML files they will be fine as well.

Staryon, the zip contains replacements for your files. All I did was add

require_once('config.inc');

At the top of each file, and I changed the placeholder text to variables:

DBIP changed to $DBIP
DBUSER changed to $DBUSER
DBPASS changed to $DBPASS
DBNAME changed to $DBNAME

That way your files do not need to be changed ever, just the database information in config.inc. Makes the install creation much much easier.

Good idea. I will change that.

By the way, I updated the first post with this http://www.getcis.com/trackme/index.zip
so it will always contain the latest changes of your files.

[staryon]

Where is your master link to get the new files and thank you for creating a Config file, I been meaning to request that (makes life so much easier for new users of your php code).

@ staryon:
When you start supporting Speed/Alt it would be cool if you could add a way to force a update and with that update have it so you can tag a custom pin on the map. Say, a user stops somewhere, you force a update with a food icon/pin (showing on the map you stopped here to get a bite to eat). Perhaps that is a silly idea but thought of it last night when I stopped to get some food.

Yes, if you check the to-do list there is already similar request :)
I like the idea of being able to choose an icon. Thanks!
You will also be able to add a comment for that update.

[odie3]

Cool, you are right there is a similar request (without the custom Icon/Pin). ;)

BTW, I get page not found trying to click the link for index.zip.

[jcleek]

I will start posting a link to the file in all of my posts, but the link isn't going to change.

Download the latest server files here (http://www.getcis.com/trackme/TrackMe_Server.zip).

[daesimps]

Another cool idea for the index.php file would be a third button which took you to the latest uploaded point and id an auto refresh - like a realtime tracker, but showing current location rather than the whole trip.

Keep up the good work. I notice that staryon has a donation link. Maybe you should get one too. I would definitely donate.

[odie3]

NM - stupid typo!

[Eitel]

I'm getting this error when I run the install.php file

Database tables created successfully
ERROR: config.inc can not be opened


Any ideas?

[jcleek]

I'm getting this error when I run the install.php file



Any ideas?

Yep. You will need to manually edit the config.inc. Your server won't let you write to files with a web page. Instructions are in the included generic config file.

[Eitel]

Yep. You will need to manually edit the config.inc. Your server won't let you write to files with a web page. Instructions are in the included generic config file.


I believe that's the problem. I don't have a config.inc file in any of the zip files I downloaded.

Edit: nvm, downloaded the file again and now I found it.

[jcleek]

Keep up the good work. I notice that staryon has a donation link. Maybe you should get one too. I would definitely donate.

Thanks for the offer! If you want to donate to me please send what you would have given me to Staryon. He deserves the credit. I am just playing with Google maps.

As for the option to show the last location I will look into it.

[boriznl]

Where can i get the trackme server zip file?

[Eitel]

Darn. I still can upload anything to my server. DBA creation when smooth, but when I try to upload the positions, I keep getting the "some positions have not been uploaded" message.

[jcleek]

Another cool idea for the index.php file would be a third button which took you to the latest uploaded point and id an auto refresh - like a realtime tracker, but showing current location rather than the whole trip.

Ask and ye shall receive. Zip file updated and you can see the example here (http://track.getcis.com).

Download the latest server files here (http://www.getcis.com/trackme/TrackMe_Server.zip).

[odie3]

I hope you do not mind this request, could you make the map size be a setting in the config file? I like to make the map 800x600... ;)

I like the new button!! :) :) :)

[wafwot]

Now that there's background color, another idea that should be quite easy is style variables in the config file for the maps. Quick config.inc example:

// Map style
$mapwidth = "600px";
$mapheight = "400px";
$mapborder = "1px";
$bordercolor = "black";
$mapalign = "center"

Then in the index.php file:

<div id=\"map\" style=\"width: $mapwidth; height: $mapheight; text-align:$mapalign; float:$mapalign; border:$mapborder solid $bordercolor;\"></div>

And I think an auto-refresh on the current location every $refresh seconds would be awesome!

My 2¢... Keep up the great work!

[staryon]

Thanks for the offer! If you want to donate to me please send what you would have given me to Staryon. He deserves the credit. I am just playing with Google maps.


If he does that I will send it to you!! man, you are doing a great work and you already part of the development of this program.

Regards

[daesimps]

jcleek - check your PM - it's important.

[jcleek]

IMPORTANT!

Ok folks, daesimps found a problem and you all need to fix it. Download the updated file and replace ALL of your files. Delete the config.inc file which has been replaced by config.php.

I have added customizations for the map, refresh seconds for the current location, and cleaned up the code a bit more.

Please update your server files now.

Download the latest server files here (http://www.getcis.com/trackme/TrackMe_Server.zip).

[daesimps]

IMPORTANT!

Ok folks, daesimps found a problem and you all need to fix it. Download the updated file and replace ALL of your files. Delete the config.inf file which has been replaced by config.php.

I have added customizations for the map, refresh seconds for the current location, and cleaned up the code a bit more.

Please update your server files now.

Download the latest server files here (http://www.getcis.com/trackme/TrackMe_Server.zip).

Just before I replace all the files I have a question/observation. Staryon's files don't seem to declare variables in them. Do they need editing to do so before everyone downloads the zip?

[staryon]

Just before I replace all the files I have a question/observation. Staryon's files don't seem to declare variables in them. Do they need editing to do so before everyone downloads the zip?

Next version will include the declaration of the variables. I'll be testing the new version during the weekend. Here is a small screen capture (Now I'm including the speed and the altitude):

http://img124.imageshack.us/img124/7337/testst7.jpg

[daesimps]

I am now getting

Parse error: syntax error, unexpected T_VARIABLE in/var/www/trackme/config.php on line 45

The install.php also still seems to be writing to config.inc


EDIT: Resolved - there was a ; missing from the end of the line $mapalign = "center";

[staryon]

I am now getting

Parse error: syntax error, unexpected T_VARIABLE in/var/www/trackme/config.php on line 45

He forgot a ; at the end of:

$mapalign = "center"

[jcleek]

Fixed the config.php... sorry about that.

Staryon, can you put the include for the config.php in your files and use the config.php for your variables? That way I don't have to change them, and they won't need to be changed unless you change them.

Also I am really looking forward to the new version. I like the speed and alt info. It will take me a little bit to get my page to show that information but shouldn't be difficult.

Download the latest server files here. (http://www.getcis.com/trackme/TrackMe_Server.zip)

[odie3]

Okay done! Thanks for the additional tweak settings in the config.php file. BTW, I guess it was a bad issue with the code (like some way to delete your database or something).

Thanks for the fix(s)!

IMPORTANT!

Ok folks, daesimps found a problem and you all need to fix it. Download the updated file and replace ALL of your files. Delete the config.inc file which has been replaced by config.php.

I have added customizations for the map, refresh seconds for the current location, and cleaned up the code a bit more.

Please update your server files now.

Download the latest server files here (http://www.getcis.com/trackme/TrackMe_Server.zip).

[staryon]

Fixed the config.php... sorry about that.

Staryon, can you put the include for the config.php in your files and use the config.php for your variables? That way I don't have to change them, and they won't need to be changed unless you change them.

Also I am really looking forward to the new version. I like the speed and alt info. It will take me a little bit to get my page to show that information but shouldn't be difficult.

Download the latest server files here. (http://www.getcis.com/trackme/TrackMe_Server.zip)

Yes, I already changed my files to use the file.

[odie3]

Oh boy, that is just SWEET! I hope that gets released soon (along with the web code to support it).

:):eek:

Next version will include the declaration of the variables. I'll be testing the new version during the weekend. Here is a small screen capture (Now I'm including the speed and the altitude):

http://img124.imageshack.us/img124/7337/testst7.jpg

[jcleek]

Staryon, if you can give me a preview of the MySQL table changes I can probably get my updates made and have them ready for your release.

[licht77]

Staryon - I love your tool! Really great work!

Two suggestions: How about calculating speed and altitude on the pdaside and include those 2 vars in the submission to the server?
And I would suggest to validate the vars passed to the sql statement. (I could do this on monday if wanted)

Thx and keep on that good work!

[staryon]

Staryon, if you can give me a preview of the MySQL table changes I can probably get my updates made and have them ready for your release.

Check your PMs.

By the way, I have a suggestion ;)
I would like to include your viewer in my website, but since I have many users and I want to keep their privacy, do you think you can provide a place to enter their username and password before seeing the data?

Thanks

[staryon]

Staryon - I love your tool! Really great work!

Two suggestions: How about calculating speed and altitude on the pdaside and include those 2 vars in the submission to the server?
And I would suggest to validate the vars passed to the sql statement. (I could do this on monday if wanted)

Thx and keep on that good work!

Yes! that's what I'm doing. It looks nice so far.
I will be testing this tonight on my driving back home. :)

[odie3]

Check your PMs.

By the way, I have a suggestion ;)
I would like to include your viewer in my website, but since I have many users and I want to keep their privacy, do you think you can provide a place to enter their username and password before seeing the data?

Thanks

BTW, speaking of privacy - the password is in clear text and you should be putting that in a MD5 hash (http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html).

[staryon]

BTW, speaking of privacy - the password is in clear text and you should be putting that in a MD5 hash (http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html).

I know, I know... :o

[staryon]

jcleek,

I forgot. In the database Speed and Altitude are stored in meters per seconds and meters respectively.

1 Meter per Second = 2.2369362920544 Miles per Hour
1 meter per second = 3.6 kilometers per hour
1 meter = 3.2808399 feet

[staryon]

jcleek,

I forgot. In the database Speed and Altitude are stored in meters per seconds and meters respectively.

1 Meter per Second = 2.2369362920544 Miles per Hour
1 meter per second = 3.6 kilometers per hour
1 meter = 3.2808399 feet

hmm... I just noticed that you don't really need that information. Anyway, there it is :)

[jcleek]

I am done coding for the night but I too have been thinking about the whole user name and password thing for the web page. I suppose I can set it up for a question at install: public or private. Public is what is there now, private will be a box to enter user ID and Pass and that is the only person's data that will show up. I just have to figure out how to do that.

I will also start on the MySQL stuff. I may be able to work on it tomorrow while driving down to Hampton if I can get the wife to drive.

[jcleek]

If you might change the code I will wait. Once you are solid on it I will make the updates.

[odie3]

Okay since updating the with the new web code TrackMe can not upload and it tells me I need to use a user/password and when I use the manual link in IE I get, "Result:3".

The site itself is working, where I can look at my kml or get trips from the DB.

So, going to poke around and try to figure this out but if you have a suggestion, I'll take it.

[odie3]

Well, its the darn globals again (forgot to place a php.ini with globals enabled for my track folder). Got to get away from globals being enabled on your server. ;)

Request about the Show Last Position (or if there is one marker on a map), could the zoom be somewhere around map.setZoom(17)? At my house the last zoom level does not work for Satellite view (I am using hybrid view).

[jcleek]

Request about the Show Last Position (or if there is one marker on a map), could the zoom be somewhere around map.setZoom(17)? At my house the last zoom level does not work for Satellite view (I am using hybrid view).

Not possible. The map figures out its own zoom level based on what is being displayed. It has nothing to do with available satellite imagery.

[odie3]

Not possible. The map figures out its own zoom level based on what is being displayed. It has nothing to do with available satellite imagery.


Well, it is:

//Find
$html .= " map.setZoom(map.getBoundsZoomLevel(bounds));\n";

// Replace with
$html .= " map.setZoom(17);\n";

I just can not figure out how to do a if/else for the "last_location" and "database_data" buttons. :(

[staryon]

I am done coding for the night but I too have been thinking about the whole user name and password thing for the web page. I suppose I can set it up for a question at install: public or private. Public is what is there now, private will be a box to enter user ID and Pass and that is the only person's data that will show up. I just have to figure out how to do that.

I will also start on the MySQL stuff. I may be able to work on it tomorrow while driving down to Hampton if I can get the wife to drive.

I think it's a great idea having those 2 options for the server!
Thanks

[powerppc]

This is great. It has been progressing since day one. I'm glad you decided not to put the map within the software, otherwise it will be following Mologogo and be another bloatware. As long as your location can be viewed live from Pocket Internet Explorer, just like tracker1.reperion.com, that would be great. That way I can track my family, friends from PIE rather than tracking them within the software which slows down the software, i.e. Mologogo.

Sorry for bringing up other software, but I figured there has to be a comparison if you are going to better than the other. One more thing, could you make a Battery Level indicator to show up on the KML if possible? Just like accutracking.com software.

I'm sure you have a long way to go Luis, but I'm glad the community is a big help. Especially jcleek with his ways with Google Maps. JCleek, I also found out that Yahoo Maps are PDA friendly, so maybe PIE can view your location live with Yahoo Maps? Not sure, but at least Accutracking uses Yahoo Maps for PDA viewing.

Luis, I still think this software should be straight to the point. I noticed your software has become more and more customize-able for people who wants to use their own server. But some people might want a simple one where they start the program, it would automatically start sending and that's it. But the way I see it is that I'm glad the software is still small enough, yet it gets to the point.

I may be asking too much at this point, but it's good to have the simplicity of what Accutracking has, but also mobile friendly like Reperion.

Keep up the good work, the speed and alt is a good addition.

[adebilloez]

Hello,
I was able to install smothly Tram_me server (install.php with no error and deleted after config.inc is existing with correct info)

Bu TrackMe is unable to update anything

Connected by Wifif I get 'unable to connect database' on tha ppc application

Connected by GPRS : "Error uplading position. Un message d'erreur ne peux pas etre ..."

The last one seems to come from my web server (because in french) but probably refer to an Socket assembly failure for the .net framework...

Any idea?

Also what can we do to troubleshoot?

[adebilloez]

OK, I made some progress by updatting manually config.php. But now always get "You need to specify a username and password for the user".

I already specified a user password (but seems not dynamicly created?)

What do this message mean on the PPC ?

ps : seems better on Wifi GPRS always same error message.

[odie3]

See if this works for your web server.

1. Create a text file and in it put this in and save it:
register_globals = 1

2. Now re-name the file to php.ini

3. Upload it to the folder where you have the trackme web files.

4. Try again to see if you do not get that username/password error.

What this file does (if you web server/hosting site allows) is to change the php settings and will allow globals in that one folder.

[adebilloez]

Thanks for the help.

I have uploaded a php.ini with your "register" in it. But nothing change, still getting this user/password error...btw in the mean time I create manually the user in MySQL db but doesn't help...

Some additional info:

I'm using a provider that use Plesk on a Windows 2003 with PHP extension.

In the root, I only do redirection with html file. Under this root I have a sub site that contain Joomla (PHP portal) and another sub folder under the root : trackme.

I give full control to IIS functionnal user on the "trackme" folder.

Unfortunatly I'm not familiar with PHP...

[odie3]

ah, then that php.ini file will not help you. I believe the reason it is not working is because there is a var in register.php that upload.php needs and the var was not declared (just guessing). So, with my hosting server (apache/php/linux) that php.ini file allows vars to work between files that have not been declared (however using your web site in that way is not very safe). I may not have that explained correctly (someone set me straight please).

[warmkiwi99]

Sorry to interrupt this technical thread but since I installed the 14/11 version, i can't see new trips on google maps. I exported gps positions today from remote location (your server) to a remote file (also on your server I guess).

When I locate http://luisespinosa.com/trackme/routes/<username>.kml I just see trips from 13/11 i.e. not today's

OK in Google Earth

Ignore this. Tried again with a new trip and it worked fine

[adebilloez]

I understand a little bit more that "not registered" variable seems not global between php page. I'm guessing that global registered could be "prohibed" somewhere on my hosting solution...

I just checked more on this setting and discovered that Joomla require it to off and it's the case for me...According your memo I need to have it On (but not really secure if I understand)

SO I can resume my case like this:

Root (only html for redirecting)
\- Joomla web site (Global register off, i don't know where is defined)
\- Trackme (global register seems off and not possible to put ON by php.ini)

Wait and see future feedback ...Thanks!

[odie3]

Yes, I believe you are understanding correctly. However, other than the php.ini trick I know how to do on my Hosting Site, I am not sure how I can help you.

Perhaps staryon or jcleek can help (and perhaps change the php code so it never needs register_globals = 1 again).

[MPIIIMan]

Wow. Still going back and forth with this register_globals crap.
Figured that would of been fixed last week when I brought it up!

[odie3]

Wow. Still going back and forth with this register_globals crap.
Figured that would of been fixed last week when I brought it up!

A most of them have, it's just the logging in part from the PDA that does not work (the web site itself no longer needs globals).

I also believe it is between request.php and the Action=upload (which i am thinking request.php calls out to upload.php). However that is a BIG guess on my part.

[staryon]

Wow. Still going back and forth with this register_globals crap.
Figured that would of been fixed last week when I brought it up!

Good. And what's your solution? jcleek's code is available to everybody. Feel free in modifying it to avoid that 'crap' so we can all take advantage of that.

[staryon]

This is great. It has been progressing since day one. I'm glad you decided not to put the map within the software, otherwise it will be following Mologogo and be another bloatware. As long as your location can be viewed live from Pocket Internet Explorer, just like tracker1.reperion.com, that would be great. That way I can track my family, friends from PIE rather than tracking them within the software which slows down the software, i.e. Mologogo.

Sorry for bringing up other software, but I figured there has to be a comparison if you are going to better than the other. One more thing, could you make a Battery Level indicator to show up on the KML if possible? Just like accutracking.com software.

I'm sure you have a long way to go Luis, but I'm glad the community is a big help. Especially jcleek with his ways with Google Maps. JCleek, I also found out that Yahoo Maps are PDA friendly, so maybe PIE can view your location live with Yahoo Maps? Not sure, but at least Accutracking uses Yahoo Maps for PDA viewing.

Luis, I still think this software should be straight to the point. I noticed your software has become more and more customize-able for people who wants to use their own server. But some people might want a simple one where they start the program, it would automatically start sending and that's it. But the way I see it is that I'm glad the software is still small enough, yet it gets to the point.

I may be asking too much at this point, but it's good to have the simplicity of what Accutracking has, but also mobile friendly like Reperion.

Keep up the good work, the speed and alt is a good addition.

Thanks a lot. I'm glad you liked it. Since you have a lot experience with other programs , are there any other features that you think that you should be there and they're not?

Regards

[staryon]

Sorry to interrupt this technical thread but since I installed the 14/11 version, i can't see new trips on google maps. I exported gps positions today from remote location (your server) to a remote file (also on your server I guess).

When I locate http://luisespinosa.com/trackme/routes/<username>.kml I just see trips from 13/11 i.e. not today's

OK in Google Earth

I've noticed that Google Maps sometimes have problems refreshing data. I don't know, maybe it's just me. The reason is because I make a modification in my kml file, open it with GE and everything is ok, however I open it later with GM and still shows my old data.
The thing is If I rename the KML file, and load it again with GM, it works fine... :confused:

[staryon]

ah, then that php.ini file will not help you. I believe the reason it is not working is because there is a var in register.php that upload.php needs and the var was not declared (just guessing). So, with my hosting server (apache/php/linux) that php.ini file allows vars to work between files that have not been declared (however using your web site in that way is not very safe). I may not have that explained correctly (someone set me straight please).

odie3, what variable do you think it is?

This is my latest upload.php file:

[odie3]

odie3, what variable do you think it is?

This is my latest upload.php file:
I am not really sure, while I dabble in php/MySQL code I am no coder at all. Currently my hosting is down to some issue at the data center so I can not really tweak stuff ATM.

[odie3]

BTW, I just download your upload.php (which is different than what I got with the site download zip)

I have a big concern with your new Get Vars:

Why use $_GET?

Note: When using the $_GET variable all variable names and values are displayed in the URL. So this method should not be used when sending passwords or other sensitive information! However, because the variables are displayed in the URL, it is possible to bookmark the page. This can be useful in some cases.
Note: The HTTP GET method is not suitable on large variable values; the value cannot exceed 100 characters.

[staryon]

Use the function urldecode on the variables


$action = $_GET["action"];
$username = urldecode($_GET["username"]);
$password = urldecode($_GET["password"]);
$lat = $_GET["lat"];
$long = $_GET["long"];
$dateadded = urldecode($_GET["dateadded"]);
$dateoccurred = urldecode($_GET["dateoccurred"]);
$datefrom = urldecode($_GET["datefrom"]);
$dateto = urldecode($_GET["dateto"]);
$tripname = urldecode($_GET["tripname"]);


I was following MPIIIMan's advice. Since he said he had a lot PHP experience (which I'm not) I thought that was the best solution.

I'll be glad in changing it if you think it's not safe.


By the way, that file has not been released yet. It's for the next version.

[MPIIIMan]

Sorry stayron, didn't think you updated your php files with the proper code.

About the GET method. I see this as the only solution due to how the application is passing the variables back to the server.

What about just having the application do the sql statements right from the application instead of calling a URL?

It would be more secure me thinks.

[adebilloez]

odie3, what variable do you think it is?

This is my latest upload.php file:

Unfortunatly, this upload.php doesn't help but I just noticed you spoke about register.php ? I don't have this file!

I just have : config export index request upload.

And get "You need to specify username and password" in the log of TrackMe when it try to update .

EDIT:
Little progress
I have now the same symptom with my GPRS connection no more assembly error during upload (just username/password issue)...

[staryon]

Sorry stayron, didn't think you updated your php files with the proper code.

About the GET method. I see this as the only solution due to how the application is passing the variables back to the server.

What about just having the application do the sql statements right from the application instead of calling a URL?

It would be more secure me thinks.

That's not possible. Most of web hostings doesn't allow direct access to the mysql database from third party applications.

[MPIIIMan]

That's not possible. Most of web hostings doesn't allow direct access to the mysql database from third party applications.


Doh, you are right. Stupid me.
I'm not familiar with VB or C++ (not sure what you used to write this)
So I'm not sure what other methods you could use that would be more secure from calling a URL with all the information.

[odie3]

Unfortunatly, this upload.php doesn't help but I just noticed you spoke about register.php ? I don't have this file!

I just have : config export index request upload.

And get "You need to specify username and password" in the log of TrackMe when it try to update .

EDIT:
Little progress
I have now the same symptom with my GPRS connection no more assembly error during upload (just username/password issue)...

Sorry, typo on my part, I meant request

[odie3]

Doh, you are right. Stupid me.
I'm not familiar with VB or C++ (not sure what you used to write this)
So I'm not sure what other methods you could use that would be more secure from calling a URL with all the information.

MD5_Hash (http://www.phpit.net/article/handling-passwords-safely-php/) it and then it's okay, I think...

[staryon]

ok guys, so what should I use?

$_REQUEST or $_GET?

[MPIIIMan]

$_REQUEST is the same as GET and POST

For example.

If you were passing something via post or get, you can call it using REQUEST.

Do MD5Hash like Odie suggested. That's probably the safest, but may be a little more work.

BTW. I'll be around all day, if you have any questions you can hit me up on AIM or Yahoo.

[adebilloez]

Doh, you are right. Stupid me.
I'm not familiar with VB or C++ (not sure what you used to write this)
So I'm not sure what other methods you could use that would be more secure from calling a URL with all the information.

+1, try to avoid passing too sensitive info in the url. But for other security stuff, we can secure this by using SSL on server.

[jcleek]

Not everyone has SSL, and those that do may not have a cert from the trusted list which would generate a ce