CAllForumUser::GetByUSER_IDEx

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

	$USER_ID = intval($USER_ID);
	$strSql =
		"SELECT F_USER.*, 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,n ".
			"	FU.INTERESTS, FU.HIDE_FROM_ONLINE, FU.SUBSC_GROUP_MESSAGE, FU.SUBSC_GET_MY_MESSAGE,n ".
			"	FU.LAST_POST, FU.ALLOW_POST, FU.SIGNATURE, FU.RANK_ID, FU.POINTS,n ".
			"	".$DB->DateToCharFunction("FU.DATE_REG", "SHORT")." as DATE_REG,n ".
			"	".$DB->DateToCharFunction("FU.LAST_VISIT", "FULL")." as LAST_VISIT,n ".
			"	U.EMAIL, U.NAME, U.SECOND_NAME, U.LAST_NAME, U.LOGIN, U.PERSONAL_BIRTHDATE,n ".
			"	U.PERSONAL_ICQ, U.PERSONAL_WWW, U.PERSONAL_PROFESSION,n ".
			"	U.PERSONAL_CITY, U.PERSONAL_COUNTRY, U.EXTERNAL_AUTH_ID, U.PERSONAL_PHOTO, U.PERSONAL_GENDER,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_forum_user FU n".
		" INNER JOIN b_user U ON (FU.USER_ID = U.ID) n".
		" LEFT JOIN ( n".
		"	 SELECT FM.AUTHOR_ID, MAX(FM.ID) AS LAST_MESSAGE_ID, COUNT(FM.ID) AS CNT n".
		"	 FROM b_forum_message FM n".
		"	 WHERE (FM.AUTHOR_ID = ".$USER_ID." AND FM.APPROVED = 'Y') n".
		"	 GROUP BY FM.AUTHOR_ID n".
		"	) F_USER ON (F_USER.AUTHOR_ID = FU.USER_ID) n".
		" WHERE (FU.USER_ID = ".$USER_ID.")";
	$db_res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);

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