import codecs

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

infile = codecs.open("hiapk_com_member.sql", "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(",")
        #print(line[3] + ":" + line[2] + line[4])
        #if True:
        try:
            email = line[3].replace(" ", "")
            passwd = (line[2] + ":" + line[4]).replace(" ", "").replace(");","").replace("\n", "")
            
            if len(email) > 6 and "@" in email and len(passwd) > 6:
                if debugMode:
                    print(email + ":" + passwd + "\n")
                else:
                    hashes.write(passwd + "\n")
                    emailhash.write(email + ":" + passwd + "\n")
        except:
            continue
            

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