yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] jcleek:
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...
[Windows Mobile Apps and Games] pennywisdom:
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!
[Windows Mobile Apps and Games] xdaradar:
homemade server update package

TrackMe is a great feature and i did some customizing for my own (paranoia?) needs.

In an attempt not just to take from this forum, but give something back, i tried to make a little package with the changes. Never done this before, so i hope i've done in right.

All regards go to Staryon for his great software. Staryon: if you don't want this, please say so. I remove the package instantly.

xdaradar changelog: 2008_08_10

support for default apache htaccess security and mysql 4.x

- config.php moved outsite webroot for security reasons

- location of kmlfiles en pictures can be defined in config.php and stored on secure locations

- when deleting trip, the generated kmlfile of that trip is deleted as well

- support for mysql 4.x added, configure in config.php

- removed possible vulnerability in TrackMe as mentioned in http://xdaforums.com/showpost.php?p=2508714&postcount=2836

>> webviewer not update and not tested

>> i'm only using google-earth as viewer

Installation

- place php scripts over the original installed ones from Staryon

- place config.php on the location of your choice

- update variables in config.php to reflect the proper filelocations and mysql version

Browsing through your website

i'm using a simple php script to browse through the kmlfiles and pictures and let google-earth do the presentation for me

installation

- unzip thumbnail.zip

- copy the index.php and .icons directory to each directory you want to browse in your website

usage

- go to your website like: mywebsite.com/TrackMe/index.php

download

http://xdaradar.mine.nu/TrackMe/TrackMe_server_update.rar

screenshots

http://xdaradar.mine.nu/TrackMe/screenshot1.jpg

http://xdaradar.mine.nu/TrackMe/screenshot2.jpg

http://xdaradar.mine.nu/TrackMe/screenshot3.jpg
[Windows Mobile Apps and Games] _LEM_:
I'm ok with that. It's just as I told you in my forum there are some features that I cannot add because of they wouldn't work ok for multiuser environments.

You can keep posting your new features/bug fixes and I will be adding some of them to the official releases depending on if I can consider it appropriate or not.

Thanks a lot for your contributions!
[Windows Mobile Apps and Games] _LEM_:
New version available!!

-Geofence.

1. You can decide if you want to include your current location in the body of the message.

2. Added option in configuration to Reset notifications when tracking is started.

- Manage Trips.

1. There was a bug when downloading a summary that contains comments with an space.

2. New column 'Start date'

3. Ability to sort by column

4. The total distance could be wrong in some cases. This has been fixed (thanks xdaradar)

- Database access has been improved and everything should be more faster including the Web viewer.

- Fixed problem when showing location on the map. It could return a wrong position in some cases (thanks xdaradar)

For people using their own server:

Files changed:

requests.php and gm.php

I have also added some indexes in the database that really improves the speed. Check the updated script database.sql for the indexes that I have added (sorry but I don't have time at this moment to post the SQL code to create the indexes)

Enjoy! :D
[Windows Mobile Apps and Games] Expecho:
Offline support / source code

Hi,

I've read that it is not possible to generate KML files to the pda's file system, only at the server. Why is that ni longer supported. In my case I want to use this great tool to track my trips during my travels. I live in Holland but outside the country using GPRS/3G is VERY expensive. I like to have a tool that can generate KML files locally and then, in an i-net cafe I like to upload that file to my webserver with a custom application that supports KML files. I cannot always attach my PDA at such place because it sometimes is not recognized. I offline mode would be fully supported I would be able to put the genereated files on a memory card, plug that into the PC at the i-net cafe and upload the data then.

My worry is that this tool is only fully useable in an always online situation, or am I totally wrong now?

Also, if the source code would be available it would be easy to crate this support myself. I know you've stated that maybe commercial company's will use your code but be aware that in the current version you can easily decompile your app as well, so it is not for that purpose that is not wise to publice your code or is it? Anyway, maybe you can integrate support for addin's so people can extend your app?

Will there ever be a .net version of the webapp? would be very interesting.. or do you have info so I can write a .net version myself?

Last of all: great job, it is a very nice tool! Just not totally suitable (i think) for offline mode.
[Windows Mobile Apps and Games] _LEM_:
That has been answered several times. Before getting rid of local mode I posted a poll asking what should I do. You can still use TrackMe when you don't have an internet connection. Check the documentation.

Regards
[Windows Mobile Apps and Games] Expecho:
Eurhm, correct me if I am wrong, but it's only good as long as you are disconnected for a while but in the end you do need an connection

at your device

to upload the files. The offline support in the current release keeps your data for future upload

via your device

. Maybe I am completely wrong here but that's what I conclude after reading the documentation. Could the previous functionallity not exists side by side with the current setup.

I am afraid i stumbled upon this litte wonder app before you placed the poll, sorry for that :)

