Acesso Skype sqlite MacOS

sqlite3 “/Users/{#os_user}/Library/Application Support/Skype/{#skype_user}/main.db” histórico de mensagens consulta sql 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 …

Continuar lendo