[ABD] The wGEric Store Mod v0.1.2! Great for RPG boards!

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.
Locked
geoffreak
Registered User
Posts: 591
Joined: Sat Feb 12, 2005 8:39 am
Contact:

Post by geoffreak »

>> crappytheclown
if anyone else has this same problem I will take a look

>> Prizem
I don't understand what you mean...
It only displays with a 0 when the user tries to use negitive amounts. If it still does let me know. Its an easy fix.
Well ya think it would be stupid in this case to put the negitive number in the first place? :lol:
In the next version there will be an installer script that will update the db automatically the first time a Store MOD page in the ACP is used. A removal link will be in the signature of each ACP page aswell as a help link. ;)
Anime Revolution - Your new #1 source for All things anime and manga!
READ MY BLOG ALREADY!
Smeep
Registered User
Posts: 86
Joined: Fri Aug 27, 2004 2:47 pm

Post by Smeep »

damn man. It works for everyone but me. I STILL can not get it to download files when a user buys. It will let them purchase no downloadable items fine, but not download ones. I updated the files, didn't work. So I uninstalled via updater, and reinstalled via updater, still doesn't work. What is wrong with me?!

Here's the unistall log

Code: Select all

Store MOD SQL Installer is modifying your database.

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

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

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

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

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

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

    * DELETE FROM `phpbb2_config` WHERE `config_name` = 'store_mod_invin' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb2_config` WHERE `config_name` = 'store_mult_cash' LIMIT 1
      +++ SQL Completed Successfully

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

    * DELETE FROM `phpbb2_config` WHERE `config_name` = 'store_installed' LIMIT 1
      +++ SQL Completed Successfully

    * DELETE FROM `phpbb2_config` WHERE `config_name` = 'store_trade_items' LIMIT 1
      +++ SQL Completed Successfully

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

    * DROP TABLE IF EXISTS `phpbb2_store_inventory
      +++ SQL Completed Successfully

    * DROP TABLE IF EXISTS `phpbb2_store_items
      +++ SQL Completed Successfully

    * DROP TABLE IF EXISTS `phpbb2_store_list
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb2_cash` DROP `cash_usestore`
      +++ SQL Completed Successfully

    * ALTER TABLE `phpbb2_users` DROP `stores_owned`
      +++ SQL Completed Successfully

  
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

  * ALTER TABLE `phpbb2_users` DROP `store_moderator`
      [color=red][b]+++ An Error Has Occurred:[/b][/color] Can't DROP 'store_moderator'. Check that column/key exists

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    * ALTER TABLE `phpbb2_users` DROP `user_dl_code`
      +++ SQL Completed Successfully
And the install log

Code: Select all

# INSERT INTO `phpbb2_config` VALUES ('store_max_items', '10')
+++ SQL Completed Successfully

# INSERT INTO `phpbb2_config` VALUES ('store_allowed_stores', '1')
+++ SQL Completed Successfully

# INSERT INTO `phpbb2_config` VALUES ('store_special_items', 'off')
+++ SQL Completed Successfully

# INSERT INTO `phpbb2_config` VALUES ('store_link_items_prof', 'off')
+++ SQL Completed Successfully

# INSERT INTO `phpbb2_config` VALUES ('store_link_items_topic', 'off')
+++ SQL Completed Successfully

# INSERT INTO `phpbb2_config` VALUES ('store_cats_hierarchy', 'off')
+++ SQL Completed Successfully

# INSERT INTO `phpbb2_config` VALUES ('store_download', 'off')
+++ An Error Has Occurred: Duplicate entry 'store_download' for key 1

# INSERT INTO `phpbb2_config` VALUES ('store_installed', 'yes')
+++ SQL Completed Successfully

# INSERT INTO `phpbb2_config` VALUES ('store_showinstaller', 'off')
+++ SQL Completed Successfully


VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV

# CREATE TABLE `phpbb2_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 'phpbb2_store_download' already exists


^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

# CREATE TABLE phpbb2_store_inventory( inventory_id bigint( 8 ) NOT NULL AUTO_INCREMENT , inventory_item bigint( 8 ) NOT NULL default '0', inventory_store bigint( 8 ) default NULL , inventory_user bigint( 8 ) default NULL , inventory_price bigint( 8 ) NOT NULL default '0', inventory_amount bigint( 8 ) NOT NULL default '0', restock_time varchar( 255 ) default NULL , restock_amount bigint( 8 ) default NULL , restock_last varchar( 255 ) default NULL , UNIQUE KEY item_id( inventory_id ) ) TYPE = MYISAM
+++ SQL Completed Successfully

# CREATE TABLE phpbb2_store_items( item_id bigint( 8 ) NOT NULL AUTO_INCREMENT , item_name varchar( 99 ) NOT NULL default '', item_description varchar( 255 ) default NULL , item_image varchar( 255 ) default NULL , item_special tinyint( 1 ) NOT NULL default '0', item_download INT( 1 ) NOT NULL , UNIQUE KEY item_id( item_id ) ) TYPE = MYISAM
+++ SQL Completed Successfully

