[RC1] The wGEric Store MOD vRC1 (15 November 2007)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
MotoXKid
Registered User
Posts: 31
Joined: Thu Jan 08, 2004 6:04 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by MotoXKid »

Rizzn. wrote: Then do

Code: Select all

UPDATE `phpbb_store_config` SET config_value = '0.2.2' WHERE config_name = 'store_version';
and

Code: Select all

UPDATE `phpbb_sconfig` SET config_value = 'yes' WHERE config_name = 'store_installed';


First code you gave worked, the second I got this error.

Code: Select all

SQL query:

UPDATE `phpbb_sconfig` SET config_value = 'yes' WHERE config_name = 'store_installed'

MySQL said: Documentation
#1146 - Table 'mkinsch5_phpb1.phpbb_sconfig' doesn't exist 
Should it be phpbb_config not phpbb_sconfig?
Last edited by MotoXKid on Mon Apr 16, 2007 1:44 am, edited 3 times in total.

Rizzn.
Registered User
Posts: 264
Joined: Wed Dec 28, 2005 9:53 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by Rizzn. »

Yes, I just bumped the 's' while typing that out...
[Alpha] Store MOD (phpBB3)
- Support site forthcoming -
--------------------------------------
[RC1] wGEric Store MOD (phpBB2)
Additional Usable Items and Store MOD Support Forums (separate site)

MotoXKid
Registered User
Posts: 31
Joined: Thu Jan 08, 2004 6:04 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by MotoXKid »

Rizzn. wrote: Yes, I just bumped the 's' while typing that out...



1st) Sorry for all the headache this must be causing.

2nd) Ran them both no problem..


3rd) Clicked anything on the shop admin cp

Code: Select all

Updating Store MOD
Store MOD is about to update the database from versions 0.0.5 to 0.2.2.
Click HERE to upgrade. (Categories Hierarchy users)

The wGEric Store MOD 0.2.2 © 2006 Prizem & Rizzn. (2003/4 wGEric, 2005 Geoffreak) [Remove]
I click "Here"

I get:

Code: Select all

