';
for($i = 0; $i < count($mode_types_text); $i++)
{
	$selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
	$select_sort_mode .= '' . $mode_types_text[$i] . '';
}
$select_sort_mode .= '';

$select_sort_order = '<select name="order"><option value="ASC" selected="selected">' . $lang['Sort_Ascending'] . '</option><option value="DESC">' . $lang['Sort_Descending'] . '</option><option value="ASC">' . $lang['Sort_Ascending'] . '</option><option value="DESC" selected="selected">' . $lang['Sort_Descending'] . '</option></select>';
//
// Generate page
//
$page_title = $lang['Memberlist'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template-&gt;set_filenames(array( 'body' =&gt; 'memberlist_body.tpl')
);
make_jumpbox('viewforum.'.$phpEx);
$template-&gt;assign_vars(array( 'L_SELECT_SORT_METHOD' =&gt;
$lang['Select_sort_method'], 'L_EMAIL' =&gt; $lang['Email'],
'L_WEBSITE' =&gt; $lang['Website'], 'L_FROM' =&gt; $lang['Location'],
'L_ORDER' =&gt; $lang['Order'], 'L_SORT' =&gt; $lang['Sort'],
'L_SUBMIT' =&gt; $lang['Sort'], 'L_AIM' =&gt; $lang['AIM'], 'L_YIM'
=&gt; $lang['YIM'], 'L_MSNM' =&gt; $lang['MSNM'], 'L_ICQ' =&gt;
$lang['ICQ'], 'L_JOINED' =&gt; $lang['Joined'], 'L_POSTS' =&gt;
$lang['Posts'], 'S_MODE_SELECT' =&gt; $select_sort_mode,
'S_ORDER_SELECT' =&gt; $select_sort_order, 'S_MODE_ACTION' =&gt;
append_sid("memberlist.$phpEx"))
);
if ( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{ $mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode']
: $HTTP_GET_VARS['mode']; switch( $mode ) { case 'joindate': $order_by
= "user_regdate ASC 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 DESC LIMIT 10"; break; default: $order_by = "user_regdate
$sort_order LIMIT $start, " . $board_config['topics_per_page']; break;
}
}
else
{ $order_by = "user_regdate $sort_order LIMIT $start, " .
$board_config['topics_per_page'];
}
$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
FROM " . USERS_TABLE . " WHERE user_id &lt;&gt; " . ANONYMOUS . " ORDER
BY $order_by";
if( !($result = $db-&gt;sql_query($sql)) )
{ message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__,
__FILE__, $sql);
}
if ( $row = $db-&gt;sql_fetchrow($result) )
{ $i = 0; do { $username = $row['username']; $user_id =
$row['user_id']; $from = ( !empty($row['user_from']) ) ?
$row['user_from'] : '&nbsp;'; $joined =
create_date($lang['DATE_FORMAT'], $row['user_regdate'],
$board_config['board_timezone']); $posts = ( $row['user_posts'] ) ?
$row['user_posts'] : 0; $poster_avatar = ''; if (
$row['user_avatar_type'] &amp;&amp; $user_id != ANONYMOUS &amp;&amp;
$row['user_allowavatar'] ) { switch( $row['user_avatar_type'] ) { case
USER_AVATAR_UPLOAD: $poster_avatar = (
$board_config['allow_avatar_upload'] ) ? '<img src="%27%20.%20$board_config%5B%27avatar_path%27%5D%20.%20%27/%27%20.%20$row%5B%27user_avatar%27%5D%20.%20%27" alt="" border="0">' : '';
					break;
				case USER_AVATAR_REMOTE:
					$poster_avatar = ( $board_config['allow_avatar_remote'] ) ? '<img src="%27%20.%20$row%5B%27user_avatar%27%5D%20.%20%27" alt="" border="0">' : '';
					break;
				case USER_AVATAR_GALLERY:
					$poster_avatar = ( $board_config['allow_avatar_local'] ) ? '<img src="%27%20.%20$board_config%5B%27avatar_gallery_path%27%5D%20.%20%27/%27%20.%20$row%5B%27user_avatar%27%5D%20.%20%27" alt="" border="0">'
: ''; break; } } if ( !empty($row['user_viewemail']) ||
$userdata['user_level'] == ADMIN ) { $email_uri = (
$board_config['board_email_form'] ) ?
append_sid("profile.$phpEx?mode=email&amp;" . POST_USERS_URL .'=' .
$user_id) : 'mailto:' . $row['user_email']; $email_img = '<a href="%27%20.%20$email_uri%20.%20%27"><img src="%27%20.%20$images%5B%27icon_email%27%5D%20.%20%27" alt="' . $lang['Send_email'] . '" title="' . $lang['Send_email'] . '" border="0"></a>';
			$email = '<a href="%27%20.%20$email_uri%20.%20%27">' . $lang['Send_email'] . '</a>';
		}
		else
		{
			$email_img = '&nbsp;';
			$email = '&nbsp;';
		}

		$temp_url = append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$user_id");
		$profile_img = '<a href="%27%20.%20$temp_url%20.%20%27"><img src="%27%20.%20$images%5B%27icon_profile%27%5D%20.%20%27" alt="' . $lang['Read_profile'] . '" title="' . $lang['Read_profile'] . '" border="0"></a>';
		$profile = '<a href="%27%20.%20$temp_url%20.%20%27">' . $lang['Read_profile'] . '</a>';

		$temp_url = append_sid("privmsg.$phpEx?mode=post&amp;" . POST_USERS_URL . "=$user_id");
		$pm_img = '<a href="%27%20.%20$temp_url%20.%20%27"><img src="%27%20.%20$images%5B%27icon_pm%27%5D%20.%20%27" alt="' . $lang['Send_private_message'] . '" title="' . $lang['Send_private_message'] . '" border="0"></a>';
		$pm = '<a href="%27%20.%20$temp_url%20.%20%27">' . $lang['Send_private_message'] . '</a>';

		$www_img = ( $row['user_website'] ) ? '<a href="%27%20.%20$row%5B%27user_website%27%5D%20.%20%27" target="_userwww"><img src="%27%20.%20$images%5B%27icon_www%27%5D%20.%20%27" alt="' . $lang['Visit_website'] . '" title="' . $lang['Visit_website'] . '" border="0"></a>' : '';
		$www = ( $row['user_website'] ) ? '<a href="%27%20.%20$row%5B%27user_website%27%5D%20.%20%27" target="_userwww">' . $lang['Visit_website'] . '</a>' : '';

		if ( !empty($row['user_icq']) )
		{
			$icq_status_img = '<a href="http://wwp.icq.com/%27%20.%20$row%5B%27user_icq%27%5D%20.%20%27#pager"><img src="http://web.icq.com/whitepages/online?icq=%27%20.%20$row%5B%27user_icq%27%5D%20.%20%27&amp;img=5" border="0" height="18" width="18"></a>';
			$icq_img = '<a href="http://wwp.icq.com/scripts/search.dll?to=%27%20.%20$row%5B%27user_icq%27%5D%20.%20%27"><img src="%27%20.%20$images%5B%27icon_icq%27%5D%20.%20%27" alt="' . $lang['ICQ'] . '" title="' . $lang['ICQ'] . '" border="0"></a>';
			$icq =  '<a href="http://wwp.icq.com/scripts/search.dll?to=%27%20.%20$row%5B%27user_icq%27%5D%20.%20%27">' . $lang['ICQ'] . '</a>';
		}
		else
		{
			$icq_status_img = '';
			$icq_img = '';
			$icq = '';
		}

		$aim_img = ( $row['user_aim'] ) ? '<a href="aim:goim?screenname=%27%20.%20$row%5B%27user_aim%27%5D%20.%20%27&amp;message=Hello+Are+you+there?"><img src="%27%20.%20$images%5B%27icon_aim%27%5D%20.%20%27" alt="' . $lang['AIM'] . '" title="' . $lang['AIM'] . '" border="0"></a>' : '';
		$aim = ( $row['user_aim'] ) ? '<a href="aim:goim?screenname=%27%20.%20$row%5B%27user_aim%27%5D%20.%20%27&amp;message=Hello+Are+you+there?">' . $lang['AIM'] . '</a>' : '';

		$temp_url = append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$user_id");
		$msn_img = ( $row['user_msnm'] ) ? '<a href="%27%20.%20$temp_url%20.%20%27"><img src="%27%20.%20$images%5B%27icon_msnm%27%5D%20.%20%27" alt="' . $lang['MSNM'] . '" title="' . $lang['MSNM'] . '" border="0"></a>' : '';
		$msn = ( $row['user_msnm'] ) ? '<a href="%27%20.%20$temp_url%20.%20%27">' . $lang['MSNM'] . '</a>' : '';

		$yim_img = ( $row['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=%27%20.%20$row%5B%27user_yim%27%5D%20.%20%27&amp;.src=pg"><img src="%27%20.%20$images%5B%27icon_yim%27%5D%20.%20%27" alt="' . $lang['YIM'] . '" title="' . $lang['YIM'] . '" border="0"></a>' : '';
		$yim = ( $row['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=%27%20.%20$row%5B%27user_yim%27%5D%20.%20%27&amp;.src=pg">' . $lang['YIM'] . '</a>' : '';

		$temp_url = append_sid("search.$phpEx?search_author=" . urlencode($username) . "&amp;showresults=posts");
		$search_img = '<a href="%27%20.%20$temp_url%20.%20%27"><img src="%27%20.%20$images%5B%27icon_search%27%5D%20.%20%27" alt="' . $lang['Search_user_posts'] . '" title="' . $lang['Search_user_posts'] . '" border="0"></a>';
		$search = '<a href="%27%20.%20$temp_url%20.%20%27">' . $lang['Search_user_posts'] . '</a>';
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
$template-&gt;assign_block_vars('memberrow', array( 'ROW_NUMBER' =&gt;
$i + ( $HTTP_GET_VARS['start'] + 1 ), 'ROW_COLOR' =&gt; '#' .
$row_color, 'ROW_CLASS' =&gt; $row_class, 'USERNAME' =&gt; $username,
'FROM' =&gt; $from, 'JOINED' =&gt; $joined, 'POSTS' =&gt; $posts,
'AVATAR_IMG' =&gt; $poster_avatar, 'PROFILE_IMG' =&gt; $profile_img,
'PROFILE' =&gt; $profile, 'SEARCH_IMG' =&gt; $search_img, 'SEARCH'
=&gt; $search, 'PM_IMG' =&gt; $pm_img, 'PM' =&gt; $pm, 'EMAIL_IMG'
=&gt; $email_img, 'EMAIL' =&gt; $email, 'WWW_IMG' =&gt; $www_img, 'WWW'
=&gt; $www, 'ICQ_STATUS_IMG' =&gt; $icq_status_img, 'ICQ_IMG' =&gt;
$icq_img, 'ICQ' =&gt; $icq, 'AIM_IMG' =&gt; $aim_img, 'AIM' =&gt; $aim,
'MSN_IMG' =&gt; $msn_img, 'MSN' =&gt; $msn, 'YIM_IMG' =&gt; $yim_img,
'YIM' =&gt; $yim, 'U_VIEWPROFILE' =&gt;
append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL .
"=$user_id")) ); $i++; } while ( $row = $db-&gt;sql_fetchrow($result)
);
}
if ( $mode != 'topten' || $board_config['topics_per_page'] &lt; 10 )
{ $sql = "SELECT count(*) AS total FROM " . USERS_TABLE . " WHERE
user_id &lt;&gt; " . ANONYMOUS; if ( !($result =
$db-&gt;sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error getting
total users', '', __LINE__, __FILE__, $sql); } if ( $total =
$db-&gt;sql_fetchrow($result) ) { $total_members = $total['total'];
$pagination =
generate_pagination("memberlist.$phpEx?mode=$mode&amp;order=$sort_order",
$total_members, $board_config['topics_per_page'], $start). '&nbsp;'; }
}
else
{ $pagination = '&nbsp;'; $total_members = 10;
}
$template-&gt;assign_vars(array( 'PAGINATION' =&gt; $pagination,
'PAGE_NUMBER' =&gt; sprintf($lang['Page_of'], ( floor( $start /
$board_config['topics_per_page'] ) + 1 ), ceil( $total_members /
$board_config['topics_per_page'] )), 'L_GOTO_PAGE' =&gt;
$lang['Goto_page'])
);
$template-&gt;pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?&gt;