Yeah, I’m a dork
for($i = 0; $i < count($mode_types_text); $i++)
{
$selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
$select_sort_mode .= '<option value="' . $mode_types[$i] . '"' . $selected . '>' . $mode_types_text[$i] . '</option>';
}
$select_sort_mode .= ‘</select>’;
$select_sort_order = ‘<select name=“order”>’;
if($sort_order == ‘ASC’)
{
$select_sort_order .= '<option value="ASC" selected="selected">' . $lang['Sort_Ascending'] . '</option><option value="DESC">' . $lang['Sort_Descending'] . '</option>';
}
else
{
$select_sort_order .= '<option value="ASC">' . $lang['Sort_Ascending'] . '</option><option value="DESC" selected="selected">' . $lang['Sort_Descending'] . '</option>';
}
$select_sort_order .= ‘</select>’;
//
// Generate page
//
$page_title = $lang[‘Memberlist’];
include($phpbb_root_path . ‘includes/page_header.’.$phpEx);
$template->set_filenames(array(
‘body’ => ‘memberlist_body.tpl’)
);
make_jumpbox(‘viewforum.’.$phpEx);
$template->assign_vars(array(
‘L_SELECT_SORT_METHOD’ => $lang[‘Select_sort_method’],
‘L_EMAIL’ => $lang[‘Email’],
‘L_WEBSITE’ => $lang[‘Website’],
‘L_FROM’ => $lang[‘Location’],
‘L_ORDER’ => $lang[‘Order’],
‘L_SORT’ => $lang[‘Sort’],
‘L_SUBMIT’ => $lang[‘Sort’],
‘L_AIM’ => $lang[‘AIM’],
‘L_YIM’ => $lang[‘YIM’],
‘L_MSNM’ => $lang[‘MSNM’],
‘L_ICQ’ => $lang[‘ICQ’],
// MOD RANK MEMBERLIST BEGIN
‘L_USER_RANK’ => $lang[‘Poster_rank’],
// MOD RANK MEMBERLIST END
‘L_JOINED’ => $lang[‘Joined’],
‘L_POSTS’ => $lang[‘Posts’],
‘L_PM’ => $lang[‘Private_Message’],
‘S_MODE_SELECT’ => $select_sort_mode,
‘S_ORDER_SELECT’ => $select_sort_order,
‘S_MODE_ACTION’ => append_sid(“memberlist.$phpEx”))
);
switch( $mode )
{
case 'joined':
$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'username':
$order_by = "username $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'location':
$order_by = "user_from $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'posts':
$order_by = "user_posts $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'email':
$order_by = "user_email $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'website':
$order_by = "user_website $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'topten':
$order_by = "user_posts $sort_order LIMIT 10";
break;
default:
$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
}
// MOD RANK MEMBERLIST BEGIN
$sql = “SELECT *
FROM ” . RANKS_TABLE . ”
ORDER BY rank_special, rank_min”;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not obtain ranks information.", '', __LINE__, __FILE__, $sql);
}
$ranksrow = array();
while ( $row = $db->sql_fetchrow($result) )
{
$ranksrow[] = $row;
}
$db->sql_freeresult($result);
// MOD RANK MEMBERLIST END
$sql = “SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_rank
FROM ” . USERS_TABLE . “
WHERE user_id <> ” . ANONYMOUS . “
ORDER BY $order_by”;
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
$i = 0;
do
{
$username = $row['username'];
$user_id = $row['user_id'];
$from = ( !empty($row['user_from']) ) ? $row['user_from'] : ' ';
$joined = create_date($lang['DATE_FORMAT'], $row['user_regdate'], $board_config['board_timezone']);
$posts = ( $row['user_posts'] ) ? $row['user_posts'] : 0;
// MOD RANK MEMBERLIST BEGIN
$user_rank = '';
$rank_image = '';
if ( $row['user_rank'] )
{
for($j = 0; $j < count($ranksrow); $j++)
{
if ( $row['user_rank'] == $ranksrow[$j]['rank_id'] && $ranksrow[$j]['rank_special'] )
{
$user_rank = $ranksrow[$j]['rank_title'];
$rank_image = ( $ranksrow[$j]['rank_image'] ) ? '
’ : ‘’;
}
}
}
else
{
for($j = 0; $j < count($ranksrow); $j++)
{
if ( $row['user_posts'] >= $ranksrow[$j]['rank_min'] && !$ranksrow[$j]['rank_special'] )
{
$user_rank = $ranksrow[$j]['rank_title'];
$rank_image = ( $ranksrow[$j]['rank_image'] ) ? '
’ : ‘’;
}
}
}
