'''
Title: SkypeFreak
Description: A cross platform forensic tool for Skype
Author: Osanda Malith (@OsandaMalith)
URL: https://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 server(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 <https://www.gnu.org/licenses/>.
'''
import os
import sqlite3
import optparse
import sys

def Profile(skypeDB, PathName):
  connexion = sqlite3.connect(skypeDB)
  c = connexion.cursor()
  c.execute("SELECT fullname, skypename, city, country,\
    datetime(profile_timestamp,'unixepoch') FROM Accounts")
  print '[*] --- Details of %s' % (os.path.basename(PathName)) +' ---'
  profile = '[*] --- Details of %s' % (os.path.basename(PathName)) +' ---\n'
  for row in c:
    print '[+] User: %s ' %(str(row[0]))
    profile += '[+] User: %s \n' %(str(row[0]))
    print '[+] Skype Username: %s'%(str(row[1]))
    profile += '[+] Skype Username: %s\n'%(str(row[1]))
    print '[+] Country: %s' % (str(row[2]))
    profile += '[+] Country: %s\n' % (str(row[2]))
    print '[+] Location: %s'% (str(row[3]))
    profile += '[+] Location: %s\n'% (str(row[3]))
    print '[+] Profile Date: %s'%(str(row[4]))

  while True:
    
    choice = raw_input("\n[~] Generate Output?\n")
    choice = choice.lower()
  
    if choice[0] == 'y':
      try:
        output = profile
        output += "\n[*] This file was Generated by Skype Freak\n[~] https://osandamalith.github.io/SkypeFreak/"
        filename = str(raw_input("[~] Enter a Filename: "))
        file = open(filename+'.txt' , "w")
        file.write(output)
        file.close()
        print '[~] File Saved to ' + os.path.abspath(filename) + '.txt'
        mainMenu(skypeDB, PathName)
        break
      except Exception, e:
        print '[!] Access Denied! Directory is not writable. Probably you are in C:\\ drive'
    if choice[0] == 'n':
      mainMenu(skypeDB, PathName)
      break 
    

def Contacts(skypeDB, PathName):
  connexion = sqlite3.connect(skypeDB)
  c = connexion.cursor()
  c.execute("SELECT displayname, skypename, country, city, about, phone_mobile, homepage, \
    birthday , datetime(lastonline_timestamp,'unixepoch') FROM Contacts;")
  print '\n[*] --- Found Contacts --- '
  contacts = '[*] --- Found Contacts of %s' % (os.path.basename(PathName)) +' ---\n'
  for row in c:
    print '[+] User: %s\n' %(str(row[0]))
    contacts += '\n\n[+] User: %s' %(str(row[0]))
    print '[+] Skype Username: %s' %(str(row[1]))
    contacts += '\n[+] Skype Username: %s\n' %(str(row[1]))
    if str(row[2])!= 'None':
      contacts += '[+] Country: %s\n' %(str(row[2]))
      print '[+] Country: %s' %(str(row[2]))
    if str(row[3])!= 'None':
      contacts += '[+] City: %s\n' %(str(row[3]))
      print '[+] City: %s' %(str(row[3]))
    if str(row[4])!= 'None':
      contacts += '[+] About Text: %s\n' %(str(row[4]))
      print '[+] About Text: %s' %(str(row[4]))
    if str(row[5])!= 'None':
      contacts += '[+] Mobile Number: %s\n' %(str(row[5]))
      print '[+] Mobile Number: %s' %(str(row[5]))
    if str(row[6])!= 'None':
      contacts += '[+] Homepage URL: %s\n' %(str(row[6]))
      print '[+] Homepage URL: %s' %(str(row[6]))
    if str(row[7])!= 'None':
      contacts += '[+] Birthday: %s\n' %(str(row[7]))
      print '[+] Birthday: %s' %(str(row[7]))
    if str(row[8])!= 'None':
      contacts += '[+] Last Online Date: %s\n' %(str(row[8]))
      print '[+] Last Online Date: %s' %(str(row[8]))

  while True:
    try:
      choice = raw_input("\n[~] Generate Output?\n")
      choice = choice.lower()
    except (NameError, SyntaxError, EOFError):
      print '[!] Error Occured'
    if choice[0] == 'y':
      try:
        output = contacts
        output += "\n[*] This file was Generated by Skype Freak\n[~] https://osandamalith.github.io/SkypeFreak/"
        filename = str(raw_input("[~] Enter a Filename: "))
        file = open(filename+'.txt' , "w")
        file.write(output)
        file.close()
        print '[~] File Saved to ' + os.path.abspath(filename) + '.txt'
        mainMenu(skypeDB, PathName)
        break
      except Exception, e:
        print '[!] Access Denied! Directory is not writable. Probably you are in C:\\ drive'
    if choice[0] == 'n':
      mainMenu(skypeDB, PathName)
      break 


