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 8909 95542e198bc8
parent 6040 a740069c21e3
child 8924 13ac59499066 
--- a/gameServer/OfficialServer/extdbinterface.hs	Sat Apr 13 20:34:30 2013 +0200
+++ b/gameServer/OfficialServer/extdbinterface.hs	Sun Apr 14 15:09:24 2013 +0400
@@ -14,7 +14,7 @@
 
 
 dbQueryAccount =
-    "SELECT users.pass, users_roles.rid FROM users LEFT JOIN users_roles ON users.uid = users_roles.uid WHERE users.name = ?"
+    "SELECT users.pass, users_roles.rid FROM users LEFT JOIN users_roles ON (users.uid = users_roles.uid AND users_roles.rid = 3) WHERE users.name = ?"
 
 dbQueryStats =
     "INSERT INTO gameserver_stats (players, rooms, last_update) VALUES (?, ?, UNIX_TIMESTAMP())"
hedgewars