Page 69 of 70

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

Posted: Fri Dec 21, 2007 1:29 am
by Baby Boy
Nevermind, I fixed my own problem. Thanks everyone, I feel so stupid I forgot to fill a certain field in...

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

Posted: Sat Dec 22, 2007 6:54 am
by Prizem
oh, thank you for brining this up

When adding inventory to a store via the acp, if the item amount is 0 (no infinite stock), it'll be added as a place holder in the store inventory. (There actually is a check if the amount == '', but that never happens because intval turns it to 0 anyways.) In the actual store, no items are displayed since the item has a 0 amount. (0 amounts are automatically deleted if it's a user store, but not for board-owned stores.) However, the buy setup (specifically the buy button) didn't take into account 0 item amounts and displays the button even when there are no items to buy. This bug has been fixed for RC2.

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

Posted: Wed Jan 30, 2008 3:03 am
by wager
Where can I download this from?

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

Posted: Wed Jan 30, 2008 3:25 pm
by Spiderman92
wager wrote:Where can I download this from?
http://www.twilightus.net/stores/store_ ... od-023.zip

IT was at his site, xD

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

Posted: Wed Jan 30, 2008 9:24 pm
by wager
Spiderman92 wrote:
wager wrote:Where can I download this from?
http://www.twilightus.net/stores/store_ ... od-023.zip

IT was at his site, xD

Is that his latest release, I saw but didn't download because I was unsure. Thanks Spiderman

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

Posted: Mon Feb 04, 2008 2:46 am
by Spiderman92
wager wrote:
Spiderman92 wrote:
wager wrote:Where can I download this from?
http://www.twilightus.net/stores/store_ ... od-023.zip

IT was at his site, xD

Is that his latest release, I saw but didn't download because I was unsure. Thanks Spiderman
Np bro, i had to look far, for i.t lol

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

Posted: Wed Feb 06, 2008 8:24 pm
by illusionest
i havent received a reply yet, so maybe a member from here can help me?

my problem was posted here: http://www.twilightus.net/stores/viewto ... ?p=580#580
and here: http://www.twilightus.net/stores/viewto ... ?p=582#582

thanks in advance! :D

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

Posted: Fri Feb 08, 2008 2:00 am
by illusionest
it is OK, i have solved this problem by removing the error code lines.

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

Posted: Sat Mar 08, 2008 9:28 pm
by tehrin
Will there be an option added to purchase items through a shop with paypal in a later version?

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

Posted: Wed Apr 09, 2008 11:04 pm
by Dog Cow
Where is the link to download RC1?

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

Posted: Thu Apr 10, 2008 12:22 am
by 3Di
Dog Cow wrote:Where is the link to download RC1?
if you really 'need' it just look at the demo site ;)

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

Posted: Wed Apr 23, 2008 8:54 am
by tehrin
I REALLY need some help with this mod.

First of all, I'd really like to add pagination to my shop pages. I have a long list of items, and it's just too much to scroll through all the pages.

Second, I set up the donation mod so that when people donate they get a specific cash currency for donations only (to be used in a donation currency shop). I want to prevent my users from trading the currency via the trades. I can disable it in the cash mod, but people will be able to get around it by trading through the shop mod.

Lastly, I keep running into errors with people buying a ton of items and then going into the negatives, spending money they don't have (but I've turned negative currencies off in the cash mod) Is there any fix for this bug?

Thanks anyone, that could help.

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

Posted: Thu Jul 17, 2008 5:37 pm
by alh31
I'm not sure what's going on and I need help please!

The store mod has been working for probably 2 two years. I have done all updates and I haven't added anything to my forum recently.

Today when I clicked on the store Configuration in the admin panel, I received this message.
Store MOD is about to update the database from versions 0.0.5 to 0.2.3.
Click HERE to upgrade. (Categories Hierarchy users)
I have been updated to 0.2.3 for awhile. When I clicked on upgrade I got:
# INSERT 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: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# 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 ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# 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: Table 'ttas_phpbb.phpbb_store_inventory' doesn't exist

