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
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;
31 comments:
I always love your posts!
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;
This is actually quite terrifying. Why would this exist? Why is my phone tracking my movements? Who could use this against me?
What should I be using on Android, Cell or WiFi?
Pretty much usefull. But does it work also as a GPS giving routes and such?
Seems useful. Perhaps I'll download =D
nice!
What? My Android is keeping tabs on me, too?!!!
android!
thanks i needed that
thank god i dont have that :O tracking where i was :x scary
Good information, very good information.
Handy :D
Sweet updates. Cheers bro.
Sweet love it following again again and again
I like how quickly you're updating the app.
Big brother is watching!
This will be pretty cool to play with.
cool, thanks =)
great post.
you always have great info!
nice post....this is why is stick to crap "HO Phone"
Not sure what I'd use this for myself, but it sure looks cool.
new interface and updates looking good for this
Very Helpful!
If I ever get an iPhone this will come in handy.
thanks for sharing
Is it possible to steal someone's database and check where was he/she moving? It would be like a spying device then.
Cool! :) still enjoying chocolate milk ;)?
Following people is easier :P
Post a Comment