Friday, April 22, 2011

MyPhoneTracker v0.9 - new interface and core rewrite

Version 0.9 of MyPhoneTracker features a new gui (cocoa style,resizeable,faster) and a nearly complete core rewrite.

You can load the database from a local iTunes Backup, the application will display all backups for your devices ordered by date.
Or load the file from an actual iPhone (jailbreak required).
The file is named "consolidated.db" and you find it inside "/private/var/root/Library/Caches/locationd/consolidated.db".

For Android devices the file is called "cache.cell" for cell determined locations and "cache.wifi" for WiFi determined locations.
You can find the file(s) inside the folder "/data/data/com.google.android.location/files".

MyPhoneTracker is a universal 32/64bit application for Mac OS X 10.6 or higher.


Version 0.9
  • new interface
  • selectable itunes backup device and date
  • crashs fixed
  • starts "clean" without a automated loaded location database
  • universal 32/64bit binary
Version 0.9.1
  • self update functionality



31 comments:

King Elysium said...

I always love your posts!

R. Hamilton said...

On a CDMA (Verizon) iPhone at least, there's another table, CdmaCellLocation, with a slightly different schema. On mine, CellLocation is empty, but CdmaCellLocation has 642 records.

Seems it would be desirable to be able to choose any or all of CdmaCellLocation, CellLocation, or WifiLocation to display.

The schema for CdmaCellLocation follows:


sqlite> .schema CdmaCellLocation
CREATE TABLE CdmaCellLocation (MCC INTEGER, SID INTEGER, NID INTEGER, BSID INTEGER, ZONEID INTEGER, BANDCLASS INTEGER, CHANNEL INTEGER, PNOFFSET INTEGER, Timestamp FLOAT, Latitude FLOAT, Longitude FLOAT, HorizontalAccuracy FLOAT, Altitude FLOAT, VerticalAccuracy FLOAT, Speed FLOAT, Course FLOAT, Confidence INTEGER, PRIMARY KEY (MCC, SID, NID, BSID, ZONEID, BANDCLASS, CHANNEL, PNOFFSET));
CREATE TRIGGER CdmaCellLocationDecrementRowCount AFTER DELETE ON CdmaCellLocation FOR EACH ROW BEGIN UPDATE CdmaCellLocationCounts SET Count=Count-1 WHERE rowid=1; END;
CREATE TRIGGER CdmaCellLocationDeleteBoundingBoxes AFTER DELETE ON CdmaCellLocation FOR EACH ROW BEGIN DELETE FROM CdmaCellLocationBoxes WHERE ROWID= OLD.ROWID; END;
CREATE TRIGGER CdmaCellLocationIncrementRowCount AFTER INSERT ON CdmaCellLocation FOR EACH ROW BEGIN UPDATE CdmaCellLocationCounts SET Count=Count+1 WHERE rowid=1; END;

CandleintheDark said...

This is actually quite terrifying. Why would this exist? Why is my phone tracking my movements? Who could use this against me?

Willy Wade said...

What should I be using on Android, Cell or WiFi?

Stare Dad said...

Pretty much usefull. But does it work also as a GPS giving routes and such?

Mike said...

Seems useful. Perhaps I'll download =D

Lemmiwinks said...

nice!

Marlene said...

What? My Android is keeping tabs on me, too?!!!

JapRoulette said...

android!

GADAFINY said...

thanks i needed that

Kim Anders said...

thank god i dont have that :O tracking where i was :x scary

The Angry Lurker said...

Good information, very good information.

Piets said...

Handy :D

phthalo said...

Sweet updates. Cheers bro.

Gaberabtic said...

Sweet love it following again again and again

Insider33 said...
This comment has been removed by the author.
Insider33 said...

I like how quickly you're updating the app.

ds said...

Big brother is watching!

Jay Reid said...

This will be pretty cool to play with.

goat-on-a-stik said...

cool, thanks =)

GeneralMakaveli said...

great post.

Venus said...

you always have great info!

Major.Mack said...

nice post....this is why is stick to crap "HO Phone"

John said...

Not sure what I'd use this for myself, but it sure looks cool.

ed said...

new interface and updates looking good for this

hoaks2 said...

Very Helpful!

Elliot MacLeod-Michael said...

If I ever get an iPhone this will come in handy.

Mo said...

thanks for sharing

Michael said...

Is it possible to steal someone's database and check where was he/she moving? It would be like a spying device then.

elexerdelex said...

Cool! :) still enjoying chocolate milk ;)?

Binder said...

Following people is easier :P