tix5dg
Last Updated: February 25, 2016
·
1.399K
· igorf

Skype sqlite access MacOS

sqlite3 "/Users/{#os_user}/Library/Application Support/Skype/{#skype_user}/main.db"

message history sql query

select conversations.id as "chat_id", 
   conversations.displayname as "chater", 
   messages.from_dispname as "authoe",  
   strftime('%d.%m.%Y %H:%M:%S',messages.timestamp, 'unixepoch', 'localtime') as "created_at", 
   messages.body_xml as "message_body" 
from conversations
   inner join messages on conversations.id = messages.convo_id
order by messages.timestamp