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

global $arrFilter;
$arSubQuery = array("IBLOCK_ID" => 11);
$arSubQuery[">CATALOG_QUANTITY"]="100";
$arrFilter['ID'] = CIBlockElement::SubQuery('CML2_LINK', $arSubQuery);
 

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
 
}


index имя папки сами придумайте, у меня по названию сайта(site) 
{
   #main settings
   source         = art (это название настроек базы - см. выше source)
      type = rt
      path = /var/lib/sphinx/имя папки
      docinfo = inline
   #choose appropriate type of morphology to use
      #morphology = lemmatize_ru_all, lemmatize_en_all, lemmatize_de_all, stem_enru
      morphology = stem_enru, soundex
   #these settings are used by bitrix:search.title component
      dict = keywords
      prefix_fields = title
      infix_fields=
      min_prefix_len = 2
      enable_star = 1
   #all fields must be defined exactly as followed
      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
   #depends on settings of your site
      # uncomment for single byte character set
      charset_type = sbcs
      # uncomment for UTF character set
      #charset_type = utf-8
}

<? //при обращении из 1с идет запрос ['type']=='catalog'
AddEventHandler("iblock", "OnBeforeIBlockSectionUpdate","SaveMySection");
function SaveMySection(&$arFields)
{
    if ($_REQUEST['type']=='catalog')//импорт  из 1с? 
    {
         unset($arFields['IBLOCK_SECTION_ID']);
    }
}?>

$dbEl = CIBlockElement::GetList($arSortA, $arFilterA, false, $arPageA, $arSelectA);
   if($dbEl->SelectedRowsCount()>0){
      while($obEl = $dbEl->GetNextElement())   
      {
         $officeArr = $obEl->GetFields();
         $officeArr['PROPERTIES'] = $obEl->GetProperties();
         $res = CIBlockElement::GetList(array(), array("IBLOCK_ID"=>14, "ID"=>$officeArr["PROPERTIES"]["HOTEL"]["VALUE"]), false, false, array("NAME", "IBLOCK_SECTION_ID", "PROPERTY_MEALS", "PROPERTY_MEALS_W"));
         while($obRes = $res->GetNextElement())   {
            $arPurFields = $obRes -> GetFields();
         }
         
         $officeArr["PROPERTIES"]["HOTEL"]["OPIS"] = $arPurFields;
         $arResult["ITEM"][]=$officeArr;
      }
   }

if ($ar["CATALOG_GROUP_ID"]==1){$cp->Update($ar["ID"], $arPrice); $upolok1=true;}
elseif ($ar["CATALOG_GROUP_ID"]==2){$cp->Update($ar["ID"], $arPrice1);$upolok2=true;}
elseif ($ar["CATALOG_GROUP_ID"]==3){$cp->Update($ar["ID"], $arPrice2);$upolok3=true;}