It's just that I am looking for an app like this for a long long time and this is the most promesing of all, but unfortunately I travel always outside my country so GPRS is very costly, but i still want to show where I am regulary. That's why I thougt about putting the kml files on a memory card for internet cafe's
[Windows Mobile Apps and Games] _LEM_:
Yes, you are correct. However, if you plan to go to a internet cafe to upload your KML files, why don't you just connect your PDA and upload your offline data? The only problem that I see is if they don't let you to install activesync there. In that case you could use your GPRS only for uploading your data, generate a remote kml and disconnect after that. Maybe it would be even cheaper than going to a internet cafe...

I don't know! it's just an idea! :rolleyes:

Regards
[Windows Mobile Apps and Games] xdaradar:
homemade package updated to match Staryons 8/4/8 release:

homemade details:

http://xdaforums.com/showpost.php?p=2487098&postcount=2781

based on Staryons 8/4/8 version:

http://xdaforums.com/showpost.php?p=2487377&postcount=2783
[Windows Mobile Apps and Games] _LEM_:
hey xdaradar,

These 2 issues were resolved so you don't need to include them in your release:

- bugfix in gm.php for sometimes wrong location send to google maps

- workaround for comment handling bug in trackme client

Thanks for your cooperation
[Windows Mobile Apps and Games] xdaradar:
I took them out indeed, but forgot to update the previous posted info.
[Windows Mobile Apps and Games] scfal:
Hello, I am part of an international beer drinking and running group that will soon have two Scotish style kilts made in our very own registered septs. These kilts will be sent out to circumnavigate the globe. We are hoping that some sort of rugged, very simple GPS devise can be sent with each kilt so that they can be tracked in real time. Is there a device out there that would act just as a GPS tracker It does not need to be a phone, or take pictures, or anything. All we want is for it to track where the kilt has gone, globally, with some sort of accuracy. It needs to be rugged/water proof. Small and inexpensive are also desired. Any suggestions?
[Windows Mobile Apps and Games] turtle2472:
This part concerns me because I don't know what you're telling me to do. I'm clueless with SQL management and make a great lemming for this kind of thing. I can change the php files but I don't know what to do about the indexes. Any chance I can get a more descriptive plan of action?
[Windows Mobile Apps and Games] justpctech:
I thought the server updates used to be in the first post of the thread but I dont see them there now? I would like to update mine if possible. I have an issue possibly related to that- when trying to manage trips, its not downloading all the trips stored on server.

Thanks again for a killer GPS tool!

EDIT: duh, checked the How To Use Your Own Server link to get latest server updates. will see if this fixes my issue now.
[Windows Mobile Apps and Games] :
server updates

i have an issue too after upgrading the server files. it seems that the 'manage trips' option can't access the sql database as it should (-just deleting the trips didn't work either). -- on the other hand: in myphpadmin there was an option 'optimize database' ... and i used it. so there might be a slight chance that the issue is related to this. i will set up my sql database again and see if the problem remains.

i've compared the database.sql with my tables in the database and i can't find any difference ... especially no new indexes?! ... what would that look like?

and last but not least: i'm still looking forward to the new web interface from mcross... now that he is back to the forums... i hope he is still working on this extJs thing... i'm thinking about looking at this programming myself... but i'm afraid that it would take A LOT of time to do that...

