Юрий Гранд (Все сообщения пользователя)

mysqlcheck -o sitemanager -u root -pMySQLSecretsPwd11

if(!$NEXT_TABLE_NAME)
   return false;

if(!$NEXT_TABLE_NAME){
   CAgent::AddAgent("cron_TableOptimizator();","main","N",86400,"","Y",FormatDate('FULL', strtotime('+1 month')),-1);
   return false;
}

function cron_TableOptimizator($TABLE_NAME = false, $OPT_ID = false){
   global $DB;
   $arLocale = array(
      'note' => 'Сообщение',
      'status' => 'Статус операции'
   );
   
   if(!$OPT_ID&&!$TABLE_NAME){
      $arTable = $DB->Query("SEL ECT table_name FR OM information_schema.tables WHERE table_schema = DATABASE() ORDER BY table_name ASC LIMIT 1")->Fetch();
      $TABLE_NAME = $arTable['table_name'];
      $OPT_ID = time();
   }
   else
      $arTable = $DB->Query("SEL ECT table_name FR OM information_schema.tables WHERE table_schema = DATABASE() AND table_name = '$TABLE_NAME'")->Fetch();
   
   $arLogP = array("SEVERITY" => "SECURITY","AUDIT_TYPE_ID" => "TABLE_OPTIMIZATOR","MODULE_ID" => "main","ITEM_ID" => $TABLE_NAME,);
      
   if($arTable)
   {
      CEventLog::Add($arLogP+array("DESCRIPTION" => "Начало оптимизации таблицы",));
      
      $rsResult = $DB->Query("optimize table `$TABLE_NAME`");
      while($arRow = $rsResult->Fetch()){
         CEventLog::Add($arLogP+array("DESCRIPTION" => $arLocale[$arRow['Msg_type']] . ': ' .$arRow['Msg_text'],));
      }
      
      $sQuery =    "SELECT table_name, table_comment FR OM information_schema.tables
               WHERE table_schema = DATABASE() AND table_name > '$TABLE_NAME' 
               ORDER BY table_name ASC 
               LIMIT 1";
      $arTable = $DB->Query($sQuery)->Fetch();
      $NEXT_TABLE_NAME = $arTable?$arTable['table_name']:false;
      $DB->Query("ALT ER   TABLE `$TABLE_NAME` COMMENT = '$OPT_ID'");
   }else{
      $sQuery =    "SELECT table_name, table_comment FR OM information_schema.tables
               WH ERE table_schema = DATABASE() AND table_comment <> '$OPT_ID' 
               ORDER BY table_name ASC 
               LIM IT 1";
      $arTable = $DB->Query($sQuery)->Fetch();
      $NEXT_TABLE_NAME = $arTable?$arTable['table_name']:false;
      CEventLog::Add($arLogP+array("DESCRIPTION" => "Ошибка оптимизации, таблица не найдена переход к следующей таблице: $NEXT_TABLE_NAME",));
   }
   if(!$NEXT_TABLE_NAME)
      return false;
   return "cron_TableOptimizator('$NEXT_TABLE_NAME', $OPT_ID);";
}

CAgent::AddAgent("cron_TableOptimizator();","main","Y",300,"","Y",FormatDate('FULL',time()),30);

               CSocNetUserToGroup::Add(
                    array(
                    "USER_ID" => $arGroup['OWNER_ID'],  //ID нового владельца
                    "GROUP_ID" => $arGroup["ID"], // ID группы
                    "ROLE" => SONET_ROLES_OWNER,
                    "=DATE_CREATE" => $GLOBALS["DB"]->CurrentTimeFunction(),
                    "=DATE_UPDATE" => $GLOBALS["DB"]->CurrentTimeFunction(),
                    "INITIATED_BY_TYPE" => SONET_INITIATED_BY_GROUP,
                    "INITIATED_BY_USER_ID" => CUser::GetID(),
                    "MESSAGE" => false,
                    )
               );
//перевод старого хозяина в модераторы
            $CSocNetUserToGroup = new CSocNetUserToGroup();
            $relOldOwner = $CSocNetUserToGroup::GetList(
               array("USER_LAST_NAME" => "ASC", "USER_NAME" => "ASC"),
               array(
                  "GROUP_ID" => $arGroup["ID"], // ID группы
                  "USER_ID" => $oldOwner, //ID старого владельца
               ),
               false,
               false,
               array("ID")
            )->Fetch();
            CSocNetUserToGroup::Update($relOldOwner['ID'], array("ROLE" => SONET_ROLES_MODERATOR,));

<sc ript>
var select = document.getElementsByName('{ИМЯПОЛЯ}');
select[0].remove(0);
</sc ript>

CModule::IncludeModule('im');
      $arMessageFields = array(
         "TO_USER_ID" => $to,
         "FROM_USER_ID" => $from, 
         "MESSAGE_TYPE" => IM_MESSAGE_SYSTEM, 
         "NOTIFY_MODULE" => "im",
         "NOTIFY_MESSAGE" => $message,
      );
      CIMMessage::Add($arMessageFields);

require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_before.php");
$ID = (int)$_REQUEST['bpID'];
if($ID>0)
LocalRedirect("/services/bp/$ID/start.php?sessid=".bitrix_sessid());
else
ShowError('Неверный ID');

   array(
      "CONDITION" => "#^/start_bp/(\\d+)/#",
      "RULE" => "bpID=\$1",
      "ID" => "myscript:bp.redirect",
      "PATH" => "/путь_к/скрипту/index.php",
   ),