'>0','append_meta'=>false,'sticky'=>false,'topic_status'=>'all','order_by'=>1,'per_page'=>1); // fake query for bbPress :-(
bb_register_view("member-list","Member List",$query,false); // register the view itself and it's name and url stub
function member_list_view($view='') {
if (!empty($view) && $view!='member-list') {return;} // is this view for us? no? return
bb_send_headers(); // send any appropriate http headers
bb_get_header(); // send any bbpress html headers like meta, css, etc.
member_list(); // all the queries/output happens in this below
bb_get_footer(); // send any bbPress footer stuff
exit; // all done!
}
function member_list() {
global $bbdb, $view_count, $page; // bbPress uses $page for the current page number, $view_count for total overall
$limit = bb_get_option('page_topics'); // how many users per page
$offset = ($page-1)*$limit; // calculate the user number to start at for the current page
$query="FROM $bbdb->users as t1
LEFT JOIN $bbdb->usermeta as t2 on t1.ID=t2.user_id
WHERE user_status=0 AND (meta_key='$bbdb->prefix"."capabilities'
AND NOT (meta_value LIKE '%inactive%' OR meta_value LIKE '%blocked%')) ";
$restrict = " ORDER BY user_registered DESC LIMIT $limit OFFSET $offset";
$view_count = $bbdb->get_var("SELECT count(*) ".$query); // calculate total number of users overall
$users = $bbdb->get_col("SELECT ID ".$query.$restrict); // get user IDs for just this page
bb_cache_users(implode(',',$users)); // cache all users about to be displayed for other bbPress functions
// just a simple output example
echo "
Member List ($view_count total,
showing ".(1+($page-1)*$limit)." - ".($page*$limit>$view_count ? $view_count : $page*$limit)
.")