Query("SELECT NAME FROM b_operation WHERE MODULE_ID = 'iblock'"); while($ar = $rsOperations->Fetch()) $arDBOperations[$ar["NAME"]] = $ar["NAME"]; foreach($arFOp as $ar) { if(!isset($arDBOperations[$ar[0]])) { $DB->Query(" INSERT INTO b_operation (NAME, MODULE_ID, BINDING) VALUES ('".$ar[0]."', 'iblock', '".$ar[1]."') ", false, "FILE: ".__FILE__."
LINE: ".__LINE__); } } $arDBTasks = array(); $rsTasks = $DB->Query("SELECT NAME FROM b_task WHERE MODULE_ID = 'iblock' AND SYS = 'Y'"); while($ar = $rsTasks->Fetch()) $arDBTasks[$ar["NAME"]] = $ar["NAME"]; foreach($arTasksF as $ar) { if(!isset($arDBTasks[$ar[0]])) { $DB->Query(" INSERT INTO b_task (NAME, LETTER, MODULE_ID, SYS, BINDING) VALUES ('".$ar[0]."', '".$ar[1]."', 'iblock', 'Y', '".$ar[2]."') ", false, "FILE: ".__FILE__."
LINE: ".__LINE__); } } // ############ b_task_operation ########### foreach($arOInT as $tname => $arOp) { $sql_str = " INSERT INTO b_task_operation (TASK_ID,OPERATION_ID) SELECT T.ID TASK_ID, O.ID OPERATION_ID FROM b_task T ,b_operation O WHERE T.SYS='Y' AND T.NAME='".$tname."' AND O.NAME in ('".implode("','", $arOp)."') AND O.NAME not in ( SELECT O2.NAME FROM b_task T2 inner join b_task_operation TO2 on TO2.TASK_ID = T2.ID inner join b_operation O2 on O2.ID = TO2.OPERATION_ID WHERE T2.SYS='Y' AND T2.NAME='".$tname."' ) "; $z = $DB->Query($sql_str, false, "FILE: ".__FILE__."
LINE: ".__LINE__); } global $CACHE_MANAGER; if(is_object($CACHE_MANAGER)) { $CACHE_MANAGER->CleanDir("b_task"); $CACHE_MANAGER->CleanDir("b_task_operation"); } ?>