CAllForumUser::GetByLogin

static function GetByLogin($Name)
{
	global $DB;
	$Name = $DB->ForSql(trim($Name));
	if (
		isset($GLOBALS["FORUM_CACHE"]["USER_NAME"]) &&
		is_set($GLOBALS["FORUM_CACHE"]["USER_NAME"], $Name) &&
		is_array($GLOBALS["FORUM_CACHE"]["USER_NAME"][$Name]) &&
		is_set($GLOBALS["FORUM_CACHE"]["USER_NAME"][$Name], "ID"))
	{
		return $GLOBALS["FORUM_CACHE"]["USER_NAME"][$Name];
	}
	else
	{
		$strSql =
			"SELECT ID AS USER_ID
			FROM b_user
			WHERE LOGIN='".$Name."'";
		$db_res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
		$res = $db_res->Fetch();
		if (!empty($res["USER_ID"]))
		{
			$strSql =
				"SELECT FU.ID, FU.USER_ID, FU.SHOW_NAME, FU.DESCRIPTION, FU.IP_ADDRESS,
					FU.REAL_IP_ADDRESS, FU.AVATAR, FU.NUM_POSTS, FU.POINTS as NUM_POINTS,
					FU.INTERESTS, FU.HIDE_FROM_ONLINE, FU.SUBSC_GROUP_MESSAGE, FU.SUBSC_GET_MY_MESSAGE,
					FU.LAST_POST, FU.ALLOW_POST, FU.SIGNATURE, FU.RANK_ID, FU.POINTS,
					".$DB->DateToCharFunction("FU.DATE_REG", "SHORT")." as DATE_REG,
					".$DB->DateToCharFunction("FU.LAST_VISIT", "FULL")." as LAST_VISIT
				FROM b_forum_user FU
				WHERE FU.USER_ID = ".$res["USER_ID"];
			$db_res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
			if ($res = $db_res->Fetch())
			{
				$GLOBALS["FORUM_CACHE"]["USER"][$res["USER_ID"]] = $res;
				$GLOBALS["FORUM_CACHE"]["USER_NAME"][$Name] = $res;
				return $res;
			}
		}
	}

	return False;
}