3.0 INSERT INTO Class SET Class_Name = 'Публикации: Статьи простые', Class_Group = 'Публикации', DaysToHold = '0', AllowTags = '1', FormPrefix = '$f_AdminCommon\r\n
', FormSuffix = '".opt( !$nc_title , \r\nopt($totRows>$f_RowNum && $cc_settings[ListingStyle]==\'fixed\' , "
Страницы: ".browse_messages($cc_env, 5)."
" )\r\n.opt($totRows && $cc_settings[ListingStyle]==\'day\' , "Архив по дням: ".listQuery("SELECT DATE_FORMAT(Date,\'%Y\') AS year, DATE_FORMAT(Date,\'%m\') AS month, DATE_FORMAT(Date,\'%d\') AS day FROM Message$classID WHERE Subdivision_ID=$sub AND Sub_Class_ID=$cc AND DATE_FORMAT(Date,\'%Y%m\')=\'$year$month\' GROUP BY DATE_FORMAT(Date,\'%d\') ORDER BY Date" , \'".($i?" | ":NULL).($data[day]==\'.$day.\'?$data[day]:"$data[day]")."\' ))\r\n.opt($totRows && $cc_settings[ListingStyle]==\'month\', "Архив по месяцам: ".listQuery("SELECT DATE_FORMAT(Date,\'%Y\') AS year, DATE_FORMAT(Date,\'%m\') AS month FROM Message$classID WHERE Subdivision_ID=$sub AND Sub_Class_ID=$cc AND DATE_FORMAT(Date,\'%Y\')=\'$year\' GROUP BY DATE_FORMAT(Date,\'%m\') ORDER BY Date" , \'".($i?" | ":NULL).($data[month]==\'.$month.\'?$data[month]:"$data[month]")."\' ))\r\n.opt($totRows && $cc_settings[ListingStyle]==\'year\', "Архив по годам: ".listQuery("SELECT DATE_FORMAT(Date,\'%Y\') AS year FROM Message$classID WHERE Subdivision_ID=$sub AND Sub_Class_ID=$cc GROUP BY DATE_FORMAT(Date,\'%Y\') ORDER BY Date" , \'".($i?" | ":NULL).($data[year]==\'.$year.\'?$data[year]:"$data[year]")."\' ))\r\n)."\r\n
', RecordTemplate = '
\r\n$f_AdminButtons\r\n".opt( $cc_settings[Group]==\'date\'&& $groupHeader=( $curDep == $f_Date_day ? NULL : $curDep=$f_Date_day ) , "

$groupHeader.$f_Date_month.$f_Date_year

" )\r\n.opt( $cc_settings[Group]==\'month\'&& $groupHeader=( $curDep == $f_Date_month ? NULL : $curDep=$f_Date_month ) , "

$groupHeader.$f_Date_year

" )."\r\n\r\n

".opt_case($cc_settings[FullLink]!=\'more\' && $f_Text , "$f_Title" , "$f_Title")."

\r\n".opt( $cc_settings[ShowPhotos] && $f_Picture , "\'$f_Title\'" )."\r\n".opt( $f_Announce , "

$f_Announce

" )."\r\n\r\n".opt( $cc_settings[Author]==\'field\' && $f_Author , "
Автор: ".($f_Email?"$f_Author":$f_Author)."
")."\r\n".opt( $cc_settings[Author]==\'profile\', "Автор")."\r\n\r\n".opt( $cc_settings[\'ShowRating\'] && $cc_settings[\'RatingSUB\'] && $cc_settings[\'RatingCC\'], "рейтинг: ".(int)s_list_class($cc_settings[\'RatingSUB\'], $cc_settings[\'RatingCC\'], "&scID=$cc&objID=$f_RowID&showWeight=1", true)."   " )."\r\n".opt( $cc_settings[\'ShowComments\'] && $cc_settings[\'CommentsSUB\'] && $cc_settings[\'CommentsCC\'] , "
комментарии: ".(int)s_list_class($cc_settings[CommentsSUB], $cc_settings[CommentsCC], "&scID=$cc&objID=$f_RowID&CountComments=1")."
" )."\r\n".opt( $cc_settings[ShowDate] , "
$f_Date_day.$f_Date_month.$f_Date_year
" )."\r\n\r\n".opt($cc_settings[FullLink]!=\'title\' && $f_Text , "подробнее...")."\r\n
\r\n
', RecordsPerPage = '20', SortBy = 'Date DESC', RecordTemplateFull = '
\r\n

$f_Title

\r\n".opt( $cc_settings[ShowPhotos] && $f_Picture , "\'$f_Title\'" )."\r\n
$f_Text
\r\n\r\n".opt( $cc_settings[Author]==\'field\' && $f_Author , "
Автор: ".($f_Email?"$f_Author":$f_Author)."
")."\r\n".opt( $cc_settings[Author]==\'profile\', "Автор")."\r\n".opt( $f_URL , "
Сайт автора: $f_URL
" )."\r\n".opt( $cc_settings[ShowDate] , "
$f_Date_day.$f_Date_month.$f_Date_year
" )."\r\n\r\n".opt( $cc_settings[\'ShowRating\'] && $cc_settings[\'RatingSUB\'] && $cc_settings[\'RatingCC\'], "
".s_list_class($cc_settings[RatingSUB], $cc_settings[RatingCC], "&scID=$cc&objID=$f_RowID&userID=$f_UserID&backlink=".urlencode(htmlspecialchars($GLOBALS[client_url]))."", true)."
")."\r\n".opt( $cc_settings[\'ShowComments\'] && $cc_settings[\'CommentsSUB\'] && $cc_settings[\'CommentsCC\'], "
".s_list_class($cc_settings[CommentsSUB], $cc_settings[CommentsCC], "&scID=$cc&objID=$f_RowID&backlink=".urlencode(htmlspecialchars($GLOBALS[client_url]))."", true)."
")."\r\n\r\n
', TitleTemplate = '', AddTemplate = '', EditTemplate = '', AddActionTemplate = '', EditActionTemplate = '', SearchTemplate = '', FullSearchTemplate = '', SubscribeTemplate = '', Settings = 'list( $year, $month, $day ) = split(\'-\', $GLOBALS[date]);\r\nif(!$year) $year = date(\'Y\');\r\nif(!$month) $month= date(\'m\');\r\nif(!$day) $day = date(\'d\');\r\n\r\nif ($cc_settings[ListingStyle]==\'fixed\') $recNum = $cc_settings[FixedNumRows];', AddCond = '', EditCond = '', SubscribeCond = '', NL2BR = '0', CheckActionTemplate = '', DeleteActionTemplate = '', CustomSettingsTemplate = '$settings_array = array(\r\n \'Author\' => array(\'type\' => \'select\',\r\n \'default_value\' => \'field\',\r\n \'caption\' => \'Автор\',\r\n \'values\' => array(\'field\' => \'значение поля «автор»\', \'profile\' => \'ссылка на профайл добавившего пользователя\')\r\n ),\r\n \'FullLink\' => array(\'type\' => \'select\',\r\n \'default_value\' => \'field\',\r\n \'caption\' => \'Ссылка на полный текст\',\r\n \'values\' => array(\'title\' => \'на заголовке\', \'more\' => \'на слове «подробнее»\', \'all\' => \'в обоих местах\')\r\n ),\r\n \'ListingStyle\' => array(\'type\' => \'select\',\r\n \'default_value\' => \'fixed\',\r\n \'caption\' => \'Листинг страниц\',\r\n \'values\' => array(\'fixed\' => \'фиксированное количество\', \'year\' => \'по годам\', \'month\' => \'по месяцам\', \'day\' => \'по дням\')\r\n ),\r\n \'FixedNumRows\' => array(\'type\' => \'string\',\r\n \'default_value\' => \'20\',\r\n \'caption\' => \'Количество статей на странице (при выводе фиксированного количества)\',\r\n \'size\' => \'3\',\r\n \'validate_regexp\' => \'/^\\d+$/\',\r\n \'validate_error\' => \'Введите целое число\'\r\n ),\r\n \'ShowDate\' => array(\'type\' => \'checkbox\',\r\n \'default_value\' => \'\',\r\n \'caption\' => \'Выводить дату у статьи\'\r\n ),\r\n \'Group\' => array(\'type\' => \'select\',\r\n \'default_value\' => \'disable\',\r\n \'caption\' => \'Группировка статей\',\r\n \'values\' => array(\'disable\' => \'не группировать\', \'date\' => \'по дате\', \'month\' => \'по месяцам\'),\r\n ),\r\n \'ShowPhotos\' => array(\'type\' => \'checkbox\',\r\n \'default_value\' => \'\',\r\n \'caption\' => \'Доступны фотографии\'\r\n ),\r\n \'ShowComments\' => array(\'type\' => \'checkbox\',\r\n \'default_value\' => \'\',\r\n \'caption\' => \'Доступны комментарии\'\r\n ),\r\n \'CommentsSUB\' => array(\'type\' => \'string\',\r\n \'default_value\' => \'0\',\r\n \'caption\' => \'Идентификатор раздела с комментариями\',\r\n \'size\' => \'3\',\r\n \'validate_regexp\' => \'/^\\d+$/\',\r\n \'validate_error\' => \'Введите целое число\'\r\n ),\r\n \'CommentsCC\' => array(\'type\' => \'string\',\r\n \'default_value\' => \'0\',\r\n \'caption\' => \'Идентификатор компонента комментариев в разделе\',\r\n \'size\' => \'3\',\r\n \'validate_regexp\' => \'/^\\d+$/\',\r\n \'validate_error\' => \'Введите целое число\'\r\n ),\r\n \'ShowRating\' => array(\'type\' => \'checkbox\',\r\n \'default_value\' => \'\',\r\n \'caption\' => \'Доступны рейтинги\'\r\n ),\r\n \'RatingSUB\' => array(\'type\' => \'string\',\r\n \'default_value\' => \'0\',\r\n \'caption\' => \'Идентификатор раздела с рейтингами\',\r\n \'size\' => \'3\',\r\n \'validate_regexp\' => \'/^\\d+$/\',\r\n \'validate_error\' => \'Введите целое число\'\r\n ),\r\n \'RatingCC\' => array(\'type\' => \'string\',\r\n \'default_value\' => \'0\',\r\n \'caption\' => \'Идентификатор компонента рейтингов в разделе\',\r\n \'size\' => \'3\',\r\n \'validate_regexp\' => \'/^\\d+$/\',\r\n \'validate_error\' => \'Введите целое число\'\r\n )\r\n);'; 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(14) NOT NULL,LastUser_ID int(11) NOT NULL default '0',LastIP varchar(15) default NULL,LastUserAgent varchar(255) default NULL,Keyword varchar(255) NOT NULL default '',URL char(255) NULL,Email char(255) NULL,Author char(255) NULL,Text text NOT NULL,Date datetime NOT NULL,Picture char(255) NULL,Announce text NULL,Title char(255) NOT NULL, 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 Sub_Class_ID (Sub_Class_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%,'URL', 'Сайт автора', 1, 'url', 0, 7, 0, '', 1); INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Email', 'E-mail автора', 1, 'email', 0, 6, 0, '', 1); INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Author', 'Автор', 1, '', 0, 5, 0, '', 1); INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Text', 'Текст', 3, '8:60', 1, 2, 0, '', 1); INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Date', 'Дата', 8, 'event', 1, 3, 0, '', 1); INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Picture', 'Изображение для списка', 6, '50000:image/*', 0, 4, 0, '', 1); INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Announce', 'Анонс', 3, '4:60', 0, 1, 0, '', 1); INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Title', 'Заголовок', 1, '', 1, 0, 0, '', 1);