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` = '";\nif ($admin_mode && !$inside_admin) {\n $str_gallery_cc_sql = "SELECT `Sub_Class_ID` FROM `Sub_Class` WHERE `Subdivision_ID` = ".(int)$sub." AND `Class_ID` = 66";\n  $int_gallery_cc = $db->get_var($str_gallery_cc_sql);\n  if ($int_gallery_cc) {\n  $result.="<div style=\'padding:10px;background-color:#eee;border:1px solid #ccc\'><a href=\'".$SUB_FOLDER."/netcat/index.php?catalogue=$catalogue&sub=$sub&cc=$int_gallery_cc\'>Перейти к редактированию: Компонент Фотогаллеря</a></div>";\n }\n}\n$result.="$f_AdminCommon\n<table width=100% cellpadding=0 cellspacing=10 class=\'nagr\'>\n<tr>\n".opt($f_counter=0,"")."', `FormSuffix` = '</tr>\n</table>\n".opt($prevLink || $nextLink,browse_messages($cc_env,10))."', `RecordTemplate` = '".opt($f_counter!=0 && fmod($f_counter,$cc_settings[NumCols])==0,"</tr><tr>")."\n<td width=\'".floor((100/$cc_settings[NumCols]))."%\'>$f_AdminButtons\n<a href=$fullLink>$f_Name</a><br><span style=\'font-weight: normal\'>Фотографий:</span> ".$CntPhotos[$f_RowID]."<br>\n<a href=\'$fullLink\'><img src=\'$f_Picture\' alt=\'$f_Name\'></a>\n</td>\n".opt($f_counter++,"")."', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '$f_Descrition<br><br>";\n\n$ccGal=$cc_settings[\'GalleryCC\'];\necho " \r\n".s_list_class($sub,$ccGal,"&gallID=$message".($curPos? "&curPos=".$curPos : ""))."', `TitleTemplate` = '$f_Name', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '";\n\n  if ($_FILES[f_Picture][size]!=0 && $_FILES[f_Picture][type]!=\'\')\n  {\n    \n    eval(listQuery("SELECT CustomSettings FROM Sub_Class WHERE Sub_Class_ID=\'$cc\'","\\$data[CustomSettings]"));\n    global $nc_core;\n    require_once($nc_core->INCLUDE_FOLDER."classes/nc_imagetransform.class.php");\n    $photo_path = $DOCUMENT_ROOT.nc_file_path($classID, $message, \'Picture\', "");\n    if ($photo_path) nc_ImageTransform::imgResize("$photo_path","$photo_path",$CustomSettings[ImgWidth],$CustomSettings[ImgHeight]);\n  }\n### default\nif($inside_admin) {\n ob_end_clean();\n header("Location: ".$goBackLink."&inside_admin=1");\n exit;\n}\nelse {\n  echo NETCAT_MODERATION_MSG_OBJADD;\n  echo "<br><br>".$goBack;\n}\necho "', `EditActionTemplate` = '";\n  if ($_FILES[f_Picture][size]!=0 && $_FILES[f_Picture][type]!=\'\')\n  {\n    eval(listQuery("SELECT CustomSettings FROM Sub_Class WHERE Sub_Class_ID=\'$cc\'","\\$data[CustomSettings]"));\n    global $nc_core;\n    require_once($nc_core->INCLUDE_FOLDER."classes/nc_imagetransform.class.php");\n    $photo_path = $DOCUMENT_ROOT.nc_file_path($classID, $message, \'Picture\', "");\n    if ($photo_path) nc_ImageTransform::imgResize("$photo_path","$photo_path",$CustomSettings[ImgWidth],$CustomSettings[ImgHeight]);\n  }\n\n### default\nif($inside_admin) {\n  ob_end_clean();\n header("Location: ".$goBackLink."&inside_admin=1");\n exit;\n}\nelse {\n  echo NETCAT_MODERATION_MSG_OBJCHANGED;\n  echo "<br><br>".$goBack;\n}\necho "', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'if ($cc_settings[\'GalleryCC\'] == 0) { die( "No GalleryCC Set !" ); } \nglobal $LinkID;\nif (!$CntPhotos)\n{\n  $CntPhotos = array();\n  $GalID = listQuery("SELECT a.Class_ID FROM Sub_Class as a WHERE a.Sub_Class_ID = \'".$cc_settings[\'GalleryCC\']."\'","\\$data[Class_ID]");\n  $cnt_sql = "SELECT AlbumID FROM Message".$GalID." WHERE Checked=1";\n  $P_res = mysql_query( $cnt_sql, $LinkID);\n  while ($P_row = mysql_fetch_array($P_res)) $CntPhotos[$P_row[AlbumID]]++;\n}', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '1', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '$settings_array = array(\n\n \'NumCols\' => array(\'type\' => \'select\',\n    \'default_value\' => \'3\',\n   \'caption\' => \'Количество колонок\',\n    \'values\' => array(\'1\'=>\'1\', \'2\'=>\'2\', \'3\'=>\'3\', \'4\'=>\'4\', \'5\'=>\'5\')\n ),\n  \n  \'Checked\' => array(\'type\' => \'checkbox\',\n    \'caption\' => \'Разделить фотогалерею на альбомы\'\n ),\n  \'ImgWidth\' => array(\'type\' => \'string\',\n   \'default_value\' => 200,\n   \'caption\' => \'Ширина\',\n    \'size\' => 5,\n    \'validate_regexp\' => \'/^\\d+$/\',\n    \'validate_error\' => \'Введите целое число\'\n ),\n  \'ImgHeight\' => array(\'type\' => \'string\',\n    \'default_value\' => 200,\n   \'caption\' => \'Высота\',\n    \'size\' => 5,\n    \'validate_regexp\' => \'/^\\d+$/\',\n    \'validate_error\' => \'Введите целое число\'\n ),\n  \'GalleryCC\' => array(\'type\' => \'string\',\n    \'default_value\' => 0,\n   \'caption\' => \'Номер компонента "Фото-галерея" в разделе\',\n   \'size\' => 5,\n    \'validate_regexp\' => \'/^\\d+$/\',\n    \'validate_error\' => \'Введите целое число\'\n )\n\n);', `ClassDescription` = '', `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, `Name` char(255) NOT NULL, `Descrition` text NULL, `Picture` 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%, 'Name', 'Название фотоальбома', 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%, 'Descrition', 'Описание фотоальбома', 3, '4:80', 0, 2, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Picture', 'Изображение фотоальбома', 6, '2000000:image/*:fs3', 1, 1, 0, '', 1);