в категории стоят права для всх пользователей я уже везде ковырялся не знаю в чем дело даже.
Открыть
Ответить
Помогите модуль album для open slaed
помогите плиззз, в админке добавленые фото видно на главной страницы видно категорию написано что там есть файлы но фото не видно что делать??? и еще изменяю размер загружаемых фото на больше а они работать не хоть всеравно остаеться как по умолчанию 1м плиз кто может помогите
читай что я писала выше :)
помогите плиззз, в админке добавленые фото видно на главной страницы видно категорию написано что там есть файлы но фото не видно что делать??? и еще изменяю размер загружаемых фото на больше а они работать не хоть всеравно остаеться как по умолчанию 1м плиз кто может помогите
читай что я писала выше :)
все так сделал но он отказываеться работать, скинь свой sql код с бд еще раз посмотрю на него!
Версия системы: Open SLAED 1.*
Версия PHP: PHP 5
Сервер: Локальный сервер
CREATE TABLE `{pref}_album_categories` (
`gallid` int(3) NOT NULL auto_increment,
`gallname` varchar(30) NOT NULL default '',
`gallimg` varchar(50) NOT NULL default '',
`galloc` longtext,
`description` text NOT NULL,
`parent` int(3) NOT NULL default '-1',
`visible` tinyint(3) unsigned NOT NULL default '0',
`template` int(10) unsigned NOT NULL default '2',
`thumbwidth` int(2) unsigned NOT NULL default '70',
`numcol` tinyint(3) unsigned NOT NULL default '3',
`total` int(10) unsigned NOT NULL default '0',
`lastadd` date NOT NULL default '0000-00-00',
PRIMARY KEY (`gallid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
CREATE TABLE `{pref}_album_comments` (
`cid` int(11) NOT NULL auto_increment,
`pid` int(4) NOT NULL default '0',
`comment` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(255) default NULL,
`member` int(1) NOT NULL default '0',
PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
CREATE TABLE `{pref}_album_media_class` (
`id` int(2) NOT NULL default '0',
`class` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `{pref}_album_media_class` VALUES (1, 'Image');
INSERT INTO `{pref}_album_media_class` VALUES (2, 'Audio');
INSERT INTO `{pref}_album_media_class` VALUES (3, 'Video');
CREATE TABLE `{pref}_album_media_types` (
`extension` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`filetype` varchar(20) NOT NULL default '',
`displaytag` text NOT NULL,
`thumbnail` varchar(255) NOT NULL default '',
PRIMARY KEY (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `{pref}_album_media_types` VALUES ('bmp', 'Image/BMP', '1', '<img src="<:FILENAME:>" border="0" alt="<:DESCRIPTION:>">', 'GIF.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('gif', 'Image/GIF', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'GIF.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('jpg', 'Image/JPG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'JPG.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('png', 'Image/PNG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'PNG.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mov', 'Video/Quicktime', '3', '<embed controller="true" width="<:WIDTH:>" height="<:HEIGHT:>" src="<:FILENAME:>" border="0" pluginspage="http://www.apple.com/quicktime/download/indext.html"></embed>', 'MOV.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('avi', 'Video/AVI', '3', '<embed src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" type="application/x-mplayer2"></embed>', 'AVI.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mpg', 'Video/MPEG', '3', '<embed src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" type="application/x-mplayer2"></embed>', 'MPG.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mp3', 'Audio/MP3', '2', '<embed controller="true" width="200" height="20" src="<:FILENAME:>" border="0" pluginspage="http://www.apple.com/quicktime/download/indext.html"></embed>', 'MP3.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mid', 'Audio/MIDI', '2', '<embed src="<:FILENAME:>" type="audio/midi" hidden="false" autostart="true" loop="true" height="20" width="200"></embed>', 'MID.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('swf', 'Video/Flash', '3', '<embed src="<:FILENAME:>" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="<:WIDTH:>" height="<:HEIGHT:>" play="true" loop="true" quality="high" scale="showall" menu="true"></embed>', 'SWF.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('rm', 'Video/RealMedia', '3', '<OBJECT height="<:HEIGHT:>">\r\n<PARAM NAME="CONTROLS" VALUE="ImageWindow">\r\n<PARAM NAME="AUTOSTART" Value="true">\r\n<PARAM NAME="SRC" VALUE="<:FILENAME:>">\r\n<embed height="<:HEIGHT:>" width="<:WIDTH:>" controls="ImageWindow" src="<:FILENAME:>?embed" type="audio/x-pn-realaudio-plugin" autostart="true" nolabels="0" autogotourl="-1"></OBJECT>', 'REAL.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('jpeg', 'Image/JPG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'JPG.gif');
CREATE TABLE `{pref}_album_pictures` (
`pid` int(10) unsigned NOT NULL auto_increment,
`gid` int(3) NOT NULL default '0',
`img` varchar(255) NOT NULL default '',
`counter` int(10) unsigned NOT NULL default '0',
`submitter` varchar(24) NOT NULL default 'Webmaster',
`date` datetime default NULL,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`votes` int(10) unsigned NOT NULL default '0',
`rate` float NOT NULL default '0',
`extension` varchar(10) NOT NULL default 'image',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
CREATE TABLE `{pref}_album_pictures_newpicture` (
`pid` int(10) unsigned NOT NULL auto_increment,
`gid` int(3) NOT NULL default '0',
`img` varchar(255) NOT NULL default '',
`counter` int(10) unsigned NOT NULL default '0',
`submitter` varchar(24) NOT NULL default 'Webmaster',
`date` datetime default NULL,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`votes` int(10) unsigned NOT NULL default '0',
`rate` float NOT NULL default '0',
`extension` varchar(10) NOT NULL default 'image',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;
CREATE TABLE `{pref}_album_template_types` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`type` tinyint(3) unsigned NOT NULL default '2',
`templateCategory` longtext NOT NULL,
`templatePictures` longtext NOT NULL,
`templateCSS` longtext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `{pref}_album_template_types` VALUES (1, 'Default Main Page Template', 1, '<table align="center">\r\n<tr>\r\n <td colspan="2">\r\n <:GALLNAME:>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td>\r\n <:IMAGE:>\r\n </td>\r\n <td valign="top" align="left">\r\n <:DESCRIPTION:>\r\n </td>\r\n</tr>\r\n</table>', '', '.common_text_black {text-color:#000000}\r\n.common_text_white {text-color:#ffffff}');
INSERT INTO `{pref}_album_template_types` VALUES (2, 'Default', 2, '<table border="1" cellpadding="2" cellspacing="0">\r\n<tr>\r\n <td align="center">\r\n <:RATINGBAR:><br><br>\r\n <:IMAGE:>\r\n </td>\r\n <td valign="top" class="bgcolor4">\r\n <p>\r\n <table border="0">\r\n <tr>\r\n <td align="center">\r\n <:DATE:>\r\n </td>\r\n <td align="center">\r\n <:NEW:>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align="center">\r\n <:HITS:>\r\n </td>\r\n <td align="center">\r\n <:RATE:>\r\n </td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p><:DESCRIPTION:></p>\r\n <p><:NBCOMMENTS:><br> \r\n <:FORMAT:> <:SIZE:>\r\n </p>\r\n </td>\r\n</tr>\r\n</table>', '<table border="0">\r\n<tr>\r\n <td valign="top" align="center">\r\n <:NAMESIZE:>\r\n <br>\r\n <TABLE border="0" CellPadding="0" CellSpacing="0">\r\n <TR>\r\n <TD valign="top">\r\n <:RATINGBAR:><br><br>\r\n <:SUBMITTER:>\r\n <:DATE:>\r\n <:HITS:>\r\n </TD>\r\n </TR>\r\n </TABLE><br>\r\n <:DOWNLOAD:><br>\r\n <:PRINT:><br><br>\r\n <:POSTCARD:>\r\n </td>\r\n <td width="75%" align="center">\r\n <:IMAGE:>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td colspan="2"><:DESCRIPTION:></td>\r\n</tr>\r\n<tr>\r\n <td colspan="2">\r\n <:COMMENTS:>\r\n </td>\r\n</tr>\r\n</table>', '.common_text_black {text-color:#000000}\r\n.common_text_white {text-color:#ffffff}');
`gallid` int(3) NOT NULL auto_increment,
`gallname` varchar(30) NOT NULL default '',
`gallimg` varchar(50) NOT NULL default '',
`galloc` longtext,
`description` text NOT NULL,
`parent` int(3) NOT NULL default '-1',
`visible` tinyint(3) unsigned NOT NULL default '0',
`template` int(10) unsigned NOT NULL default '2',
`thumbwidth` int(2) unsigned NOT NULL default '70',
`numcol` tinyint(3) unsigned NOT NULL default '3',
`total` int(10) unsigned NOT NULL default '0',
`lastadd` date NOT NULL default '0000-00-00',
PRIMARY KEY (`gallid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
CREATE TABLE `{pref}_album_comments` (
`cid` int(11) NOT NULL auto_increment,
`pid` int(4) NOT NULL default '0',
`comment` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(255) default NULL,
`member` int(1) NOT NULL default '0',
PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
CREATE TABLE `{pref}_album_media_class` (
`id` int(2) NOT NULL default '0',
`class` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `{pref}_album_media_class` VALUES (1, 'Image');
INSERT INTO `{pref}_album_media_class` VALUES (2, 'Audio');
INSERT INTO `{pref}_album_media_class` VALUES (3, 'Video');
CREATE TABLE `{pref}_album_media_types` (
`extension` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`filetype` varchar(20) NOT NULL default '',
`displaytag` text NOT NULL,
`thumbnail` varchar(255) NOT NULL default '',
PRIMARY KEY (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `{pref}_album_media_types` VALUES ('bmp', 'Image/BMP', '1', '<img src="<:FILENAME:>" border="0" alt="<:DESCRIPTION:>">', 'GIF.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('gif', 'Image/GIF', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'GIF.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('jpg', 'Image/JPG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'JPG.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('png', 'Image/PNG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'PNG.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mov', 'Video/Quicktime', '3', '<embed controller="true" width="<:WIDTH:>" height="<:HEIGHT:>" src="<:FILENAME:>" border="0" pluginspage="http://www.apple.com/quicktime/download/indext.html"></embed>', 'MOV.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('avi', 'Video/AVI', '3', '<embed src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" type="application/x-mplayer2"></embed>', 'AVI.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mpg', 'Video/MPEG', '3', '<embed src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" type="application/x-mplayer2"></embed>', 'MPG.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mp3', 'Audio/MP3', '2', '<embed controller="true" width="200" height="20" src="<:FILENAME:>" border="0" pluginspage="http://www.apple.com/quicktime/download/indext.html"></embed>', 'MP3.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('mid', 'Audio/MIDI', '2', '<embed src="<:FILENAME:>" type="audio/midi" hidden="false" autostart="true" loop="true" height="20" width="200"></embed>', 'MID.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('swf', 'Video/Flash', '3', '<embed src="<:FILENAME:>" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="<:WIDTH:>" height="<:HEIGHT:>" play="true" loop="true" quality="high" scale="showall" menu="true"></embed>', 'SWF.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('rm', 'Video/RealMedia', '3', '<OBJECT height="<:HEIGHT:>">\r\n<PARAM NAME="CONTROLS" VALUE="ImageWindow">\r\n<PARAM NAME="AUTOSTART" Value="true">\r\n<PARAM NAME="SRC" VALUE="<:FILENAME:>">\r\n<embed height="<:HEIGHT:>" width="<:WIDTH:>" controls="ImageWindow" src="<:FILENAME:>?embed" type="audio/x-pn-realaudio-plugin" autostart="true" nolabels="0" autogotourl="-1"></OBJECT>', 'REAL.gif');
INSERT INTO `{pref}_album_media_types` VALUES ('jpeg', 'Image/JPG', '1', '<img src="<:FILENAME:>" border="0" width="<:WIDTH:>" height="<:HEIGHT:>" alt="<:DESCRIPTION:>">', 'JPG.gif');
CREATE TABLE `{pref}_album_pictures` (
`pid` int(10) unsigned NOT NULL auto_increment,
`gid` int(3) NOT NULL default '0',
`img` varchar(255) NOT NULL default '',
`counter` int(10) unsigned NOT NULL default '0',
`submitter` varchar(24) NOT NULL default 'Webmaster',
`date` datetime default NULL,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`votes` int(10) unsigned NOT NULL default '0',
`rate` float NOT NULL default '0',
`extension` varchar(10) NOT NULL default 'image',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
CREATE TABLE `{pref}_album_pictures_newpicture` (
`pid` int(10) unsigned NOT NULL auto_increment,
`gid` int(3) NOT NULL default '0',
`img` varchar(255) NOT NULL default '',
`counter` int(10) unsigned NOT NULL default '0',
`submitter` varchar(24) NOT NULL default 'Webmaster',
`date` datetime default NULL,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`votes` int(10) unsigned NOT NULL default '0',
`rate` float NOT NULL default '0',
`extension` varchar(10) NOT NULL default 'image',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;
CREATE TABLE `{pref}_album_template_types` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`type` tinyint(3) unsigned NOT NULL default '2',
`templateCategory` longtext NOT NULL,
`templatePictures` longtext NOT NULL,
`templateCSS` longtext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `{pref}_album_template_types` VALUES (1, 'Default Main Page Template', 1, '<table align="center">\r\n<tr>\r\n <td colspan="2">\r\n <:GALLNAME:>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td>\r\n <:IMAGE:>\r\n </td>\r\n <td valign="top" align="left">\r\n <:DESCRIPTION:>\r\n </td>\r\n</tr>\r\n</table>', '', '.common_text_black {text-color:#000000}\r\n.common_text_white {text-color:#ffffff}');
INSERT INTO `{pref}_album_template_types` VALUES (2, 'Default', 2, '<table border="1" cellpadding="2" cellspacing="0">\r\n<tr>\r\n <td align="center">\r\n <:RATINGBAR:><br><br>\r\n <:IMAGE:>\r\n </td>\r\n <td valign="top" class="bgcolor4">\r\n <p>\r\n <table border="0">\r\n <tr>\r\n <td align="center">\r\n <:DATE:>\r\n </td>\r\n <td align="center">\r\n <:NEW:>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align="center">\r\n <:HITS:>\r\n </td>\r\n <td align="center">\r\n <:RATE:>\r\n </td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p><:DESCRIPTION:></p>\r\n <p><:NBCOMMENTS:><br> \r\n <:FORMAT:> <:SIZE:>\r\n </p>\r\n </td>\r\n</tr>\r\n</table>', '<table border="0">\r\n<tr>\r\n <td valign="top" align="center">\r\n <:NAMESIZE:>\r\n <br>\r\n <TABLE border="0" CellPadding="0" CellSpacing="0">\r\n <TR>\r\n <TD valign="top">\r\n <:RATINGBAR:><br><br>\r\n <:SUBMITTER:>\r\n <:DATE:>\r\n <:HITS:>\r\n </TD>\r\n </TR>\r\n </TABLE><br>\r\n <:DOWNLOAD:><br>\r\n <:PRINT:><br><br>\r\n <:POSTCARD:>\r\n </td>\r\n <td width="75%" align="center">\r\n <:IMAGE:>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td colspan="2"><:DESCRIPTION:></td>\r\n</tr>\r\n<tr>\r\n <td colspan="2">\r\n <:COMMENTS:>\r\n </td>\r\n</tr>\r\n</table>', '.common_text_black {text-color:#000000}\r\n.common_text_white {text-color:#ffffff}');
