Последние сообщения блогов

$arColumns = array(
   "NAME" => GetMessage("SBB_BNAME"),
   "DISCOUNT" => GetMessage("SBB_BDISCOUNT"),
   "WEIGHT" => GetMessage("SBB_BWEIGHT"),
   "PROPS" => GetMessage("SBB_BPROPS"),
   "DELETE" => GetMessage("SBB_BDELETE"),
   "DELAY" => GetMessage("SBB_BDELAY"),
   "TYPE" => GetMessage("SBB_BTYPE"),
   "PRICE" => GetMessage("SBB_BPRICE"),
   "QUANTITY" => GetMessage("SBB_BQUANTITY"),
   "SUM" => GetMessage("SBB_BSUM")
);
if (Loader::includeModule('catalog'))
{
   $arIblockIDs = array();
   $arIblockNames = array();
   $catalogIterator = Catalog\CatalogIblockTable::getList(array(
      'select' => array('IBLOCK_ID', 'NAME' => 'IBLOCK.NAME'),
      'order' => array('IBLOCK_ID' => 'ASC')
   ));
   while ($catalog = $catalogIterator->fetch())
   {
      $catalog['IBLOCK_ID'] = (int)$catalog['IBLOCK_ID'];
      $arIblockIDs[] = $catalog['IBLOCK_ID'];
      $arIblockNames[$catalog['IBLOCK_ID']] = $catalog['NAME'];
   }
   unset($catalog, $catalogIterator);


   if (!empty($arIblockIDs))
   {
      $arProps = array();
      $propertyIterator = Iblock\PropertyTable::getList(array(
         'select' => array('ID', 'CODE', 'NAME', 'IBLOCK_ID'),
         'filter' => array('@IBLOCK_ID' => $arIblockIDs, '=ACTIVE' => 'Y', '!=XML_ID' => CIBlockPropertyTools::XML_SKU_LINK),
         'order' => array('IBLOCK_ID' => 'ASC', 'SORT' => 'ASC', 'ID' => 'ASC')
      ));
      while ($property = $propertyIterator->fetch())
      {
         $property['ID'] = (int)$property['ID'];
         $property['IBLOCK_ID'] = (int)$property['IBLOCK_ID'];
         $property['CODE'] = (string)$property['CODE'];
         if ($property['CODE'] == '')
            $property['CODE'] = $property['ID'];
         if (!isset($arProps[$property['CODE']]))
         {
            $arProps[$property['CODE']] = array(
               'CODE' => $property['CODE'],
               'TITLE' => $property['NAME'].' ['.$property['CODE'].']',
               'ID' => array($property['ID']),
               'IBLOCK_ID' => array($property['IBLOCK_ID'] => $property['IBLOCK_ID']),
               'IBLOCK_TITLE' => array($property['IBLOCK_ID'] => $arIblockNames[$property['IBLOCK_ID']]),
               'COUNT' => 1
            );
         }
         else
         {
            $arProps[$property['CODE']]['ID'][] = $property['ID'];
            $arProps[$property['CODE']]['IBLOCK_ID'][$property['IBLOCK_ID']] = $property['IBLOCK_ID'];
            if ($arProps[$property['CODE']]['COUNT'] < 2)
               $arProps[$property['CODE']]['IBLOCK_TITLE'][$property['IBLOCK_ID']] = $arIblockNames[$property['IBLOCK_ID']];
            $arProps[$property['CODE']]['COUNT']++;
         }
      }
      unset($property, $propertyIterator, $arIblockNames, $arIblockIDs);


      $propList = array();
      foreach ($arProps as &$property)
      {
         $iblockList = '';
         if ($property['COUNT'] > 1)
         {
            $iblockList = ($property['COUNT'] > 2 ? ' ( ... )' : ' ('.implode(', ', $property['IBLOCK_TITLE']).')');
         }
         $propList['PROPERTY_'.$property['CODE']] = $property['TITLE'].$iblockList;
      }
      unset($property, $arProps);


      if (!empty($propList))
         $arColumns = array_merge($arColumns, $propList);
      unset($propList);
   }
}
$arTemplateParameters["COLUMNS_LIST"] = array(
   "NAME"=>GetMessage("SBB_COLUMNS_LIST"),
   "TYPE"=>"LIST",
   "MULTIPLE"=>"Y",
   "VALUES"=>$arColumns,
   "DEFAULT"=>array("NAME", "PRICE", "TYPE", "DISCOUNT", "QUANTITY", "DELETE", "DELAY", "WEIGHT"),
   "COLS"=>25,
   "SIZE"=>7,
   "ADDITIONAL_VALUES"=>"N",
   "PARENT" => "VISUAL",
   'REFRESH' => 'Y',
);

