phpBB.de

$sql = array();

$sql[] = "create table `phpbb_shopitems` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` CHAR (32) NOT NULL, `shop` CHAR (32) NOT NULL, `sdesc` CHAR (80) NOT NULL, `ldesc` TEXT NOT NULL, `cost` INT (20) UNSIGNED DEFAULT '100', `stock` TINYINT (3) UNSIGNED DEFAULT '10', `maxstock` TINYINT (3) UNSIGNED DEFAULT '100', `sold` INT (5) UNSIGNED NOT NULL DEFAULT '0', `accessforum` INT (4) DEFAULT '0', PRIMARY KEY(`id`), INDEX(`name`))";
$sql[] = "create table `phpbb_shops` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `shopname` CHAR (32) NOT NULL, `shoptype` CHAR (32) NOT NULL, PRIMARY KEY(`id`), `type` char (32) NOT NULL, `restocktime` INT (20) UNSIGNED DEFAULT '86400', `restockedtime` INT (20) UNSIGNED DEFAULT '0', `restockamount` INT (4) UNSIGNED DEFAULT '5', `amountearnt` INT (20) UNSIGNED DEFAULT '0', INDEX(`shopname`))";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('multibuys', 'on')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('restocks', 'off')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('sellrate', '75')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('viewtopic', 'images')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('viewprofile', 'images')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('viewinventory', 'grouped')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('specialshop', 'ßstoreÞdisabledßnameÞEffects StoreßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values ('viewtopiclimit', '5')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values('shop_orderby', 'name')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values('shop_give', 'on')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values('shop_trade', 'on')";
$sql[] = "insert into " . CONFIG_TABLE . " (config_name, config_value) values('shop_invlimit', '0')";
$sql[] = "alter table " . USERS_TABLE . " add `user_effects` CHAR (255)";
$sql[] = "alter table " . USERS_TABLE . " add `user_privs` CHAR (255)";
$sql[] = "alter table " . USERS_TABLE . " add `user_custitle` TEXT";
$sql[] = "alter table " . USERS_TABLE . " add `user_specmsg` TEXT";
$sql[] = "alter table " . USERS_TABLE . " add `user_items` TEXT";
$sql[] = "alter table " . USERS_TABLE . " add `user_trade` TEXT";

$sql_count = count($sql);

# --------------------------------------------------------
#
# Table structure for table'phpbb_shopitems'
#
CREATE TABLE phpbb_shopitems (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(32) NOT NULL,
shop CHAR(32) NOT NULL,
sdesc CHAR(80) NOT NULL,
ldesc TEXT NOT NULL,
cost INT(20) UNSIGNED DEFAULT '100',
stock TINYINT(3) UNSIGNED DEFAULT '10',
maxstock TINYINT (3) UNSIGNED DEFAULT '100',
sold INT(5) UNSIGNED NOT NULL DEFAULT '0',
accessforum INT(4) DEFAULT '0',
PRIMARY KEY (id),
INDEX (name)
);


# --------------------------------------------------------
#
# Table structure for table'phpbb_shops'
#
CREATE TABLE phpbb_shops (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
shopname CHAR(32) NOT NULL,
shoptype CHAR(32) NOT NULL,
type` char(32) NOT NULL,
restocktime INT(20) UNSIGNED DEFAULT '86400',
restockedtime INT(20) UNSIGNED DEFAULT '0',
restockamount INT(4) UNSIGNED DEFAULT '5',
amountearnt INT(20) UNSIGNED DEFAULT '0',
PRIMARY KEY (id),
INDEX (shopname)
);

INSERT INTO phpbb_config (config_name, config_value) values ('multibuys', 'on');
INSERT INTO phpbb_config (config_name, config_value) values ('restocks', 'off');
INSERT INTO phpbb_config (config_name, config_value) values ('sellrate', '75');
INSERT INTO phpbb_config (config_name, config_value) values ('viewtopic', 'images');
INSERT INTO phpbb_config (config_name, config_value) values ('viewprofile', 'images');
INSERT INTO phpbb_config (config_name, config_value) values ('viewinventory', 'grouped');
INSERT INTO phpbb_config (config_name, config_value) values ('specialshop', 'ßstoreÞdisabledßnameÞEffects StoreßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1');
INSERT INTO phpbb_config (config_name, config_value) values ('viewtopiclimit', '5');
INSERT INTO phpbb_config (config_name, config_value) values('shop_orderby', 'name');
INSERT INTO phpbb_config (config_name, config_value) values('shop_give', 'on');
INSERT INTO phpbb_config (config_name, config_value) values('shop_trade', 'on');
INSERT INTO phpbb_config (config_name, config_value) values('shop_invlimit', '0');

masseg_icon_mod
View_Profile_Mod
impressum_v110_emc
admin_reminder_1_0_7
Bank Hack (Point System Add on)
Blacklist Hack
delete_smilies100
gast_ava
poster_level_mod
level_mod_changes
Admin Userlist v1.1.0
phpBB2_nickpage_1_3
phpBB2_nickpage_liste
Point System
smiley-paket
staff_203
user_posts_103

hatte den Fehler gefunden ^^

`