yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] daesimps:
I'm no PHP expert, but I have been advised against it as it is a similar security risk to having "register_globals" set to on. I found a few pages that talk about it's use. Here is a quote from one of them

"If you refer to a variable $username without initializing it beforehand, you may be wrongfully assuming that its initial value will be null. extract, like register_globals can falsify that assumption, allowing the variable $username to be initialised by end users. In short, it’s just like turning register_globals on again."

An example is Jcleek's index.php. He checked for a variable called "loggedin", which he sets in his code. If we used the code suggested above, then a user could pass a URL with a POST of loggedin=yes and the code above would automatically initialise this variable with the value "yes", thereby possibly bypassing the authentication code and proceeding as though a valid login had been performed. I have not verified jcleeks code to see if this would actually happen, but it is an example. I could, however, be completely wrong!

Based on that I prefer to declare the variables manually.
[Windows Mobile Apps and Games] odie3:
Good point... should stay as it is then. :)
[Windows Mobile Apps and Games] jcleek:
ch ch ch changes!

Ok guys, I did a lot of work today to improve the mashup but I have a real question for you: What purpose does it server to show the KML file on my google maps page? The last archive is EXACTLY the same as the KML file. It offers no added information at all. Why even have it? It is code that has to be maintained which takes time and effort. So the question is should I just remove the KML code from my page?

Now for the changes. I have added polylines between points AND I have color coded the markers on the archive maps. For an example:

1) CLICK HERE and click the SHOW ARCHIVE button. The start of the track is the green icon. The end of the track is the red one.

2) Click the SHOW LAST LOCATION button. See the red icon? That is the last known location.

Again, the only two things we really need are the archive and the last location. The KML needs to go away. I just need some consensus before I remove the code and produce a new version.
[Windows Mobile Apps and Games] _LEM_:
pretty cool! I think I am going to add the green and red icons in google earth as well.

I'm also thinking in replacing the pushpins with arrows, so you can see the direction on the map. Not sure how to do this yet.
[Windows Mobile Apps and Games] daesimps:
Sounds good to me. I only really use the last location and archive. I suppose there is the argument that you can use the PDA app to export based on date range instead of trip, thereby creating a kml which is a composite of multiple trips. Not something that I'd use, but I bet there'll be at least one person who uses it in this manner :)
[Windows Mobile Apps and Games] jcleek:
Also I can use any of these icons. Any ones in there more appropriate?
[Windows Mobile Apps and Games] jcleek:
I didn't mean to get rid of the KML, just the SHOW KML FILE on my index page. It serves no purpose there except to duplicate data in a way that I can't control (icons, colors, polylines, etc).
[Windows Mobile Apps and Games] _LEM_:
hey jcleek,

a request here.... in the drop down for the trips, do you think you can add '<None>' and '<Any>'?

Regarding <None>....

With TrackMe it's possible not to assign positions to a specific trip, so the FK_TRIPS_ID field in the Position table is NULL.

<Any> will show everything in the database for that user.

I love your plugin man!
[Windows Mobile Apps and Games] _LEM_:
I agree. I never use that option anyway ;)
[Windows Mobile Apps and Games] _LEM_:
Those look great! Actually I was looking for something like that now that I'm thinking in adding 'Force update'

For example, if you stop for lunch, you can force an update and choose the icon that you want to be shown later on the map.
[Windows Mobile Apps and Games] jcleek:
I can accomodate that in my code as well.
[Windows Mobile Apps and Games] jcleek:
Done, but the ANY is simply too slow to be usable. You can look at my page and see what I mean. I only have about 8 trips on there... And I don't have any NULL examples so that map is blank for me.
[Windows Mobile Apps and Games] _LEM_:
Thanks!!

When I use the Export function in TrackMe and I select <None> or <Any> I usually combine it with a Date Range, otherwise as you said, you will have too much data.

Another option would be that you add the Date Range... but I don't want to give you more work to do!! What you have done so far it's great.
[Windows Mobile Apps and Games] daesimps:
What I meant is that you can use the PDA to search on a date range (therefore spanning multiple trips) and use it to create a kml file. How would you then display that kml?

