###
### "Kill Skype Home 4 Ever"
###
### This little python code is intended to remove the annoying autostart behaviour
### of the Skype Client on Windows which opens automatically the "Skype Home" window
### on every startup of the skype client.
###
### This code removes the relevant setting from the Skype Software's internal settings db.
###


###
### Download Executable from:
### http://ge.tt/9zElhI7?c
###

import sqlite3
import os
import ctypes
from ctypes import wintypes, windll

# Thanks to: http://stackoverflow.com/questions/626796/how-do-i-find-the-windows-common-application-data-folder-using-python/626927#626927
# for this function
# Look for the user's appdata path on a windows system
def appdata():
    CSIDL_COMMON_APPDATA = 35
    CSIDL_APPDATA = 26

    _SHGetFolderPath = windll.shell32.SHGetFolderPathW
    _SHGetFolderPath.argtypes = [wintypes.HWND,
                                ctypes.c_int,
                                wintypes.HANDLE,
                                wintypes.DWORD, wintypes.LPCWSTR]

    path_buf = wintypes.create_unicode_buffer(wintypes.MAX_PATH)
    result = _SHGetFolderPath(0, CSIDL_APPDATA, 0, 0, path_buf)
    return path_buf.value

# Build path
pt = os.path.join(appdata(), 'Skype', 'shared_dynco', 'dc.db')

# Open conection to SQL-Lite database
conn = sqlite3.connect(pt)

# Modify the webapps entry in bupdate table
# Thanks to: http://www.tipps-tricks-kniffe.de/skype-home-ausblenden-so-deaktivieren-sie-die-uberflussige-skype-home-ansicht/
conn.execute("""UPDATE bupdate
          SET body='<webapps></webapps>'
          WHERE uri='ui/webapps/config/1197'""")

# Save (commit) the changes
conn.commit()

# We can close the connection now
conn.close()

# done and goodbye
quit()