0,'r.RoleID>'=>7); if($Random && $NoPhoto) { $Order='RAND()'; } else if((!$NoPhoto) && ($Random)) { $Where['u.Photo >']=0; $Order='RAND()'; } else if(!$NoPhoto) { $Where['u.Photo >']=0; $Order='u.UserID'; } else { $Order='u.UserID'; } /* $this->Users = $SQL ->Select($Select) ->From($From) ->Join('UserRole r','u.UserID = r.UserID') ->Where($Where) ->Get(); */ // $this->Users = $SQL ->Select($Select) ->From($From) ->Join('UserRole r','u.UserID = r.UserID') ->Where($Where) ->OrderBy($Order) ->Limit($Limit) ->Get(); //print_r(get_class_methods($this->Users)); //print_r($this->Users->ResultArray()); $this->All_Users = $SQL ->Select('u.UserID') ->From('User u') ->Join('UserRole r', 'u.UserID = r.UserID') ->Where(array('u.Deleted'=>0,'r.RoleID>'=>7)) ->Get(); } public function AssetTarget() { return 'Panel'; } public function ToString() { $String = ''; $Session = Gdn::Session(); $permissions=$Session->User->Permissions; $admin=preg_match('/Garden.Settings.Manage/',$permissions); ob_start(); $Limit = Gdn::Config('UserList.Limit'); $Photo = Gdn::Config('UserList.Photo'); $Title = Gdn::Config('UserList.Title'); $ShowNumUsers = Gdn::Config('UserList.ShowNumUsers'); if(empty($Title)) { $Title="Members"; } if($Photo) { ?>

'.$Title.''; if($ShowNumUsers) echo " (".$this->All_Users->NumRows().")"; ?>

Browse Members