#!/usr/bin/python
from __future__ import print_function
import os
import sqlite3
import optparse
import sys
import time
try:
input = raw_input
except:
pass
'''
Title: SkypeFreak
Description: A cross platform forensic tool for Skype
Author: Osanda Malith (@OsandaMalith) & Yasoob Khalid (@yasoobkhalid)
URL: http://osandamalith.github.io/SkypeFreak/
Disclaimer: This tool is meant for ethical (legal) purposes only.
Notes: Please note this tool may contain errors, and
is provided "as it is". There is no guarantee
that it will work on your target systems(s), as
the code may have to be adapted.
This is to avoid script kiddie abuse as well.
License:
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see .
'''
contributors = [
'Osanda Malith @osandamalith',
'Muhammad Yasoob Ullah Khalid @yasoobkhalid'
]
class SkypeJunk(object):
'''
This is the main object which contains all of the required functions.
It contains the following methods:
*) __init__(self,db)
*) _get_profile(self)
*) _get_contacts(self)
*) _get_calls(self)
*) _get_msgs(self)
*) _gen_report(self)
*) _gen_full_report(self)
*) _put_to_file(self,filename,data)
*) _get_choice(self)
*) _get_save_choice(self)
You just need to pass a skype database path which instantiating this class.
For example SkypeJunk('/home//.Skype//main.db').
After that you can use any method from this class.
'''
def __init__(self,skypedb,pathname):
self.db = skypedb
self.con = sqlite3.connect(self.db)
self.path = pathname
self.name = os.path.basename(self.path)
self.type_of= None
def _get_profile(self):
with self.con:
cur = self.con.cursor()
data = cur.execute("SELECT fullname, skypename, city, country,\
datetime(profile_timestamp,'unixepoch') FROM Accounts")
for row in data:
self.details = {
'[+] User ' : str(row[0]),
'[+] Skype Username' : str(row[1]),
'[+] Country ' : str(row[2]) or "unknown",
'[+] Location ' : str(row[3]),
'[+] Profile Date' : str(row[4])
}
self.type_of = "profile"
return self.details
def _get_contacts(self):
with self.con:
cur = self.con.cursor()
data = cur.execute("SELECT displayname, skypename, country, city, about, phone_mobile,\
homepage, birthday , datetime(lastonline_timestamp,'unixepoch') FROM Contacts;")
self.details = {}
for count,row in enumerate(data):
self.details[count] = {}
self.details[count]['[+] User '] = str(row[0])
self.details[count]['[+] Skype Username'] = str(row[1])
if row[2]:
self.details[count]['[+] Country '] = str(row[2])
elif row[3]:
self.details[count]['[+] City '] = str(row[3])
elif row[4]:
self.details[count]['[+] About '] = str(row[4])
elif row[5]:
self.details[count]['[+] Mobile No '] = str(row[5])
elif row[6]:
self.details[count]['[+] Homepage'] = str(row[6])
elif row[7]:
self.details[count]['[+] Birthday'] = str(row[7])
elif row[8]:
self.details[count]['[+] Last Online'] = str(row[8])
self.type_of = "contacts"
return self.details
def _get_calls(self):
with self.con:
cur = self.con.cursor()
data = cur.execute("SELECT datetime(begin_timestamp,'unixepoch'), \
time(duration,'unixepoch'), is_incoming, identity FROM calls, \
conversations WHERE calls.conv_dbid = conversations.id;")
self.details = {}
for count, row in enumerate(data):
self.details[count] = row
self.type_of = "calls"
return self.details
def _get_msgs(self):
with self.con:
cur = self.con.cursor()
data = cur.execute("SELECT datetime(timestamp,'unixepoch'), \
dialog_partner, author, body_xml FROM Messages;")
self.details = {}
for count, row in enumerate(data):
try:
if 'partlist' not in str(row[3]):
if str(row[1]) != str(row[2]):
msgDirection = ['[+] To\t', str(row[1])]
else:
msgDirection = ['[+] From', str(row[2])]
self.details[count] = {
msgDirection[0] : msgDirection[1],
'[+] Time' : str(row[0]),
'[+] Message' : str(row[3]).replace(''',"'")
}
except:
pass
self.type_of = "msgs"
return self.details
def __status(self,num):
if num == 0:
return "Outgoing"
elif num == 1:
return "Incomming"
else:
return num
def _get_contributors(self):
print('\nContributors:\n')
for one in contributors:
print(one)
sys.exit(0)
def _gen_report(self):
data = ''
if self.type_of == "profile":
data += '\n[*] ----- Found The Profile ----- \n\n'
for i in self.details:
data += i+'\t'+': '+self.details[i]+'\n'
return data
elif self.type_of == "contacts":
data += '\n[*] ----- Found {0} Contacts ----- \n'.format(len(self.details))
for i in self.details:
data += '\n'
for single in self.details[i]:
data += single+'\t'+': '+self.details[i][single]+'\n'
return data
elif self.type_of == "calls":
formating = ['[+] Date\t','[+] Duration','[+] Status\t','[+] User\t']
data += '\n[*] ----- Found {0} Calls ----- '.format(len(self.details))+'\n'
for i in self.details:
data += "\n"
for c,single in enumerate(self.details[i]):
data += formating[c]+'\t: '+str(self.__status(single))+'\n'
return data
elif self.type_of == "msgs":
data += '\n[*] ----- Found {0} Messages ----- '.format(len(self.details))+'\n'
for i in self.details:
data += '\n'
for single in self.details[i]:
data += single+'\t: '+self.details[i][single]+"\n"
return data
def _gen_full_report(self):
self._get_profile()
data = self._gen_report()
self._get_contacts()
data += '\n'+self._gen_report()
self._get_calls()
data += '\n'+self._gen_report()
self._get_msgs()
data += '\n'+self._gen_report()+'\n'
print(data)
self._get_save_choice(data)
def _put_to_file(self,file,data):
data += "\n[*] This file was Generated by Skype Freak\n[~] http://osandamalith.github.io/SkypeFreak/"
with open(file,'wb') as f:
f.write(data.encode('utf-8'))
def _get_choice(self):
choice = None
while choice is None:
try:
choice = int(input("[~] What Do You Like to Investigate? \
\n1. Profile\n2. Contact\n3. Calls\n4. Messages\n5. Generate Full Report\n\
6. Print the list of contributors & exit\n7. Exit\n" ))
except ValueError:
print('[!] Enter Only a Number')
choices = {
1 : self._get_profile,
2 : self._get_contacts,
3 : self._get_calls,
4 : self._get_msgs,
5 : self._gen_full_report,
6 : self._get_contributors,
7 : sys.exit
}
if choice not in [5,6]:
choices.get(choice,sys.exit)()
data = self._gen_report()
print(data)
self._get_save_choice(data)
else:
choices.get(choice,sys.exit)()
def _get_save_choice(self,data):
choice = None
while True:
choice = input('[~] Would you like to save these results in a file? ')
if 'y' in choice:
filename = input('[~] What should be the name of the file? ')
self._put_to_file(filename,data)
print('[*] All of the data is saved')
time.sleep(1)
break
elif 'n' in choice:
break
else:
print('[!] You selected wrong option.\n[!] Please try again!')
print('out of while choices_save')
def clear_screen():
if os.name == "nt":
os.system('cls')
else:
os.system('clear')
def print_banner():
print('''
8""""8
8 e e e e eeeee eeee
8eeeee 8 8 8 8 8 8 8
88 8eee8e 8eeee8 8eee8 8eee
e 88 88 8 88 88 88
8eee88 88 8 88 88 88ee
8""""
8 eeeee eeee eeeee e e
8eeee 8 8 8 8 8 8 8
88 8eee8e 8eee 8eee8 8eee8e
88 88 8 88 88 8 88 8
88 88 8 88ee 88 8 88 8
''')
print('[*] A creation of Osanda Malith & Muhammad Yasoob Ullah Khalid\n\
[*] Follow @OsandaMalith and @yasoobkhalid\n\
[*] URL: http://osandamalith.github.io/SkypeFreak/\n')
def main():
clear_screen()
username = input('[~] Enter your Skype Username: ')
clear_screen()
try:
db,path = gen_path(username)
except TypeError:
print('[!] The name you entered was not correct')
sys.exit(0)
skype = SkypeJunk(db,path)
try:
while True:
print_banner()
skype._get_choice()
clear_screen()
except KeyboardInterrupt:
print('\n[!] Got Ctrl+C key. Shutting down gracefully\n')
sys.exit(0)
def gen_path(username):
if os.name == "nt":
PathName = os.getenv('appdata') + "\\Skype\\" + username
elif os.name == "posix":
PathName = os.getenv('HOME') + "/.Skype/" + username
if PathName == None :
print('[!] Please Enter a valid Skype username ')
elif ((os.name == "posix") and (os.path.isdir(PathName) == False)):
PathName = os.getenv('HOME') + "/Library/Application Support/Skype/" + username
skypeDB = os.path.join(PathName, 'main.db')
if os.path.isfile(skypeDB):
return skypeDB,PathName
elif os.path.isdir(PathName) == False:
print('[!] Username Does Not Exist ')
else:
skypeDB = os.path.join(PathName, 'main.db')
if os.path.isfile(skypeDB):
return skypeDB,PathName
if __name__ == '__main__':
main()