CMedialibItem::GetList

static function GetList($Params)
{
	global $DB;

	$q = '';
	if (is_array($Params['arCollections'] ?? null))
	{
		if (count($Params['arCollections']) == 1)
		{
			$q = 'WHERE MCI.COLLECTION_ID='.intval($Params['arCollections'][0]);
		}
		elseif (count($Params['arCollections']) > 1)
		{
			$strCollections = "0";
			for($i = 0, $l = count($Params['arCollections']); $i < $l; $i++)
				$strCollections .= ",".intval($Params['arCollections'][$i]);
			$q = 'WHERE MCI.COLLECTION_ID in ('.$strCollections.')';
		}
	}

	if (isset($Params['id']) && $Params['id'] > 0)
		$q = 'WHERE MI.ID='.intval($Params['id']);

	if (isset($Params['minId']) && $Params['minId'] > 0)
	{
		if ($q <> '')
			$q = trim($q)." AND MI.ID>=".intval($Params['minId']);
		else
			$q .= "WHERE MI.ID>=".intval($Params['minId']);
	}

	$err_mess = CMedialibCollection::GetErrorMess()."
Function: CMedialibItem::GetList
Line: ";
	$strSql = "SELECT
				MI.*,MCI.COLLECTION_ID, F.HEIGHT, F.WIDTH, F.FILE_SIZE, F.CONTENT_TYPE, F.SUBDIR, F.FILE_NAME, F.HANDLER_ID,
				".$DB->DateToCharFunction("MI.DATE_UPDATE")." as DATE_UPDATE2
			FROM b_medialib_collection_item MCI
			INNER JOIN b_medialib_item MI ON (MI.ID=MCI.ITEM_ID)
			INNER JOIN b_file F ON (F.ID=MI.SOURCE_ID) ".$q;

	$res = $DB->Query($strSql, false, $err_mess);
	$arResult = Array();
	$rootPath = CSite::GetSiteDocRoot(false);
	$tmbW = COption::GetOptionInt('fileman', "ml_thumb_width", 140);
	$tmbH = COption::GetOptionInt('fileman', "ml_thumb_height", 105);

	while($arRes = $res->Fetch())
	{
		CMedialibItem::GenerateThumbnail($arRes, array('rootPath' => $rootPath, 'width' => $tmbW, 'height' => $tmbH));
		$arRes['PATH'] = CFile::GetFileSRC($arRes, false, false);
		$arRes['PATH_EXTERNAL'] = CFile::GetFileSRC($arRes, false, true);
		$arResult[]=$arRes;
	}

	return $arResult;
}