and as always... thanks staryon for keeping up your great work... my family is so happy everytime they can follow me virtually on my trips :-)
[Windows Mobile Apps and Games] lrossouw:
some ideas...

Hi

I quite enjoy this prog, and like what it is doing. Had some ideas which may be interesting:

1) There is another thread about a program which may be usefull. See http://xdaforums.com/showthread.php?t=393189&highlight=cellid It is about tracking/logging cell tower ids and using this as a proxy for location to save battery power. Thus a) it would be usefull to capture GPS coords and CellIDs to build up data with regard to CellIDs and b) to capture just CellIDs. Capturing CellIDs take less power because the GPS doesn't need to be running. Implementing just a) is also an option. My view is that TrackMe already has the relevant "infrastructure", and should relatively easily get a) done.

2) I use the software for relatively infrequent updates as I don't want to mess with my battery life. But I often use navigation software when driving and connected to car charger. In these scenarios a) my position is changing rapdily and b) my GPS is already on. Is it possible to set the software such that if noone else is using the GPS update location every 30 (or other longish number) minutes (and switching off the GPS in between as it can do already) and if the GPS is on in anycase update more frequently.

Thoughts?

Cheers

Louis
[Windows Mobile Apps and Games] _LEM_:
hey guys,

For people using their own server:

I had to make some changes on the indexes again. Sorry about that.

I updated the file database.sql with the latest changes.

If you ignore the server changes that I posted on Sunday, these are the only changes in the database:

CREATE INDEX Index_FK_Trips_ID ON positions( FK_Trips_ID )
CREATE INDEX Index_FK_Users_ID ON positions( FK_Users_ID )

turtle2472, indexes are used to improve the speed when accessing data in the database. Just run the previous 2 commands on your mysql database and you're done.
[Windows Mobile Apps and Games] _LEM_:
Are you getting any particular error when downloading the trips?
[Windows Mobile Apps and Games] _LEM_:
Check my previous post. Those are the indexes that have been added.

Are you still having that issue when managing trips?

Remember that you need to update client as well!
[Windows Mobile Apps and Games] _LEM_:
I like that. If it's not too complicated to implement I will add something like that to TrackMe. Thanks for the suggestion

EDIT:

I have been reading the thread and I haven't found a way of translating the cell tower locations to a geographical location such as a latitude and longitude.

Is there a way of doing that?

Sorry but that's not possible to do with TrackMe.

Regards
[Windows Mobile Apps and Games] justpctech:
Fixed with the latest...erm...almost latest server updates! :D wasnt giving any errors, but just showed 1 of 8 stored trips I had on my server. Got it now though, and thanks again for the great app.

Edit: so I can just run both these commands on the database now then and it will be updated? Not too strong on sql here...

CREATE INDEX Index_FK_Trips_ID ON positions( FK_Trips_ID )

CREATE INDEX Index_FK_Users_ID ON positions( FK_Users_ID )
[Windows Mobile Apps and Games] _LEM_:
Yes, that's correct.
[Windows Mobile Apps and Games] _LEM_:
hey guys... I just had an idea about the cellid thing.

What about if TrackMe could work in 2 modes. It could get the location from your GPS or from your CELLID.

If you choose from your GPS, we will have an option that if it is enabled, it will upload an entry in a table with your current cellid and lat/long from your GPS. This table will be public.

Now, if you choose CELLID mode, the GPS won't be used for reading your current position. Instead it will take your CELLID and check that public table (that has been generated by all TrackMe users) and it will retrieve the latest lat/long for your current CELLID.

Once this info is retrieved, TrackMe will work in the same way than if you use your GPS, it will upload your lat/long to the Positions table.

What do you guys think? I really like that idea :)
[Windows Mobile Apps and Games] xdaradar:
there's lots of stuff around to do this. Google for "gpstracker". Most commonly used is devices with a sim-card inside and some serversoftware to interact with the device. At the serverside a sms is sent tot the device which responds with the gps coordinates. Once you have those, you can do with it what ever you like. Basicly used for tracking down stolen cars and so.