Like I said, I don't use the kml, but there may be people who would want to use it in the manner I describe.

Anyway - good work. Can't believe how far this project has come.:)
[Windows Mobile Apps and Games] adebilloez:
Now that I got these 2 superb apps working... thanks to the (2) authors!

Here's the usage that I plan for using :

* Share my today :follow-me ... -> last xxx positions

* Share my recurrent trip (I go work ..I go Tennis ...) -> simple Trip details

* I'm going in holiday, follow me ->I decide the start and destination to reach , friend can follow me and when destination is reached they get a mail.

* I'm near you, call me -> if my position is near to a marker the owner of the marker is notified so we can meet...

* And last but not least ...find friend near me! (already implemented)

Social networking are in the tube ... I'm sharing idea based on YOUR work sorry for that...

*
[Windows Mobile Apps and Games] justdavesj:
I'm trying to set up my own server for trackme. I have most of it working but when the application tries to upload the .kml file it gives an error. It looks like the requests.php file does not take the action kml into account. Is there a fix for this?

thanks
[Windows Mobile Apps and Games] jcleek:
My page only displays the username.kml file the PDA creates anyway and there is little point in re-writing code to do what the PDA can already do. The system isn't designed to allow you to store multiple KML files and to do so would be dumb anyway... that is what the MySQL database is for.
[Windows Mobile Apps and Games] jcleek:
As Staryon has discovered, there is no way to make this thing be everything to everyone. It long ago met my needs but I continue to develop based on needs that I believe are beneficial to everyone and worth the effort to produce. That's the beauty of open-source: you can make it do whatever you need it to. My google maps mashup is meant to display data that is on the server as a series of trips or a single (latest) point.

* Share my today :follow-me ... -> last xxx positions

Want to have someone follow you? Set up a public server, or give them your user name and password and the trip archive always shows the current (or most recent) track first.

* Share my recurrent trip (I go work ..I go Tennis ...) -> simple Trip details

Want to show your trip to work? Start a new trip called "Work" and drive to work. Trips are saved in the database and available from the trips list.

* I'm going in holiday, follow me ->I decide the start and destination to reach , friend can follow me and when destination is reached they get a mail.

Same as first point

* I'm near you, call me -> if my position is near to a marker the owner of the marker is notified so we can meet...

That is a great feature for you to figure out how to implement ;-)

As I said, we can't possible make it every single thing to every person without devekoping a monster; something we have repeatedly all agreed we DID NOT want.
[Windows Mobile Apps and Games] _LEM_:
never heard about that error.

Please provide more details... like the error type.

You say that you are uploading a kml file. In that case, the file has been generated on your pda, for that reason action='kml' is not called in the requests.php file, that's only if you are generating the kml file on your server.
[Windows Mobile Apps and Games] justdavesj:
You can see the error I get in the attachment.

The http for this request from the pda is as follows:

192.168.3.2 - - [19/Nov/2007:16:00:52 -0800] "GET trackme/export.php?action=kml&username=xxxxxxxx&password=xxxxxxxx&datefrom=2007-11-19%2010:0:38&dateto=2007-11-19%2017:0:38 HTTP/1.1" 200 30

The action=kml is what I'm referring to.

thanks
[Windows Mobile Apps and Games] justdavesj:
I got it working now. I've had to add an include ('config.inc'); to all the beginning of all the php files. It seems that my version of php will not automatically include that. Also, I'm running mysql on linux and the database setup says it finishes without errors, but it does not set up the tables. I had to use the commands out of the database file and manually enter them into mysql.

Thanks for the great software.
[Windows Mobile Apps and Games] _LEM_:
Good. I'm glad it worked. However, keep in mind (based on the screenshot that you posted) that you were not uploading a kml file. The kml was being generated on the server.
[Windows Mobile Apps and Games] jcleek:
Ok, final draft of the updated version. Comments?

1) I removed the KML display (redundant and not configurable)

2) Made the intermediate icons on a trip smaller and gray to make the start and end stand out

