4.5
-- NetCat 4.5 Extra [0] component file, generated 2011-04-19 20:56:14
INSERT INTO `Class` SET `Class_Name` = 'Поиск по сайту', `Class_Group` = 'Поиск по сайту', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '";\r\nif (!$search_query) {\r\n  $result .= nc_search::should(\'EnableAdvancedSearchForm\') \r\n                 ? $nc_search->show_advanced_form()\r\n                 : $nc_search->show_form();\r\n}\r\nelse {\r\n  $result .= "<div class=\'nc_search_form\'><div class=\'nc_search_input\'>".$nc_search->show_form()."</div><div class=\'nc_search_arrow\'></div></div>";\r\n  $totRows = $results->get_total_count();\r\n  if ($totRows == 0) {\r\n    if ($results->get_error_message()) {\r\n      $result .= "<div class=\'nc_search_status nc_search_error\'>" . NETCAT_MODULE_SEARCH_QUERY_ERROR . "</div>";\r\n    }\r\n    else {\r\n      $result .= "<div class=\'nc_search_status nc_search_no_results\'>" . NETCAT_MODULE_SEARCH_NO_RESULTS . "</div>";\r\n    }\r\n  }\r\n  else {\r\n    if ($results->get_correction_suggestion()) {\r\n      $result .= "<div class=\'nc_search_query_suggesion\'>{$results->get_correction_suggestion()}</div>";\r\n    }\r\n\r\n    if ($show_time) { // показать блок сортировки по дате/релевантности\r\n      $params = $nc_core->input->fetch_get();\r\n      unset($params["curPos"]);\r\n      unset($params["REQUEST_URI"]);\r\n      $params = http_build_query($params, \'\', \'&amp;\');\r\n      $result .= "<div class=\'nc_search_sort\'>" . NETCAT_MODULE_SEARCH_SORT_BY .\r\n                 ($sortby == \'last_modified\'\r\n                     ? "<span>" . NETCAT_MODULE_SEARCH_SORT_BY_LAST_MODIFIED . "</span>" \r\n                     : "<a href=\'?$params&amp;sortby=last_modified\'>" . NETCAT_MODULE_SEARCH_SORT_BY_LAST_MODIFIED . "</a>") .\r\n                 " | " .\r\n                 ($sortby == \'\'\r\n                     ? "<span>" . NETCAT_MODULE_SEARCH_SORT_BY_RELEVANCE . "</span>" \r\n                     : "<a href=\'?$params&amp;sortby=\'>" . NETCAT_MODULE_SEARCH_SORT_BY_RELEVANCE . "</a>") .\r\n                 "</div>";\r\n    }\r\n\r\n    $result .= \r\n\r\n      "<ol class=\'nc_search_results\' start=\'$begRow\'>";\r\n  }\r\n}\r\n\r\nif (!$advanced) {$result .= "<div class=\'nc_search_range\'>" . \r\n         ($begRow == $endRow \r\n            ? sprintf(NETCAT_MODULE_SEARCH_RESULTS_ONE, $begRow, $totRows) \r\n            : sprintf(NETCAT_MODULE_SEARCH_RESULTS_RANGE, $begRow, $endRow, $totRows)) . \r\n      ":</div>";}\r\n\r\n$result .= "', `FormSuffix` = '";\r\n\r\nif ($totRows) {\r\n  $result .= "</ol>" .\r\n     "<div class=\'nc_search_pages\'><div class=\'nc_search_nav\'><strong>".NETCAT_MODULE_SEARCH_PAGES."</strong>" .\r\n      opt_case($prevLink, "<span class=\'nc_search_prev\'>&larr; Ctrl <a class=\'prev\' href=\'$prevLink\'>".NETCAT_MODULE_SEARCH_RESULTS_PREV."</a></span>", "<span class=\'nc_search_inactive\'>&larr; Ctrl ".NETCAT_MODULE_SEARCH_RESULTS_PREV."</span>") .\r\n      opt_case($nextLink, "<span class=\'nc_search_next\'><a class=\'next\' href=\'$nextLink\'>".NETCAT_MODULE_SEARCH_RESULTS_NEXT."</a> Ctrl &rarr;</span>", "<span class=\'nc_search_inactive\'>".NETCAT_MODULE_SEARCH_RESULTS_NEXT." Ctrl &rarr;</span>") .\r\n    "</div>".\r\n      browse_messages($cc_env, 10) .\r\n     "</div>" . \r\n     // навигация Ctrl+стрелки\r\n     "<script type=\'text/javascript\'>\r\n       if (typeof jQuery != \'undefined\') { \r\n         (function($) {\r\n            var links = { 37: $(\'.nc_search_pages a.prev\').attr(\'href\'),\r\n                          39: $(\'.nc_search_pages a.next\').attr(\'href\') };\r\n            $(document).keydown(function(e) {\r\n              if (e.ctrlKey && links[e.keyCode]) { window.location = links[e.keyCode]; }\r\n            });\r\n          })(jQuery); \r\n        }\r\n      </script>";\r\n}\r\n\r\n$result .= "', `RecordTemplate` = '<div class=\'nc_search_list\'><li><div class=\'nc_search_title\'><a href=\'$f_url\'" . (nc_search::should(\'OpenLinksInNewWindow\') ? " target=\'_blank\'" : "") . ">$f_title</a></div>" .\r\n  (nc_search::should(\'ShowMatchedFragment\') ? "<div class=\'nc_search_context\'>$f_context</div>" : "") .\r\n  ($show_time ? "<div class=\'nc_search_datetime\'>" . strftime(NETCAT_MODULE_SEARCH_DATETIME_FORMAT, strtotime($f_lastmodified)) . "</div>" : "") .\r\n"</li></div>\r\n', `RecordsPerPage` = '10', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'global $nc_search;\r\n$nc_data = array();\r\n$input = $nc_core->input;\r\n$search_query = $input->fetch_get(\'search_query\');\r\n\r\nif ($search_query) {\r\n  $search_query = $nc_search->make_query_string($search_query, $search_query_exclude);\r\n  if (!$recNum) { $recNum = $maxRows; }\r\n  $params = "&field=$field&interval=$interval&intervalvalue=$intervalvalue&intervalunit=$intervalunit" .\r\n            "&sortby=$sortby&sortdirection=$sortdirection&language=$language" .\r\n            "&curPos=$curPos&recNum=$recNum&nologging=$nologging";\r\n  $show_time = ($interval && $intervalvalue && $intervalunit) || ($sortby == \'lastmodified\');\r\n  $results = $nc_data = $nc_search->get_results($search_query, $input->fetch_get(\'area\'), $params);\r\n  $totRows = $results->get_total_count();\r\n  // запрос мог быть изменён в get_results(); нам нужен изменённый запрос для листалки страниц\r\n  $nc_core->input->_GET[\'search_query\'] = $results->get_query_string(); // это hack, запросто может перестать работать!\r\n}\r\n', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '1', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '', `ClassDescription` = '', `DeleteTemplate` = '', `ClassTemplate` = '0', `Type` = 'useful', `CacheForUser` = '0';
CREATE TABLE `Message%INSERT_ID%` (  `Message_ID` int(11) NOT NULL auto_increment,  `User_ID` int(11) NOT NULL,  `Subdivision_ID` int(11) NOT NULL,  `Sub_Class_ID` int(11) NOT NULL,  `Priority` int(11) NOT NULL default '0',  `Keyword` char(255) NOT NULL,  `Checked` tinyint(4) NOT NULL default '1',  `TimeToDelete` date default NULL,  `TimeToUncheck` date default NULL,  `IP` char(15) default NULL,  `UserAgent` char(255) default NULL,  `Parent_Message_ID` int(11) NOT NULL default '0',  `Created` datetime NOT NULL,  `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `LastUser_ID` int(11) NOT NULL,  `LastIP` char(15) default NULL,  `LastUserAgent` char(255) default NULL,  PRIMARY KEY  (`Message_ID`),  UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`),  KEY `User_ID` (`User_ID`),  KEY `LastUser_ID` (`LastUser_ID`),  KEY `Subdivision_ID` (`Subdivision_ID`),  KEY `Parent_Message_ID` (`Parent_Message_ID`)) TYPE=MyISAM;