• Модуль: 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; }