phpBB.de

#################################################################
## 
## Installation Notes: 
## 
## You should change all your templates and language packs
##
## If you are using a prefix to you DB tabels other than "phpbb_" then
## you have to change this in the SQL commands, e.g. "mybb_album" instead
## of "phpbb_album" - ONLY in the initial SQL commands, not in the php code ! 
## 
## The most important thing to keep in mind is, take your time, make 
## sure you are finding the correct lines to modify, then take care to paste the new code. 
## Please also keep in mind, if you are using more than one language file or theme at your 
## site, you will need to edit the corrosponding files for each occurrence.
##
## This Mod requires GD to generate thumbnails. If you donot have GD installed please ask
## the server admin to compile GD into PHP.
#################################################################
## Example Page/Tech-Support Forum: http://smartor.is-root.com
################################################################# 


#
#-----[ SQL QUERY ]------------------------------
#
CREATE TABLE phpbb_album (
	id int(11) NOT NULL auto_increment,
	filename varchar(99) NOT NULL,
	title varchar(255) NOT NULL,
	user_id mediumint(8) NOT NULL,
	username varchar(25) NOT NULL,
	timestamp int(10) unsigned NOT NULL,
	cat_id mediumint(8) DEFAULT '1' NOT NULL,
	PRIMARY KEY (id));

CREATE TABLE phpbb_album_config (
	config_name varchar(255) NOT NULL,
	config_value varchar(255) NOT NULL,
	PRIMARY KEY (config_name));

INSERT INTO phpbb_album_config VALUES ('max_pics', '255');
INSERT INTO phpbb_album_config VALUES ('max_file_size', '256000');
INSERT INTO phpbb_album_config VALUES ('max_width', '1600');
INSERT INTO phpbb_album_config VALUES ('max_height', '1200');
INSERT INTO phpbb_album_config VALUES ('view_level', '-1');
INSERT INTO phpbb_album_config VALUES ('upload_level', '0');
INSERT INTO phpbb_album_config VALUES ('rows_per_page', '4');
INSERT INTO phpbb_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO phpbb_album_config VALUES ('thumbnail_scaling', '1');
INSERT INTO phpbb_album_config VALUES ('thumbnail_force_GIF', '0');

CREATE TABLE phpbb_album_cat (
	cat_id mediumint(8) NOT NULL auto_increment,
	cat_title varchar(50) NOT NULL,
	cat_lock tinyint(1) DEFAULT '0' NOT NULL,
	PRIMARY KEY (cat_id));

Installation Level: Easy
Installation Time: 30 Minutes

Fehler
Die zusätzlichen Funktionen für verknüpfte Tabellen wurden automatisch deaktiviert. Klicken Sie hier um herauszufinden warum. 

$cfg['Servers'][$i]['pmadb'] string
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you will need to create a new db.

To use this functionality as superuser create a new database:
create a new database for phpmyadmin:
CREATE DATABASE phpmyadmin;
Note that "controluser" must have SELECT, INSERT and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser):
GRANT SELECT,INSERT,DELETE ON phpmyadmin.* to 'pma'@localhost;
do not give any other user rights on this database.
enter the databasename in $cfg['Servers'][$i]['pmadb']

CREATE TABLE phpbb_album (
id int(11) NOT NULL auto_increment,
filename varchar(99) NOT NULL,
title varchar(255) NOT NULL,
user_id mediumint(8) NOT NULL,
username varchar(25) NOT NULL,
timestamp int(10) unsigned NOT NULL,
cat_id mediumint(8) DEFAULT '1' NOT NULL,
PRIMARY KEY (id));

Fehler
Die zusätzlichen Funktionen für verknüpfte Tabellen wurden automatisch deaktiviert. Klicken Sie hier um herauszufinden warum.

$cfg['Servers'][$i]['pmadb'] = 'datenbank_name';

$cfg['Servers'][$i]['table_info'] = '';
CREATE TABLE `PMA_table_info` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`display_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`db_name`, `table_name`)
) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';



$cfg['Servers'][$i]['column_comments'] = '';
CREATE TABLE `PMA_column_comments` (
id int(5) unsigned NOT NULL auto_increment,
db_name varchar(64) NOT NULL default '',
table_name varchar(64) NOT NULL default '',
column_name varchar(64) NOT NULL default '',
comment varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY db_name (db_name, table_name, column_name)
) TYPE=MyISAM COMMENT='Comments for Columns';



$cfg['Servers'][$i]['pdf_pages'] = '';
CREATE TABLE `PMA_pdf_pages` (
`db_name` varchar(64) NOT NULL default '',
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) NOT NULL default '',
PRIMARY KEY (page_nr),
KEY (db_name)
) TYPE=MyISAM COMMENT='PDF Relationpages for PMA';



$cfg['Servers'][$i]['table_coords'] = '';
CREATE TABLE `PMA_table_coords` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pdf_page_number` int NOT NULL default '0',
`x` float unsigned NOT NULL default '0',
`y` float unsigned NOT NULL default '0',
PRIMARY KEY (`db_name`, `table_name`, `pdf_page_number`)
) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';



$cfg['Servers'][$i]['relation'] = '';
CREATE TABLE `PMA_relation` (
`master_db` varchar(64) NOT NULL default '',
`master_table` varchar(64) NOT NULL default '',
`master_field` varchar(64) NOT NULL default '',
`foreign_db` varchar(64) NOT NULL default '',
`foreign_table` varchar(64) NOT NULL default '',
`foreign_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`master_db`, `master_table`, `master_field`),
KEY foreign_field (foreign_db, foreign_table)
) TYPE=MyISAM COMMENT='Relation table';