Mercurial Mercurial > sheepy-clone / changeset
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 file | annotate | diff | comparison | revisions 
--- 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 = ?"
sheepy-clone