4.6
-- NetCat 4.6 Extra [0] component file, generated 2011-10-14 16:38:23
INSERT INTO `Class` SET `Class_Name` = 'Форум v2: Последние сообщения', `Class_Group` = 'Форум v2', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '$f_AdminCommon\n<table cellpadding=\'5\' cellspacing=\'1\' border=\'0\' style=\'width:100%; background:#CCC\'>\n<col width=\'1%\'/><col width=\'99%\'/>', `FormSuffix` = '</table>', `RecordTemplate` = '";\n\n$f_Message = nc_substr(nc_bbcode_clear($f_Message_full), 0, 50);\nif (nc_strrpos($f_Message, " ")) {\n  $f_Message = nc_substr($f_Message, 0, nc_strrpos($f_Message, " "));\n}\n\n$result .= "\n<tr valign=\'top\'>\n  <td style=\'background:#".(is_even($f_RowNum) ? "EEE" : "FFF")."\'><img src=\'".$SUB_FOLDER.$HTTP_ROOT_PATH."modules/forum2/images/".$f_Type.".gif\' border=\'0\' alt=\'\'/></td>\n  <td style=\'background:#".(is_even($f_RowNum) ? "EEE" : "FFF")."\'><a href=\'".$f_fullLink."\'>".htmlspecialchars(($f_Subject ? $f_Subject : $f_Message), ENT_QUOTES)."</a><br/>".$f_Created.", <b>".$f_Author."</b></td>\n</tr>', `RecordsPerPage` = '10', `SortBy` = 'Created DESC ', `RecordTemplateFull` = '', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = '// get forum object\n$parent_obj = nc_forum2_parent::get_object();\n$forum_obj = nc_forum2_forum::get_object();\n$topic_obj = nc_forum2_topic::get_object();\n$reply_obj = nc_forum2_reply::get_object();\n\n// clear query\n$ignore_all = 1;\n\n$last_topic_link = ($admin_mode ? "CONCAT(\'".$SUB_FOLDER.$HTTP_ROOT_PATH."full.php?catalogue=\', cc.`Catalogue_ID`, \'&sub=\', m.`Subdivision_ID`,  \'&cc=\', m.`Sub_Class_ID`, \'&message=\', m.`Message_ID`)" : "CONCAT(\'".$SUB_FOLDER."\',sub.`Hidden_URL`, cc.`EnglishName`, \'_\', m.`Message_ID`, \'.html\')");\n$last_reply_link = ($admin_mode ? "CONCAT(\'".$SUB_FOLDER.$HTTP_ROOT_PATH."full.php?catalogue=\', cc.`Catalogue_ID`, \'&sub=\', m.`Subdivision_ID`,  \'&cc=\', tm.`Sub_Class_ID`, \'&message=\', m.`Topic_ID`)" : "CONCAT(\'".$SUB_FOLDER."\',sub.`Hidden_URL`, cc.`EnglishName`, \'_\', m.`Topic_ID`, \'.html\', \'#reply\', m.`Message_ID`)");\n\n$message_select = "(SELECT usr.`Login`, m.`Message_ID`, m.`Created`, m.`Subject`, m.`Message`, ".$last_topic_link.", \'topic\' AS type FROM `Message".$topic_obj->get_class_id()."` AS m\n  LEFT JOIN `User` AS usr ON m.`User_ID` = usr.`User_ID`\n  LEFT JOIN `Subdivision` AS sub ON m.`Subdivision_ID` = sub.`Subdivision_ID`\n  LEFT JOIN `Sub_Class` AS cc ON m.`Sub_Class_ID` = cc.`Sub_Class_ID`)\n  UNION\n  (SELECT usr.`Login`, m.`Message_ID`, m.`Created`, m.`Subject`, m.`Message`, ".$last_reply_link.", \'reply\' AS type FROM `Message".$reply_obj->get_class_id()."` AS m\n  LEFT JOIN `User` AS usr ON m.`User_ID` = usr.`User_ID`\n  LEFT JOIN `Message".$topic_obj->get_class_id()."` AS tm ON m.`Topic_ID` = tm.`Message_ID`\n  LEFT JOIN `Subdivision` AS sub ON tm.`Subdivision_ID` = sub.`Subdivision_ID`\n  LEFT JOIN `Sub_Class` AS cc ON tm.`Sub_Class_ID` = cc.`Sub_Class_ID`)\n  ".($cc_env[\'SortBy\'] ? " ORDER BY ".$cc_env[\'SortBy\'] : "")."\n  ".($recNum ? " LIMIT ".intval($recNum) : ($cc_env[\'RecordsPerPage\'] ? " LIMIT ".$cc_env[\'RecordsPerPage\'] : "") );\n\n$result_vars = \'$f_Author, $f_RowID, $f_Created, $f_Subject, $f_Message_full, $f_fullLink, $f_Type\';\n\nunset($last_topic_link, $last_reply_link);', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `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,  `ncTitle` varchar(255) DEFAULT NULL,  `ncKeywords` varchar(255) DEFAULT NULL,  `ncDescription` text,  `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`)) ENGINE=MyISAM;