diff options
author | Dico200 <dico.karssiens@gmail.com> | 2015-03-29 12:48:32 +0200 |
---|---|---|
committer | Dico200 <dico.karssiens@gmail.com> | 2015-03-29 12:48:32 +0200 |
commit | 661e25dc675cb1aade3b7038520d0f6371981a88 (patch) | |
tree | faf0b318d0a3c1d6d3245ef9054fdae9e4343893 /synchronizeranks.py | |
parent | 6590a8d30a2ebf59ba251f0fe06a87a537bd482d (diff) |
Some tweaks and updates
Diffstat (limited to 'synchronizeranks.py')
-rw-r--r-- | synchronizeranks.py | 25 |
1 files changed, 12 insertions, 13 deletions
diff --git a/synchronizeranks.py b/synchronizeranks.py index 946b952..97439e0 100644 --- a/synchronizeranks.py +++ b/synchronizeranks.py @@ -17,40 +17,34 @@ ranks = { @hook.event("player.PlayerJoinEvent", "normal") def on_player_join(event): user = event.getPlayer() - uuid = uid(player) + uuid = uid(player).replace("-", "") role = get_role(uuid) if role in [1, 2, 6]: #Disabled/Banned/Superadmin return - if role != None: + if role: for rank in ranks: if user.hasPermission("group." + rank): - set_role(uuid, ranks[rank]) + if role != ranks[rank]: + set_role(uuid, ranks[rank]) return if not user.hasPlayedBefore(): return if role == None: msg(user, "&cYou haven't registed yet! Make sure to do so on redstoner.com") - elif not is_email_confirmed(uuid): - msg(user, "&cWe noticed that you haven't confirmed your website email! Don't forget to do so!") def get_role(uuid): - return execute_query("SELECT `role_id` FROM users WHERE `uuid` = ? LIMIT 1")[0][17] + return execute_query("SELECT `role_id` FROM users WHERE `uuid` = ? LIMIT 1", uuid)[0][17] def set_role(uuid, role_id): - execute_query("UPDATE users SET `role_id` = %d WHERE `uuid` = ?" % role_id) - - -def is_email_confirmed(uuid): - return execute_query("SELECT `confirmed` FROM users WHERE `uuid` = ? LIMIT 1")[0][15] + execute_update("UPDATE users SET `role_id` = %d WHERE `uuid` = ?" % role_id, uuid) def execute_query(query, uuid): conn = zxJDBC.connect(mysql_database, mysql_user, mysql_pass, "com.mysql.jdbc.Driver") curs = conn.cursor() - uuid = uid(player).replace("-", "") curs.execute(query, (uuid,)) results = curs.fetchall() curs.close() @@ -58,4 +52,9 @@ def execute_query(query, uuid): return results - +def execute_update(update, uuid): + conn = zxJDBC.connect(mysql_database, mysql_user, mysql_pass, "com.mysql.jdbc.Driver") + curs = conn.cursor() + curs.execute(update, (uuid,)) + curs.close() + conn.close()
\ No newline at end of file |