CSmile::getById

static function getById($id, $lang = LANGUAGE_ID)
{
	global $DB;

	$id = intval($id);
	$arResult = Array();

	$strSql = "
		SELECT s.*, sl.NAME, sl.LID
		FROM b_smile s
		LEFT JOIN b_smile_lang sl ON sl.TYPE = '".self::TYPE_SMILE."' AND sl.SID = s.ID".($lang !== false? " AND sl.LID = '".$DB->ForSql(htmlspecialcharsbx($lang))."'": "")."
		WHERE s.ID = ".$id."";
	$res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);

	if ($lang !== self::GET_ALL_LANGUAGE)
	{
		$arResult = $res->GetNext(true, false);
		unset($arResult['LID']);
	}
	else
	{
		while ($row = $res->GetNext(true, false))
		{
			if (empty($arResult))
			{
				$arResult = $row;
				$arResult['NAME'] = Array();
				unset($arResult['LID']);
			}
			$arResult['NAME'][$row['LID']] = $row['NAME'];
		}
	}
	return $arResult;
}