--- a/gameServer/OfficialServer/DBInteraction.hs	Sat Apr 11 13:25:26 2009 +0000
+++ b/gameServer/OfficialServer/DBInteraction.hs	Sun Apr 12 06:01:17 2009 +0000
@@ -36,8 +36,7 @@
 -------------------------------------------------------------------
 
 dbQueryString =
-	"SELECT users.pass, users_roles.rid FROM `users`, users_roles "
-	++ "WHERE users.name = ? AND users_roles.uid = users.uid"
+	"select users.pass, users_roles.rid from users left join users_roles on users.uid = users_roles.uid where users.name = ?"
 
 dbInteractionLoop queries coreChan dbConn = do
 	q <- readChan queries