Device that send out there locations without being asked for, like tracking it's wherabouts started of for following animals for study's and so. For what i have seen they were pretty large and expensive.
[Windows Mobile Apps and Games] xdaradar:
This reminds me of a old development project back in 2004. We called it "the poor man's GPS".

The basis idea was to give people with cell-phones, not being pda's users with gps devices and internet access, the functionality quite like TrackMe. Determine the location via cellid's and send it via SMS to a server.

Since there was no public cellid database, we had to fill our own cellid database by gathering the data from all users.

The next one is creating traffic flow information and sharing possible traffic-jam's. Build up a database with positions and avarage speed at that location. Share this in a common database. This gives in due time a sort of general picture of the speed at that location. When being there at a much lower speed could be an indications for traficjams. This would fire-off a signal on a trafficjam information website or so.

Googlemaps for the pda and smartphone already implemented the use of cellid for positioning. Look at http://www.google.com/gmm/index.html

Using it in TrackMe would certainly be a nice addon when you have no gps or the batterypower to use. It's use would be incidental. Once you get used to tracking with GPS and exact tracks in google-earth, the cellid location is not precise enough. like: "i'm somewhere inside this 1500 meter area". This would give very bumpy tracks.

But if not used for showing tracks of the actual travel, but for sharing your whereabouts. being in Amsterdam or London or so, it should be sufficient.
[Windows Mobile Apps and Games] _LEM_:
I agree with what you say. It would be a nice addon but it will not give you precise data. However, I thought about the following... EDITED... my solution sucks ;) It would give you the closest location of the cell tower, but we really need is your real position.
[Windows Mobile Apps and Games] lrossouw:
Acurracy: The thread about CellID software carried on about tracking multiple cellids and the signal strength and triangulating to get a better fix. A simpler approach may be to average actual GPS readings for a given CellID.

CellID database: I think there is some free to use cellid tower data already hosted by google. See the other thread.

Uses: CellID without coordinates will also be useful. If this is stored in a separate "table". I.e. not strictly linked to a coord. For example if I am using the the cellid near work I could get a server to set my facebook status, twitter or whatever to say "Louis is at work" or "at home" or whatever automatically.

I am thinking a seperate CellID table with timestamps and linking to the GPS track table where GPS was active. If GPS was not active you could add a coordinate estimate to the table (marking it as estimate)
[Windows Mobile Apps and Games] _LEM_:
Last night I was working on all this. I almost have something ready to be released.

We'll start doing as I mentioned in my previous post and hopefully this new feature will be evolving and showing more accurate information.

I know there is a Google API to access lat/long information by a cell id but haven't found anything yet. If somebody finds something please let me know.
[Windows Mobile Apps and Games] lrossouw:
For API stuff look at this post.

Not sure it is enough.

The OpenCellID project though looks better and more open (sic)...
[Windows Mobile Apps and Games] _LEM_:
Thanks lrossouw! I was looking at the first link right now when I saw your post :)

I'll check the second link as well.

Regards
[Windows Mobile Apps and Games] _LEM_:
lrossouw,

I cannot get it to work, if I use this file

http://www.witracks.com.br/gmaps.txt

rename it to .php and put it on my server, after calling it with the right parameters I get this error:

Warning: file_get_contents() expects at most 2 parameters, 3 given in /home/content/l/u/i/luisespinosa/html/test.php on line 81

Not found!

However if I call

http://www.witracks.com.br/gmaps.php?myl={mcc}:{mnc}:{lac}:{cellid}

exactly with the same parameters, it works fine.

Any ideas? Could anybody try it on their servers?
[Windows Mobile Apps and Games] lrossouw:
Sorry I just saw that and understood that it could be useful. How it works is beyond my knowledge.:rolleyes:
[Windows Mobile Apps and Games] AciDCooL:
I just tried and and I have to say this is an awsome program.

The interface is a bit sad, but hey it works!

Great job dude hope u will keep it updated
[Windows Mobile Apps and Games] _LEM_:
Thanks.

