# HG changeset patch
# User unc0rr
# Date 1239516077 0
# Node ID 58c29439225dd64d92ba40f0ccfac53a6c2a5b18
# Parent  1459c9adf84be4703c019b333dd4a3574e04d28f
Better SQL statement, allows NULL rid

diff -r 1459c9adf84b -r 58c29439225d gameServer/OfficialServer/DBInteraction.hs
--- 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