Don't accept any password from players banned on the website
authorunC0Rr
Thu, 27 Aug 2015 14:47:38 +0300
changeset 11053 a009cc19a639
parent 11052 f55a49bd13b9
child 11054 6e575b29881c
Don't accept any password from players banned on the website
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 = ?"