4.6
-- NetCat 4.6 Extra [0] component file, generated 2011-10-14 16:38:23
INSERT INTO `Class` SET `Class_Name` = 'Последние комментарии', `Class_Group` = 'Комментарии', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '$f_AdminCommon\n<h3>Последние комментарии</h3>', `FormSuffix` = '', `RecordTemplate` = '$f_AdminButtons\r\n";\r\n$f_Keyword = $db->get_var("SELECT `Keyword` FROM `Message".$f_ClassID."` WHERE `Message_ID` = \'".$f_MessageID."\' ");\r\n$msg_link = $f_SubURL.($f_Keyword ? $f_Keyword.".html" : $f_EnglishName."_".$f_MessageID.".html");\r\n$f_Comment = nc_bbcode_clear($f_Comment );\r\n$cc_settings[\'TextLength\'] = $cc_settings[\'TextLength\'] ? $cc_settings[\'TextLength\'] : 30;\r\n$f_Comment = nc_substr($f_Comment, 0, $cc_settings[\'TextLength\']).(nc_strlen($f_Comment)>$cc_settings[\'TextLength\'] ? "..." : "");\r\n$result .="\r\n<p>$f_Created\r\n<a href=\'$msg_link#nc_commentID".$f_SubClassID."_".$f_MessageID."_".$f_id."\'>$f_Comment</a>\r\n- пишет ".($f_UserID ? "<a href=\'".nc_auth_profile_url($f_UserID, 1)."\'>$f_Login</a>" : ($f_Guest ? $f_Guest : NETCAT_MODULE_COMMENTS_GUEST))." \r\n в разделе\r\n         <a href=\'$f_SubURL\' style=\'font-weight: bold;\'>$f_SubName</a>\r\n</p>', `RecordsPerPage` = '0', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '<form action=\'".($admin_mode ? "".$HTTP_ROOT_PATH."index.php?" : "".$SUB_FOLDER.$current_sub[\'Hidden_URL\'].$current_cc[\'EnglishName\'].".html" )."\' method=\'get\'>\n<input type=\'hidden\' name=\'action\' value=\'index\' />\n<input type=\'hidden\' name=\'admin_mode\' value=\'".$admin_mode."\' />\n<input type=\'text\' name=\'f_SubID\' value=\'".$f_SubID."\' />\n<input value=\'".NETCAT_SEARCH_FIND_IT."\' type=\'submit\' />\n</form>', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = '$user_name = $nc_core->get_settings(\'UserName\', \'comments\');\r\n\r\n$ignore_all = 1;\r\n$query_select ="c.`Comment`, c.`Message_ID`, c.`id`,\r\n	IF( UNIX_TIMESTAMP(c.`Updated`) > UNIX_TIMESTAMP(c.`Date`), DATE_FORMAT(c.`Updated`, \'%d.%m.%Y %H:%i:%s\'), DATE_FORMAT(c.`Date`, \'%d.%m.%Y %H:%i:%s\') ) AS `Date`,\r\n        u.`User_ID`, u.`".($user_name ? $user_name : "Login")."`, c.`Guest_Name`,\r\n        sc.`Sub_Class_ID`, sc.`Sub_Class_Name`, sc.`Class_ID`, sc.`EnglishName`,\r\n        sub.`Subdivision_ID`, sub.`Subdivision_Name`, sub.`Hidden_URL`";\r\n$query_from = "`Comments_Text` as c";\r\n$query_join = " LEFT JOIN `User` as u ON u.`User_ID` = c.`User_ID`\r\n  LEFT JOIN `Sub_Class` as sc ON sc.`Sub_Class_ID` = c.`Sub_Class_ID`\r\n  LEFT JOIN `Subdivision` as sub ON sub.`Subdivision_ID` = sc.`Subdivision_ID`";\r\n$query_where = "c.`Checked` = 1";\r\n$query_order = "`Date` DESC";\r\n$query_limit = $cc_env[\'RecordsPerPage\'] ? $cc_env[\'RecordsPerPage\'] : "15";\r\n\r\n$result_vars = \'$f_Comment, $f_MessageID,  $f_id, $f_Created,\r\n			$f_UserID, $f_Login, $f_Guest,\r\n                	$f_SubClassID, $f_SubClassName, $f_ClassID, $f_EnglishName,\r\n			$f_SubID, $f_SubName, $f_SubURL\';', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '1', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '$settings_array = array(\r\n \'TextLength\' => array(\'type\' => \'string\',\r\n   \'default_value\' => \'30\',\r\n    \'caption\' => \'Длина отображаемого текста комментария\',\r\n    \'size\' => \'4\',\r\n    \'validate_regexp\' => \'/^\\d+$/\',\r\n    \'validate_error\' => \'Введите целое число\'\r\n ));', `ClassDescription` = '', `DeleteTemplate` = '', `ClassTemplate` = '0', `Type` = 'useful', `CacheForUser` = '0';
INSERT INTO `Class` SET `Class_Name` = 'Комментарии для личного кабинета', `Class_Group` = 'Шаблоны компонентов', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '".s_browse_cc( $browse_tabs )."\r\n<h2>$pre</h2>\r\n".opt(!$totRows, "<div style=\'margin-top: 10px;\'>Нет записей</div>")."\r\n', `FormSuffix` = '', `RecordTemplate` = '$f_AdminButtons\r\n";\r\n$f_Keyword = $db->get_var("SELECT `Keyword` FROM `Message".$f_ClassID."` WHERE `Message_ID` = \'".$f_MessageID."\' ");\r\n$msg_link = $f_SubURL.($f_Keyword ? $f_Keyword.".html" : $f_EnglishName."_".$f_MessageID.".html");\r\n$f_Comment = nc_bbcode_clear($f_Comment );\r\n$cc_settings[\'TextLength\'] = $cc_settings[\'TextLength\'] ? $cc_settings[\'TextLength\'] : 30;\r\n$f_Comment = nc_substr($f_Comment, 0, $cc_settings[\'TextLength\']).(nc_strlen($f_Comment)>$cc_settings[\'TextLength\'] ? "..." : "");\r\n$result .="\r\n<p>$f_Created\r\n<a href=\'$msg_link#nc_commentID".$f_SubClassID."_".$f_MessageID."_".$f_id."\'>$f_Comment</a>\r\n в разделе\r\n         <a href=\'$f_SubURL\' style=\'font-weight: bold;\'>$f_SubName</a>\r\n</p>', `RecordsPerPage` = '0', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '<form action=\'".($admin_mode ? "".$HTTP_ROOT_PATH."index.php?" : "".$SUB_FOLDER.$current_sub[\'Hidden_URL\'].$current_cc[\'EnglishName\'].".html" )."\' method=\'get\'>\n<input type=\'hidden\' name=\'action\' value=\'index\' />\n<input type=\'hidden\' name=\'admin_mode\' value=\'".$admin_mode."\' />\n<input type=\'text\' name=\'f_SubID\' value=\'".$f_SubID."\' />\n<input value=\'".NETCAT_SEARCH_FIND_IT."\' type=\'submit\' />\n</form>', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = '$user_name = $nc_core->get_settings(\'UserName\', \'comments\');\r\nglobal $browse_tabs;\r\n\r\n// записи определенного пользователя\r\n$by_user_id = intval($by_user_id);\r\nif ( !$by_user_id ) $by_user_id = $AUTH_USER_ID;\r\n\r\n// для заголовка\r\nif ( $by_user_id != $AUTH_USER_ID ) {\r\n  $f_Author = $db->get_var("SELECT `".$user_name."` FROM `User` WHERE `User_ID` = \'".$by_user_id."\' ");\r\n  $pre = "Комментарии пользователя <a href=\'".nc_auth_profile_url($by_user_id)."\'>$f_Author</a>";\r\n   //if ( !$f_Author ) header("Location: /");\r\n}\r\nelse {\r\n  $f_Author = $current_user[$user_name];\r\n  $pre = "Мои комментарии";\r\n}\r\n\r\n$cc_env[\'Cache_Access_ID\'] = 2;\r\n$ignore_all = 1;\r\n\r\n$query_select ="c.`Comment`, c.`Message_ID`, c.`id`,\r\n	IF( UNIX_TIMESTAMP(c.`Updated`) > UNIX_TIMESTAMP(c.`Date`), DATE_FORMAT(c.`Updated`, \'%d.%m.%Y %H:%i:%s\'), DATE_FORMAT(c.`Date`, \'%d.%m.%Y %H:%i:%s\') ) AS `Date`,\r\n        u.`User_ID`, u.`".($user_name ? $user_name : "Login")."`, c.`Guest_Name`,\r\n        sc.`Sub_Class_ID`, sc.`Sub_Class_Name`, sc.`Class_ID`, sc.`EnglishName`,\r\n        sub.`Subdivision_ID`, sub.`Subdivision_Name`, sub.`Hidden_URL`";\r\n$query_from = "`Comments_Text` as c";\r\n$query_join = " LEFT JOIN `User` as u ON u.`User_ID` = c.`User_ID`\r\n  LEFT JOIN `Sub_Class` as sc ON sc.`Sub_Class_ID` = c.`Sub_Class_ID`\r\n  LEFT JOIN `Subdivision` as sub ON sub.`Subdivision_ID` = sc.`Subdivision_ID`";\r\n$query_where = "c.`Checked` = 1 AND c.`User_ID` = \'".$by_user_id."\' ";\r\n$query_order = "`Date` DESC";\r\n$query_limit = $cc_env[\'RecordsPerPage\'] ? $cc_env[\'RecordsPerPage\'] : "15";\r\n\r\n$result_vars = \'$f_Comment, $f_MessageID,  $f_id, $f_Created,\r\n			$f_UserID, $f_Login, $f_Guest,\r\n                	$f_SubClassID, $f_SubClassName, $f_ClassID, $f_EnglishName,\r\n			$f_SubID, $f_SubName, $f_SubURL\';\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '1', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '$settings_array = array(\r\n \'TextLength\' => array(\'type\' => \'string\',\r\n   \'default_value\' => \'30\',\r\n    \'caption\' => \'Длина отображаемого текста комментария\',\r\n    \'size\' => \'4\',\r\n    \'validate_regexp\' => \'/^\\d+$/\',\r\n    \'validate_error\' => \'Введите целое число\'\r\n ));', `ClassDescription` = '', `DeleteTemplate` = '', `ClassTemplate` = '%INSERT_ID%', `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;