If you guys like this one I will update the private server implementation piece and send it to Staryon.
[Windows Mobile Apps and Games] _LEM_:
just one thing...

if you select <Any>, Trip name is not shown when you click on a pushpin.
[Windows Mobile Apps and Games] justdavesj:
Now I'm having a problem with the google map. I've attached a screenshot.
[Windows Mobile Apps and Games] jcleek:
Fixed. Anything else?
[Windows Mobile Apps and Games] jcleek:
That is not google maps. Did you install this on youe own server? It looks like the map size is set to 600 x 20.
[Windows Mobile Apps and Games] _LEM_:
Good. It works now.

The only thing is always show the trip <Any>

Probably you hardcoded a variable for testing...
[Windows Mobile Apps and Games] justdavesj:
Yes, it's installed on my own server. I checked the height and width in the config file and they look fine (600x400).

The application is also having trouble connecting with the gps sometimes. I have an att 8525 with external bluetooth gps (holux m1000). Everything works fine the first time I start the application but if I stop it and try to start it again it just hangs at "waiting for GPS response." The only way I can get it working again is to soft-boot the pda. I have google maps and live search and they both work fine with the gps.

thanks
[Windows Mobile Apps and Games] jcleek:
Then something else is wrong, but I an not sure what. Even if your database is empty the map should show a blank world map. Give me a few minutes to finish up my changes and get it to Staryon then try installing the php files again.
[Windows Mobile Apps and Games] odie3:
That is pretty sweet, I like that a lot!
[Windows Mobile Apps and Games] androgyn:
what is about artemis?

Dear all. I am using this amazing program very well with my kaiser.

I tried to use it at my artemis too.

But unfortunately I got a pop up that PInvoke-DLL sqlceme30.dll ist not installed. After net frame 2.0 from Billy I thought it is done. But, no way. Same failure then w/o net frame.

What is to do? It can't be only for my kaiser, isn't it?

Best regards

Guido
[Windows Mobile Apps and Games] Eitel:
Check the config file. Mine was doing the same thing and I found out that is was calling pixels twice, as in "600pxpx"
[Windows Mobile Apps and Games] _LEM_:
Hi Guido,

The program should be compatible with any device running Windows Mobile and an internal/bluetooth GPS. Unfortunately I cannot test it with other devices, because I only have the kaiser. However, I know some other people who are using it with other PDAs and Smartphones.

Anyway, try to copy the following file to the folder where you have the program installed, just in case it resolves the problem. It seems that you are missing the library to access SQL Server Mobile databases.

http://luisespinosa.com/temp/System.Data.SqlServerCe.dll
[Windows Mobile Apps and Games] Eitel:
staryon, I have a request. Right now the program stores and uploads every X amount of time (both are the same). Could you set the times diferent? As in store location every X time and upload every X time. Example, mark points every 30 seconds but upload every 2 minutes.
[Windows Mobile Apps and Games] justdavesj:
That was the problem.

thanks
[Windows Mobile Apps and Games] AndyInFl:
Here is a suggestion:

I think (I'm not a programmer) that some useful information could be easily added to the info captions that are generated by doing some calculations of the date already stored in the trips.

1. It maybe be helpful to include a point number of each position. The polylines would seem to overlap when traveling in a small radius. If someone recorded positions that required back tracking or over/underpass driving in trafic, the lines might be difficult to decern.

2. Presently, the start and end point are being determined. So by taking the start and end times, you would know the total trip time / distance / number of positions / average speed.

As long as the data is present in the trip, I believe it would be useful to display.

Here's my suggestion of a possible info caption.

Again, thanks to all!
[Windows Mobile Apps and Games] _LEM_:
I'm sorry Eitel, but I prefer to keep the program simple. I think that can confuse some people because they may think that something was uploaded when it was not because it was in the buffer. On the other hand, I think one timer is enough.

thanks for your suggestion though
[Windows Mobile Apps and Games] jcleek:
Staryon has the updated index.php and will update the zip after we can work out a small bug. Changes include:

1) I literally cut the code down to less than half of the previous version. The code was trimmed down to remove the KML section and consolidated the map drawing for both the pub and priv setups to share the same code.

