Алексей Волков (Все сообщения пользователя)

$GLOBALS['custom_filter'] = array("PROPERTY_NAME_OF_PROPERTY"=>значение свойства); 

//$arFilterT = Array('IBLOCK_ID'=>18, 'ACTIVE_DATE'=>'Y', 'ACTIVE'=>'Y', 'PROPERTY_CODE_PARTS'=>$prishlo); //- время выполнения на 35000 эл:99,9сек
$arFilterT = Array('IBLOCK_ID'=>18, 'ACTIVE_DATE'=>'Y', 'ACTIVE'=>'Y',  array(
              "ID" => CIBlockElement::SubQuery("ID", array(
                "IBLOCK_ID" => 18,
                "PROPERTY_CODE_PARTS" => array($prishlo),
              ))
        ));//-время выполнения 3,1сек
 

<?
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php");
global $APPLICATION, $USER;
if(!is_object($USER)){
     $USER = new CUser();
}
$USER->Authorize(1);
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/footer.php");
?>
 

Ошибка подключения к серверу Sphinx:
Указанный индекс не найден.

indexer
{
   mem_limit      = 32M
}


searchd
{
        listen                  = 127.0.0.1:9312
   listen         = 9306:mysql41
   log         = /var/log/sphinx/searchd.log
   query_log      = /var/log/sphinx/query.log
   read_timeout      = 5
   max_children      = 30
   pid_file      = /var/run/sphinx/searchd.pid
   max_matches      = 1000
   seamless_rotate      = 1
   preopen_indexes      = 1
   unlink_old      = 1
   workers         = threads # for RT to work
   binlog_path      = /var/lib/sphinx
}



source art
{
   type         = mysql
   sql_host      = localhost
   sql_user      = ******
   sql_pass      = *******
   sql_db         = ******
   sql_port      = 3306   # optional, default is 3306
 
   sql_query_pre = SET NAMES utf8
   sql_query_pre = SET CHARACTER SET utf8
 
   sql_query      = \
      SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
      FROM documents
 
 
   sql_attr_uint      = group_id
   sql_attr_timestamp   = date_added
   sql_ranged_throttle   = 0
   sql_query_info      = SELECT * FROM documents WHERE id=$id
 
}

source trv
{
   type         = mysql
   sql_host      = localhost
   sql_user      = ****
   sql_pass      = ****
   sql_db         = ****
   sql_port      = 3306   # optional, default is 3306
 
   sql_query_pre = SET NAMES utf8
   sql_query_pre = SET CHARACTER SET utf8
 
   sql_query      = \
      SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
      FROM documents
 
 
   sql_attr_uint      = group_id
   sql_attr_timestamp   = date_added
   sql_ranged_throttle   = 0
   sql_query_info      = SELECT * FROM documents WHERE id=$id
 
}

index bitrix_art
{
   #main settings
   source         = art
      type = rt
      path = /var/lib/sphinx/bitrix_art
      docinfo = inline
      morphology = stem_enru, soundex
      dict = keywords
      prefix_fields = title
      infix_fields=
      min_prefix_len = 2
      enable_star = 1
      rt_field = title
      rt_field = body
      rt_attr_uint = module_id
      rt_attr_string = module
      rt_attr_uint = item_id
      rt_attr_string = item
      rt_attr_uint = param1_id
      rt_attr_string = param1
      rt_attr_uint = param2_id
      rt_attr_string = param2
      rt_attr_timestamp = date_change
      rt_attr_timestamp = date_to
      rt_attr_timestamp = date_from
      rt_attr_uint = custom_rank
      rt_attr_multi = tags
      rt_attr_multi = right
      rt_attr_multi = site
      rt_attr_multi = param
      charset_type = sbcs
}

index bitrix_trv
{
   #main settings
   source         = trv
      type = rt
      path = /var/lib/sphinx/bitrix_trv
      docinfo = inline
      morphology = stem_enru, soundex
      dict = keywords
      prefix_fields = title
      infix_fields=
      min_prefix_len = 2
      enable_star = 1
      rt_field = title
      rt_field = body
      rt_attr_uint = module_id
      rt_attr_string = module
      rt_attr_uint = item_id
      rt_attr_string = item
      rt_attr_uint = param1_id
      rt_attr_string = param1
      rt_attr_uint = param2_id
      rt_attr_string = param2
      rt_attr_timestamp = date_change
      rt_attr_timestamp = date_to
      rt_attr_timestamp = date_from
      rt_attr_uint = custom_rank
      rt_attr_multi = tags
      rt_attr_multi = right
      rt_attr_multi = site
      rt_attr_multi = param
      charset_type = sbcs
}
 

indexer --all --rotate
Sphinx 2.0.8-id64-release (r3831)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinx/sphinx.conf'...
skipping non-plain index 'bitrix_art'...
skipping non-plain index 'bitrix_trv'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
 

COption::SetOptionString("main","captcha_registration","N");//отключили капчу
COption::SetOptionString("main","new_user_registration_email_confirmation","N");//отключили подтверждение
$arResult = $USER->Register($_POST["mail"], "", "", $pas, $pas, $_POST["mail"]); //регистрируем и авторизуем
//далее включаем обратно 
COption::SetOptionString("main","captcha_registration","Y");
COption::SetOptionString("main","new_user_registration_email_confirmation","Y");
//ShowMessage($arResult); //все успешно
$USER_ID = $USER->GetID(); // тут мой индификатор, а не только что созданный
 

/air/PAGEN/2/?arFilter...

/air/?arFilter...

/air/section_code/?arFilter...  

/air/section_code/PAGEN/2/?arFilter...

foreach($_REQUEST["arrFilterO"] as $k=>$val){
      if (is_array($val)){
         foreach($val as $z){
            $arq[]=array(
               "ID" => CIBlockElement::SubQuery("ID", array(
                  "IBLOCK_ID" => $arParams['Other'],
                  "PROPERTY" => array($k=>$z),
               ))
            );
         }
      }else{
         $arq["PROPERTY"][$k]=$val;
      }
   }
   
   $dbElq = CIBlockElement::GetList(array(), array("IBLOCK_ID"=>$arParams['Other'], 'ACTIVE'=>'Y', $arq), false, false, array("ID"));
 

arrFilterO[WI_FI]=8534&arrFilterO[POOL][0]=8526&arrFilterO[POOL][1]=8525
 

"PROPERTY"=>$_REQUEST["arrFilterO"]
 

array(
              "ID" => CIBlockElement::SubQuery("ID", array(
                "IBLOCK_ID" => 14,
                "PROPERTY" => $_REQUEST["arrFilterO"],
              ))
        )

CPrice::Update($ar["ID"], $arPrice) 

$dbEl = CIBlockElement::GetList(array('sort' => 'asc'), array('IBLOCK_ID' => 6, 'ID'=>'15063'), false, false, Array("ID","NAME","XML_ID"));
if($dbEl->SelectedRowsCount()>0){
   while($obEl = $dbEl->GetNextElement())   
   {
      $Arr[] = $obEl->GetFields();
      
   }
}
 

Array
(
    [0] => Array
        (
            [ID] => 15063
            [~ID] => 15063
            [NAME] => Колодки тормозные передние HP1097 Hardron
            [~NAME] => Колодки тормозные передние HP1097 Hardron
            [XML_ID] => 1090
            [~XML_ID] => 1090
            [SORT] => 500
            [~SORT] => 500
        )

)