Shop Mod deinstallation
Verfasst: 28.12.2006 13:39
So, bei mir ist es im Moment etwas komisch, ich wollte Shop Mod deinstallieren, weil ich ihn neuinstallieren wollte, so ein bischen bin ich schon weiter gekommen, doch ein paar Sachen, weiß ich nicht wie ich sie wegbekomme (ihr müsst wissen, ich bin ein ziemlicher neuling, was phpbb betrifft) Also so sieht es im MOment aus:
DANKE
Wie bkomme ich den rest weg, bitte helft mir!!!
* CREATE TABLE `phpbb_shopitems` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`shop` varchar(32) NOT NULL default '',
`sdesc` varchar(80) NOT NULL default '',
`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',
`special_link` varchar(255) NOT NULL default '',
`synth` text NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
)
+++ Successfull
* CREATE TABLE `phpbb_shops` (
`id` int(10) unsigned NOT NULL auto_increment,
`shopname` varchar(32) NOT NULL default '',
`shoptype` varchar(32) NOT NULL default '',
`type` varchar(32) NOT NULL default '',
`d_type` tinyint(3) NOT NULL default '0',
`district` tinyint(3) NOT NULL default '0',
`restocktime` int(20) unsigned default '86400',
`restockedtime` int(20) unsigned default '0',
`restockamount` int(4) unsigned default '5',
`url` varchar(255) default NULL,
`shop_owner` varchar(32) NOT NULL default '',
`template` varchar(32) NOT NULL default '',
`item_template` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `shopname` (`shopname`)
)
+++ Successfull
* CREATE TABLE `phpbb_transactions` (
`id` int(10) NOT NULL auto_increment,
`user_id` int(5) NOT NULL default '0',
`target_id` int(5) NOT NULL default '0',
`target_name` varchar(32) NOT NULL default '',
`type` varchar(32) NOT NULL default '',
`action` varchar(32) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
`misc` text NOT NULL,
`ip` varchar(16) NOT NULL default '',
`timestamp` int(32) default NULL,
UNIQUE KEY `id` (`id`)
)
+++ Successfull
* CREATE TABLE `phpbb_user_items` (
`id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0',
`item_id` int(20) NOT NULL default '0',
`item_name` varchar(32) NOT NULL default '',
`item_l_desc` text NOT NULL,
`item_s_desc` varchar(100) NOT NULL default '',
`worn` tinyint(1) NOT NULL default '0',
`die_time` int(20) NOT NULL default '0',
`special` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `item_id` (`item_id`),
KEY `user_id` (`user_id`)
)
+++ Successfull
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('multibuys', 'on')
!!! Error: Duplicate entry 'multibuys' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('restocks', 'on')
!!! Error: Duplicate entry 'restocks' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('sellrate', '55')
!!! Error: Duplicate entry 'sellrate' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewtopic', 'images')
!!! Error: Duplicate entry 'viewtopic' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewprofile', 'images')
!!! Error: Duplicate entry 'viewprofile' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewinventory', 'grouped')
!!! Error: Duplicate entry 'viewinventory' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewtopiclimit', '5')
!!! Error: Duplicate entry 'viewtopiclimit' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_orderby', 'name')
!!! Error: Duplicate entry 'shop_orderby' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_give', 'on')
!!! Error: Duplicate entry 'shop_give' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_trade', 'on')
!!! Error: Duplicate entry 'shop_trade' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_discard', 'on')
!!! Error: Duplicate entry 'shop_discard' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_invlimit', '0')
!!! Error: Duplicate entry 'shop_invlimit' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_owners', 'on')
!!! Error: Duplicate entry 'shop_owners' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_districts', 'off')
!!! Error: Duplicate entry 'shop_districts' for key 1
* alter table phpbb_users add `user_trade` TEXT
!!! Error: Duplicate column name 'user_trade'
Completed with errors!
DANKE
