No Comments

Author: samdiaz Posted On: January 4th, 2013 In:Tips and Tricks

There are some times when you need to delete a specific user’s conversation from Skype, but you don’t want to clear your total history.

Using SQLiteManager (the free trial is enough for this script) open the Skype database. For computers running Windows, it is located at %APPDATA%\Skype\your-skype-username\main.db. Once you’re in SQLiteManager, go to Script > New Script and create one with the name of your choice (I used Scrub Me Clean). Then simply copy this code into the script and save it.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- Scrub Me Clean.lua
-- Created with SQLiteManager 4.0.1
-- Created by: Sam Diaz // WhatSam.com
-- On Friday, December 28, 2012

userName = Dialogs:GetValue("User to Scrub", "Enter username:")
if (userName == false) then return end
rs = Database:SQLSelect("SELECT count(*) FROM Messages WHERE author = '" .. userName .. "' OR dialog_partner = '" .. userName .. "'")
if (rs == nil) then return end
del = Dialogs:Question("There are " .. rs:Value(1) .. " messages to/from " .. userName, "Are you sure you wish to delete all " .. rs:Value(1) .. " messages?")
if (del) then
delx2 = Dialogs:Question("ARE YOU", "SURE?")
if (delx2) then
poof = Database:SQLSelect("DELETE FROM Messages WHERE author = '" .. userName .. "' OR dialog_partner = '" .. userName .. "'")
Dialogs:Message("POOF! What were we talking about?")
else
Dialogs:Message("OK, nothing has been deleted")
end
else
Dialogs:Message("OK, nothing has been deleted")
end
Dialogs:Message("Your secret is safe with me ;)")

You will be prompted for the person’s screen name you wish to wipe, then asked a few times if you’re sure (there is no undo for this unless you backed up the DB file).

 

Hope you like it! Feel free to  it on my GitHub repo.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>