2) All points are now connected in the drawn map by polylines.

3) Points are color coded for the start (green), end or current (red), and intermediate (gray) points.

4) Trip options added for NONE and ANY. Note: the ANY page can take a long time to display if you have a lot of points in your table!

Things still to do:

1) Change the private login to use session cookies vs passing the username and password on every submit. This will allow the current position page to refresh like it does on the public implementation.

2) Explore options proposed by AndyInFl - great ideas

3) Clean up code to use style sheet instead of depreciated code

Staryon, check your email...
[Windows Mobile Apps and Games] URPREY:
Hi - I have a problem hopefully someone can help me with. I used the program today to track a short trip, and everything showed on the screen to be uploading. however, when I pull up the trip in Google Earth, all of the points are blank with no lat/lon or speed or anything. I also cannot log into the trackme website with the user ID and password I initially chose. Is there an issue with my login account or something else? This is on my Tilt. Thanks!

[edit]I figured out the issue. It was a password problem. Thanks[edit]
[Windows Mobile Apps and Games] _LEM_:
Done. New version is ready to download.
[Windows Mobile Apps and Games] Eitel:
That's ok. I was just thinking that moving less data may be better for people that don't have unlimited data. Not my case thou, and the transfers are still small.
[Windows Mobile Apps and Games] _LEM_:
Hi Urprey,

I checked the database and you're right. The points are there, but they are all empty but the last 3. I have never seen something like that!

Please try again and let me know if it keeps happening. Maybe your GPS was not initialized correctly or something...
[Windows Mobile Apps and Games] androgyn:
Thank you. I got it to the point the software freeze on my unit. Will say if I use the standard GPs setting like Com4 no HW port and automatic managed by MS the SW will freeze. If I unckeck automatic, no port found. If HW port 2, nothing will happen.

I know myself that we are in the Kaiser and not in a Artemis thread, so I just want to thanks to all for their patience.

best Regards

Guido from Cologne/Germany
[Windows Mobile Apps and Games] _LEM_:
Sorry guys.

Download the files again, I made a mistake in the index.php file.

http://luisespinosa.com/bin/TrackMe_Server.zip
[Windows Mobile Apps and Games] _LEM_:
I'm sorry you are having problems with the program.

Just in case, could you try with this other program that another user wrote?

http://xdaforums.com/showthread.php?p=1589423#post1589423

It's a program that checks the GPS connectivity.

Thanks
[Windows Mobile Apps and Games] _LEM_:
Eitel, correct me if I am wrong... even if I don't upload the data now, I would have to do it later, so the same bandwidth would be used...
[Windows Mobile Apps and Games] androgyn:
Thanks again for answer. Yes, with TomTom on original configuration it works fine. I will play around a little bit next day. I will let you know what is going on.

BR

Guido
[Windows Mobile Apps and Games] jcleek:
AndyInFl asked for these fields to be added to the baloon information for each point:

Total Time: The total time is relatively easy. The date/time format needs to be converted to *nix timestamp for calculations and then back after calculating.

Distance: Distance is also relatively easy but will not be accurate at all. I question the value of this information. Say you travel in a 100 mile circle at 100 miles per hour. In an hour you travel 100 miles, right? If you have the GPS set to get a new position every hour it will show you didn't travel at all.

Average Speed: Not possible using current tables. Data in the speed colum is stored as a DOUBLE field type and can not be averaged. I could count each speed entry and divide by total entries but that is like 8 or 9 lines of code to do a standard MySQL AVG function which is a single DB query.

Point number of total points: Again easy to do but why? You can have a 100 mile trip with 10 points or 10,000. What does that really tell you? What value does it add and is it worth the effort to put it in?

After giving a total of about 5 minutes of thought I think that the only items that would have any value is the average speed and total time. I will look into how to do the speed without the column being an INT field and the time calculations.
[Windows Mobile Apps and Games] _LEM_:
Guido,

The program is in the first post. It's called GPSInit
[Windows Mobile Apps and Games] _LEM_:
jcleek,

