4.2
-- NetCat 4.2 Extra [0] component file, generated 2010-10-01 18:17:03
INSERT INTO `Class` SET `Class_Name` = 'Пользователи: Друзья', `Class_Group` = 'Пользователи', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '";\r\n\r\n$result .= "\r\n<form action=\'/".$SUB_FOLDER."netcat/modules/auth/add_relation.php\' method=\'post\'>\r\n<table class=\'nc_user_list\'>\r\n<tr>\r\n<th>Пользователь</th>\r\n<th>Отношение</th>\r\n</tr>', `FormSuffix` = '<tr><td colspan=\'2\' align=\'center\'>\r\n<input type=\'submit\' value=\'OK\'>\r\n</td></tr>\r\n</table>\r\n<input type=\'hidden\' value=\'".$_SERVER[\'REQUEST_URI\']."\' name=\'redirect_url\'>\r\n</form>\r\n\r\n<div class=\'nc_pagination\'>Страницы: ".browse_messages($cc_env, 10)."</div>\r\n\r\n', `RecordTemplate` = '";\r\n$is_friend = nc_auth_is_friend($f_user_id);\r\n$is_banned = nc_auth_is_banned($f_user_id);\r\n$is_neutral = !($is_friend || $is_banned) ;\r\n$result .= "\r\n<tr>\r\n  <td><a href=\'".nc_auth_profile_url($f_user_id)."\'>$f_login</a></td>\r\n  <td align=\'center\'>\r\n    <input type=\'radio\' name=\'user_".$f_user_id."\' value=\'1\'  ".($is_friend ? \'checked\' : \'\')." > Друг\r\n    <input type=\'radio\' name=\'user_".$f_user_id."\' value=\'-1\' ".($is_neutral ? \'checked\' : \'\')." > Нейтраль\r\n    <input type=\'radio\' name=\'user_".$f_user_id."\' value=\'2\'  ".($is_banned ? \'checked\' : \'\')." > Враг\r\n  </td>\r\n</tr>', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = '// запрос будет составляться вручную\r\n$ignore_all = 1;\r\n// поля для выборки\r\n$query_select = \'User_ID, Login\';\r\n// таблица\r\n$query_from = \'User\';\r\n// самого себя не показываем\r\n$query_where = "User_ID <> ".$AUTH_USER_ID;\r\n// по 20 пользоватлей на странице\r\n$query_limit = ($curPos+0).", 20";\r\n// в эти переменные попадут результаты выборки\r\n$result_vars = \'$f_user_id, $f_login\';', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `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, `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;