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` = '1', `FormPrefix` = '$f_AdminCommon\r\n$t_prefix\r\n<ol start=\'".($curPos+1)."\'>', `FormSuffix` = '</ol>\r\n".browse_messages($cc_env, 10)."', `RecordTemplate` = '<li>\r\n<h3><a href=".opt_case( $f_SiteURLCom, $f_SiteURLCom, $f_SiteURL ).">$f_SiteName</a></h3>\r\n".opt($admin_mode, LM_PopupLink($f_SiteURL, $f_SiteBackURL))."\r\n<br>\r\n".opt($admin_mode && !$f_Checked, "<div style=\'color:red\'>".NETCAT_MODULE_LINKS_TURNED_OFF." $f_SiteUnchecked</div>")."\r\n".opt_case($f_SiteCodeCom, $f_SiteCodeCom, $f_SiteCode)."<br>\r\n<span style=\'color:green\'>$f_SiteURL</span> <a href=$fullLink>@</a>\r\n$f_AdminButtons\r\n</li>', `RecordsPerPage` = '10', `SortBy` = 'Priority, Created desc', `RecordTemplateFull` = '<b><a href=".opt_case($f_SiteURLCom, $f_SiteURLCom, $f_SiteURL).">$f_SiteName</a></b><br>\r\n".opt($admin_mode && !$f_Checked, "<font color=red>".NETCAT_MODULE_LINKS_TURNED_OFF." $f_SiteUnchecked</font><br>")."\r\n".opt_case($f_SiteCodeCom, $f_SiteCodeCom, $f_SiteCode)."<br>\r\n".opt($admin_mode, LM_PopupLink($f_SiteURL, $f_SiteBackURL))."\r\n', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '".LM_Send_Mail_Added()."', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'if( isset($srch) ) $srch = $db->escape($srch);\r\n$is_root = 0;\r\nif( !$current_sub[Parent_Sub_ID] )\r\n	$is_root = 1;\r\nelseif( !listQuery(\'select count(Sub_Class_ID) as count from Sub_Class where Class_ID=\'.$MODULE_VARS[linkmanager][LINKS_CLASS].\' and Subdivision_ID=\'.$current_sub[Parent_Sub_ID] , \'$data[count]\') )\r\n	$is_root=1;\r\n\r\nif ($is_root){\r\n	$ignore_sub = 1;\r\n	$ignore_cc = 1;\r\n	$t_pref = "\r\n		<form action=\'{$_SERVER[REQUEST_URI]}\' method=\'get\'>\r\n			<input type=\'text\' size=\'25\' name=\'srch\' value=\'".htmlspecialchars($srch, ENT_QUOTES)."\'> <input type=\'submit\' value=\'".NETCAT_MODULE_LINKS_DO_SEARCH."\'>\r\n		</form>\r\n		<a href=\'rules/\'>".NETCAT_MODULE_LINKS_RULES."</a> // <a href=\'codes/\'>".NETCAT_MODULE_LINKS_CODES2."</a>";\r\n	if($srch) $query_where = "SiteName like \'%$srch%\' or SiteURL like \'%$srch%\' or SiteCode like \'%$srch%\'";\r\n}else{\r\n	$t_pref = listQuery("select Hidden_URL from Subdivision where Subdivision_ID=".$current_sub[Parent_Sub_ID], "<a href=".$SUB_FOLDER."\\$data[Hidden_URL]>".NETCAT_MODULE_LINKS_GO_UP."</a> // <a href=$addLink>".NETCAT_MODULE_LINKS_ADD_SITE."</a>");\r\n}\r\n\r\n\r\nif( listQuery("select count(Subdivision_ID) as count from Subdivision where Parent_Sub_ID=$sub and Checked=1", \'$data[count]\') ){\r\n	$res1 = mysql_query("select Subdivision_ID, Subdivision_Name, Hidden_URL from Subdivision where Parent_Sub_ID=$sub and Checked=1 order by Priority");\r\n	while( $row = mysql_fetch_assoc($res1) ){\r\n		$i++;\r\n		$t_prefix .= "<tr><td valign=\'top\'><a href=".$SUB_FOLDER.$row[Hidden_URL].">".$row[Subdivision_Name]."</a> ".listQuery("select count(Message_ID) as count from Message".$MODULE_VARS[linkmanager][LINKS_CLASS]." where Subdivision_ID=".$row[Subdivision_ID]." and Checked=1", "(\\$data[count])")."</td></tr>";\r\n	}\r\n}\r\n\r\n\r\n$t_prefix = "<table width=\'100%\' border=\'0\'>$t_prefix</table>$t_pref";', `AddCond` = '$warn = LM_Verify_Link($f_SiteURL, $f_SiteCode, $f_SiteBackURL, 0, $f_SiteEmail, "add");\r\nif ($warn)\r\n{\r\n $warnText=$warn;\r\n $posting=0;\r\n}\r\n', `EditCond` = '$warn = LM_Verify_Link($f_SiteURL, $f_SiteCode, $f_SiteBackURL, $message, $f_SiteEmail, "edit");\r\nif ($warn)\r\n{\r\n $warnText=$warn;\r\n $posting=0;\r\n}', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '', `ClassDescription` = 'Компонент используется в модуле "Управление ссылками".\r\nБолее подробная информация о компоненте содержится в документации к этому модулю.', `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 DEFAULT '0',  `Subdivision_ID` int(11) NOT NULL DEFAULT '0',  `Sub_Class_ID` int(11) NOT NULL DEFAULT '0',  `Priority` int(11) NOT NULL DEFAULT '0',  `Checked` tinyint(4) NOT NULL DEFAULT '1',  `TimeToDelete` date DEFAULT NULL,  `TimeToUncheck` date DEFAULT NULL,  `IP` varchar(15) DEFAULT NULL,  `UserAgent` varchar(255) DEFAULT NULL,  `Parent_Message_ID` int(11) NOT NULL DEFAULT '0',  `Created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  `LastUser_ID` int(11) NOT NULL DEFAULT '0',  `LastIP` varchar(15) DEFAULT NULL,  `LastUserAgent` varchar(255) DEFAULT NULL,  `Keyword` varchar(255) NOT NULL DEFAULT '',  `ncTitle` varchar(255) DEFAULT NULL,  `ncKeywords` varchar(255) DEFAULT NULL,  `ncDescription` text,  `SiteNotProcess` tinyint(4) NOT NULL DEFAULT '0',  `SiteUnchecked` datetime DEFAULT NULL,  `SiteURLCom` varchar(255) DEFAULT NULL,  `SiteCodeCom` text,  `SiteURL` varchar(255) NOT NULL DEFAULT '',  `SiteEmail` varchar(255) NOT NULL DEFAULT '',  `SiteBackURL` varchar(255) DEFAULT NULL,  `SiteCode` text,  `SiteName` varchar(255) NOT NULL DEFAULT '',  PRIMARY KEY (`Message_ID`),  UNIQUE KEY `Sub_Class_ID_2` (`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;
 INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteURLCom', 'Компилированная ссылка', 1, '', 0, 6, 0, '', 3);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteURL', 'URL Вашего сайта', 1, 'url', 1, 2, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteEmail', 'Ваш РЕАЛЬНЫЙ e-mail', 1, 'email', 1, 5, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteBackURL', 'Адрес страницы с обратной ссылкой', 1, 'url', 0, 4, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteName', 'Название вашего сайта', 1, '', 1, 1, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteCodeCom', 'Компилированный код ссылки', 3, '', 0, 7, 0, '', 3);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteCode', 'HTML-код ссылки', 3, '8:40', 0, 3, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteNotProcess', 'Не обрабатывать ссылку роботом', 5, '', 1, 9, 0, '', 2);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'SiteUnchecked', 'Дата выключения ссылки', 8, '', 0, 8, 0, '', 3);