diff -r 6ea838b8dcd5 -r 13ac59499066 gameServer/OfficialServer/extdbinterface.hs --- 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,