Jetzt will ich gerade im Admin Bereich eine neue Kategorie im Fotoalbum eröffnen, da kommt diese Meldung.
Code: Alles auswählen
-----[ SQL ]-------------------------------------------------
#
# You can manually execute "SQL_full_album_pack_1_4_0.txt" instead of run this portion of code
# Or you can copy "fap_install.php" to your phpBB root and execute it from your browser when you're logged in with admin rights
#
CREATE TABLE `phpbb_album` (
`pic_id` int(11) unsigned NOT NULL auto_increment,
`pic_filename` varchar(255) NOT NULL default '',
`pic_thumbnail` varchar(255) NULL default '',
`pic_title` varchar(255) NOT NULL default '',
`pic_desc` text,
`pic_user_id` mediumint(8) NOT NULL default '0',
`pic_username` varchar(32) NULL default '',
`pic_user_ip` varchar(8) NOT NULL default '0',
`pic_time` int(11) unsigned NOT NULL default '0',
`pic_cat_id` mediumint(8) unsigned NOT NULL default '1',
`pic_view_count` int(11) unsigned NOT NULL default '0',
`pic_lock` tinyint(3) NOT NULL default '0',
`pic_approval` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`pic_id`),
KEY `pic_cat_id` (`pic_cat_id`),
KEY `pic_user_id` (`pic_user_id`),
KEY `pic_time` (`pic_time`)
);
CREATE TABLE `phpbb_album_cat` (
`cat_id` mediumint(8) unsigned NOT NULL auto_increment,
`cat_title` varchar(255) NOT NULL default '',
`cat_desc` text,
`cat_wm` text,
`cat_order` mediumint(8) NOT NULL default '0',
`cat_view_level` tinyint(3) NOT NULL default '-1',
`cat_upload_level` tinyint(3) NOT NULL default '0',
`cat_rate_level` tinyint(3) NOT NULL default '0',
`cat_comment_level` tinyint(3) NOT NULL default '0',
`cat_edit_level` tinyint(3) NOT NULL default '0',
`cat_delete_level` tinyint(3) NOT NULL default '2',
`cat_view_groups` varchar(255) NULL default '',
`cat_upload_groups` varchar(255) NULL default '',
`cat_rate_groups` varchar(255) NULL default '',
`cat_comment_groups` varchar(255) NULL default '',
`cat_edit_groups` varchar(255) NULL default '',
`cat_delete_groups` varchar(255) NULL default '',
`cat_moderator_groups` varchar(255) NULL default '',
`cat_approval` tinyint(3) NOT NULL default '0',
`cat_parent` mediumint(8) unsigned default '0',
`cat_user_id` mediumint(8) unsigned default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
);
CREATE TABLE `phpbb_album_comment` (
`comment_id` int(11) unsigned NOT NULL auto_increment,
`comment_pic_id` int(11) unsigned NOT NULL default '0',
`comment_cat_id` int(11) NOT NULL default '0',
`comment_user_id` mediumint(8) NOT NULL default '0',
`comment_username` varchar(32) NULL default '',
`comment_user_ip` varchar(8) NOT NULL default '',
`comment_time` int(11) unsigned NOT NULL default '0',
`comment_text` text,
`comment_edit_time` int(11) unsigned NULL default '0',
`comment_edit_count` smallint(5) unsigned NOT NULL default '0',
`comment_edit_user_id` mediumint(8) NULL default '0',
PRIMARY KEY (`comment_id`),
KEY `comment_pic_id` (`comment_pic_id`),
KEY `comment_user_id` (`comment_user_id`),
KEY `comment_user_ip` (`comment_user_ip`),
KEY `comment_time` (`comment_time`)
);
CREATE TABLE `phpbb_album_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
);
CREATE TABLE `phpbb_album_rate` (
`rate_pic_id` int(11) unsigned NOT NULL default '0',
`rate_user_id` mediumint(8) NOT NULL default '0',
`rate_user_ip` char(8) NOT NULL default '',
`rate_point` tinyint(3) unsigned NOT NULL default '0',
`rate_hon_point` tinyint(3) NOT NULL default '0',
KEY `rate_pic_id` (`rate_pic_id`),
KEY `rate_user_id` (`rate_user_id`),
KEY `rate_user_ip` (`rate_user_ip`),
KEY `rate_point` (`rate_point`)
);
INSERT INTO `phpbb_album_config` VALUES ('max_pics', '1024');
INSERT INTO `phpbb_album_config` VALUES ('user_pics_limit', '-1');
INSERT INTO `phpbb_album_config` VALUES ('mod_pics_limit', '-1');
INSERT INTO `phpbb_album_config` VALUES ('max_file_size', '128000');
INSERT INTO `phpbb_album_config` VALUES ('max_width', '1024');
INSERT INTO `phpbb_album_config` VALUES ('max_height', '768');
INSERT INTO `phpbb_album_config` VALUES ('rows_per_page', '5');
INSERT INTO `phpbb_album_config` VALUES ('cols_per_page', '4');
INSERT INTO `phpbb_album_config` VALUES ('fullpic_popup', '0');
INSERT INTO `phpbb_album_config` VALUES ('thumbnail_quality', '75');
INSERT INTO `phpbb_album_config` VALUES ('thumbnail_size', '125');
INSERT INTO `phpbb_album_config` VALUES ('thumbnail_cache', '1');
INSERT INTO `phpbb_album_config` VALUES ('sort_method', 'pic_time');
INSERT INTO `phpbb_album_config` VALUES ('sort_order', 'DESC');
INSERT INTO `phpbb_album_config` VALUES ('jpg_allowed', '1');
INSERT INTO `phpbb_album_config` VALUES ('png_allowed', '1');
INSERT INTO `phpbb_album_config` VALUES ('gif_allowed', '1');
INSERT INTO `phpbb_album_config` VALUES ('desc_length', '512');
INSERT INTO `phpbb_album_config` VALUES ('hotlink_prevent', '0');
INSERT INTO `phpbb_album_config` VALUES ('hotlink_allowed', 'mightygorgon.com');
INSERT INTO `phpbb_album_config` VALUES ('personal_gallery', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_private', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_limit', '-1');
INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_view', '-1');
INSERT INTO `phpbb_album_config` VALUES ('rate', '1');
INSERT INTO `phpbb_album_config` VALUES ('rate_scale', '10');
INSERT INTO `phpbb_album_config` VALUES ('comment', '1');
INSERT INTO `phpbb_album_config` VALUES ('gd_version', '2');
INSERT INTO `phpbb_album_config` VALUES ('album_version', '.0.54');
INSERT INTO `phpbb_album_config` VALUES ('fap_version', '1.4.0');
INSERT INTO `phpbb_album_config` VALUES ('show_index_thumb', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_index_total_pics', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_total_comments', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_comments', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_comment', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_pics', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_recent_in_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_recent_instead_of_nopics', '1');
INSERT INTO `phpbb_album_config` VALUES ('line_break_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_gallery_mod', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_sub_categories', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_sub_category_limit', '-1');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_subcats_in_index', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_in_subcats', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_personal_gallery_link', '1');
INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting', 'cat_order');
INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting_direction', 'ASC');
INSERT INTO `phpbb_album_config` VALUES ('album_debug_mode', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_all_in_personal_gallery', '1');
INSERT INTO `phpbb_album_config` VALUES ('new_pic_check_interval', '1M');
INSERT INTO `phpbb_album_config` VALUES ('index_enable_supercells', '0');
INSERT INTO `phpbb_album_config` VALUES ('email_notification', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_download', '2');
INSERT INTO `phpbb_album_config` VALUES ('show_slideshow', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_pic_size_on_thumb', '1');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3');
INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0');
INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0');
INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2');
INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1');
INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4');
INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '450');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '600');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_files_to_upload', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_pregenerated_fields', '1');
INSERT INTO `phpbb_album_config` VALUES ('dynamic_fields', '1');
INSERT INTO `phpbb_album_config` VALUES ('pregenerate_fields', '0');
INSERT INTO `phpbb_album_config` VALUES ('propercase_pic_title', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic_lv', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_pics_approval', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_img_no_gd', '0');
INSERT INTO `phpbb_album_config` VALUES ('dynamic_pic_resampling', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_file_size_resampling', '1024000');
INSERT INTO `phpbb_album_config` VALUES ('switch_nuffload', '0');
INSERT INTO `phpbb_album_config` VALUES ('path_to_bin', './cgi-bin/');
INSERT INTO `phpbb_album_config` VALUES ('perl_uploader', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_progress_bar', '1');
INSERT INTO `phpbb_album_config` VALUES ('close_on_finish', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_pause', '5');
INSERT INTO `phpbb_album_config` VALUES ('simple_format', '0');
INSERT INTO `phpbb_album_config` VALUES ('multiple_uploads', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_uploads', '5');
INSERT INTO `phpbb_album_config` VALUES ('zip_uploads', '1');
INSERT INTO `phpbb_album_config` VALUES ('resize_pic', '1');
INSERT INTO `phpbb_album_config` VALUES ('resize_width', '600');
INSERT INTO `phpbb_album_config` VALUES ('resize_height', '600');
INSERT INTO `phpbb_album_config` VALUES ('resize_quality', '70');
INSERT INTO `phpbb_album_config` VALUES ('show_pics_nav', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_inline_copyright', '0');
INSERT INTO `phpbb_album_config` VALUES ('enable_nuffimage', '1');
INSERT INTO `phpbb_album_config` VALUES ('enable_sepia_bw', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_avatar_gallery', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_gif_mid_thumb', '1');
INSERT INTO `phpbb_album_config` VALUES ('slideshow_script', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_exif', '0');
INSERT INTO `phpbb_album_config` VALUES ('album_bbcode', '1');
INSERT INTO `phpbb_album_config` VALUES ('quick_thumbs', '0');
