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` = '".s_browse_cc( $browse_tabs)."\n<h2>$pre</h2>\n".(!$totRows ?"<div style=\'margin-top: 10px;\'>Нет записей.</div>" : "\n<table cellpadding=\'5\' cellspacing=\'1\' border=\'0\' style=\'width:100%; background:#CCC; margin-top: 10px;\'>\n" )."', `FormSuffix` = '</table>', `RecordTemplate` = '<tr class=\'title\' id=\'reply$f_RowID\'>\n  <td style=\'width: 15%;background:#".(!is_even($f_RowNum) ? "EEE" : "FFF")."\'> $f_Created\n  </td>\n  <td style=\'background:#".(!is_even($f_RowNum) ? "EEE" : "FFF")."\'> \n     <a href=\'$url\'>$Name</a> >> <a href=\'".$url."topic_".$f_topic_id.".html#reply$f_RowID\'>$f_subject</a>\n  </td>\n</tr>\n\n<tr>\n  <td style=\'background:#".(!is_even($f_RowNum) ? "EEE" : "FFF")."\' colspan=\'2\'>\n    ".nl2br(nc_bbcode(htmlspecialchars($f_Message)))."<br/><br/>\n    ".($f_Author_Signature ? "———————————<br/>".nc_bbcode(htmlspecialchars($f_Author_Signature)) : "")."\n  </td>\n</tr>\n\n\n\n', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'global $browse_tabs;\n// записи определенного пользователя\n$by_user_id = intval($by_user_id);\nif ( !$by_user_id ) $by_user_id = $AUTH_USER_ID;\n$query_where .= " AND a.`User_ID` = \'".$by_user_id."\' ";\n\n$ignore_all = 1;\n\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//таблица с темами\n$topic_table = "Message" . $topic_obj->get_class_id();\n//таблица с сообщениями\n$reply_table = "Message" . $reply_obj->get_class_id();\n\n//выбираем данные\n$select = "SELECT UNIX_TIMESTAMP(u.`Created`), a.`Subject`, a.`Message`, a.`Message_ID`, a.Created as `dat`, a.User_ID,\n                  sub.`EnglishName`, sub.`Hidden_URL`, sub.`Subdivision_Name`, ";\n\n$where = " \nsub.`Subdivision_ID` = a.`Subdivision_ID` \nAND u.`User_ID` = \'".$by_user_id."\' ";\n              \n\n$message_select = $select ." 0, a.Message_ID, a.Subject\n                   FROM ($topic_table AS a, Subdivision as `sub`)\n                   LEFT JOIN `User` AS `u` ON u.User_ID = a.User_ID\n                   WHERE $where\n\n                   UNION \n\n                   ".$select." 1, a.Topic_ID, ( select Subject FROM Message".$topic_obj->get_class_id()." where Message_ID =  a.Topic_ID)\n                   FROM ($reply_table AS a, Subdivision as `sub`)\n                   LEFT JOIN `User` AS `u` ON u.User_ID = a.User_ID\n                   WHERE $where\n\n		  ORDER BY `dat` DESC\n                  ".($recNum ? " LIMIT ".intval($recNum) : ($cc_env[\'RecordsPerPage\'] ? " LIMIT ".$cc_env[\'RecordsPerPage\'] : "") );       \n                  \n$result_vars = \'$f_Author_Regdate, $f_Subject, $f_Message, $f_RowID, $f_Created, $f_UserID, $eng_name, $url, $Name, $f_is_reply, $f_topic_id, $f_subject\';\n\n\n\nif ( $by_user_id != $AUTH_USER_ID ) {\n  $f_Author = $db->get_var("SELECT IF(`ForumName` <> \'\', `ForumName`,`".$nc_core->AUTHORIZE_BY."`) FROM `User` WHERE `User_ID` = \'".$by_user_id."\' ");\n  $pre = "Сообщения на форуме пользователя <a href=\'".nc_auth_profile_url($by_user_id)."\'>$f_Author</a>";\n   if ( !$f_Author ) header("Location: /");\n}\nelse {\n  $f_Author = $current_user[$nc_core->AUTHORIZE_BY];\n  $pre = "Мои сообщения на форуме";\n}\n\n$cc_env[\'Cache_Access_ID\'] = 2;', `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,  `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;