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