3.0
INSERT INTO Class SET Class_Name = 'Товары и услуги: Простой каталог товаров', Class_Group = 'Товары и услуги', DaysToHold = '0', AllowTags = '1', FormPrefix = '$f_AdminCommon\n<div class=\'nc_list nc_simple_catalog\'>\n<table class=\'nc_table\'>\n".( $NumCols>1 ? str_repeat("<col $ColWidth />",$NumCols) : NULL )."\n<tr>', FormSuffix = '".( $f_RowNum%$NumCols ? str_repeat(\'<td>&nbsp;</td>\',($NumCols-$f_RowNum%$NumCols)) : NULL )."\n</tr>\n</table>\n\n".opt( $totRows>$f_RowNum && !$nc_title && !$srchPat ,\n"<div class=\'nc_pagination\'>\n".opt($cc_settings[\'PaginationMode\']!=\'nums\',"\n <div class=\'nc_prev_next\'>\n  <span class=\'nc_prev_link\'>".opt_case($prevLink , "<a href=\'$prevLink\'>Назад</a>","Назад")."</span>\n  <span class=\'nc_next_link\'>".opt_case($nextLink, "<a href=\'$nextLink\'>Далее</a>","Далее")."</span>\n </div>\n").opt($cc_settings[\'PaginationMode\']!=\'next_prev\',"\n  <div class=\'nc_pagination\'>Страницы: ".browse_messages($cc_env, 5)."</div>\n")."\n</div>\n")."\n\n</div>', RecordTemplate = '".opt( !($f_RowNum%$NumCols) && $f_RowNum , \'</tr><tr>\' )."\n<td class=\'nc_row\'>\n$f_AdminButtons\n\n<h3>".( $cc_settings[\'Link\'] != \'photo\' ? "<a href=\'$fullLink\'>$f_Title</a>" : $f_Title )."</h3>\n".( $f_PhotoSmall ? ( $cc_settings[\'Link\'] != \'title\' ? "<a href=\'$fullLink\'><img src=\'$f_PhotoSmall\' class=\'nc_row_img\' alt=\'$f_Title\' /></a>" : "<img src=\'$f_PhotoSmall\' class=\'nc_row_img\' alt=\'$f_Title\' />" ) : NULL )."\n".( !$cc_settings[\'ShowPrice\'] && $f_Price ? "<div class=\'nc_price\'><span class=\'nc_title\'>Цена: </span><span class=\'nc_value\'>$f_Price $Pay</span></div>" : NULL )."\n".( $f_Description ? "<div class=\'nc_description\'>$f_Description</div>" : NULL )."\n\n</td>', RecordsPerPage = '20', SortBy = '', RecordTemplateFull = '<div class=\'nc_full nc_simple_catalog\'>\n<h2>$f_Title</h2>\n".( $f_PhotoSmall ? opt( $f_PhotoLarge , "<a href=\'$f_PhotoLarge\'>" )."<img src=\'$f_PhotoSmall\' class=\'nc_row_img\' align=\'left\' alt=\'$f_Title\' />".opt( $f_PhotoLarge , \'</a>\' ) : NULL )."\n".( $f_TextFull ? "<div class=\'nc_full_text\'>$f_TextFull</div>" : NULL )."\n".( $f_Price ? "<div class=\'nc_price\'><span class=\'nc_title\'>Цена: </span><span class=\'nc_value\'>$f_Price $Pay</span></div>" : NULL )."\n</div>', TitleTemplate = '', AddTemplate = '', EditTemplate = '', AddActionTemplate = '', EditActionTemplate = '', SearchTemplate = '', FullSearchTemplate = '', SubscribeTemplate = '', Settings = '( !isset($nc_num_cols) ? $NumCols = &$cc_settings[NumCols] : $NumCols= (int)$nc_num_cols );\n$ColWidth= ( $NumCols>1 ? \'width="\'.(floor(100/$NumCols)).\'%"\' : NULL);\n$Pay = array(\'rur\'=>\'руб.\',\'usd\'=>\'$\',\'eu\'=>\'&euro;\',\'no\'=>\'\',\'other\'=>$cc_settings[\'OtherPay\']);\n$Pay = $Pay[$cc_settings[\'Pay\']];', AddCond = '', EditCond = '', SubscribeCond = '', NL2BR = '0', CheckActionTemplate = '', DeleteActionTemplate = '', CustomSettingsTemplate = '$settings_array = array(\n	\'PaginationMode\' => array(\'type\' => \'select\',\n		\'default_value\' => \'next_prev\',\n		\'caption\' => \'Листинг по страницам\',\n		\'values\' => array(\'next_prev\' => \'вперед/назад\', \'nums\' => \'по номерам страниц\', \'all\'=>\'оба варианта\')\n	),\n	\'NumCols\' => array(\'type\' => \'string\',\n		\'default_value\' => \'3\',\n		\'caption\' => \'Количество колонок\',\n		\'size\' => \'3\',\n		\'validate_regexp\' => \'/^\\d+$/\',\n		\'validate_error\' => \'Введите целое число\'\n	),\n	\'ShowPrice\' => array(\'type\' => \'checkbox\',\n		\'caption\' => \'Не выводить цену в списке\'	\n	),\n	\'Pay\' => array(\'type\' => \'select\',\n		\'default_value\' => \'rur\',\n		\'caption\' => \'Цена в\',\n		\'values\' => array(\'rur\' => \'рубли\', \'usd\' => \'доллары\', \'eu\'=>\'евро\', \'no\'=>\'не выводить\', \'other\'=>\'другая валюта\' )\n	),\n	\'OtherPay\' => array(\'type\' => \'string\',\n		\'default_value\' => \'\',\n		\'caption\' => \'Другая валюта\',\n		\'size\' => \'21\'\n	),\n	\'Link\' => array(\'type\' => \'select\',\n		\'default_value\' => \'all\',\n		\'caption\' => \'Ссылка на полный вид\',\n		\'values\' => array( \'photo\' => \'на фото\', \'title\' => \'на названии\', \'all\'=>\'на фото и на названии\' )\n	)\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 '',Title char(255) NOT NULL,Price int NULL,PhotoSmall char(255) NULL,PhotoLarge char(255) NULL,Description text NULL,TextFull text 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%,'Title', 'Название', 1, '', 1, 0, 0, '', 1);
INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Price', 'Цена', 2, '', 0, 1, 0, '', 1);
INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'PhotoSmall', 'Маленькое фото', 6, '50000:image/*', 0, 2, 0, '', 1);
INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'PhotoLarge', 'Большое фото', 6, '200000:image/*', 0, 3, 0, '', 1);
INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'Description', 'Краткое описание', 3, '4:60', 0, 4, 0, '', 1);
INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'TextFull', 'Подробное описание', 3, '6:60', 0, 5, 0, '', 1);