yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Development and Hacking General] _LEM_:
To be honest, I have no idea how licenses work, especially on an application like this.

I would have to ask the company who was supporting the products. Is there something in particular that I should ask them?
[Windows Mobile Development and Hacking General] khaytsus:
That's a difficult one, indeed. Do they own the server code as well? If so, I assume they understand that the server code is openly available, but at this time is unlicensed. I would suggest that you would go with a GPL v3 type license but I'm not sure if there are better licenses for commercially-owned yet open software.

Your concern is larger than my original one... My original one was that I have no idea of the (intended?) license from the original author. As I understand it, most of the server code was written by other user(s).

I'm not sure if you can just stamp a license on it as-is. However, since it is open code, I guess a "branch" of it with a new license would be okay as long as the old code was made available under the "old license" (none). I honestly don't know.

I'll poke around and see if I can find anyone who does this sort of thing. Ideally I'd like to see the main (unlicensed) portions GPL v3 and a LICENSE file attributing the other files as well, such as the CELLID stuff that looks like it might have come (mostly) unaltered from other sources etc.

I've set up a git repo myself so that I can more easily track changes (read: unscrew my screwups) but it'd be nice to get it on something like github. Lem, let me know if this is not okay or you'd like any additional information added to the repo, readme, etc type things. Unless we need to (to add a license) I'm not intending on forking etc your server, I just want to put it up so it can have some possible collaboration.

http://theblackmoor.net/git/?p=trackmev3/.git;a=summary

If anyone wants to play with it, try to fix things, my all means feel free. It's ugly right now, you've been warned. I've commented out a ton of code that's currently broken (needing conversion) to get the basics to work.

If you try it out, make it a separate entry on your webserver but you can point it at your main database. The viewer is read-only so it should be perfectly safe and you can see (compare) real data.

You can check it out if you like using git: git clone http://theblackmoor.net/repos/trackmev3/.git

If anyone tries it out and has fixes to make, http://git-scm.com/book/en/Distributed-Git-Contributing-to-a-Project#Public-Large-Project has good info on how to email patches. I don't have the server public at this time (I'll look into that) but you can always download the whole snapshot at any time by clicking on the "snapshot" link to the right of the latest commit.
[Windows Mobile Development and Hacking General] khaytsus:
Lem,

I looked around a bit, I found this, and someone actually pointed it out to me as well.

http://www.codinghorror.com/blog/2007/04/pick-a-license-any-license.html

And I'm being told that a BSD license might be more appropriate for commercial open-code software.
[Windows Mobile Development and Hacking General] khaytsus:
Lem,

I somehow missed this message from earlier, absolutely don't mind working with someone, as I'm just plundering around until something magically works right now ;)
[Windows Mobile Development and Hacking General] _LEM_:
That's a very interesting link. I will bookmark it. I really feel like the author from that article. I don't like at all to have to deal with licensing when I develop something!

And yes, the server is completely different from the client and the company that acquired the software shouldn't have any rights to it.

Thanks for adding a git repo for TrackMe. It's perfectly ok and I really appreciate that.
[Windows Mobile Development and Hacking General] _LEM_:
That's great. Thanks. Could you PM me with your email? that way I can have you guys in touch together.
[Windows Mobile Development and Hacking General] turtle2472:
So glad this thread came up again! I happened to gain ownership of an Android phone that I can finally run TrackMe on. Some day the release of the iPhone version might happen, but in the mean time I'm back to using my server again. :) Looking forward to seeing the updates on this to keep it going.
[Windows Mobile Development and Hacking General] _LEM_:
So glad to see you back! :good::good:
[Windows Mobile Development and Hacking General] uszu:
new web viewer

Uff, I made it through 10 posts, so I may post here :p

I wrote a web viewer for TrackMe data. It is a complete rewrite of the original viewer. The only thing that is left of old viewer is interface look and feel.

It uses Google Maps API v3 but I plan to implement also an OpenLayers/OpenStreetMap alternative.

My viewer is based on ajax, so everything works dynamically without page reloading.

