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