How would you make the interface happier?
[Windows Mobile Apps and Games] _LEM_:
Not a problem. Thanks a lot for your help.
[Windows Mobile Apps and Games] AciDCooL:
hahaha what I ment was actually the interface on the webpage... Those button look so dull like a hello world program but like I said im a dude who goes more for functonality then looks.

Btw does ur program not wait for a decend gps signal?

This happend to me just sitting @ my desk not moving my phone. And Im pretty close to the window normally about 5 to 6 satt's.

Is quite fun to watch tho :)

http://luisespinosa.com/trackme/index.php?showmapdata=1

username: acidpublic

password: public
[Windows Mobile Apps and Games] _LEM_:
I see :)

yeah.... mcross is already working on a new version of the interface that will look much nicer.

Regarding your other question, there is an option in the Configuration where you can specify how many satellites are required to consider a position as valid.
[Windows Mobile Apps and Games] AciDCooL:
lol ur quick responder, Just found the second u posted it I feel pretty stupid overseeing that. Good to hear that a new interface is in the making. Does it include some new editing options. Would be great if I uploaded the wrong picture in the wrong place and switch them over :p

edit: how many satts are rly required to make a good fix was it 3 or 4 ?
[Windows Mobile Apps and Games] _LEM_:
I don't think it includes an option for editing. There was a link with some sample images of the new interface but I don't know where they are at this moment.

I have set 4 satellites on mine and it works fine for me.
[Windows Mobile Apps and Games] AciDCooL:
Thx dude, I would recommend setting it to 4 on default..
[Windows Mobile Apps and Games] lrossouw:
Some more code on this Google API.

And more
[Windows Mobile Apps and Games] _LEM_:
Thanks. Yes, I already saw those pages (I read most of the cellid thread)

I got it to work from my program, but I still haven't found a way of getting the data using a web page. There has to be something in that http://www.witracks.com.br/gmaps.txt page that is wrong, because it works fine on

http://www.witracks.com.br/gmaps.php?myl={mcc}:{mnc}:{lac}:{cellid}

You can test it by doing this:

http://www.witracks.com.br/gmaps.php?myl=311:410:7993:28357
[Windows Mobile Apps and Games] xdaradar:
It's maybe an issue with our php version or configuration. even the simple one go wrong:

$content=file_get_contents("http://www.google.com",FALSE,NULL);

echo $content;

will give the same error, but:

$content=file_get_contents("http://www.google.com",FALSE);

echo $content;

works.
[Windows Mobile Apps and Games] seninho:
Hi,

I want to save kml-File local, but when I use Tools>Export GPS postion with settings kml and local, track me establishes an internet connection. I don't want it to do so, because I#m planning a trip to another country and don't want my polaris to connect to GPRS or something in a foreign net.

Is there any possibility to avoid internet connection an upload the files later?:confused:
[Windows Mobile Apps and Games] Phree:
Hey,

If you implement the cell id, do you plan to (over time) build up a database of cell id's? I use a piece of s/w that does just this - but it also locates WiFi AP's and stores those as well - and I believe this can be used to aid location too? Anyway, the site I use is here. I use the free software that just records the cell id's & AP's...It's amazing just how many people are still running unsecure AP's - free internet anyone?!

Found an interesting post about the possibility of using WiFi - have a read here and search the page for Network Base Station Database

If you are planning to build a database of cell id's, would it be helpful for users to send you files? What I mean by this is...My iPaq doesn't have any phone capabilities (so it wouldn't read cell id's) but my Symbian phone does. So I could run something like this and then upload the logfile to aid the growth of the database...
[Windows Mobile Apps and Games] _LEM_:
Yes, please check the documentation.
[Windows Mobile Apps and Games] _LEM_:
yeah, but by doing that we cannot pass the $xcontext variable:

$str=file_get_contents("http://www.google.com/glm/mmap",FALSE,$xcontext);
[Windows Mobile Apps and Games] _LEM_:
It's a good idea. I'll keep it in mind.

Thanks
[Windows Mobile Apps and Games] _LEM_:
I found a solution. It works on my server which is running apparently 4.x

If I rename the file extension from .php to .php5 it works :confused: