CAllForumUser::GetByIDEx

static function GetByIDEx($ID, $arAddParams = array())
{
	global $DB;
	$arAddParams = (is_array($arAddParams) ? $arAddParams : array($arAddParams));

	$ID = intval($ID);
	$strSql =
		"SELECT FU.ID, FU.USER_ID, FU.SHOW_NAME, FU.DESCRIPTION, FU.IP_ADDRESS,n ".
		"	FU.REAL_IP_ADDRESS, FU.AVATAR, FU.NUM_POSTS, FU.POINTS as NUM_POINTS, FU.INTERESTS,n ".
		"	FU.LAST_POST, FU.ALLOW_POST, FU.SIGNATURE, FU.RANK_ID,n ".
		"	U.EMAIL, U.NAME, U.SECOND_NAME, U.LAST_NAME, U.LOGIN, U.PERSONAL_BIRTHDATE,n ".
		"	".$DB->DateToCharFunction("FU.DATE_REG", "SHORT")." as DATE_REG,n ".
		"	".$DB->DateToCharFunction("FU.LAST_VISIT", "FULL")." as LAST_VISIT,n ".
		"	U.PERSONAL_ICQ, U.PERSONAL_WWW, U.PERSONAL_PROFESSION,n ".
		"	U.PERSONAL_CITY, U.PERSONAL_COUNTRY, U.EXTERNAL_AUTH_ID, U.PERSONAL_PHOTO,n ".
		"	U.PERSONAL_GENDER, FU.POINTS, FU.HIDE_FROM_ONLINE, FU.SUBSC_GROUP_MESSAGE, FU.SUBSC_GET_MY_MESSAGE,n ".
		"	".$DB->DateToCharFunction("U.PERSONAL_BIRTHDAY", "SHORT")." as PERSONAL_BIRTHDAY ".
		(array_key_exists("SHOW_ABC", $arAddParams) || in_array("SHOW_ABC", $arAddParams) ?
			", nt".CForumUser::GetFormattedNameFieldsForSelect(
				array_merge(
					$arAddParams,
					array(
						"sUserTablePrefix" => "U.",
						"sForumUserTablePrefix" => "FU.",
						"sFieldName" => "SHOW_ABC"),
					false
				)
			) : "")."n".
		" FROM b_user U, b_forum_user FU n".
		" WHERE FU.USER_ID = U.ID AND FU.ID = ".$ID." ";
	$db_res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);

	if ($res = $db_res->Fetch())
	{
		return $res;
	}
	return False;
}