I tried with these values

Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	0
Edit	Delete	25.317
Edit	Delete	25.417
Edit	Delete	25.218
Edit	Delete	25.502
Edit	Delete	25.511
Edit	Delete	21.28
Edit	Delete	23.822
Edit	Delete	27.566
Edit	Delete	28.218
Edit	Delete	25.015
Edit	Delete	21.407
Edit	Delete	23.013
Edit	Delete	25.583
Edit	Delete	25.437
Edit	Delete	25.647
Edit	Delete	25.663
Edit	Delete	25.612
Edit	Delete	25.387
Edit	Delete	25.613

and this function:

select avg(speed) from positions where fk_users_id=1

and it returned 19.637026666667

That's what you need, right?
[Windows Mobile Apps and Games] grizzley:
Just FYI, I had alot of problems getting GPS to read during a recent plane trip. No program (Google Maps, TomTom, TrackMe, etc...) could find satelites.

I was on 8 different airplanes and only 1 of those planes could get GPS readings.
[Windows Mobile Apps and Games] odie3:
*Idea but may be stupid*

So, I was playing around Google Earth yesterday and was clicking Camera icons. You know it would be cool to upload pictures that you have taken and when you click on a marker you get a picture in the pop-up (if one was uploaded with that position). Might be a whole lot of work and perhaps not possiable with the API and meta data tags.

This kind falls into the Comment and custom markers...
[Windows Mobile Apps and Games] odie3:
Thanks to you and jcleek! Page is coming along very nicely!
[Windows Mobile Apps and Games] AndyInFl:
Just my thoughts:

I saw the conventional uses of the program and also can see a few unconventional ones that I and possibly others could use. As someone who spends time on the water and and on the trails, this program would allow me to create a database of trips not available to me with conventional street maps; places where there are no roads. Just thought a plotter type program built into the phone would mean one less device needed to have fun.

As a parental or employee watchdog type program, this information could be used to track location/performance of child, delivery, etc..

Total Time: Just a matter of record for a repeat trip.

Distance: Just like having an odometer on the car.

Average Speed: The rental car companies used to use this to issue company speeding tickets when the GPS first came out. Good monitor.

Point Number: Just a way of tracking where you where in which order.

Again, just thoughts.... I always try to look at the given item/situation and think how I can use something in a different matter than it was intened for and still gain a significant value. One man's junk is another man's treasure.

Why have elevation when so far it isn't even close to accurate. If I drive in the flat lands of Florida and the elevation in reality doesn't change regardless of the amount of time or distance, then what does that really tell me?

Thanks for everyone's efforts.
[Windows Mobile Apps and Games] wafwot:
Great idea for different color stop and start markers!

Is it possible to use a different color for current location map, say orange, or blue? Or yellow or purple?
[Windows Mobile Apps and Games] jcleek:
There are mashups out there already that will do exactly that.
[Windows Mobile Apps and Games] jcleek:
I would have to add in a whole new section of code just to accomodate a new color. As it is, it is the last (and only) icon on the page so it gets red just like a page with a hundred icons. Lot of work just for a color change.
[Windows Mobile Apps and Games] wafwot:
This is true. A 3D fix requires at least 4 satellites, and I usually have 7 or 8 locks, but elevation is all over the place. I've tested this out on roads I traveled multiple times a day for more than a decade. I know the road is a 6 degree incline, but my phone maps it with more rise and falls than a roller coaster!

How hard would it be to make logging speed and elevation an option?
[Windows Mobile Apps and Games] wafwot:
Heh... Smaller is better!
[Windows Mobile Apps and Games] _LEM_:
Thanks for your suggestions.

After reading your suggestions, I remembered about Geofencing which is something that I will probably include for the next version (a very basic implementation)

Description:

An imaginary boundary set which contains a GPS device - if that GPS device exceeds the boundary, an alarm is activated.

In our case, an email will be sent.
[Windows Mobile Apps and Games] sarab99:
Hi jcleek,

Can you please check the satellite view. It seems doesn't work.

thanks.