import codecs

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

infile = codecs.open("bestadsontv.com_md5_354k", "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")

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[2] #Change this
            passwd = line[8] # Change this
            if debugMode:
                    print(email + ":" + passwd + "\n")
                    
            if len(email) > 6 and len(passwd) > 30 and "@" in email:
                    hashes.write(passwd + "\n")
                    emailhash.write(email + ":" + passwd + "\n")
        except:
            pass

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