def Calls(skypeDB, PathName):
  connexion = sqlite3.connect(skypeDB)
  c = connexion.cursor()
  c.execute("SELECT datetime(begin_timestamp,'unixepoch'), time(duration,'unixepoch'), \
    is_incoming, identity  FROM calls, conversations WHERE calls.conv_dbid = conversations.id;")
  print '\n[*] --- Found Calls --- '
  calls = '[*] --- Found Calls of %s' % (os.path.basename(PathName)) +' ---\n'
  for row in c:
    
    print '[+] Date: %s'%(str(row[0])) + ' | Partner: %s' %(str(row[3]))
    if (str(row[1])) != 'None':
      print '[+] Call Duration: %s' %(str(row[1])) 
    if ((str(row[2])) == '1'):
      print '[~] This was an Incoming Call\n'
    else: 
      print '[~] This was an Outgoing Call\n'
      #output
    
    calls += '[+] Date: %s'%(str(row[0])) + ' | Partner: %s\n' %(str(row[3]))
    if (str(row[1])) != 'None':
      calls += '[+] Call Duration: %s\n' %(str(row[1]))
    if ((str(row[2])) == '1'):
      calls += '[~] This was an Incoming Call\n\n'
    else: 
      calls += '[~] This was an Outgoing Call\n\n'
  
  while True:
    try:
      choice = raw_input("\n[~] Generate Output?\n")
      choice = choice.lower()
    except (NameError, SyntaxError, EOFError):
      print '[!] Error Occured'
    if choice[0] == 'y':
      try:
        output = calls
        output += "\n[*] This file was Generated by Skype Freak\n[~] https://osandamalith.github.io/SkypeFreak/"
        filename = str(raw_input("[~] Enter a Filename: "))
        file = open(filename+'.txt' , "w")
        file.write(output)
        file.close()
        print '[~] File Saved to ' + os.path.abspath(filename) + '.txt'
        mainMenu(skypeDB, PathName)
        break
      except Exception, e:
        print '[!] Access Denied! Directory is not writable. Probably you are in C:\\ drive'
    if choice[0] == 'n':
      mainMenu(skypeDB, PathName)
      break 

def Msgs(skypeDB, PathName):
  connexion = sqlite3.connect(skypeDB)
  c = connexion.cursor()
  c.execute("SELECT datetime(timestamp,'unixepoch'), \
    dialog_partner, author, body_xml FROM Messages;")
  msgs = '[*] --- Messages Found of %s' % (os.path.basename(PathName)) +' ---\n'
  for row in c:
    try:
      if 'partlist' not in str(row[3]):
        if str(row[1]) != str(row[2]):
          msgDirection = 'To ' + str(row[1]) + ': '
        else:
          msgDirection = 'From ' + str(row[2]) + ': '
        print 'Time: ' + str(row[0]) + ' ' \
        + msgDirection + str(row[3])
        
        msgs += 'Time: ' + str(row[0]) + ' ' + msgDirection + str(row[3]) + '\n'
    except:
      pass

  while True:
    try:
      choice = raw_input("[~] Generate Output?\n")
      choice = choice.lower()
    except (NameError, SyntaxError, EOFError):
      print '[!] Error Occured'
    if choice[0] == 'y':
      try:
        output = msgs
        output += "\n[*] This file was Generated by Skype Freak\n[~] https://osandamalith.github.io/SkypeFreak/"
        filename = str(raw_input("[~] Enter Filename: "))
        file = open(filename+'.txt' , "w")
        file.write(output)
        file.close()
        print '[~] File Saved to ' + os.path.abspath(filename) + '.txt'
        mainMenu(skypeDB, PathName)
        break
      except Exception, e:
        print '[!] Access Denied! Directory is not writable. Probably you are in C:\\ drive'
    if choice[0] == 'n':
      mainMenu(skypeDB, PathName)
      break 

