Александр Мушников (Все сообщения пользователя)

global $DB;$event = $DB->ForSQL( $event );$lid     = $DB->ForSQL( $lid );$rsMessTpl = $DB->Query( "SEL ECT * FR OM b_event_message WHERE EVENT_NAME='$event' AND LID='$lid';" );

global $DB;$arr_result = array();$arr_items   = array();$event     = $DB->ForSQL( $event );$lid      = $DB->ForSQL( $lid );$str_sel     = "SELECT e.id, e.active, e.email_from, e.email_to, e.subject, e.message, e.body_type,";$str_sel     .= "e.bcc, e.reply_to, e.cc, e.in_reply_to, e.priority, e.field1_name, e.field1_value,";$str_sel     .= "e.field2_name, e.field2_value, s.site_id as lid";$str_sel     .= " FR OM b_event_message e, b_event_message_site s";$str_sel     .= " wh ere s.event_message_id = e.id and e.event_name='$event' and s.site_id='$lid';";$rsMessTpl = $DB->Query( $str_sel );

  ...
  jQuery.get(  '/bitrix/tools/ajax.php', 
            { 'name_startsWith':request.term },
             f unction(data) {
             e val("var result=" + data + ";");
             // здесь массив result содержит ваш переданный из скрипта массив
             // и если ваш PHP скрипт немного изменить в конце таким образом:
             // ...
             // echo json_encode( array( 'name' => $name  ) );
             // ...
             // то обращаться к элементам массива можно будет как-то так:
             for( var i=0; i < result[ 'name' ].length; i++ ) {
               a lert( result[ 'name'][ i ] );                           // это всего-лишь  пример :)
             }
       }
    );

 <?php
require_once($_SERVER['DOCUMENT_ROOT']."/bitrix/modules/main/include/prolog_before.php");

$ban_id        = (int )$_REQUEST[ 'id' ];
$cache_time = (int )$_REQUEST[ 'cache_time' ];


if( $ban_id < 1 or $ban_id > 10 )  {
    $ban_id = 1;
}

$ban_type_sid = "OTP_BAN_PAGE_".strval($ban_id);

if( CModule::IncludeModule("advertising") )  {

    $obCache = new CPHPCache;
    // время кеширования - 30 минут
    // $cache_time =  30*60;
    // формируем идентификатор кеша в зависимости от всех параметров
    // которые могут повлиять на результирующий HTML
    $cache_id     = 'tabbed_banners'.$ban_type_sid;
    $cache_path = "/".SITE_ID."/alexm/tabbed_banners/";

    // если кеш есть и он ещё не истек то
    if( $obCache->InitCache( $cache_time, $cache_id, $cache_path ) ) {
        $vars    = $obCache->GetVars();
        $ar       = $vars[ "ar" ];
    } else {

        $rs = CAdvBanner::GetList( $by="s_weight",
                                                        $order="asc",
                                                        array( "TYPE_SID" => $ban_type_sid,
                                                                  "TYPE_SID_EXACT_MATCH" => "Y",
                                                                  "SITE" => SITE_ID ),
                                                        $if_filtered,
                                                        "N"  );

        if( $rs ) {
            $ar   = Array();
            $arr  = Array();
            $cdt = date("Ymd");

            while( $arr = $rs->Fetch() ) {

                  if( $arr['ACTIVE'] != "Y" )
                      continue;

                  if( ! empty( $arr['DATE_SHOW_FROM'] ) ) {
                        $yyy       = substr( $arr['DATE_SHOW_FROM'], 6, 4 );
                        $mmm    = substr( $arr['DATE_SHOW_FROM'], 3, 2 );
                        $ddd      = substr( $arr['DATE_SHOW_FROM'], 0, 2 );
                        $dt_beg  = $yyy . $mmm . $ddd;

                        if( $dt_beg > $cdt )
                            continue;
                  }

                  $ar []= $arr;
          }

        }

    if( $obCache->StartDataCache()  )  {

          // записываем  в файл кеша переменные
          $obCache->EndDataCache( array( "ar" => $ar ) );
          }

    }

    if( $ar &&  count( $ar ) > 0 ) {

       $r_i                 = array_rand( $ar );
       $i_color           = stripos( $ar[$r_i]['NAME'], "color" );

       if( $i_color > 0 )
           $str_color    = "#".substr( $ar[$r_i]['NAME'], $i_color + 6, 6 );
       else
           $str_color    = "transparent";

       $str_htm         = CAdvBanner::GetHTML( $ar[$r_i] )."<st yle type=\"text/css\">
                               div.big_banner_block div.big_banner {
                               background-color:       $str_color;
                               }</style>";

       echo $str_htm;

       CAdvBanner::FixShow( $arfix );
    }

  }


require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/epilog_after.php");
?>

                 <?php
                 if( $USER->IsAuthorized() )  // IsAdmin()
                   {
                   $APPLICATION->IncludeComponent( "bitrix:main.include",
                                                                      "",
                                                                      Array( "AREA_FILE_SHOW"=>"page",
                                                                               "AREA_FILE_SUFFIX"=>"gnc_center",
                                                                               "AREA_FILE_RECURSIVE" => "N",
                                                                               "EDIT_TEMPLATE"=>"" )  );
                   }
                 else
                   {
                   $APPLICATION->IncludeComponent( "bitrix:main.include",
                                                                      "",
                                                                      Array( "AREA_FILE_SHOW"=>"page",
                                                                               "AREA_FILE_SUFFIX"=>"gnc_denied",
                                                                               "AREA_FILE_RECURSIVE" => "N",
                                                                               "EDIT_TEMPLATE"=>"" )  );
                   }
                 ?>