Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
1 contributor

Users who have contributed to this file

32 lines (29 sloc) 840 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=Locationd Wi-Fi Location
[Database Metadata]
DATABASE=cache_encryptedB.db,cache_encryptedA.db,lockCache_encryptedA.db
PLATFORMS=IOS
VERSIONS=8,9,10,11,12
[Query Metadata]
QUERY_NAME=locationd_cacheencryptedAB_wifilocation
ACTIVITY=Location
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 8,9,10,11,12]
QUERY=
SELECT
LATITUDE || ", " || LONGITUDE AS "COORDINATES",
MAC as "Base10 MAC",
CHANNEL AS "CHANNEL",
INFOMASK AS "INFOMASK",
SPEED AS "SPEED",
COURSE AS "COURSE",
CONFIDENCE AS "CONFIDENCE",
SCORE AS "SCORE",
REACH AS "REACH",
HORIZONTALACCURACY AS "HORIZONTAL ACCURACY",
VERTICALACCURACY AS "VERTICAL ACCURACY",
LATITUDE AS "LATITUDE",
LONGITUDE AS "LONGITUDE",
DATETIME(TIMESTAMP + 978307200,'UNIXEPOCH') AS "TIMESTAMP"
FROM WifiLocation
You can’t perform that action at this time.