Mercurial Mercurial > hedgewars / 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.
Check for admin role right in the sql statemenet
authorunc0rr
Sun, 14 Apr 2013 15:09:24 +0400
changeset 8909 95542e198bc8
parent 8908 d3033e3a4113
child 8910 a60f7ebab219
Check for admin role right in the sql statemenet
gameServer/OfficialServer/extdbinterface.hs file | annotate | diff | comparison | revisions 
--- 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