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

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
        )

) 

$rsSites = CSite::GetByID(SITE_ID); 
 

 "CONDITION" => "#^/catalog/categoria/([a-zA-Z0-9_]+)/([a-zA-Z0-9_]+)/(.*)#",
      "RULE" => "CATEGORIA=$1&AUTO=$2",
      "ID" => "bitrix:catalog",
      "PATH" => "/catalog/categoria/list.php",

<?$APPLICATION->IncludeComponent(
   "bitrix:main.include",   
   "",   
   Array(
      "AREA_FILE_SHOW" => "file",
      "PATH" => SITE_DIR."include/schools.php",//тут путь к вашему файлу
      "AREA_FILE_RECURSIVE" => "N",
      "EDIT_MODE" => "html",
   ),
   false,
   Array('HIDE_ICONS' => 'Y')
);?>
 

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']);
    }
}?>