# CREATE TABLE phpbb2_store_list( store_id bigint( 8 ) NOT NULL AUTO_INCREMENT , owner_id bigint( 8 ) NOT NULL default '0', store_name varchar( 100 ) NOT NULL default '', store_description varchar( 255 ) default NULL , cash_id bigint( 8 ) NOT NULL default '0', UNIQUE KEY store_id( store_id ) ) TYPE = MYISAM
+++ SQL Completed Successfully

# ALTER TABLE `phpbb2_cash` ADD cash_usestore CHAR( 1 ) DEFAULT '1' NOT NULL
+++ SQL Completed Successfully

# ALTER TABLE phpbb2_users ADD stores_owned BIGINT( 8 ) DEFAULT '0' NOT NULL ;
+++ SQL Completed Successfully

# ALTER TABLE `phpbb2_users` ADD `user_dl_code` VARCHAR( 255 ) NOT NULL ;
+++ SQL Completed Successfully
Stupid bad luck
http://www.paint-zone.co.uk/ball

Paintballing webcomic ^^
Prizem
Registered User
Posts: 249
Joined: Sun Sep 07, 2003 9:14 am
Contact:

Post by Prizem »

geoffreak wrote: >> Prizem
I don't understand what you mean...
Well ya think it would be stupid in this case to put the negitive number in the first place?

Well, concerning the transferring of negative amounts from the store, it's just like the problem with transferring negative amounts from the personal inventory, except it's from the store. I did a clean install with cash (2.2.1) and store (0.1.1) to try it.

Although it would be dumb for someone to give a negative price, just in case, perhaps you could set an error message saying it's not allowed anyways.
Losan
Registered User
Posts: 8
Joined: Sat Jul 10, 2004 2:02 pm

Post by Losan »

Okay, installed easily, everything works fine in the ACP. My problem is when anyone clicks on the Store or Item links, they get a blank page. I checked the templates and uploaded them twice. No effect, blank pages still. Any ideas?
geoffreak
Registered User
Posts: 591
Joined: Sat Feb 12, 2005 8:39 am
Contact:

Post by geoffreak »

>> Smeep
I have looked at my code and that is an error on my part.
It will be fixed next version

>> Prizem
I think I left out the code in one section then
I will put an error message in anyways :lol:

>> Losan
did you modify the files as said in the install script?
Anime Revolution - Your new #1 source for All things anime and manga!
READ MY BLOG ALREADY!
Losan
Registered User
Posts: 8
Joined: Sat Jul 10, 2004 2:02 pm

Post by Losan »

yep, sure did. Figured out the problem. The shop.php file was not loading correctly. Once I fixed that it worked perfectly. Thanks
geoffreak
Registered User
Posts: 591
Joined: Sat Feb 12, 2005 8:39 am
Contact:

Post by geoffreak »

come again?
Anime Revolution - Your new #1 source for All things anime and manga!
READ MY BLOG ALREADY!
ecollins
Registered User
Posts: 35
Joined: Tue May 31, 2005 8:23 pm

Post by ecollins »

I might be stupid but I just downloaded this to test on one of my test boards, and well it seems one major part of the steps is missing from the download.

Code: Select all

Make sure you run the store_db.php after install or update!
No Store_db.php in the download where can I find it?
crappytheclown
Registered User
Posts: 106
Joined: Tue Mar 29, 2005 10:50 pm
Location: NYC
Contact:

Post by crappytheclown »

you go to the ACP of your forum and there is a link to store db or sumthing and click the links there depending wehter u have categories heirachy installed or not
Image
KevDesigns
Registered User
Posts: 62
Joined: Thu Apr 14, 2005 12:05 pm
Location: Florida
Contact:

Post by KevDesigns »

for some weird reason every download is weird. they all download to the same item and if i delete that item, it will just go to another download. i deleted them in the acp and readded them but it still doesnt work. any ideas?
geoffreak
Registered User
Posts: 591
Joined: Sat Feb 12, 2005 8:39 am
Contact:

Post by geoffreak »

I am working on it now so it works at 100% effeciency
I have never heard of that problem before KevDesigns...
Anime Revolution - Your new #1 source for All things anime and manga!
READ MY BLOG ALREADY!
KevDesigns
Registered User
Posts: 62
Joined: Thu Apr 14, 2005 12:05 pm
Location: Florida
Contact:

Post by KevDesigns »

geoffreak wrote: I am working on it now so it works at 100% effeciency
I have never heard of that problem before KevDesigns...


i re-uploaded and checked everything on the install file and everything is fine but it still doesnt work.
geoffreak
Registered User
Posts: 591
Joined: Sat Feb 12, 2005 8:39 am
Contact:

Post by geoffreak »

I think it might be a browser cache thing
try setting a different download folder or making sure the downloads exist
Anime Revolution - Your new #1 source for All things anime and manga!
READ MY BLOG ALREADY!
KevDesigns
Registered User
Posts: 62
Joined: Thu Apr 14, 2005 12:05 pm
Location: Florida
Contact:

Post by KevDesigns »

i tried it at 2 friends' house and its the same thing.
DarthShrine
Registered User
Posts: 5
Joined: Wed May 18, 2005 10:26 am

Post by DarthShrine »

I've got an item on my store...And when I click but, it deducts the amount on the site, deducts my cash, but it says I have no items...Why?
Locked

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