• Модуль: security
  • Путь к файлу: ~/bitrix/modules/security/classes/general/site_checker.php
  • Класс: CSecuritySiteChecker
  • Вызов: CSecuritySiteChecker::getList
static function getList($pFilter = array(), $pMaxCount = 1)
{
	/** @global CDataBase $DB */
	global $DB;

	$sqlQuery = "SELECT RESULTS, ".$DB->DateToCharFunction("TEST_DATE", "SHORT")." TEST_DATE FROM ".self::$tableName;
	if (is_array($pFilter) && !empty($pFilter))
	{
		$sqlWhereQuery = array();
		foreach($pFilter as $key => $value)
		{
			if (is_string($value) && $value != "" && in_array($key, self::$dbFields))
			{
				$sqlWhereQuery[] = $key."='".$DB->ForSql($value)."'";
			}
		}
		if(!empty($sqlWhereQuery))
		{
			$sqlQuery .= " WHERE ".GetFilterSqlSearch($sqlWhereQuery);
		}
	}

	$sqlQuery .= " ORDER BY ID desc";
	$sqlQuery = $DB->TopSql($sqlQuery, $pMaxCount);
	$arResult = $DB->Query($sqlQuery, false, "FILE: ".__FILE__."
LINE: ".__LINE__); return $arResult; }