![]() " Search for a message with the text 'home' SELECT last_activity_timestamp, identity, type, given_displayname, displayname FROM Conversations ORDER BY last_activity_timestamp DESC LIMIT 100 " List the 100 most recent conversations (and all participants) SELECT id, convo_id, timestamp, type, author, body_xml FROM Messages ORDER BY timestamp DESC LIMIT 100 SELECT skypename, lastused_timestamp FROM Contacts ORDER BY lastused_timestamp DESC LIMIT 25 ![]() " List the 25 most recently contacted contacts You'll probably need to use the good ol' ctrl f to search in the output for things like time, author, and username. ![]() schema Messages " all about the Messages table schema Contacts " all about the Contacts table You'll want to take a look at the available tables, and their descriptions. ![]() Sqlite3 ~/Library/Application\ Support/Skype/>/main.db C'mon now, this is Stackoverflow, let's get technical, shall we? Let's put away childish jpegs, gui tools, and spreadsheet psuedocode and get to the heart of the problem!įirst you've got to find the correct skype db for your user: ls ~/Library/Application\ Support/Skype/ ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |