Shop Mod 260 [ Gelöst ]

[Dark Night]

Folgendes Problemm

der will die Tabellen nicht anlegen das hier sind die original dinger aus der install.php

$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);

und das habe ich in der mysql_schema.sql drin stehen

# --------------------------------------------------------
#
# 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)
);

und das in der mysql_basic.sql

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');

ich denke aber das das alles Richtig ist,

keine anung woran es ligt aber ich nutze das phpbb v2.0.6 habe volgende mods installiert:

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 ^^

`

[Gast]

tja kleiner mal richtig lesen würde ich kann es aber nicht mehr richtig weil ich am feiern bin aber egal !!! schau nochmal genau nach.

[FSKiller / Phoenix]

tja kleiner mal richtig lesen würde ich kann es aber nicht mehr richtig weil ich am feiern bin aber egal !!! schau nochmal genau nach.

[Dark Night]

killerchen du nicht lesen können das prob hatte sich schon erledigt habe den fehler gefunden da war nen zeichen in der sql datei das da nicht sein sollte was ich einfach nur wech nehmen kann löl