yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Development and Hacking General] xZise:
Do you still have information about that trip? For example most browsers have a “console” (e.g. on Firefox if you press F12 and select the console tab) which might be helpful to determine what is wrong. Maybe the trip uses some special names or similar which broke it. For example I had one issue (which isn't fixed yet) where the altitude was an empty string (in the code it generated, I don't have access to the database to check if it is actually an empty string or null) and that tripped JavaScript.

Same as before: Does the console show anything? And does it apply to any other trip? If you look in your database, you can see the ids of the trip and using ?trip=X (where X is the ID) should show a trip without using the dropdown list. Maybe that changes anything (although I fear this is not the case).

I'm in the process of converting the viewer from mysql commands (which have been deprecated quite some time and removed in PHP 7) to PDO (which is not MySqli). Unfortunately it doesn't really output any helpful error messages if it couldn't connect to the database. But there are two options which could help: In my case some errors are in the Apache's error log. Try to take a look there to see what is not working. The other option is to open database.php and in there is connect_save. Change the code in the catch block so that it looks like this:

function connect_save($connection=false)
{
try {
return connect($connection);
} catch (PDOException $e) {
print($e->getMessage());
return null;
}
}

I know debugging is hard, especially if you aren't the developer on that. But I unfortunately don't have a MySQL server installed (which is also why I'm using PDO) and so I can't easily test the install script.
[Windows Mobile Development and Hacking General] OpitZle:
TrackMeViewer Update to Version 3.1

As of now, via GitHub and on Luis' TrackMe Server, users can download for own use or access via Browser the

TrackMeViewer v 3.1​

The new features in this version include:

1. Support for a wide range of publicly available tile (=map) providers (in addition to the already available Google Maps)

(some require an API or Access Key - many are totally free - including satellite views)

2. Support for Web Servers running with php v 7.x

3. Support for storing you private setting via Cookies

4. Support for Web Server ports other than 80

5. Get rid of php warnings in Web Server logs

The database layout has not changed from V2.0 and therefore V3.1 is backward compatible with your current MySQL database/tables.

(Btw. Version 3.0 was never released)

Please have fun and report problems in https://xdaforums.com/showthread.php?t=477394
[Windows Mobile Development and Hacking General] _LEM_:
Thanks so much for your cooperation with the TrackMe viewer, OpitZle!

If you guys are using your own server, I recommend you to update to this new version. It's really great.

The official version running on my server is now using this update, too.
[Windows Mobile Development and Hacking General] _LEM_:
NEWS

Google has changed some policies and it's preventing the app to be updated. I've been trying to find out during the last few days what is causing the rejection.

That's something they always do and the last thing they try is to help the developers to find those issues! :( I'll keep you guys updated.

I also recently updated my code from Eclipse to Android Studio (yay!!) Lot of work but now it's using the most popular IDE and latest libraries. That will make development so much faster

and fluid. As soon as my update gets approved I plan to keep adding new features.

On the other hand, user OpitZle has been working on the web viewer. He has been doing an awesome job

by adding a lot more of info to be displayed and new features. He will be updating the repository on github soon with the new update.

I will also be updating the official server on my web.

Here is the screenshot of the new version of the web viewer (check the cool graph at the bottom!!)

[IMG="New web viewer"]https://i.imgur.com/dbhCZeM.png[/IMG]
[Windows Mobile Development and Hacking General] OpitZle:
TrackMeViewer v3.5 is on GitHub (/espinosaluis/TrackMeViewer) now

The v3.5 is a major rework of the TrackMeViewer with many features and function enhancements:

For users:

o Let the user allow to select the colour for the trip line

o Use specified Date and Time formats from config.php in all displays

o Switched to a less complex date and time picker for start and end date/time way point filtering

o Let the user allow to suppress the position markers, if the trip recording provides to many or too dense positions

o Remember last trip seen by the user

o Let the user allow to group trips by choosing proper naming (<groupname>:<tripname>) and display groups of trips together ("[Any]")

o Let the user allow to delete one single Marker Point (position) of a trip from the database

o Show detailed trip data to the side of the map (resizeable). Things such as: max speed, max altitude, min altitude, descent ascent percentage, moving time, full trip time, etc

o Let the user allow to scroll through each point of a trip (backward/forward) from the details pop-up

o Show the latitude and longitude of the Marker Points in the details pop-up in different notations (e.g. 48.86648N, 9°01'30.4"E, 9°5.01304'W)

o Store user options settings in cookies and ask for allow or deny

o Issue a warning once a day, when a user modifies a trip, that it will be overwritten with a resynch from the TrackMe App

o Add a warning when user selects "[Any]" trips

o Changed "Display Options Show/Hide" check box to toggle option settings and make them to work immediately

For Web App owner:

o Let the Web App owner to allow to run Apache2 Web Server on any port (not only 80) or path.

o Let the Web App owner to specify the Web Page title in the config.php

For maintainer:

o Removed no longer necessary "None" trip selection

o Got rid of extra " ... = urldecode($_GET ...". Superglobal $_GET is already decoded

o Consequently and everywhere use PDO for all database access with bound parameters to prohibit data injection

o Got rid of "UNDEFINED INDEX <xyz>" notices issued by php and saved in Apache log file

o Restructured and reformatted code for better readability and maintenance

Note: The translations into French, Italian, Dutch and Slovak were developed via Google Translator. If someone has better translations or wants to provide any edditional language, please feel free to announce here.
[Windows Mobile Development and Hacking General] Go3Team:
It's just as easy adding to requests.php:

$lat = $_GET["lat"];
$lat = round($lat, 5);
$long = $_GET["long"];
$long = round($long, 5);

Works fine, and as far as I can tell, doesn't take much more time to process it. Although doing it client side would help, if someone's data plan is limited.
[Windows Mobile Development and Hacking General] _LEM_:
Yes, but for some actions additional data may be appended to that string.

Like:

Result:0|ICONNAME1

I know it's not best design but... :)
[Windows Mobile Development and Hacking General] _LEM_:
Yes, I prefer to do it on the client side so I can minimize the traffic a little bit.
[Windows Mobile Development and Hacking General] timoline:
Hi,

you sure you want to do this?

Doesn't this harm the precision?

And another thing,

Isn't this cool....as feature

http://googlegeodevelopers.blogspot.com/2008/10/geocoding-in-reverse.html

Kr,
[Windows Mobile Development and Hacking General] Diggen:
I am also against this. The better way I think is to shorten Result0: to R0 or complete without the letter. This is save 5 or 6 Bytes per answer without harms against 1 or 2 for shorten / inaccurate Tracks.
[Windows Mobile Development and Hacking General] Go3Team:
The difference is negligible, only a few feet. GPS drift varies that much anyway.

I use Google's reverse geocoding on my server, click the link and look at the bottom. As long as the position is close to a street, it should show up. A lot of my back end stuff computes distances as well.

http://fleettracking.fleettrack.net/maps
[Windows Mobile Development and Hacking General] timoline:
Can you give me an example how you do this?

/timoline
[Windows Mobile Development and Hacking General] _LEM_:
ok guys, I will leave it as it is.
[Windows Mobile Development and Hacking General] Go3Team:
You will need the Google Maps API for this.

http://maps.google.com/maps/geo?q=$lat,$long&output=xml&sensor=true&key=$api

$lat and $long are self explained.

xml is the type of data you want returned.

sensor is if you are using the query along with a GPS unit or not.

key is your API key.

The XML that google sends back is not always the same format. I assume they do this to make things a little harder for us.

Break down the XML into the data you need.

I added another table to the database to store the address data. It's indexed with the positions table for referencing purposes. The data can also be pulled on the fly when the page is called up, for limited database space.
[Windows Mobile Development and Hacking General] timoline:
wow thx,

can someone help me to put this url in a var?(php)

$adres="http://maps.google.com/maps/geo?q=".$Latitude.",".$Longitude."&output=csv&sensor=true&key=".$googleapikey;

thx again for your help
[Windows Mobile Development and Hacking General] Go3Team:
For XML:

$url="http://maps.google.com/maps/geo?q=$lat,$long&output=xml&sensor=true&key=$api";
// Grab URL
$output = file_get_contents($url);
// Parse XML
$xml = simplexml_load_string($output);
$address = $xml->Response->Placemark->AddressDetails->Country->AdministrativeArea->Thoroughfare->ThoroughfareName;
$address1 = $xml->Response->Placemark->AddressDetails->Country->AdministrativeArea->Locality->Thoroughfare->ThoroughfareName;
$city = $xml->Response->Placemark[2]->AddressDetails->Country->AdministrativeArea->AddressLine;
$city1 = $xml->Response->Placemark[0]->AddressDetails->Country->AdministrativeArea->Locality->LocalityName;
$state = $xml->Response->Placemark->AddressDetails->Country->AdministrativeArea->AdministrativeAreaName;
$zip = $xml->Response->Placemark->AddressDetails->Country->AdministrativeArea->PostalCode->PostalCodeNumber;
$zip1 = $xml->Response->Placemark->AddressDetails->Country->AdministrativeArea->Locality->PostalCode->PostalCodeNumber;
$country = $xml->Response->Placemark[1]->AddressDetails->Country->CountryName;
$county = $xml->Response->Placemark[4]->AddressDetails->Country->AdministrativeArea->AddressLine;
$county1 = $xml->Response->Placemark[3]->AddressDetails->Country->AdministrativeArea->AddressLine;

if (empty($address)) {
$address = $address1;
}
$address = str_replace("'","''",$address);
if (empty($city)) {
$city = $city1;
}
$city = str_replace("'","''",$city);
if (empty($zip)) {
$zip = $zip1;
}

if (empty($county)) {
$county = $county1;
}
$county = str_replace("'","''",$county);
[Windows Mobile Development and Hacking General] timoline:
Thx again,

First I have to update my PHP to 5.x, then I'll try this.

Kr,
[Windows Mobile Development and Hacking General] WatskeBart:
Silly me

I cleaned up my attachments from the User CP :o it's there again.
[Windows Mobile Development and Hacking General] pzucchel:
Hi!

do i understand correctly that the trackme webserver 2.00 is still not available for download?

Could i suggest to mention explicitly the version numbers in the first page of the thread? it is very difficult to understand if the software has been updated.

...and thanks indeed, compliments again for the great job!

trackme is, in my opinion, one of the top ten applications for windows mobile - it does deserve a lot of attention and contributions (unfortunately, this is not the domain where i can help...) :(
[Windows Mobile Development and Hacking General] heyk:
server install problems

why do i get these messages;

Notice: Undefined index: language in D:\www\m\o\b\mobile-pc.nl\public_html\my\trackme\index.php on line 14

Notice: Undefined variable: storelanguage in D:\www\m\o\b\mobile-pc.nl\public_html\my\trackme\index.php on line 18

etc.

i'm a beginner in this, i can't get my webserver running correctly, the map is completly mixed up. pls can someone help me in this. thanx.
[Windows Mobile Development and Hacking General] _LEM_:
Thanks for your comments!

Yes, I'm afraid that release won't be available.

I tried contacting the author by using an email that somebody gave me but it ended up being somebody else email.

I think the author posted in TrackMe's thread a long time ago but so far I haven't been able to find his posts. :(
[Windows Mobile Development and Hacking General] _LEM_:
Thanks. I just updated the official release.
[Windows Mobile Development and Hacking General] _LEM_:
Ok I will try to do that next time that I make a change.
[Windows Mobile Development and Hacking General] phattooth:
Hey all,

The other day I was thinking how I didn't like the fact that if you went two directions on the same road you would only see the top circular track direction icon on the map... so I decided I would change the Icons to something more transparent so you could see arrows for both (all) directions traveled.

Well, I'm by no means a graphics guru, but I would like to share what I made with you all, in case I'm not the only one out there that feels this way. I started out with an idea and it evolved (of course) so I've provided some of the iterations I liked from along the way.

Just replace the icons on your server with any of the ones in this zip (I've even provided the originals in case you want to go back).

Enjoy!
[Windows Mobile Development and Hacking General] _LEM_:
Thanks for sharing that!

They look very nice.
[Windows Mobile Development and Hacking General] phattooth:
Absolutely my pleasure!

I love this whole thing you've created... anyway at all I can give some back, I am happy too!

Thank you!
[Windows Mobile Development and Hacking General] timoline:
It's possible to disable :notice and warnings messages in php.ini

Maybe it helps

/kr
[Windows Mobile Development and Hacking General] khaytsus:
While I can't say those won't affect any PHP configuration, those are just notices and should not affect the script functionality. I think he's seeing the notices and assuming they're the issue, but they are not.
[Windows Mobile Development and Hacking General] heyk:
khaytsus,Thanx, you where right, I've added a line to my index.php to disable the notice and now eveything is ok, the map is diplayed ok now.

This is a great way to view my tracks. thanx.
[Windows Mobile Development and Hacking General] turtle2472:
Is it realistic to have the TrackMe server page be able to export a track to a gpx file? So when I'm viewing a track from a road trip that I would have a button to take the data on my screen (for the whole track really) and drop a valid gpx file on my desktop (or where ever my saved web files go)?

To carry out why I'm asking: Once I can get a valid gpx file I can then merge the GPS data with my photos from the trip and geotag all of them with another application. This way images take n with my DSLR and my wife's PS would be able to be tagged and not just the ones taken with the Tilt or her iPhone.
[Windows Mobile Development and Hacking General] _LEM_:
Yes, I think that would be nice (also to KML)

If you have some time and experience with PHP please go ahead. I think many people will be interested on this.
[Windows Mobile Development and Hacking General] turtle2472:
Sadly, I know nothing about coding and was putting it here as a feature request for those who can code.
[Windows Mobile Development and Hacking General] _LEM_:
User bwired shared this with us. It may be useful for people thinking in using ASP pages.

Below the classic ASP file which will work for trackme
ans store all the data in a MYSQL table
You need to create the table first.

<html>
<%
Dim my_conn, strSql, rs
Dim sAction, sUsername, sPassword, sSpeed, sLat, sLong, sTripname, sAltitude, sDb, sCid, sBs, sSs

sAction = Request.QueryString("a")
'response.write(sAction)

sUsername = Request.QueryString("u")
'response.write(sUsername)

sPassword = Request.QueryString("p")
'response.write(sPassword)

sLat = Request.QueryString("lat")
'response.write(sLat)

sLong = Request.QueryString("long")
'response.write(sLong)

sTripname = Request.QueryString("tn")
'response.write(sTripname)

sSpeed = Request.QueryString("sp")
'response.write(sSpeed)
If isnumeric(sSpeed) then 'convert to meters
sSpeed = (sSpeed * 3.6)
Else
sSpeed = 0
End if

sAltitude = Request.QueryString("alt")
'response.write(sAltitude)
If isnumeric(sAltitude) then
sAltitude = (sAltitude * 0.3048) 'convert to meters
Else
sAltitude = 0
End if

sCid = Request.QueryString("cid") ' cell id network

SBs = Request.QueryString("bs") ' battary stat cell

sSs = Request.QueryString("ss") 'signal strengt cell

sDb = Request.QueryString("db")
'response.write(sDb)

Set my_conn = createobject("ADODB.Connection")
my_conn.open = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=xxxxxz;UID=xxxx; PWD=xxxx;OPTION=35;"
Set rs = CreateObject("ADODB.Recordset")
strSql = "select * from GPS order by id desc limit 1"
rs.Open strSQL, my_conn, 1, 3
rs.addnew
rs("username") = sUsername
rs("password") = sPassword
rs("action") = sAction
rs("datum") = now
rs("lat") = sLat
rs("slong") = sLong
rs("tripname") = sTripname
rs("speed") = formatnumber(sSpeed,1)
rs("altitude") = formatnumber(sAltitude,1)
rs("db") = sDb
rs("GSM_Cell_ID") = sCid
rs("GSM_Signal_strenght") = sSs
rs("Phone_BattStat") = sBs
rs.update
rs.close
my_conn.close
response.write("Result:0")
'Response.Status = "204 no content"
'response.redirect "pk2.asp?lat=" & sLat & "&long=" & sLong
%>
</html>
[Windows Mobile Development and Hacking General] khaytsus:
If you are a *nix guy, I have been polishing a Perl script that geotags images based on TrackMe's database.

Caveats:

Uses MySQL directly, so needs to be able to connect. ie: Probably your own server, I seriously doubt Staryon would allow remote mysql access. I'm thinking about writing a PHP script to interface via the web. Takes care of multiuser problems and folks who don't have access to MySQL. It'd be slower for sure, but it'd be a second interface for the script and would presumably allow people to use my geotag script on Staryon's server or any remote server they don't have MySQL access on. (Of course, said PHP would have to be on the server)

And no idea if it'd work in Windows. I'd *assume* with ActiveState Perl it could but don't have such an environment to test it.
[Windows Mobile Development and Hacking General] turtle2472:
My server is running CentOS so that shouldn't be a problem and I do have access to my MySQL DB as well. I'm certainly interested in more details on this.

So it'll go through the *whole* TrackMe DB and not just individual tracks? This could make getting my back images updated much easier.

I am still interested in being able to export via the web interface as I had originally posted too for future use. Your option sounds awesome for getting the backlog caught up. :)
[Windows Mobile Development and Hacking General] khaytsus:
I'll PM you with a link that you can try out. I've used it on a bit of my images and it works well, but probably needs more validation before I put it out there for all to use, ya know.

What it does is use the Exif::Tool module to get the DateCreated tag from the image, then uses some funky SQL magic to do an upper and lower sort of dates from the positions table, then the closest one wins. There's also a constraint I call 'fuzzy' which restrains how old the positional data can be before it's considered valid. If it gets a result, it then records the data in the file, again using Exif::Tool, including smartly telling it N/E/S/W based on the data (-84 is 84 Westerly, etc), sets the datum, and appends a comment to the image with the trip name. There are options for each of these, fuzzy, time offset (in case camera doesn't match GPS), to make a comment or not, and a "CSV" output which only outputs lat,lon,imagename and doesn't write anything. Good for csv->kml, and good for testing. :)

BTW, here my client is Fedora Core 6, server CentOS.
[Windows Mobile Development and Hacking General] bwired:
Hi Luis,

With this http url you can directly do a reverse geocoding.

http://maps.google.com/maps/geo?output=xml&oe=utf-8&ll=51.8773267,5.11604566666667&key=$key

This means you can get directly the Address of the Lat & long coordinates!

This works perfectly.

I now do this with a seperate program after the record is stored by trackme in my database, but it would be great to have it in the trackme software.

Or possibly in the php or asp servercode. The last option is not working because trackme can not handle any more code after the result:0 code

It looks like it still has a connection with trackme because any code after the result:0 will throw an error on my cellphone.

Rrgards
[Windows Mobile Development and Hacking General] _LEM_:
Thanks for that.

However, how would you use that information? Would you store it in the database?

In my opinion it would be nice to have an option in the viewer that would query the google maps when you click on a pushpin to retrieve the address name. So it will only be queried when needed and not stored in the database.
[Windows Mobile Development and Hacking General] bwired:
Thats also an option, will try that

but for retrieval/viewing of a complete trip its better to have it stored.
[Windows Mobile Development and Hacking General] webpatrick:
Showing Altitude

Who wouldn't like to see functionality like this?

Like in: http://xdaforums.com/showpost.php?p=1995576&postcount=2132

See also: http://bimrace.com/ba/race/race_map.php?race=5 (unfortunately out of action)
[Windows Mobile Development and Hacking General] _LEM_:
I would like to see that. A user (sorry but I cannot remember his name) made something similar but I couldn't add it to the official release because I had some problems installing the fonts that the plugin needed.

Anybody is interested in writing a plugin like this (or modifying the one that user wrote) for TrackMe?
[Windows Mobile Development and Hacking General] timoline:
First I tried it with jpgraph, but that gives the font problem.

but I think I found a better api/program for it....

check this out....

http://teethgrinder.co.uk/open-flash-chart-2/

I have some code ready, but far from finished and still not the way I would like to see it.

y-axis = speed, altitude, batteystatus

x-axis = distance

Maybe you can add somekind of request list at one of the first posts?

/timoline
[Windows Mobile Development and Hacking General] deuzeff:
Hi there,

I'd like to know if there is any simple way to moderate trips and photos uploaded to the server?

For example, one uploads a pic, but this person would like to remove it for a reason. Except deleting this very point using the function of TrackMe on the mobile phone, is it possible to do it via the web client? So far I don't think so, but it could be a handy function (for example a delete button, asking for a password (the one from the user)).

Greets.
[Windows Mobile Development and Hacking General] _LEM_:
Yes, I think that would be a nice thing to add for the web viewer.
[Windows Mobile Development and Hacking General] khaytsus:
Staryon,

I've used requests.php to build a geotag request to accept remote Web lookups for the Geotagging script I've been writing. Works well, and basically just copied and refactored what was already in requests.php. Said another way, I don't know PHP well, but I can copy and paste to make what I want. :)

My section drops right into requests.php, but I've also during testing made a separate geotag.php so I have either option. Which would you feel more comfortable accepting into the TrackMe server code?

This is assuming you're comfortable with the whole idea that users can utilize your TrackMe server/database to look up their datapoints for geotagging images. The API is simple, so people could always write their own tagging script and use the same server code. For example, Windows users might want to write something in .Net which has a GUI. Me, I'll stick to Perl.

Let me know, I'll PM you the URL to check it out.