gameServer/OfficialServer/extdbinterface.hs
branch0.9.19
changeset 8924 13ac59499066
parent 8909 95542e198bc8
child 9138 9e94a9bc8c7e
child 9399 1767c92eff37
--- a/gameServer/OfficialServer/extdbinterface.hs	Sat Apr 20 02:17:53 2013 +0200
+++ b/gameServer/OfficialServer/extdbinterface.hs	Sat Apr 20 02:20:15 2013 +0200
@@ -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())"
@@ -29,7 +29,7 @@
                 execute statement [SqlByteString clNick]
                 passAndRole <- fetchRow statement
                 finish statement
-                let response = 
+                let response =
                         if isJust passAndRole then
                         (
                             clId,