Het album op het forum (phpBB 2.0.21) werkt goed nu. Echter als ik nu in het ACP in de configuratie van het forum iets wil aanpassen krijg ik de volgende error.
Code: Selecteer alles
<?php
/***************************************************************************
* db_update.php
* -------------------
*
* copyright : ©2003 Freakin' Booty ;-P & Antony Bailey
* project : http://sourceforge.net/projects/dbgenerator
* Website : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
if( !$userdata['session_logged_in'] )
{
$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
exit;
}
if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}
$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';
$sql = array();
$sql[] = "CREATE TABLE comm_album (
pic_id int(11) UNSIGNED NOT NULL auto_increment,
pic_filename varchar(255) NOT NULL,
pic_thumbnail varchar(255),
pic_title varchar(255) NOT NULL,
pic_desc text,
pic_user_id mediumint(8) NOT NULL,
pic_username varchar(32),
pic_user_ip char(8) NOT NULL DEFAULT '0',
pic_time int(11) UNSIGNED NOT NULL,
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))";
$sql[] = "CREATE TABLE comm_album_rate (
rate_pic_id int(11) UNSIGNED NOT NULL,
rate_user_id mediumint(8) NOT NULL,
rate_user_ip char(8) NOT NULL,
rate_point tinyint(3) UNSIGNED NOT NULL,
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))";
$sql[] = "CREATE TABLE comm_album_comment (
comment_id int(11) UNSIGNED NOT NULL auto_increment,
comment_pic_id int(11) UNSIGNED NOT NULL,
comment_user_id mediumint(8) NOT NULL,
comment_username varchar(32),
comment_user_ip char(8) NOT NULL,
comment_time int(11) UNSIGNED NOT NULL,
comment_text TEXT,
comment_edit_time int(11) UNSIGNED,
comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
comment_edit_user_id mediumint(8),
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))";
$sql[] = "CREATE TABLE comm_album_cat (
cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
cat_title varchar(255) NOT NULL,
cat_desc text,
cat_order mediumint(8) NOT NULL,
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),
cat_upload_groups varchar(255),
cat_rate_groups varchar(255),
cat_comment_groups varchar(255),
cat_edit_groups varchar(255),
cat_delete_groups varchar(255),
cat_moderator_groups varchar(255),
cat_approval tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order))";
$sql[] = "CREATE TABLE comm_album_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name))";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_pics', '1024')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('user_pics_limit', '50')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('mod_pics_limit', '250')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_file_size', '128000')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_width', '800')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_height', '600')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('rows_per_page', '3')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('cols_per_page', '4')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('fullpic_popup', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('thumbnail_quality', '50')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('thumbnail_size', '125')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('thumbnail_cache', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('sort_method', 'pic_time')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('sort_order', 'DESC')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('jpg_allowed', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('png_allowed', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('gif_allowed', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('desc_length', '512')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('hotlink_prevent', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('hotlink_allowed', 'smartor.is-root.com')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery_private', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery_limit', '10')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery_view', '-1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('rate', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('rate_scale', '10')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('comment', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('gd_version', '2')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('album_version', '.0.54')";
for( $i = 0; $i < count($sql); $i++ )
{
if( !$result = $db->sql_query ($sql[$i]) )
{
$error = $db->sql_error();
echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
}
else
{
echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successful</b></font></li><br />';
}
}
echo '</ul></span></td></tr><tr><td class="catBottom" height="28"> </td></tr>';
echo '<tr><th>Installation Complete</th></tr><tr><td><span class="genmed">Please be sure to delete this file now.<br />If you require any further assistance, please visit the <a href="http://www.phpbbhacks.com/forums">phpBBHacks.com Support Forums</a>.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Go back to your index page</a>.</span></td></table>';
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Ik denk toch dat het daar ergens in moet zitten. Want voor dat de Mod album_v2054 erop stond kreeg ik geen foutmeldingen in configuratie van het forum in het ACP.
Ben al 2 dagen bezig met het album. Steeds eraf en er weer op zetten van de Album Mod. Solly .... 
:thumb: