Mercurial Mercurial > hedgewars / diff
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
gameServer/OfficialServer/extdbinterface.hs
changeset 11053 a009cc19a639
parent 11046 47a8c19ecb60
child 11246 09a2d3988569 
--- 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 = ?"
hedgewars