Чебан Валерий: Сообщения

LoadModule evasive2_module modules/mod_evasive2.so

<IfModule evasive2_module>
    DOSDisplayToken Off
    DOSHashTableSize 3097
    DOSPageCount 2
    DOSSiteCount 50
    DOSPageInterval 1
    DOSSiteInterval 1
    DOSBlockingPeriod 10
    DOSLogDir "<Your-dir>Apache/logs"
    DOSWhitelist 127.0.0.1
    DOSWhitelist 192.168.1.*
</IfModule>

cat /var/log/httpd/access_log | awk ' {print $1}' | sort | uniq -c | sort -n | tail -n 10

cat /var/log/httpd/access_log | grep 5.255.253.63 | head -1

d:\server\Apache\bin>ab -n 5000 -c 10 -s 300 -k http://***********:80**/w***h/m*****************i/

Usage: ab [options] [http://]hostname[:port]/path
Options are:
    -n requests     Number of requests to perform
    -c concurrency Number of multiple requests to make at a time
    -s timeout      Seconds to max. wait for each response
                    Default is 30 seconds
    -k              Use HTTP KeepAlive feature
…  

// \bitrix\components\bitrix\blog.blog\component.php
   global ${$arParams["FILTER_NAME"]};
   $arFilter = $$arParams["FILTER_NAME"]; // ошибка php7:
   if(!is_array($arFilter))
      $arFilter = array();

[ParseError] 
syntax error, unexpected '[', expecting ',' or ';' (0)

// \bitrix\components\bitrix\blog.blog\component.php   
   global ${$arParams["FILTER_NAME"]};
   $arFilter = ${$arParams["FILTER_NAME"]};  // вот так мы явно указываем имя переменной
   if(!is_array($arFilter))
      $arFilter = array();

// дамп запроса на быструю руку
$showLastQuery = function ($queryBuilder) {
   echo '<h4>' . wordwrap($queryBuilder->getLastQuery(), 150) . "</h4>\n\n";
};


// инфоблок 1.0. Выбираем элемент и одно свойство, по нему делаем сортировку. 
// алиас поля делаем DOC_ID
use Bitrix\Iblock    as ib;
use Bitrix\Main    as bm;

$propertySelectAndSortId    = 30;
$propertyFieldName         = 'DOC_ID';

$queryBuilder = new bm\Entity\Query( ib\ElementTable::getEntity() );
$elC = $queryBuilder
         ->setSelect( array('NAME', 'ID', 'IBLOCK_ID', $propertyFieldName)  )
         ->registerRuntimeField($propertyFieldName, array(
            "data_type"   => '\Bitrix\Iblock\ElementPropertyTable',
            'reference'    => array('=this.ID' => 'ref.IBLOCK_ELEMENT_ID'),
         ))
         ->setFilter(array(
            'IBLOCK_ID' => 10, 
            'IBLOCK_ELEMENT_' . $propertyFieldName . '_IBLOCK_PROPERTY_ID' 
                                                      => $propertySelectAndSortId
         ))
         ->setOrder(  array('IBLOCK_ELEMENT_' . $propertyFieldName . '_VALUE' => 'ASC')  )
         ->exec()->fetchAll();

$showLastQuery( $queryBuilder );
echo count($elC);

xdebug_var_dump($elC); 

SEL ECT 
   `iblock_element`.`NAME` AS `NAME`,
   `iblock_element`.`ID` AS `ID`,
   `iblock_element`.`IBLOCK_ID` AS `IBLOCK_ID`,
   `iblock_element_doc_id`.`ID` AS `IBLOCK_ELEMENT_DOC_ID_ID`,
   `iblock_element_doc_id`.`IBLOCK_PROPERTY_ID` AS `IBLOCK_ELEMENT_DOC_ID_IBLOCK_PROPERTY_ID`,
   `iblock_element_doc_id`.`IBLOCK_ELEMENT_ID` AS `IBLOCK_ELEMENT_DOC_ID_IBLOCK_ELEMENT_ID`,
   `iblock_element_doc_id`.`VALUE` AS `IBLOCK_ELEMENT_DOC_ID_VALUE`,
   `iblock_element_doc_id`.`VALUE_TYPE` AS `IBLOCK_ELEMENT_DOC_ID_VALUE_TYPE`,
   `iblock_element_doc_id`.`VALUE_ENUM` AS `IBLOCK_ELEMENT_DOC_ID_VALUE_ENUM`,
   `iblock_element_doc_id`.`VALUE_NUM` AS `IBLOCK_ELEMENT_DOC_ID_VALUE_NUM`,
   `iblock_element_doc_id`.`DESCRIPTION` AS `IBLOCK_ELEMENT_DOC_ID_DESCRIPTION`
FR OM `b_iblock_element` `iblock_element` 
LEFT JOIN `b_iblock_element_property` `iblock_element_doc_id` ON `iblock_element`.`ID` = `iblock_element_doc_id`.`IBLOCK_ELEMENT_ID`
WHERE `iblock_element`.`IBLOCK_ID` = 10
AND `iblock_element_doc_id`.`IBLOCK_PROPERTY_ID` = 30
ORDER BY `iblock_element_doc_id`.`VALUE` ASC 

array(101) {
  [0]=>
  array(11) {
    ["NAME"]=>
    string(89) "БТ22 Организация защиты от закладочных устройств"
    ["ID"]=>
    string(3) "909"
    ["IBLOCK_ID"]=>
    string(2) "10"
    ["IBLOCK_ELEMENT_DOC_ID_ID"]=>
    string(6) "196316"
    ["IBLOCK_ELEMENT_DOC_ID_IBLOCK_PROPERTY_ID"]=>
    string(2) "30"
    ["IBLOCK_ELEMENT_DOC_ID_IBLOCK_ELEMENT_ID"]=>
    string(3) "909"
    ["IBLOCK_ELEMENT_DOC_ID_VALUE"]=>
    string(19) "5806196164056982304"
    ["IBLOCK_ELEMENT_DOC_ID_VALUE_TYPE"]=>
    string(4) "text"
    ["IBLOCK_ELEMENT_DOC_ID_VALUE_ENUM"]=>
    string(10) "2147483647"
    ["IBLOCK_ELEMENT_DOC_ID_VALUE_NUM"]=>
    string(19) "58061961640569.0000"
    ["IBLOCK_ELEMENT_DOC_ID_DESCRIPTION"]=>
    NULL
  } 
  // ....

AddEventHandler('main', 'OnBeforeProlog', function () {
   global $APPLICATION;
   if ($APPLICATION->GetCurPage() == '/bitrix/admin/perfmon_tables.php' && $_GET['orm'] != 'y') {
      LocalRedirect( $APPLICATION->GetCurPageParam("orm=y") );
   }
});