Module: support
File: options
Function: ClearCategoryTable
Line: "; $DB->Query("DELETE FROM b_ticket_sla_2_category", false, $err_mess.__LINE__); $arrSLA = array(); $strSql = " SELECT SLA.ID FROM b_ticket_sla SLA "; $z = $DB->Query( $strSql, false, $err_mess . __LINE__ ); while( $zr = $z->Fetch() ) { $arFields_i = array( "SLA_ID" => intval($zr["ID"]), "CATEGORY_ID" => 0, ); $ID = $DB->Insert( "b_ticket_sla_2_category", $arFields_i, $err_mess . __LINE__ ); } } $module_id = "support"; IncludeModuleLangFile($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/".$module_id."/include.php"); IncludeModuleLangFile(__FILE__); $SUP_RIGHT = $APPLICATION->GetGroupRight($module_id); if ($SUP_RIGHT>="R") : if ($REQUEST_METHOD=="GET" && $SUP_RIGHT>="W" && $RestoreDefaults <> '' && check_bitrix_sessid()) { COption::RemoveOption("support"); $z = CGroup::GetList("id", "asc", array("ACTIVE" => "Y", "ADMIN" => "N")); while($zr = $z->Fetch()) $APPLICATION->DelGroupRight($module_id, array($zr["ID"])); } $message = false; require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/".$module_id."/include.php"); if($REQUEST_METHOD=="POST" && $Update <> '' && $SUP_RIGHT>="W" && check_bitrix_sessid()) { $SUPPORT_DIR = str_replace("\\", "/", $SUPPORT_DIR); $SUPPORT_DIR = str_replace("//", "/", $SUPPORT_DIR); COption::SetOptionString($module_id, "SUPPORT_DIR", $SUPPORT_DIR); COption::SetOptionString($module_id, "SUPPORT_EDIT", $SUPPORT_EDIT); COption::SetOptionString($module_id, "SUPPORT_MAX_FILESIZE", intval($SUPPORT_MAX_FILESIZE)); COption::SetOptionString($module_id, "ONLINE_INTERVAL", intval($ONLINE_INTERVAL)); COption::SetOptionString($module_id, "DEFAULT_VALUE_HIDDEN", $DEFAULT_VALUE_HIDDEN); COption::SetOptionString($module_id, "DEFAULT_RESPONSIBLE_ID", $DEFAULT_RESPONSIBLE_ID); COption::SetOptionString($module_id, "DEFAULT_AUTO_CLOSE_DAYS", $DEFAULT_AUTO_CLOSE_DAYS); COption::SetOptionString($module_id, "VIEW_TICKET_DEFAULT_MODE", $VIEW_TICKET_DEFAULT_MODE); COption::SetOptionString($module_id, "ONLINE_AUTO_REFRESH", $ONLINE_AUTO_REFRESH); COption::SetOptionString($module_id, "MESSAGES_PER_PAGE", $MESSAGES_PER_PAGE); COption::SetOptionString($module_id, "SHOW_COMMENTS_IN_TICKET_LIST", $SHOW_COMMENTS_IN_TICKET_LIST ?: 'N'); COption::SetOptionString($module_id, "SOURCE_MAIL", $SOURCE_MAIL); COption::SetOptionString($module_id, "REINDEX_MSG_S", $REINDEX_MSG_S); if (preg_match_all('|#|'.BX_UTF_PCRE_MODIFIER, $SUPERTICKET_COUPON_FORMAT, $_tmp) && is_array($_tmp[0]) && count($_tmp[0]) >= 6) { COption::SetOptionString($module_id, "SUPERTICKET_COUPON_FORMAT", $SUPERTICKET_COUPON_FORMAT); } else { $message = new CAdminMessage(GetMessage('SUP_SUPERTICKET_ERROR')); } COption::SetOptionString($module_id, "SUPERTICKET_DEFAULT_SLA", $SUPERTICKET_DEFAULT_SLA); $SUPPORT_OLD_FUNCTIONALITY_OLD = COption::GetOptionString($module_id, "SUPPORT_OLD_FUNCTIONALITY"); $SUPPORT_OLD_FUNCTIONALITY = ( $SUPPORT_OLD_FUNCTIONALITY == "Y" ? "Y" : "N" ); if( $SUPPORT_OLD_FUNCTIONALITY_OLD <> $SUPPORT_OLD_FUNCTIONALITY ) ClearCategoryTable(); COption::SetOptionString($module_id, "SUPPORT_OLD_FUNCTIONALITY", $SUPPORT_OLD_FUNCTIONALITY); COption::SetOptionString($module_id, "SUPPORT_DEFAULT_SLA_ID", intval($SUPPORT_DEFAULT_SLA_ID) ); COption::SetOptionString($module_id, "SUPPORT_CACHE_DAYS_FORWARD", intval($SUPPORT_CACHE_DAYS_FORWARD) ); COption::SetOptionString($module_id, "SUPPORT_CACHE_DAYS_BACKWARD", intval($SUPPORT_CACHE_DAYS_BACKWARD) ); } $SUPPORT_DIR = COption::GetOptionString($module_id, "SUPPORT_DIR"); $SUPPORT_EDIT = COption::GetOptionString($module_id, "SUPPORT_EDIT"); $SUPPORT_MAX_FILESIZE = COption::GetOptionString($module_id, "SUPPORT_MAX_FILESIZE"); $ONLINE_INTERVAL = COption::GetOptionString($module_id, "ONLINE_INTERVAL"); $DEFAULT_VALUE_HIDDEN = COption::GetOptionString($module_id, "DEFAULT_VALUE_HIDDEN"); $DEFAULT_RESPONSIBLE_ID = COption::GetOptionString($module_id, "DEFAULT_RESPONSIBLE_ID"); $DEFAULT_AUTO_CLOSE_DAYS = COption::GetOptionString($module_id, "DEFAULT_AUTO_CLOSE_DAYS"); $VIEW_TICKET_DEFAULT_MODE = COption::GetOptionString($module_id, "VIEW_TICKET_DEFAULT_MODE"); $ONLINE_AUTO_REFRESH = COption::GetOptionString($module_id, "ONLINE_AUTO_REFRESH"); $MESSAGES_PER_PAGE = COption::GetOptionString($module_id, "MESSAGES_PER_PAGE"); $SHOW_COMMENTS_IN_TICKET_LIST = COption::GetOptionString($module_id, "SHOW_COMMENTS_IN_TICKET_LIST"); $SOURCE_MAIL = COption::GetOptionString($module_id, "SOURCE_MAIL"); $SUPERTICKET_COUPON_FORMAT = COption::GetOptionString($module_id, "SUPERTICKET_COUPON_FORMAT"); $SUPERTICKET_DEFAULT_SLA = COption::GetOptionString($module_id, "SUPERTICKET_DEFAULT_SLA"); $SUPPORT_OLD_FUNCTIONALITY = COption::GetOptionString($module_id, "SUPPORT_OLD_FUNCTIONALITY"); $SUPPORT_DEFAULT_SLA_ID = COption::GetOptionString($module_id, "SUPPORT_DEFAULT_SLA_ID"); $SUPPORT_CACHE_DAYS_FORWARD = COption::GetOptionString($module_id, "SUPPORT_CACHE_DAYS_FORWARD"); $SUPPORT_CACHE_DAYS_BACKWARD = COption::GetOptionString($module_id, "SUPPORT_CACHE_DAYS_BACKWARD"); $REINDEX_MSG_S = COption::GetOptionString($module_id, "REINDEX_MSG_S",8); if ($message) echo $message->Show(); $aTabs = array( array("DIV" => "edit1", "TAB" => GetMessage("MAIN_TAB_SET"), "ICON" => "support_settings", "TITLE" => GetMessage("MAIN_TAB_TITLE_SET")), array("DIV" => "edit2", "TAB" => GetMessage("MAIN_TAB_RIGHTS"), "ICON" => "support_settings", "TITLE" => GetMessage("MAIN_TAB_TITLE_RIGHTS")), ); $tabControl = new CAdminTabControl("tabControl", $aTabs); ?> Begin(); ?>