<dl>
		<dt><label for="username">{L_USERNAME}:</label></dt>
		<dd><input type="text" name="username" id="username" value="{USERNAME}" class="inputbox" /></dd>
	</dl>

	<dl>
		<dt><label for="phpbb">phpBB:</label></dt>
		<dd><input type="text" name="phpbb" id="phpbb" value="" class="inputbox" /></dd>
	</dl>	

$search_params = array('username', 'email', 'icq', 'aim', 'yahoo', 'msn', 'jabber', 'search_group_id', 'joined_select', 'active_select', 'count_select', 'joined', 'active', 'count', 'ip');

'username',

 'phpbb',

$username	= request_var('username', '', true);

			$phpbb		= request_var('phpbb', '');

			$sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->any_char, utf8_clean_string($username))) : '';

			$sql_where .= ($phpbb) ? ' AND fd.pf_phpbb ' . $db->sql_like_expression(str_replace('*', $db->any_char, $phpbb)) . ' ' : '';

FROM ' . USERS_TABLE . " u$sql_from

FROM (' . USERS_TABLE . " u$sql_from) LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id)

FROM " . USERS_TABLE . " u
				$sql_from

FROM (" . USERS_TABLE . " u
                 $sql_from)
			LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id)