• Модуль: fileman
  • Путь к файлу: ~/bitrix/modules/fileman/classes/general/medialib.php
  • Класс: CMedialibItem
  • Вызов: CMedialibItem::DeleteEmpty
static function DeleteEmpty()
{
	global $DB;

	$strSql = 'SELECT MI.*,MCI.COLLECTION_ID
		FROM b_medialib_item MI
		LEFT JOIN b_medialib_collection_item MCI ON (MI.ID=MCI.ITEM_ID)
		WHERE MCI.COLLECTION_ID is null';
	$res = $DB->Query($strSql, false, "FILE: ".__FILE__."
LINE: ".__LINE__); $strItems = "0"; while($arRes = $res->Fetch()) { $strItems .= ",".intval($arRes['ID']); if ($arRes['SOURCE_ID'] > 0) // Clean from 'b_file' CFile::Delete(intval($arRes['SOURCE_ID'])); } // Clean from 'b_medialib_item' if ($strItems != "0") $DB->Query("DELETE FROM b_medialib_item WHERE ID in (".$strItems.")", false, "FILE: ".__FILE__."
LINE: ".__LINE__); }