[pLog-svn] r2472 - plog/branches/plog-1.0.2/class/dao

[jondaley at devel.plogworld.net]

Author: jondaley
Date: 2005-09-15 12:07:33 +0000 (Thu, 15 Sep 2005)
New Revision: 2472

Modified:
   plog/branches/plog-1.0.2/class/dao/users.class.php
Log:
Fixes http://bugs.plogworld.net/view.php?id=705.  Thanks toki

Modified: plog/branches/plog-1.0.2/class/dao/users.class.php
===================================================================
--- plog/branches/plog-1.0.2/class/dao/users.class.php	2005-09-14 21:52:11 UTC (rev 2471)
+++ plog/branches/plog-1.0.2/class/dao/users.class.php	2005-09-15 12:07:33 UTC (rev 2472)
@@ -68,7 +68,8 @@
                       IF(p.permission_id = 1, 1, 0 ) AS site_admin,
                       u.status AS status
                       FROM {$prefix}users u LEFT JOIN {$prefix}users_permissions p ON u.id = p.user_id
-                      WHERE u.user = '".Db::qstr($user)."' AND u.password = '".md5($pass)."'";
+                      WHERE u.user = '".Db::qstr($user)."' AND u.password = '".md5($pass)."'
+                      ORDER BY blog_id";
 
             $userInfo = $this->_getUserInfoFromQuery( $query );
 
@@ -90,7 +91,7 @@
                              IF(p.permission_id = 1, 1, 0 ) AS site_admin,
                              u.status AS status
                       FROM {$prefix}users u LEFT JOIN {$prefix}users_permissions p ON u.id = p.user_id
-                      WHERE u.user = '".Db::qstr($username)."'";
+                      WHERE u.user = '".Db::qstr($username)."' ORDER BY blog_id";
 
             $userInfo = $this->_getUserInfoFromQuery( $query );
 
@@ -116,7 +117,7 @@
                                  IF(p.permission_id = 1, 1, 0 ) AS site_admin,
                                  u.status AS status
                           FROM {$prefix}users u LEFT JOIN {$prefix}users_permissions p ON u.id = p.user_id
-                          WHERE u.id = $userid";
+                          WHERE u.id = $userid ORDER BY blog_id";
 
                 $userInfo = $this->_getUserInfoFromQuery( $query, $extendedInfo );