def fullReport(skypeDB, PathName):
  connexion = sqlite3.connect(skypeDB)
  c = connexion.cursor()
  c.execute("SELECT fullname, skypename, city, country,\
    datetime(profile_timestamp,'unixepoch') FROM Accounts")
  profile = '[*] --- Details of %s' % (os.path.basename(PathName)) +' ---\n\n'
  for row in c:
    profile += '[+] User: %s \n' %(str(row[0]))
    profile += '[+] Skype Username: %s\n'%(str(row[1]))
    profile += '[+] Country: %s\n' % (str(row[2]))
    profile += '[+] Location: %s\n'% (str(row[3]))

  c.execute("SELECT displayname, skypename, country, city, about, phone_mobile, homepage, \
    birthday , datetime(lastonline_timestamp,'unixepoch') FROM Contacts;")
  
  contacts = '\n\n[*] --- Found Contacts of %s' % (os.path.basename(PathName)) +' ---\n\n'
  for row in c:
    contacts += '\n\n[+] User: %s' %(str(row[0]))
    contacts += '\n[+] Skype Username: %s\n' %(str(row[1]))
    if str(row[2])!= 'None':
      contacts += '[+] Country: %s\n' %(str(row[2]))
    if str(row[3])!= 'None':
      contacts += '[+] City: %s\n' %(str(row[3]))
    if str(row[4])!= 'None':
      contacts += '[+] About Text: %s\n' %(str(row[4]))
    if str(row[5])!= 'None':
      contacts += '[+] Mobile Number: %s\n' %(str(row[5]))
    if str(row[6])!= 'None':
      contacts += '[+] Homepage URL: %s\n' %(str(row[6]))
    if str(row[7])!= 'None':
      contacts += '[+] Birthday: %s\n' %(str(row[7]))
    if str(row[8])!= 'None':
      contacts += '[+] Last Online Date: %s\n' %(str(row[8]))
  
  c.execute("SELECT datetime(begin_timestamp,'unixepoch'), time(duration,'unixepoch'), \
    is_incoming, identity  FROM calls, conversations WHERE calls.conv_dbid = conversations.id;")
  
  calls = '\n\n[*] --- Found Calls of %s' % (os.path.basename(PathName)) +' ---\n\n'
  for row in c:
    
    calls += '[+] Date: %s'%(str(row[0])) + ' | Partner: %s\n' %(str(row[3]))
    if (str(row[1])) != 'None':
      calls += '[+] Call Duration: %s\n' %(str(row[1]))
    if ((str(row[2])) == '1'):
      calls += '[~] This was an Incoming Call\n\n'
    else: 
      calls += '[~] This was an Outgoing Call\n\n'
  
  connexion = sqlite3.connect(skypeDB)
  c.execute("SELECT datetime(timestamp,'unixepoch'), \
    dialog_partner, author, body_xml FROM Messages;")
  msgs = '\n\n[*] --- Messages Found of %s' % (os.path.basename(PathName)) +' ---\n\n'
  for row in c:
    try:
      if 'partlist' not in str(row[3]):
        if str(row[1]) != str(row[2]):
          msgDirection = 'To ' + str(row[1]) + ': '
        else:
          msgDirection = 'From ' + str(row[2]) + ': '
        msgs += 'Time: ' + str(row[0]) + ' ' + msgDirection + str(row[3]) + '\n'
    except:
      pass
      
  output = profile + contacts + calls + msgs
  output += "\n[*] This file was Generated by Skype Freak\n[~] https://osandamalith.github.io/SkypeFreak/"
  filename = str(raw_input("[~] Enter Filename: "))
  file = open(filename+'.txt' , "w")
  file.write(output)
  file.close()
  print '[~] File Saved to ' + os.path.abspath(filename) + '.txt'
  mainMenu(skypeDB, PathName)
  

def mainMenu(skypeDB, PathName):
  while True:
    try:
      choice = raw_input("[~] Go to Main Menu?\n")
      choice = choice.lower()
    except (NameError, SyntaxError, EOFError):
      print '[!] Error Occured'
    if choice[0] == 'y':
      banner(skypeDB, PathName)
    if choice[0] == 'n':
      sys.exit(0) 

def banner(skypeDB, PathName):
  
  if os.name == "nt":
    os.system('cls')
  else:
    os.system('clear')
  
  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  '%s' %('A creation of Osanda Malith\nURL: https://osandamalith.github.io/SkypeFreak/') + '\n'
  
  while True:
    try:
      choice = int(raw_input("[~] What Do You Like to Investigate? \
        \n1. Profile\n2. Contact\n3. Calls\n4. Messages\n5. Generate Full Report\n6. Exit\n" ))
    except ValueError:
      print '[!] Enter Only a Number'
      continue
    if choice == 1:
      Profile(skypeDB, PathName)
      break
    if choice == 2:
      Contacts(skypeDB, PathName)
      break
    if choice == 3:
      Calls(skypeDB, PathName)
      break
    if choice == 4:
      Msgs(skypeDB, PathName)
      break
    if choice == 5:
      fullReport(skypeDB, PathName)
      break
    if choice == 6:
      sys.exit(0)
    else:
      print '[!] Invalid Choice'



def menu(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):
      banner(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):
      banner(skypeDB,PathName)

def main():
  try:
    if os.name == "nt":
      os.system('cls')
    else:
      os.system('clear')
    while True:
      username = str(raw_input("[~] Enter your Skype Username: "))
      menu(username)
      break
        
  except (KeyboardInterrupt):
    print '[!] Ctrl + C detected\n[!] Exiting'
    sys.exit(0)
  except (EOFError):
    print '[!] Ctrl + D detected\n[!] Exiting'
    sys.exit(0)
    
      

if __name__ == "__main__": 
  main()