4.1
-- NetCat 4.1 Extra [0] component file, generated 2010-10-04 12:26:19
INSERT INTO `Class` SET `Class_Name` = 'Люди, работа: Личные контакты', `Class_Group` = 'Люди, работа', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '$f_AdminCommon\n<div class=\'nc_list nc_person_contacts\'>\n<table class=\'nc_table\'>\n".opt($colNums>1,str_repeat("<col $colWidth />" , $colNums))."\n<tr>', `FormSuffix` = '".opt($f_RowNum%$colNums, str_repeat(\'<td>&nbsp;</td>\',$colNums-$f_RowNum%$colNums) )."\n</tr>\n</table>\n</div>', `RecordTemplate` = '".opt( !($f_RowNum%$colNums) && $f_RowNum, \'</tr><tr>\' )."\n\n<td class=\'nc_row\'>$f_AdminButtons\n<h3>$f_Name</h3>\n".opt($f_Address , "<div class=\'nc_item\'><span class=\'nc_title\'>Адрес: </span><span class=\'nc_value\'>$f_Address</span></div>" )."\n".opt($f_PhoneHome, "<div class=\'nc_item\'><span class=\'nc_title\'>Телефон домашний: </span><span class=\'nc_value\'>$f_PhoneHome</span></div>" )."\n".opt($f_PhoneMobile, "<div class=\'nc_item\'><span class=\'nc_title\'>Телефон мобильный: </span><span class=\'nc_value\'>$f_PhoneMobile</span></div>" )."\n".opt($f_PhoneWork, "<div class=\'nc_item\'><span class=\'nc_title\'>Телефон рабочий: </span><span class=\'nc_value\'>$f_PhoneWork</span></div>" )."\n".opt($f_Blog, "<div class=\'nc_item\'><span class=\'nc_title\'>Адрес блога: </span><span class=\'nc_value\'><a href=\'$f_Blog\'>$f_Blog</a></span></div>" )."\n".opt($f_Homepage, "<div class=\'nc_item\'><span class=\'nc_title\'>Домашняя страница: </span><span class=\'nc_value\'><a href=\'$f_Homepage\'>$f_Homepage</a></span></div>" )."\n".opt($f_ICQ, "<div class=\'nc_item\'><span class=\'nc_title\'>Номер ICQ: </span><span class=\'nc_value\'>$f_ICQ</span></div>" )."\n".opt($f_Skype, "<div class=\'nc_item\'><span class=\'nc_title\'>Имя Skype: </span><span class=\'nc_value\'>$f_Skype</span></div>" )."\n</td>', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '<div class=\'nc_full nc_person_contacts\'>\n<h2>$f_Name</h2>\n".opt($f_Address , "<div class=\'nc_item\'><span class=\'nc_title\'>Адрес: </span><span class=\'nc_value\'>$f_Address</span></div>" )."\n".opt($f_PhoneHome, "<div class=\'nc_item\'><span class=\'nc_title\'>Телефон домашний: </span><span class=\'nc_value\'>$f_PhoneHome</span></div>" )."\n".opt($f_PhoneMobile, "<div class=\'nc_item\'><span class=\'nc_title\'>Телефон мобильный: </span><span class=\'nc_value\'>$f_PhoneMobile</span></div>" )."\n".opt($f_PhoneWork, "<div class=\'nc_item\'><span class=\'nc_title\'>Телефон рабочий: </span><span class=\'nc_value\'>$f_PhoneWork</span></div>" )."\n".opt($f_Blog, "<div class=\'nc_item\'><span class=\'nc_title\'>Адрес блога: </span><span class=\'nc_value\'><a href=\'$f_Blog\'>$f_Blog</a></span></div>" )."\n".opt($f_Homepage, "<div class=\'nc_item\'><span class=\'nc_title\'>Домашняя страница: </span><span class=\'nc_value\'><a href=\'$f_Homepage\'>$f_Homepage</a></span></div>" )."\n".opt($f_ICQ, "<div class=\'nc_item\'><span class=\'nc_title\'>Номер ICQ: </span><span class=\'nc_value\'>$f_ICQ</span></div>" )."\n".opt($f_Skype, "<div class=\'nc_item\'><span class=\'nc_title\'>Имя Skype: </span><span class=\'nc_value\'>$f_Skype</span></div>" )."\n</div>', `TitleTemplate` = '', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = '( !isset($nc_num_cols) ? $colNums = &$cc_settings[CollsNum] : $colNums = (int)$nc_num_cols );\n$colWidth = ( $colNums>1 ? \'width="\'.(floor(100/$colNums)).\'%"\' : NULL);\n', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '$settings_array = array(\n  \'CollsNum\' => array(\'type\' => \'string\',\n   \'default_value\' => \'3\',\n   \'caption\' => \'Количество колонок\',\n    \'size\' => \'3\',\n    \'validate_regexp\' => \'/^\\d+$/\',\n    \'validate_error\' => \'Введите целое число\'\n ),\n);', `ClassDescription` = 'Назначение компонента – автоматизировать ввод личных контактов.\n\nПоля: имя, адрес, телефон домашний, рабочий и мобильный, адрес \nличного блога и домашней страницы, номер ICQ и Skype.', `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, `Skype` char(255) NULL, `ICQ` char(255) NULL, `Homepage` char(255) NULL, `Blog` char(255) NULL, `PhoneWork` char(255) NULL, `PhoneMobile` char(255) NULL, `PhoneHome` char(255) NULL, `Address` char(255) NULL, `Name` char(255) NOT 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;
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Skype', 'Имя Skype', 1, '', 0, 8, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'ICQ', 'Номер ICQ', 1, '', 0, 7, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Homepage', 'Домашняя страница', 1, 'url', 0, 6, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Blog', 'Адрес блога', 1, 'url', 0, 5, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'PhoneWork', 'Телефон рабочий', 1, '', 0, 4, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'PhoneMobile', 'Телефон мобильный', 1, '', 0, 3, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'PhoneHome', 'Телефон домашний', 1, '', 0, 2, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Address', 'Адрес', 1, '', 0, 1, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Name', 'Имя', 1, '', 1, 0, 0, '', 1);