4.1
-- NetCat 4.1 Extra [0] component file, generated 2010-10-04 12:26:19
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` = '<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."\'>".($f_Subject ? $f_Subject : $f_Message)."</a><br/>".$f_Created.", <b>".$f_Author."</b></td>\n</tr>', `RecordsPerPage` = '10', `SortBy` = 'Created DESC ', `RecordTemplateFull` = '', `TitleTemplate` = '', `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.`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.`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`, SUBSTRING_INDEX(m.`Message`, \' \', 5), ".$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`, SUBSTRING_INDEX(m.`Message`, \' \', 5), ".$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, $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', `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;