- Модуль: main
- Путь к файлу: ~/bitrix/modules/main/classes/general/file.php
- Класс: CFile
- Вызов: CFile::GetFromDb
static function GetFromDb($fileId, $realId)
{
global $DB;
$strSql = "
SELECT f.*,
{$DB->DateToCharFunction("f.TIMESTAMP_X")} as TIMESTAMP_X,
'' as VERSION_ORIGINAL_ID, '' as META
FROM b_file f
WHERE f.ID = {$fileId}
";
if ($realId !== true)
{
$strSql .= "
UNION
SELECT f.*,
{$DB->DateToCharFunction("f.TIMESTAMP_X")} as TIMESTAMP_X,
fv.ORIGINAL_ID as VERSION_ORIGINAL_ID, fv.META as META
FROM b_file f
INNER JOIN b_file_version fv ON fv.VERSION_ID = f.ID
WHERE fv.ORIGINAL_ID = {$fileId}
ORDER BY ID DESC
LIMIT 1
";
}
return $DB->Query($strSql);
}