import codecs

debugMode= False
opener = "INSERT INTO `member` VALUES ("

infile = codecs.open("ROMWE.com_osCommerce_June_2018.txt", "r", encoding="utf-8", errors="replace")
hashes =  codecs.open("hashes.txt", "w", encoding="utf-8", errors="replace")
emailhash = codecs.open("emailhash.txt", "w", encoding="utf-8", errors="replace")
emailhashnosalt = codecs.open("emailhashnosalt.txt", "w", encoding="utf-8", errors="replace")

for lines in infile:
    lines = lines.replace(opener,"")
    lines = lines.split("),(")

    for line in lines:
        line = line.replace("'","")
        line = line.split("||")
        #if True:
        try:
            email = line[1] #Change this
            passwd = line[6].rstrip() # Change this
            if debugMode:
                    print(email + ":" + passwd + "\n")
                    
            if len(email) > 6 and len(passwd) > 6 and "@" in email:
                    hashes.write(passwd + "\n")
                    emailhash.write(email + ":" + passwd + "\n")
                    emailhashnosalt.write(email + ":" + passwd.split(":")[0] + "\n")
        except:
            pass

infile.close()
hashes.close()
emailhash.close()
emailhashnosalt.close()