I use TrackMe on Android, so I implemented only the functions present in this version. There is no support for photos or comments. I will surely add those features when they become present on Android. Anyway functions missing from previous viewer should be easy to add, if anybody wants it.

On the other hand I added altitudes graph. I thought about adding other graphs (like speed) and statistics but gps data I get with the Android app often miss info like speed, angle etc. (why?)

The code is GPL, so everybody can contribute or reuse it. If you make changes to it please contribute your patches back.

The code is available at github:

https://github.com/bfabiszewski/phpTrackme

You can see a simple demo at:

http://flaa.fabiszewski.net/phptrackme/

(auto registration of new users from client is blocked on this site)

---------- Post added at 09:06 AM ---------- Previous post was at 08:46 AM ----------

I think it was mentioned in this thread before but I noticed there are still serious security issues in requests.php script from this package.

Several times in the code strings submitted by users are used in mysql queries without, at least, escaping special characters.

Like here:

$username = urldecode($_GET["u"]);
...
$result = mysql_query("Select ID FROM users WHERE username = '$username' and password='$password'");

Inserting single quotation mark into submitted string one may change the query and bypass authentication or even get all password hashes from mysql table, or overwrite all rows with some UPDATE query.

This should at least be corrected to:

$username = mysql_real_escape_string($_GET["u"]);

Also note that superglobal $_GET is already decoded. Using urldecode() on it could have unexpected results.
[Windows Mobile Development and Hacking General] Dtrieb:
Sounds great, what need I to install it on my webserver?

PHP, MYSQL ???
[Windows Mobile Development and Hacking General] uszu:
Yes, PHP and MySQL is a must.

I believe minimum PHP version is 5.1.2, as I used XMLWriter.

If you have older PHP version you will have to install PECL xmlwriter. Beginning from 5.1.2 it was included into PHP core.

PHP should also be compiled with libxml, but anyway, this is a default option. Should work out of a box unless someone built php explicitly disabling libxml.

I don't know minimum version of MySQL, than is required here. There is nothing fancy about sql queries used here. I think mysqli extension requires MySQL 4.1 or newer.

Unfortunately I didn't prepare any installer. If you have MySQL database already set up for TrackMe, everything should work after setting database parameters in config.php. If you don't have database and tables, use included trackme.sql script to prepare your database.
[Windows Mobile Development and Hacking General] _LEM_:
uszu,

Thanks SO MUCH for doing this new version of the viewer. I really appreciate your contribution.

I will also modify right away the security issue that you mentioned.

There has not been too much development for a while on TrackMe but I haven't abandoned the project. It's just I have been more interested

on other things but I would really like to come back as soon as possible. There is still so much to do and I think this app still offers a lot of potential.

So don't get discouraged about improving the viewer because sooner or later, I will continue adding new features.

Thanks again for that awesome work!
[Windows Mobile Development and Hacking General] Chameleon846:
Hi. Fantastic timing! Pipeten are now including 3 free MySQL databases with their Windows multihost package in addition to the 3 x MSSQL databases, so I'm able to setup my own server again. I had just installed the legacy server & all is working well with my Android client, but I've just seen this post & I'm really interested in installing your new version.

Am I able to run both versions in parallel, or will the addition of the database salt key mean that the old version won't be able to read any new users? If that's the case, would leaving the salt blank be a workaround for now?

It's brilliant to see futher development with this excellent program (It was definitely my favourite WM6 program!). The addition of being able to upload photos / comments in the Android version would definitely be good.

Also, if someone was able to produce an asp version of the viewer it would be the icing on the cake!!! (More than happy mixing asp / php at the moment though!).

EDIT: Aaah.. my initial excitement has been dampened. As I've got a Windows package the PHP available is limited. The old mysql module runs fine (hence the old server is OK), but I cannot use mysqli or PDO, so I'm getting the error: PHP Fatal error: Cannot instantiate non-existent class: mysqli in H:\hshome\######\######.co.uk\trackme2\auth.php on line 22

Guess I'll have to wait for an asp version afterall...
[Windows Mobile Development and Hacking General] uszu:
Thanks for TrackMe! :)

It would be nice to have picture and comments support in Android version.

