CSmileSet::getByStringId

static function getByStringId($stringId, $type = self::TYPE_SET, $lang = LANGUAGE_ID)
{
	global $DB;

	$arResult = Array();

	if (!in_array($type, Array(self::TYPE_SET, self::TYPE_GALLERY))) // for legacy
	{
		$lang = $type;
		$type = self::TYPE_SET;
	}

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

	if ($lang !== false)
	{
		$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;
}