$arrColumn = array();
foreach($arCurrentValues["COLUMNS_LIST"] as $id=>$code){
   $arrColumn[$code] = $arColumns[$code];
}
foreach($arCurrentValues["COLUMNS_LIST"] as $id=>$val){
   $arTemplateParameters['COLUMN_SORT'.$id] = array(
      'NAME' => GetMessage('COLUMN_NAME').($id+1),
      'TYPE' => 'LIST',
      'VALUES' => $arrColumn,
      "PARENT" => "VISUAL",
   );
}

$newArrHeaders = array();
foreach($arResult["GRID"]["HEADERS"] as $k=>$arHeader){
   $new_id = array_search ($arParams["COLUMN_SORT".$k], $arParams["COLUMNS_LIST"]);
   $newArrHeaders[] = $arResult["GRID"]["HEADERS"][$new_id];
}
ksort($newArrHeaders);
$arResult["GRID"]["HEADERS"] = $newArrHeaders;

//Handle case when ELEMENT_CODE used
if($arParams["ELEMENT_ID"] <= 0)
    $arParams["ELEMENT_ID"] = CIBlockFindTools::GetElementID(
        $arParams["ELEMENT_ID"],
        $arParams["~ELEMENT_CODE"],
        false,
        $arFilter["SECTION_CODE"],
        $arFilter
    );

if ($arParams["STRICT_SECTION_CHECK"])
{
   if ($arParams["SECTION_ID"] > 0)
   {
      $arFilter["SECTION_ID"] = $arParams["SECTION_ID"];
   }
   elseif (strlen($arParams["~SECTION_CODE"]) > 0)
   {
      $arFilter["SECTION_CODE"] = $arParams["~SECTION_CODE"];
   }
   elseif ($this->getParent() && strpos($arParams["DETAIL_URL"], "#SECTION_CODE_PATH#") !== false)
   {
      $this->abortResultCache();
      Iblock\Component\Tools::process404(
         trim($arParams["MESSAGE_404"]) ?: GetMessage("T_NEWS_DETAIL_NF")
         ,true
         ,$arParams["SET_STATUS_404"] === "Y"
         ,$arParams["SHOW_404"] === "Y"
         ,$arParams["FILE_404"]
      );
      return 0;
   }
}

//Handle case when ELEMENT_CODE used
if($arParams["ELEMENT_ID"] <= 0)
    $arParams["ELEMENT_ID"] = CIBlockFindTools::GetElementID(
        $arParams["ELEMENT_ID"],
        $arParams["~ELEMENT_CODE"],
        (isset($arFilter["SECTION_ID"])?$arFilter["SECTION_ID"]:false),
        (isset($arFilter["SECTION_CODE"])?$arFilter["SECTION_CODE"]:false),
        $arFilter
    );

<?$APPLICATION->IncludeComponent(
   "dev2fun:news.detail",
   "",
   Array()
);?>

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

<?php
 
use Bitrix\Main\Application;
use Bitrix\Main\Entity\ExpressionFieldd;
 
require($_SERVER['DOCUMENT_ROOT'] . '/bitrix/header.php');
 
Application::getConnection(SampleTable::getConnectionName())->startTracker(true);

 
$iterator = SampleTable::getList([
    'select' => [
        '*',
        new ExpressionField('weight', 'WEIGHT()'),
    ],
    'match' => 'книга',
    'filter' => [
        '=available' => 1,
    ],
    'count_total' => true,
    'offset' => 0,
    'limit' => 10,
    'order' => [
        'weight' => 'DESC',
    ],
    'option' => [
        'max_matches' => 50000,
    ],
]);

 
echo '<pre>';print_r($iterator->getTrackerQuery()->getSql());echo '</pre>';
 
echo '<pre>';print_r($iterator->fetchAll());echo '</pre>';