By the way, using GPS only on Android (Samsung ACE II), speed and angle is not sent with each position. Only once every several uploads. Do you know what is the reason for this? Also speed is often sent as zero, while it is probably unknown and should be null.

Another nice improvement would be communicating with server with POST requests, instead of GET, so that password is not sent in url. Using https we could safely transfer data.

Anyway, nice job!

---------- Post added at 11:52 AM ---------- Previous post was at 11:41 AM ----------

That's a pity. Although this extension is available since PHP 5.0, in fact, as I read in PHP manual, on Windows the mysqli extension is not enabled by default. It is enabled by default since PHP 5.3. On the other hand it is rather popular extension, so usually hosting providers enable it.

You have bad luck, sorry.

---------- Post added at 12:07 PM ---------- Previous post was at 11:52 AM ----------

I uploaded new version to github and demo server. It adds OpenLayers support. OpenLayers works now with OpenStreetMap, but we could load any other supported layer, like OpenCycleMap etc.

Have fun!
[Windows Mobile Development and Hacking General] Chameleon846:
Yes! My problem is that I'm on a Windows package, not their PHP one, so although I have access to PHP modules it doesn't include mysqli...

That aside, it's great to see further development with both Trackme & the server side.
[Windows Mobile Development and Hacking General] Dtrieb:
I have set all on my websever and it works very well.

Here some ideas:

Set a default place on the first run on the map

Set a default user

Set the title of the Site from "fabiszewski.net • geolocation" to user wishes
[Windows Mobile Development and Hacking General] _LEM_:
Yes, uploading pictures and comments was on top of my list when I stopped working on the Android version. It will be the first thing to do when I get back!

Regarding the missing angle information... I would have to look it up, but maybe it's just because the driver is not providing that information for some reason depending on the gps status. It could be speed, movement, accuracy...
[Windows Mobile Development and Hacking General] uszu:
That could be an option in config.php.

If you are logged in, you will have your last route displayed after log in.

When you log in, you will be default user.

This can be set in lang.php.

Thanks for German translation!
[Windows Mobile Development and Hacking General] uszu:
I don't know about Windows binary packages, but couldn't you download php_mysqli.dll extension for your php version, or install new version which includes it?

Windows binaries are available here.
[Windows Mobile Development and Hacking General] Chameleon846:
Hi. Thanks for the suggestion. Having contacted my host provider I don't think it would work, but it might be worth a try! I'm away from home for a couple of weeks, but I'll look into it when I'm back.

Cheers.
[Windows Mobile Development and Hacking General] pewe:
Thanks for the efforts in updating to maps API V3.

I have some queries however.

First:

When I access the page (with the authentication OFF) I can see the users in the database and the trips for each user BUT the map is central on Poland and when I select any trip nothing happens.

If I turn on Authentication the login works for a new user which was added by uploading a trip from my WinMo V6.5 phone with a new username/password. But even though the trips ae shown for the logged in user once again the map is blank and centered on Poland.

Second:

The password generation method is different from the previous version.

I cannot login with a 'previous' username/password combination, and if I go to the 'old' installation (which uses the same database) I cannot log in with the new user details.

NOTE I notice that 'salt' is used in password generation in the new version, but not in the old one - so what needs to be done to access the 'old' users/trips?

Can someone advise on possible solutions?

Thanks
[Windows Mobile Development and Hacking General] uszu:
That's strange. What is your browser? Do you have same problem when using my demo page?

Old version also uses salt. To use old passwords set salt to "trackmeuser".
[Windows Mobile Development and Hacking General] pewe:
It happens with both Firefox (V21) and IE (V10).

Your demo page works OK. I even tried re-uploading all the files and still it does nothing when I change the trip or user - always shows the default map.

The error log shows this when I try to load user maps

Thanks - don't know how I missed that.:D
[Windows Mobile Development and Hacking General] uszu:
Is it possible that your database layout differs from default setup used in default and my viewer? Could you export your database structure and post it here?

Try to run this query directly on your mysql database (from command line, phpMyAdmin or anything else) and see if it fails:

