wp_table_prefix ) {
if( $order == 'postcount' )
$result = $bbdb->get_results("SELECT * , COUNT(*) AS posts FROM ".$bb->wp_table_prefix."posts RIGHT JOIN ".$bb->wp_table_prefix."users ON poster_id = ID WHERE user_status = 0 GROUP BY user_login ORDER BY posts DESC, post_text DESC LIMIT $page, $usercount");
else
$result = $bbdb->get_results("SELECT * FROM ".$bb->wp_table_prefix."users WHERE user_status = 0 ORDER BY $order LIMIT $page, $usercount");
} else {
if( $order == 'postcount' )
$result = $bbdb->get_results("SELECT * , COUNT(*) AS posts FROM $bbdb->posts RIGHT JOIN $bbdb->users ON poster_id = ID WHERE user_status = 0 GROUP BY user_login ORDER BY posts DESC, post_text DESC LIMIT $page, $usercount");
else
$result = $bbdb->get_results("SELECT * FROM $bbdb->users WHERE user_status = 0 ORDER BY $order LIMIT $page, $usercount");
}
return $result;
}
function get_mlist_time( $timevar ) {
global $bb;
return strftime("%m/%d/%y at %r",strtotime($timevar)+($bb->gmt_offset * 60 * 60));
}
function get_mlist_pages($currentpage, $usercount = 10) {
$numpages = ceil(bb_mlist_count_users() / $usercount);
$i = 1;
if ( $currentpage <= 1 )
echo " ";
else
if ( isset($_GET['orderby']) )
if( isset($_GET['usercount']) )
echo 'Prev, ';
else
echo 'Prev, ';
else
if( isset($_GET['usercount']) )
echo 'Prev, ';
else
echo 'Prev, ';
while ( $i <= $numpages ) {
if ($i == $currentpage ) {
echo "".$i."";
if ( $currentpage != $numpages )
echo ", "; }
elseif ( isset($_GET['orderby']) )
if( isset($_GET['usercount']) )
echo ''.$i.', ';
else
echo ''.$i.', ';
else
if( isset($_GET['usercount']) )
echo ''.$i.', ';
else
echo ''.$i.', ';
$i++;
}
if ( $currentpage == $numpages )
echo " ";
else
if ( isset($_GET['orderby']) )
if( isset($_GET['usercount']) )
echo 'Next';
else
echo 'Next';
else
if( isset($_GET['usercount']) )
echo 'Next';
else
echo 'Next';
}
function bb_memberlist_link() {
echo apply_filters('bb_memberlist_link', bb_get_memberlist_link() );
}
function bb_get_memberlist_link( $tag = '' ) {
if ( bb_get_option('mod_rewrite') )
$r = bb_get_option('uri') . "mlist/" . ( '' != $tag ? "?$tag" : '' );
else
$r = bb_get_option('uri') . "mlist.php" . ( '' != $tag ? "?$tag" : '' );
return apply_filters( 'get_memberlist_link', $r );
}
function bb_mlist_get_name_order_link() {
if ( isset($_GET['orderby']) && $_GET['orderby'] == 'user_login') :
if( isset($_GET['usercount']) )
echo bb_get_memberlist_link("usercount=".$_GET['usercount']."&orderby=user_login DESC");
else
echo bb_get_memberlist_link("orderby=user_login DESC");
else :
if( isset($_GET['usercount']) )
echo bb_get_memberlist_link("usercount=".$_GET['usercount']."&orderby=user_login");
else
echo bb_get_memberlist_link("orderby=user_login");
endif;
}
function bb_mlist_get_date_order_link() {
if ( isset($_GET['orderby']) && $_GET['orderby'] == 'user_registered') :
if( isset($_GET['usercount']) )
echo bb_get_memberlist_link("usercount=".$_GET['usercount']."&orderby=user_registered DESC");
else
echo bb_get_memberlist_link("orderby=user_registered DESC");
else :
if( isset($_GET['usercount']) )
echo bb_get_memberlist_link("usercount=".$_GET['usercount']."&orderby=user_registered");
else
echo bb_get_memberlist_link("orderby=user_registered");
endif;
}
function bb_mlist_get_postcount_order_link() {
if( isset($_GET['usercount']) )
echo bb_get_memberlist_link("usercount=".$_GET['usercount']."&orderby=postcount");
else
echo bb_get_memberlist_link("orderby=postcount");
}
function bb_mlist_delete_users() {
global $bbdb, $bb;
$tode = $_POST["todel"];
if ( isset($tode) ) {
foreach ( $tode as $d ) :
if ( $bb->wp_table_prefix )
$delteeded = $bbdb->query("DELETE FROM ".$bb->wp_table_prefix."users WHERE ID = $d");
else
$delteeded = $bbdb->query("UPDATE $bbdb->users SET user_status = 1 WHERE ID = $d");
endforeach; }
}
function bb_mlist_count_users() {
global $bbdb, $bb;
if ( $bb->wp_table_prefix )
return $bbdb->query("SELECT * FROM ".$bb->wp_table_prefix."users WHERE user_status = 0");
else
return $bbdb->query("SELECT * FROM $bbdb->users WHERE user_status = 0");
}
function mlist_is_selected($usercount, $selectvalue){
if( $usercount == $selectvalue )
echo 'selected="selected"';
else
echo '';
}
?>