- Модуль: main
- Путь к файлу: ~/bitrix/modules/main/classes/general/smile.php
- Класс: CSmileSet
- Вызов: CSmileSet::getById
static function getById($id, $lang = LANGUAGE_ID)
{
global $DB;
$id = intval($id);
$arResult = Array();
$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.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;
}