Store MOD SQL Installer is modifying your database.

    * 010INSERT INTO `phpbb_config` VALUES ('store_installed', 'yes')
      +++ An Error Has Occurred: Duplicate entry 'store_installed' for key 1

    * CREATE TABLE `phpbb_store_download` ( `dl_number` INT( 5 ) NOT NULL auto_increment, `dl_path` VARCHAR( 255 ) NOT NULL, PRIMARY KEY (`dl_number`) ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=3;
      +++ An Error Has Occurred: Table 'phpbb_store_download' already exists

    * ALTER TABLE `phpbb_cash` ADD `cash_usestore` CHAR( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'cash_usestore'

    * 011ALTER TABLE `phpbb_store_items` ADD `item_download` INT( 3 ) NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'item_download'

    * ALTER TABLE `phpbb_users` ADD `user_dl_code` VARCHAR( 255 ) NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'user_dl_code'

    * 013ALTER TABLE `phpbb_store_items` CHANGE `item_description` `item_description` TEXT DEFAULT NULL ;
      +++ SQL Completed Successfully

    * 014ALTER TABLE `phpbb_users` ADD `user_pm_purchase` VARCHAR( 255 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'user_pm_purchase'

    * 020DELETE FROM `phpbb_config` WHERE `config_name` = 'store_version' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_max_items' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_allowed_stores' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_special_items' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_link_items_prof' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_link_items_topic' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_cats_hierarchy' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_download_folder' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_showinstaller' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_pm_purchase' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_pm_purchase_owner' LIMIT 1
      +++ SQL Completed Successfully

    * CREATE TABLE `phpbb_store_config` ( `config_name` VARCHAR(255) NOT NULL, `config_value` VARCHAR(255) NOT NULL, PRIMARY KEY (`config_name`) )
      +++ An Error Has Occurred: Table 'phpbb_store_config' already exists

    * CREATE TABLE `phpbb_store_districts` ( `district_id` BIGINT( 8 ) NOT NULL AUTO_INCREMENT, `district_name` VARCHAR( 100 ) NOT NULL, `district_description` VARCHAR( 255 ) DEFAULT NULL, `district_image` VARCHAR( 255 ) DEFAULT NULL , `district_order` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL, `auth_view` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_buy` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_sell` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_create` TINYINT( 1 ) DEFAULT '0' NOT NULL, UNIQUE KEY district_id( `district_id` ) ) TYPE = MYISAM
      +++ An Error Has Occurred: Table 'phpbb_store_districts' already exists

    * CREATE TABLE `phpbb_store_auth_access` ( `group_id` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL, `store_id` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL, `district_id` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL, `auth_view` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_buy` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_sell` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_create` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_mod` TINYINT( 1 ) DEFAULT '0' NOT NULL, KEY group_id (`group_id`), KEY store_id (`store_id`), KEY district_id (`district_id`) )
      +++ An Error Has Occurred: Table 'phpbb_store_auth_access' already exists

    * CREATE TABLE `phpbb_store_trade_items` ( `trade_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `owner_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `item_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `cash_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `amount` BIGINT( 8 ) DEFAULT '0' NOT NULL, KEY (`trade_id`) )
      +++ An Error Has Occurred: Table 'phpbb_store_trade_items' already exists

    * CREATE TABLE `phpbb_store_trade_list` ( `trade_id` BIGINT( 8 ) NOT NULL AUTO_INCREMENT, `s_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `r_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `req_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `pm_sent` TINYINT( 1 ) DEFAULT '0' NOT NULL, KEY (`trade_id`) )
      +++ An Error Has Occurred: Table 'phpbb_store_trade_list' already exists

    * INSERT INTO `phpbb_store_config` VALUES ('store_version', '0.0.0')
      +++ An Error Has Occurred: Duplicate entry 'store_version' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_allowed_stores', '1')
      +++ An Error Has Occurred: Duplicate entry 'store_allowed_stores' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_max_items', '10')
      +++ An Error Has Occurred: Duplicate entry 'store_max_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_download_folder', 'store_downloads')
      +++ An Error Has Occurred: Duplicate entry 'store_download_folder' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_board_owner_name', 'Board')
      +++ An Error Has Occurred: Duplicate entry 'store_board_owner_name' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_special_items', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_special_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_index_style', 'list')
      +++ An Error Has Occurred: Duplicate entry 'store_index_style' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_items_user', 1)
      +++ An Error Has Occurred: Duplicate entry 'store_view_items_user' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_items_mod', 1)
      +++ An Error Has Occurred: Duplicate entry 'store_view_items_mod' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_items_prof', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_link_items_prof' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_items_topic', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_link_items_topic' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_allowed_view_topic_items', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_allowed_view_topic_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_item_desc', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_view_item_desc' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_item_images', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_view_item_images' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_cats_hierarchy', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_cats_hierarchy' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_pm_purchase', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_pm_purchase' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_pm_purchase_owner', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_pm_purchase_owner' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_index_images', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_index_images' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_use_item_width', '400')
      +++ An Error Has Occurred: Duplicate entry 'store_use_item_width' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_use_item_height', '250')
      +++ An Error Has Occurred: Duplicate entry 'store_use_item_height' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_trade_items', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_trade_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_user_create_items', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_user_create_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_mod_invin', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_mod_invin' for key 1

    * ALTER TABLE `phpbb_users` CHANGE `user_dl_code` `user_dl_code` TEXT DEFAULT NULL ;
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb_store_inventory` ADD `dl_code` TEXT DEFAULT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'dl_code'

    * ALTER TABLE `phpbb_store_inventory` ADD `viewtopic` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'viewtopic'

    * ALTER TABLE `phpbb_store_items` ADD `view_desc` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'view_desc'

    * ALTER TABLE `phpbb_store_list` ADD `district_id` BIGINT( 8 ) DEFAULT '0' NOT NULL AFTER `store_id` ;
      +++ An Error Has Occurred: Duplicate column name 'district_id'

    * ALTER TABLE `phpbb_store_list` ADD `store_image` VARCHAR( 255 ) DEFAULT NULL AFTER `store_description` ;
      +++ An Error Has Occurred: Duplicate column name 'store_image'

    * ALTER TABLE `phpbb_store_list` ADD `store_order` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL AFTER `store_image` ;
      +++ An Error Has Occurred: Duplicate column name 'store_order'

    * ALTER TABLE `phpbb_store_list` ADD `view_item_desc` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'view_item_desc'

    * ALTER TABLE `phpbb_store_list` ADD `view_item_imgs` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'view_item_imgs'

    * ALTER TABLE `phpbb_store_list` ADD `auth_view` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'auth_view'

    * ALTER TABLE `phpbb_store_list` ADD `auth_buy` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'auth_buy'

    * ALTER TABLE `phpbb_store_list` ADD `auth_sell` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'auth_sell'

    * INSERT INTO `phpbb_store_districts` (district_id, district_name, district_description, district_image, district_order, auth_view, auth_buy, auth_sell, auth_create) VALUES (1, 'Test District', 'This is a test district.', '', 10, 0, 1, 1, 1)
      +++ An Error Has Occurred: Duplicate entry '1' for key 1

    * UPDATE `phpbb_store_list` SET district_id = 1 WHERE district_id = 0
      +++ SQL Completed Successfully

    * 021INSERT INTO `phpbb_store_config` VALUES ('store_pm_owner', '2')
      +++ An Error Has Occurred: Duplicate entry 'store_pm_owner' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_viewtopic_row', '1')
      +++ An Error Has Occurred: Duplicate entry 'store_viewtopic_row' for key 1

    * ALTER TABLE `phpbb_store_items` ADD `expiration_time` INT( 11 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'expiration_time'

    * ALTER TABLE `phpbb_store_inventory` CHANGE `restock_last` `restock_last` int( 11 ) DEFAULT '0' NOT NULL ;
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb_store_inventory` ADD `receive_time` INT( 11 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'receive_time'

    * 022UPDATE `phpbb_config` SET config_value = 'yes' WHERE config_name = 'store_installed'
      +++ SQL Completed Successfully

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_stores_prof', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_link_stores_prof' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_stores_topic', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_link_stores_topic' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_tax', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_tax' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_price', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_price' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_price_cash', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_price_cash' for key 1

    * UPDATE `phpbb_store_config` SET config_value = '0.2.2' WHERE config_name = 'store_version'
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb_users` ADD `stores_max` INT( 8 ) DEFAULT '-1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'stores_max'

    * ALTER TABLE `phpbb_store_districts` ADD `district_tax` DECIMAL( 5, 2 ) DEFAULT '-1' NOT NULL AFTER `district_order` ;
      +++ An Error Has Occurred: Duplicate column name 'district_tax'

    * ALTER TABLE `phpbb_store_districts` ADD `district_max` INT( 8 ) DEFAULT '-1' NOT NULL AFTER `district_tax` ;
      +++ An Error Has Occurred: Duplicate column name 'district_max'

    * ALTER TABLE `phpbb_store_districts` ADD `district_store_price` BIGINT( 8 ) DEFAULT '-1' NOT NULL AFTER `district_max` ;
      +++ An Error Has Occurred: Duplicate column name 'district_store_price'

    * ALTER TABLE `phpbb_store_districts` ADD `district_store_price_cash` BIGINT( 8 ) DEFAULT '0' NOT NULL AFTER `district_store_price` ;
      +++ An Error Has Occurred: Duplicate column name 'district_store_price_cash'

    * ALTER TABLE `phpbb_store_items` ADD `item_tax` DECIMAL( 5, 2 ) DEFAULT '-1' NOT NULL AFTER `item_image` ;
      +++ An Error Has Occurred: Duplicate column name 'item_tax'

Rizzn.
Registered User
Posts: 264
Joined: Wed Dec 28, 2005 9:53 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by Rizzn. »

OPEN admin_store.php
FIND

Code: Select all

	case 'install': $file = 'install';
REPLACE WITH

Code: Select all

	case 'install': $file = 'config';
(or just comment out that line and the 'break;' after it) Then upload it and try again.

Just remember to 'undo' this change to upgrade to future versions.
[Alpha] Store MOD (phpBB3)
- Support site forthcoming -
--------------------------------------
[RC1] wGEric Store MOD (phpBB2)
Additional Usable Items and Store MOD Support Forums (separate site)

MotoXKid
Registered User
Posts: 31
Joined: Thu Jan 08, 2004 6:04 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by MotoXKid »

Rizzn. wrote: OPEN admin_store.php
FIND

Code: Select all

	case 'install': $file = 'install';
REPLACE WITH

Code: Select all

	case 'install': $file = 'config';
(or just comment out that line and the 'break;' after it) Then upload it and try again.

Just remember to 'undo' this change to upgrade to future versions.


Edited and uploaded..

I go to anything for store in admin panel.. Click it.. Tells me I need to upgrade..

Code: Select all

Store MOD SQL Installer is modifying your database.

    * 010INSERT INTO `phpbb_config` VALUES ('store_installed', 'yes')
      +++ An Error Has Occurred: Duplicate entry 'store_installed' for key 1

    * CREATE TABLE `phpbb_store_download` ( `dl_number` INT( 5 ) NOT NULL auto_increment, `dl_path` VARCHAR( 255 ) NOT NULL, PRIMARY KEY (`dl_number`) ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=3;
      +++ An Error Has Occurred: Table 'phpbb_store_download' already exists

    * ALTER TABLE `phpbb_cash` ADD `cash_usestore` CHAR( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'cash_usestore'

    * 011ALTER TABLE `phpbb_store_items` ADD `item_download` INT( 3 ) NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'item_download'

    * ALTER TABLE `phpbb_users` ADD `user_dl_code` VARCHAR( 255 ) NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'user_dl_code'

    * 013ALTER TABLE `phpbb_store_items` CHANGE `item_description` `item_description` TEXT DEFAULT NULL ;
      +++ SQL Completed Successfully

    * 014ALTER TABLE `phpbb_users` ADD `user_pm_purchase` VARCHAR( 255 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'user_pm_purchase'

    * 020DELETE FROM `phpbb_config` WHERE `config_name` = 'store_version' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_max_items' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_allowed_stores' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_special_items' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_link_items_prof' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_link_items_topic' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_cats_hierarchy' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_download_folder' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_showinstaller' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_pm_purchase' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb_config` WHERE `config_name` = 'store_pm_purchase_owner' LIMIT 1
      +++ SQL Completed Successfully

    * CREATE TABLE `phpbb_store_config` ( `config_name` VARCHAR(255) NOT NULL, `config_value` VARCHAR(255) NOT NULL, PRIMARY KEY (`config_name`) )
      +++ An Error Has Occurred: Table 'phpbb_store_config' already exists

    * CREATE TABLE `phpbb_store_districts` ( `district_id` BIGINT( 8 ) NOT NULL AUTO_INCREMENT, `district_name` VARCHAR( 100 ) NOT NULL, `district_description` VARCHAR( 255 ) DEFAULT NULL, `district_image` VARCHAR( 255 ) DEFAULT NULL , `district_order` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL, `auth_view` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_buy` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_sell` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_create` TINYINT( 1 ) DEFAULT '0' NOT NULL, UNIQUE KEY district_id( `district_id` ) ) TYPE = MYISAM
      +++ An Error Has Occurred: Table 'phpbb_store_districts' already exists

    * CREATE TABLE `phpbb_store_auth_access` ( `group_id` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL, `store_id` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL, `district_id` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL, `auth_view` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_buy` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_sell` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_create` TINYINT( 1 ) DEFAULT '0' NOT NULL, `auth_mod` TINYINT( 1 ) DEFAULT '0' NOT NULL, KEY group_id (`group_id`), KEY store_id (`store_id`), KEY district_id (`district_id`) )
      +++ An Error Has Occurred: Table 'phpbb_store_auth_access' already exists

    * CREATE TABLE `phpbb_store_trade_items` ( `trade_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `owner_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `item_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `cash_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `amount` BIGINT( 8 ) DEFAULT '0' NOT NULL, KEY (`trade_id`) )
      +++ An Error Has Occurred: Table 'phpbb_store_trade_items' already exists

    * CREATE TABLE `phpbb_store_trade_list` ( `trade_id` BIGINT( 8 ) NOT NULL AUTO_INCREMENT, `s_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `r_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `req_id` BIGINT( 8 ) DEFAULT '0' NOT NULL, `pm_sent` TINYINT( 1 ) DEFAULT '0' NOT NULL, KEY (`trade_id`) )
      +++ An Error Has Occurred: Table 'phpbb_store_trade_list' already exists

    * INSERT INTO `phpbb_store_config` VALUES ('store_version', '0.0.0')
      +++ An Error Has Occurred: Duplicate entry 'store_version' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_allowed_stores', '1')
      +++ An Error Has Occurred: Duplicate entry 'store_allowed_stores' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_max_items', '10')
      +++ An Error Has Occurred: Duplicate entry 'store_max_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_download_folder', 'store_downloads')
      +++ An Error Has Occurred: Duplicate entry 'store_download_folder' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_board_owner_name', 'Board')
      +++ An Error Has Occurred: Duplicate entry 'store_board_owner_name' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_special_items', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_special_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_index_style', 'list')
      +++ An Error Has Occurred: Duplicate entry 'store_index_style' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_items_user', 1)
      +++ An Error Has Occurred: Duplicate entry 'store_view_items_user' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_items_mod', 1)
      +++ An Error Has Occurred: Duplicate entry 'store_view_items_mod' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_items_prof', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_link_items_prof' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_items_topic', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_link_items_topic' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_allowed_view_topic_items', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_allowed_view_topic_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_item_desc', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_view_item_desc' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_view_item_images', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_view_item_images' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_cats_hierarchy', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_cats_hierarchy' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_pm_purchase', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_pm_purchase' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_pm_purchase_owner', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_pm_purchase_owner' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_index_images', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_index_images' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_use_item_width', '400')
      +++ An Error Has Occurred: Duplicate entry 'store_use_item_width' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_use_item_height', '250')
      +++ An Error Has Occurred: Duplicate entry 'store_use_item_height' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_trade_items', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_trade_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_user_create_items', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_user_create_items' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_mod_invin', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_mod_invin' for key 1

    * ALTER TABLE `phpbb_users` CHANGE `user_dl_code` `user_dl_code` TEXT DEFAULT NULL ;
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb_store_inventory` ADD `dl_code` TEXT DEFAULT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'dl_code'

    * ALTER TABLE `phpbb_store_inventory` ADD `viewtopic` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'viewtopic'

    * ALTER TABLE `phpbb_store_items` ADD `view_desc` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'view_desc'

    * ALTER TABLE `phpbb_store_list` ADD `district_id` BIGINT( 8 ) DEFAULT '0' NOT NULL AFTER `store_id` ;
      +++ An Error Has Occurred: Duplicate column name 'district_id'

    * ALTER TABLE `phpbb_store_list` ADD `store_image` VARCHAR( 255 ) DEFAULT NULL AFTER `store_description` ;
      +++ An Error Has Occurred: Duplicate column name 'store_image'

    * ALTER TABLE `phpbb_store_list` ADD `store_order` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL AFTER `store_image` ;
      +++ An Error Has Occurred: Duplicate column name 'store_order'

    * ALTER TABLE `phpbb_store_list` ADD `view_item_desc` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'view_item_desc'

    * ALTER TABLE `phpbb_store_list` ADD `view_item_imgs` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'view_item_imgs'

    * ALTER TABLE `phpbb_store_list` ADD `auth_view` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'auth_view'

    * ALTER TABLE `phpbb_store_list` ADD `auth_buy` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'auth_buy'

    * ALTER TABLE `phpbb_store_list` ADD `auth_sell` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'auth_sell'

    * INSERT INTO `phpbb_store_districts` (district_id, district_name, district_description, district_image, district_order, auth_view, auth_buy, auth_sell, auth_create) VALUES (1, 'Test District', 'This is a test district.', '', 10, 0, 1, 1, 1)
      +++ An Error Has Occurred: Duplicate entry '1' for key 1

    * UPDATE `phpbb_store_list` SET district_id = 1 WHERE district_id = 0
      +++ SQL Completed Successfully

    * 021INSERT INTO `phpbb_store_config` VALUES ('store_pm_owner', '2')
      +++ An Error Has Occurred: Duplicate entry 'store_pm_owner' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_viewtopic_row', '1')
      +++ An Error Has Occurred: Duplicate entry 'store_viewtopic_row' for key 1

    * ALTER TABLE `phpbb_store_items` ADD `expiration_time` INT( 11 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'expiration_time'

    * ALTER TABLE `phpbb_store_inventory` CHANGE `restock_last` `restock_last` int( 11 ) DEFAULT '0' NOT NULL ;
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb_store_inventory` ADD `receive_time` INT( 11 ) DEFAULT '0' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'receive_time'

    * 022UPDATE `phpbb_config` SET config_value = 'yes' WHERE config_name = 'store_installed'
      +++ SQL Completed Successfully

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_stores_prof', 'on')
      +++ An Error Has Occurred: Duplicate entry 'store_link_stores_prof' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_link_stores_topic', 'off')
      +++ An Error Has Occurred: Duplicate entry 'store_link_stores_topic' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_tax', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_tax' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_price', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_price' for key 1

    * INSERT INTO `phpbb_store_config` VALUES ('store_price_cash', '0')
      +++ An Error Has Occurred: Duplicate entry 'store_price_cash' for key 1

    * UPDATE `phpbb_store_config` SET config_value = '0.2.2' WHERE config_name = 'store_version'
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb_users` ADD `stores_max` INT( 8 ) DEFAULT '-1' NOT NULL ;
      +++ An Error Has Occurred: Duplicate column name 'stores_max'

    * ALTER TABLE `phpbb_store_districts` ADD `district_tax` DECIMAL( 5, 2 ) DEFAULT '-1' NOT NULL AFTER `district_order` ;
      +++ An Error Has Occurred: Duplicate column name 'district_tax'

    * ALTER TABLE `phpbb_store_districts` ADD `district_max` INT( 8 ) DEFAULT '-1' NOT NULL AFTER `district_tax` ;
      +++ An Error Has Occurred: Duplicate column name 'district_max'

    * ALTER TABLE `phpbb_store_districts` ADD `district_store_price` BIGINT( 8 ) DEFAULT '-1' NOT NULL AFTER `district_max` ;
      +++ An Error Has Occurred: Duplicate column name 'district_store_price'

    * ALTER TABLE `phpbb_store_districts` ADD `district_store_price_cash` BIGINT( 8 ) DEFAULT '0' NOT NULL AFTER `district_store_price` ;
      +++ An Error Has Occurred: Duplicate column name 'district_store_price_cash'

    * ALTER TABLE `phpbb_store_items` ADD `item_tax` DECIMAL( 5, 2 ) DEFAULT '-1' NOT NULL AFTER `item_image` ;
      +++ An Error Has Occurred: Duplicate column name 'item_tax'

Finshed
Database modification is now complete.
If you experience any problems with Store MOD, please visit the support topic at phpBB.com.

Thanks for choosing Store MOD!

The wGEric Store MOD 0.2.2 © 2006 Prizem & Rizzn. (2003/4 wGEric, 2005 Geoffreak) [Remove]
Powered by phpBB 2.0.22 © 2001 phpBB Group
=\

Rizzn.
Registered User
Posts: 264
Joined: Wed Dec 28, 2005 9:53 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by Rizzn. »

Ok, are you trying to do a new install or upgrade from an older version? If an older version, which one?
[Alpha] Store MOD (phpBB3)
- Support site forthcoming -
--------------------------------------
[RC1] wGEric Store MOD (phpBB2)
Additional Usable Items and Store MOD Support Forums (separate site)

MotoXKid
Registered User
Posts: 31
Joined: Thu Jan 08, 2004 6:04 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by MotoXKid »

Rizzn. wrote: Ok, are you trying to do a new install or upgrade from an older version? If an older version, which one?



New install. I used Zarath's Shop Mod before on my old database (Which was recently transfered), but I dropped all the SQL statements from his mod that could have been in the database.

Rizzn.
Registered User
Posts: 264
Joined: Wed Dec 28, 2005 9:53 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by Rizzn. »

MotoXKid wrote:
Rizzn. wrote: Ok, are you trying to do a new install or upgrade from an older version? If an older version, which one?



New install. I used Zarath's Shop Mod before on my old database (Which was recently transfered), but I dropped all the SQL statements from his mod that could have been in the database.
Did you also remove all the files from your server?

I would suggest removing all the SQL entries, reuploading all the the Store MOD files, then trying to install it again.
[Alpha] Store MOD (phpBB3)
- Support site forthcoming -
--------------------------------------
[RC1] wGEric Store MOD (phpBB2)
Additional Usable Items and Store MOD Support Forums (separate site)

MotoXKid
Registered User
Posts: 31
Joined: Thu Jan 08, 2004 6:04 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by MotoXKid »

Rizzn. wrote:
MotoXKid wrote:
Rizzn. wrote: Ok, are you trying to do a new install or upgrade from an older version? If an older version, which one?



New install. I used Zarath's Shop Mod before on my old database (Which was recently transfered), but I dropped all the SQL statements from his mod that could have been in the database.
Did you also remove all the files from your server?

I would suggest removing all the SQL entries, reuploading all the the Store MOD files, then trying to install it again.


Yeah I removed all the entries.

I deleted and then re-uploaded all the Store Mod files... Didn't do the trick. :(

MotoXKid
Registered User
Posts: 31
Joined: Thu Jan 08, 2004 6:04 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by MotoXKid »

Hey man, I got it working successfully!

Thanks for all the help dude. Your a great mod author and this is a superb modification. I've used it many times in the past and all with great results, thus, why I was so persistent on using this specific mod! :)

Rizzn.
Registered User
Posts: 264
Joined: Wed Dec 28, 2005 9:53 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by Rizzn. »

What was the problem or what did you do to fix it?
[Alpha] Store MOD (phpBB3)
- Support site forthcoming -
--------------------------------------
[RC1] wGEric Store MOD (phpBB2)
Additional Usable Items and Store MOD Support Forums (separate site)

MotoXKid
Registered User
Posts: 31
Joined: Thu Jan 08, 2004 6:04 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by MotoXKid »

Rizzn. wrote: What was the problem or what did you do to fix it?



I dropped all the tables, and ran them manually, along with all the changes you gave me after re-uploading all the files and re installing the mod.

Rizzn.
Registered User
Posts: 264
Joined: Wed Dec 28, 2005 9:53 am
Contact:

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by Rizzn. »

Yeah, for some reason the installer wonks out on some servers. We're still trying to pinpoint the exact cause, but we haven't had much luck with it.
[Alpha] Store MOD (phpBB3)
- Support site forthcoming -
--------------------------------------
[RC1] wGEric Store MOD (phpBB2)
Additional Usable Items and Store MOD Support Forums (separate site)

mackindlays
Registered User
Posts: 9
Joined: Tue Apr 03, 2007 4:49 pm

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by mackindlays »

Rizzn. wrote: @mackindlays

The problem is that you don't have a district cash and an overall cash amount set in the ACP. Even if the amount is set to "0", a cash type currently needs to be selected in both areas to prevent that problem.

To prevent that from occurring in the future...

OPEN store.php
FIND

Code: Select all

			store_update_cash($userdata['user_id'], $new_user_cash, $district_cash);
REPLACE WITH

Code: Select all

			if ($district_cash)
			{
				store_update_cash($userdata['user_id'], $new_user_cash, $district_cash);
			}


Thanks that did it

RCIV
Registered User
Posts: 2
Joined: Mon Apr 16, 2007 10:32 pm

Re: [BETA] The wGEric Store MOD v0.2.2 (18 Jan 2007)

Post by RCIV »

Hey guys I just installed this and it works perfectly, but i was wondering if there was anyway that if someone bought a board owned item they would be auto added to a usergroup and given a certain rank? If you can that would be awesome!

Post Reply

Return to “[2.0.x] MODs in Development”