# ALTER TABLE phpbb_store_inventory ADD viewtopic TINYINT( 1 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_inventory' doesn't exist

# ALTER TABLE phpbb_store_items ADD view_desc TINYINT( 1 ) DEFAULT '1' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# ALTER TABLE phpbb_store_list ADD district_id BIGINT( 8 ) DEFAULT '0' NOT NULL AFTER store_id ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# ALTER TABLE phpbb_store_list ADD store_image VARCHAR( 255 ) DEFAULT NULL AFTER store_description ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# ALTER TABLE phpbb_store_list ADD store_order MEDIUMINT( 8 ) DEFAULT '0' NOT NULL AFTER store_image ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# ALTER TABLE phpbb_store_list ADD view_item_desc TINYINT( 1 ) DEFAULT '1' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# ALTER TABLE phpbb_store_list ADD view_item_imgs TINYINT( 1 ) DEFAULT '1' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# ALTER TABLE phpbb_store_list ADD auth_view TINYINT( 1 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# ALTER TABLE phpbb_store_list ADD auth_buy TINYINT( 1 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# ALTER TABLE phpbb_store_list ADD auth_sell TINYINT( 1 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# 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
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# 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: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# ALTER TABLE phpbb_store_inventory CHANGE restock_last restock_last int( 11 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_inventory' doesn't exist

# ALTER TABLE phpbb_store_inventory ADD receive_time INT( 11 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_inventory' doesn't exist

# 022INSERT 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

# 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: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# 023UPDATE phpbb_config SET config_value = 'yes' WHERE config_name = 'store_installed'
+++ SQL Completed Successfully

# CREATE TABLE phpbb_store_item_cats ( cat_id BIGINT( 8 ) NOT NULL AUTO_INCREMENT, cat_name VARCHAR( 99 ) NOT NULL, cat_description TEXT DEFAULT NULL , UNIQUE KEY cat_id( cat_id ) ) TYPE = MYISAM
+++ An Error Has Occurred: Table 'phpbb_store_item_cats' already exists

# INSERT INTO phpbb_store_config VALUES ('store_item_expire_message', 'Oh my, it seems your %s has expired.')
+++ An Error Has Occurred: Duplicate entry 'store_item_expire_message' for key 1

# UPDATE phpbb_store_config SET config_value = '0.2.3' WHERE config_name = 'store_version'
+++ SQL Completed Successfully

# ALTER TABLE phpbb_store_items ADD item_cat BIGINT( 8 ) DEFAULT '1' NOT NULL AFTER item_id ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# ALTER TABLE phpbb_store_items ADD expiration_type TINYINT( 1 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# ALTER TABLE phpbb_store_items ADD expiration_notice TEXT DEFAULT '' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_items' doesn't exist

# ALTER TABLE phpbb_store_inventory ADD infinite_stock TINYINT( 1 ) DEFAULT '0' NOT NULL ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_inventory' doesn't exist

# ALTER TABLE phpbb_store_list ADD store_owner_name VARCHAR( 255 ) DEFAULT '' NOT NULL AFTER store_order ;
+++ An Error Has Occurred: Table 'ttas_phpbb.phpbb_store_list' doesn't exist

# INSERT INTO phpbb_store_item_cats (cat_id, cat_name, cat_description) VALUES (1, 'General Item', 'All uncategorized items.')
+++ An Error Has Occurred: Duplicate entry '1' for key 1
Now nothing is working. I keep getting this and it appears the store mod is no longer installed. I have tables that do not exist anymore. I can not find the where to get the code for the manual sql install because the link is no longer working.

Can anyone help me?
Thanks!!!

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

Posted: Sat Oct 11, 2008 8:20 am
by prophetUK
Looks like this is [ABD] as well now. No replies here, and no responses to PMs.

Don't suppose anyone else would know how to fix the problem in trade PM notifications (which I think is to do with lang_store.php) where the links to accept or modify trade proposals are just written out in plain text (RC1)?

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

Posted: Sat Oct 11, 2008 12:02 pm
by Brf