[pLog-svn] r4165 - plog/trunk/class/dao/userdata

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-10-22 20:42:56 +0000 (Sun, 22 Oct 2006)
New Revision: 4165

Modified:
   plog/trunk/class/dao/userdata/lifetypeuserdataprovider.class.php
Log:
fixed an issue with Users::getBlogUsers()


Modified: plog/trunk/class/dao/userdata/lifetypeuserdataprovider.class.php
===================================================================
--- plog/trunk/class/dao/userdata/lifetypeuserdataprovider.class.php	2006-10-22 20:34:50 UTC (rev 4164)
+++ plog/trunk/class/dao/userdata/lifetypeuserdataprovider.class.php	2006-10-22 20:42:56 UTC (rev 4165)
@@ -222,15 +222,13 @@
             }
 
             // now get the other users who have permission for that blog.
-            $query2 = "SELECT {$prefix}users.* FROM {$prefix}users, {$prefix}users_permissions 
-                       WHERE {$prefix}users.id = {$prefix}users_permissions.user_id 
-                       AND {$prefix}users_permissions.blog_id = '".Db::qstr($blogId)."';";
+            $query2 = "SELECT DISTINCT user_id FROM {$prefix}users_permissions WHERE blog_id = '".Db::qstr( $blogId )."'";
             $result2 = $this->Execute( $query2 );
             if( !$result2 ) // if error, return what we have so far...
                 return $users;
 
             while( $row = $result2->FetchRow()) {
-                array_push( $users, $this->mapRow($row));
+                array_push( $users, $this->getUserInfoFromId( $row["user_id"] ));
             }
             $result2->Close();