# HG changeset patch
# User unC0Rr
# Date 1440676058 -10800
# Node ID a009cc19a6398cc2c23727e9adf04404d2138ef3
# Parent  f55a49bd13b905099c3cd81252dc7f7fe9249de6
Don't accept any password from players banned on the website

diff -r f55a49bd13b9 -r a009cc19a639 gameServer/OfficialServer/extdbinterface.hs
--- a/gameServer/OfficialServer/extdbinterface.hs	Mon Aug 17 14:14:58 2015 -0400
+++ b/gameServer/OfficialServer/extdbinterface.hs	Thu Aug 27 14:47:38 2015 +0300
@@ -37,7 +37,7 @@
 
 
 dbQueryAccount =
-    "SELECT users.pass, \
+    "SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END, \
     \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), \
     \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) \
     \ FROM users WHERE users.name = ?"