4.1
-- NetCat 4.1 Extra [0] component file, generated 2010-10-04 12:26:19
INSERT INTO `Class` SET `Class_Name` = 'Облако тегов: Теги', `Class_Group` = 'Облако тегов', `DaysToHold` = '0', `AllowTags` = '1', `FormPrefix` = '$f_AdminCommon";\r\n# получаем данные\r\nlist($mess_array_all, $tagText) = nc_tag_cloud_show_result($tag, $tagsub, $tagcc);\r\n# выводим нужные сообщения\r\n$totRows = count($mess_array_all);\r\n$cc_env[\'totRows\'] = $totRows;\r\nif($tag && $mess_array_all) {\r\n  $messCount = 1;\r\n  unset($mess_array);\r\n  $mess_array_all[] = 1; # чтобы цикл выполнился один лишний раз\r\n  foreach($mess_array_all AS $value) {\r\n  if($messCount>$curPos && ($messCount-$curPos-1)<=$recNum && ($messCount-$curPos)>0) {\r\n    if( ($value[\'Sub_Class_ID\']==$mess_cc || !$mess_cc) && ($messCount-$curPos)<=$recNum) {\r\n      if(!$mess_cc) {\r\n        $mess_sub = $value[\'Subdivision_ID\'];\r\n        $mess_cc = $value[\'Sub_Class_ID\'];\r\n      }\r\n      $mess_array[] = $value[\'Message_ID\'];\r\n    }\r\n    else {\r\n      if($mess_array) {\r\n        $messages_str = join(",", $mess_array);\r\n        $content.=s_list_class($mess_sub, $mess_cc, opt($messages_str, "&tags_messages=$messages_str")."&isTitle=2&preTitle=1&showNav=0" );\r\n      }\r\n      unset($mess_array);\r\n      $messages_str = "";\r\n      $mess_array[] = $value[\'Message_ID\'];\r\n      $mess_sub = $value[\'Subdivision_ID\'];\r\n      $mess_cc = $value[\'Sub_Class_ID\'];\r\n    }\r\n  }\r\n  ++$messCount;\r\n  }\r\n}\r\n$result.="\r\n<div class=\'nc_list\'>\r\n  <h3>\r\n    ".($tag ? "Тег — ".((int)$tagsub || (int)$tagcc ? "<a href=\'".$SUB_FOLDER.$current_sub[\'Hidden_URL\']."?tag=$tag\' title=\'вывести все сообщения с этим тегом\'>".$tagText."</a>" : $tagText) : "Популярные теги")."\r\n  </h3>\r\n  ".($content && $tag ? $content : nc_tag_cloud_all($catalogue, "<a href=\'$SUB_FOLDER/tags/%TAG_LINK%TAG_SUB_LINK\' style=\'font-size:%TAG_HEIGHT%; \\".opt(%TAG_HEIGHT>160, \'line-height:1em;\').\\"\'>%TAG_NAME</a>"))."', `FormSuffix` = '".($totRows>($curPos+$recNum)  ? opt($nextLink="?curPos=".($curPos+$recNum),"") : "")."\r\n".($prevLink || $nextLink ? "<div class=\'nc_pagination\'>страница: ".($prevLink ? "<a href=\'".$prevLink.($QUERY_STRING ? $QUERY_STRING : "")."\'>" : "")."&laquo;&laquo;".($prevLink ? "</a>" : "")." ".browse_messages($cc_env, 10)." ".($nextLink ? " <a href=\'".$nextLink.($QUERY_STRING ? $QUERY_STRING : "")."\'>" : "")."&raquo;&raquo;".($nextLink ? "</a>" : "")."</div>" : "")."\r\n</div>', `RecordTemplate` = '$f_AdminButtons', `RecordsPerPage` = '5', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'global $REQUEST_URI;\r\n\r\n$ignore_sub = true;\r\n$ignore_cc = true;\r\n\r\n$QUERY_STRING=explode("?", $REQUEST_URI);\r\n$QUERY_STRING=eregi_replace("&?curPos=[0-9]+", "", "&".$QUERY_STRING[1]);', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '', `ClassDescription` = 'Компонент используется в модуле "Облако тегов".\r\nБолее подробная информация о компоненте содержится в документации к этому модулю.', `DeleteTemplate` = '', `ClassTemplate` = '0', `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;