Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
19 lines (17 sloc) 487 Bytes
/* The database needed for this query is called AwemeIM.db.
This query was tested in DB Browser for SQLite verion 3.10.1.
For details see blog post here: https://abrignoni.blogspot.com/2018/11/finding-tiktok-messages-in-ios.html
By: Alexis Brignoni
Twitter: @AlexisBrignoni
*/
select
uid,
customID,
nickname,
case
when latestchattimestamp > 1 then datetime(latestchattimestamp, 'unixepoch', 'localtime')
else latestchattimestamp
end
latestchattimestamp,
url1
from awemecontacts