#!/usr/bin/env python

import _mysql, sys

HOST = "localhost"
USER = "root"
PASSWORD = "3llzr43ff"
DATABASE = "trinity_chars"

if sys.argv.__len__() != 4:
    print "Usage: title-remover.py cislo_guildy poradi_pole maska"
    sys.exit(1)

guildId = int(sys.argv[1])
index = int(sys.argv[2])
mask = int(sys.argv[3])

DB = _mysql.connect(host = HOST, user = USER, passwd = PASSWORD, db = DATABASE)

print "Removing title (%d, %d) from player who are no in guild %d." % (index, mask, guildId)

DB.query("select characters.guid, characters.knownTitles from characters left join guild_member on (characters.guid = guild_member.guid) where (guild_member.guid is null or guild_member.guildId != %d);" % guildId)
res = DB.store_result()

while True:
    row = res.fetch_row()
    if row.__len__() == 0:
        break

    guid = row[0][0]
    knownTitles = row[0][1].split(" ")[:6]

    knownTitles[index] = str(int(knownTitles[index]) & ~mask)
    DB.query("update characters set knownTitles = '%s' where guid = '%s'" % (" ".join(knownTitles), guid))

print "Done."