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/DBInteraction.hs
changeset 1963 58c29439225d
parent 1921 2a09f7f786a0
child 1970 130e7805d49c 
--- 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
hedgewars