SELECT positions.ID,Latitude,Longitude,Altitude,Speed,Angle,
DateOccurred,username,trips.Name,trips.ID FROM positions
LEFT JOIN users ON (positions.FK_Users_ID=users.ID)
LEFT JOIN trips ON (positions.FK_Trips_ID=trips.ID)
WHERE positions.[COLOR="Red"]FK_Users_ID=1[/COLOR] AND positions.[COLOR="red"]FK_Trips_ID=1[/COLOR]
ORDER BY positions.DateOccurred

In this example I use user id "1" and trip id "1". If these values don't exist in your tables, replace with existing values.
[Windows Mobile Development and Hacking General] pewe:
Thanks Uszu.

I found a problem which came to light when I tried your query.

For some reason I had a field 'DateOccurred' in the 'Trips' table as well as in the 'Positions' table - and this appeared to confuse the script.

I am not sure why the presence of this field in the 'Trips' table did not break the original server script, but as soon as I removed it your script worked.

Not sure why the second field 'DateOccurred' was in the 'Trips' table - but I was experimenting earlier this year with a script to update the database from a gpx file rather than directly from the phone and I may have done something daft then.:o
[Windows Mobile Development and Hacking General] uszu:
Great!

It was a join query combining results from multiple tables. Server didn't know which instance of DateOccurred to take. In the original script there was no such query.
[Windows Mobile Development and Hacking General] uszu:
Recently I played with WP8 version of the TrackMe client.

As it allows to upload comments I added support for comments to my phpTrackme.
[Windows Mobile Development and Hacking General] Chameleon846:
Hi uszu,

It's been a while since I last had a go using your new php web viewer. I didn't manage to get the stand-alone binaries to work, but luckily Pipeten have just upgraded the PHP support on their Windows hosting packages & MySQLi is now included.

The web viewer (v2.2) is working perfectly on my own server & I'm really impressed!

The only changes I had to make was to manually change the code in auth.php & logout.php so that it didn't try to use https.With the original code it kept on trying to connect via https & gave a certificate error (I haven't got a dedicated IP).

Thanks so much for the work that you've put into this.

I just hope that it convinces LEM to continue development with the Android app - it would be great to be able to upload photos like with the old Win Mobile versions.
[Windows Mobile Development and Hacking General] uszu:
Thanks for reporting it. I corrected this issue related to Windows hosting.

I agree that it would be great!
[Windows Mobile Development and Hacking General] petzibaer:
Display last Trip

Hello,

thanks for this great work!

Is it possible to display the last trip without select in the pulldown boxes?

track.schwemberger.at

best regards Peter
[Windows Mobile Development and Hacking General] _LEM_:
Hi Peter,

There is not an option for that, but I think it should be easy to do if you have some experience modifying the PHP

source code.

Regards
[Windows Mobile Development and Hacking General] uszu:
I see you are using modified version of phpTrackme (by @mcampbellsmith) with multiple users' tracks.

Last trip is not selected by default in this case. I will try to merge the changes into my project and fix last track display.
[Windows Mobile Development and Hacking General] petzibaer:
Thank you

Thank you very much!

Best regards Peter:)
[Windows Mobile Development and Hacking General] uszu:
I put new version of phpTrackme on my github. It is marked as version 2.3

It is mainly a merge of mcampbellsmith's changes.

I am not sure it is what you meant, but I added a new feature – when there are multiple users' tracks available, the latest one is selected by default.

Hope it helps!
[Windows Mobile Development and Hacking General] _LEM_:
That's great. Thanks a lot for keeping it updated.
[Windows Mobile Development and Hacking General] petzibaer:
Great Work!!

:good:

Now all features are built in!

Thank you so much

best regards Peter
[Windows Mobile Development and Hacking General] uszu:
Thanks for resuming TrackMe development!

Automatic upload of offline positions is very important improvement.

:good:
[Windows Mobile Development and Hacking General] _LEM_:
I'm glad you like it. I plan to continue adding new things probably next week. :)
[Windows Mobile Development and Hacking General] khaytsus:
It's because they're global registers I suspect, and your PHP instance no longer allows that. See this post? http://xdaforums.com/showpost.php?p=3665891&postcount=113

Basically you can't reference a POST variable directly with Register Globals disabled. The example in the linked post is this:

$startday is a POST variable which has to be referenced as $_REQUEST['startday'] with Register Globals disabled. With Register Globals, just using $startday was valid but gives errors with Register Globals disabled. For these it's often just a replace all for the problematic variables. I've done some stuff to my local install to fix this, but I also have a lot of other changes and I was not keeping track in any kind of repo so I can't really say what I changed for other reasons.. I'm just a copy and paste PHP'er.

Hope this helps somehow ;)
[Windows Mobile Development and Hacking General] p-de-geus:
I made index.php PHP5.4 compliant.

See attached the compliant index.php file.
[Windows Mobile Development and Hacking General] _LEM_:
Thanks a lot for that!
[Windows Mobile Development and Hacking General] pewe:
I tried this tonight and have a problem.

When I visit my site, a map flashes up with a route on it, then the screen goes blank.

Is this php version related (my host runs 5.5) - or something else?

Thanks
[Windows Mobile Development and Hacking General] pewe:
I found the problem.

In the config file I had not removed the words "Replace with your Google API Key" - once I did that and just left "" in the file everything seemed to work.

Perhaps those words could be removed in the download package so the lesser aware :o don't have the problem.
[Windows Mobile Development and Hacking General] p-de-geus:
Anyone here using the Server having issues?

When i open the website the map isn't showing and firefox gives me the message that main.js(google maps api) is unresponsive.
[Windows Mobile Development and Hacking General] _LEM_:
I just tried on my site and seems to work ok.
[Windows Mobile Development and Hacking General] p-de-geus:
I noticed that i was running version 1.20 and there is a newer version, 1.21.

When trying version 1.21, after correcting the index.php, i don't see the map.

I'll check if i can find why this is..
[Windows Mobile Development and Hacking General] p-de-geus:
I found out that the issue occurred came because of a trip i added manually to the database.

After removing the trip data the map is showing with the last added trip.

Only now i have a different issue, i can't show another trip when selecting from the dropdown list.

I try to figure this issue out now!
[Windows Mobile Development and Hacking General] _LEM_:
The official web viewer has been updated to 2.0!

Thanks to xZise for his help on this.

For people using their own servers, you can always get the latest version from:

https://github.com/espinosaluis/TrackMeViewer
[Windows Mobile Development and Hacking General] Chameleon846:
Hi, I'm hoping someone can help!

I've been using Trackme for several years, and for the last couple with Android & my own server with the viewer based on USZU's custom web viewer (v2.2).

With the recent updates to the Android version I thought I'd upgrade my viewer to the official 2.0.

In order to ensure that my database had all the right table I deleted the old one & started again.

My problem is that the install.php fails to connect to the database.

I am running PHP 5.5.6 (although I've also tried 5.2.17, 5.3.17, & 5.4.22), which has MySql, MySqli & calendar enabled.

The MySql database is 5.5.45. The user is a dba & I am definitely using the 'long' php hash length for the password.

The folders / files on the server are writable.

The install.php file loads, but when submitting the info it fails to connect to the server. I have tried manually editing the config.php, but get the same result. I have also tried manually recreating the server using direct sql commands (which works fine), but still the same problem when I run the index.php file.

I have run a test php mysqli file to test the connection with the database & it works fine.

If I revert to the original 1.2 files the installation works fine & I can also use USZU's 2.2 viewer.

The depth of php coding in the Official v2.0 is a bit beyond me (!), any ideas why it isn't connecting with the database?
[Windows Mobile Development and Hacking General] _LEM_:
Chameleon846,

I wish I could help you with this issue. I didn't write the viewer, so I can't really tell you what things you could try. I was going to suggest that maybe you didn't upgraded your db correctly, but you said that you created it from scratch. Just one thing, when you say that it fails to connect to the database, does it give you an error in particular?
[Windows Mobile Development and Hacking General] Chameleon846:
Unfortunately it's just the code within the install.php page that returns "ERROR: Failed to connect to database."