IShop - Simple, Flexible, and Integrateable.

Version 1.1.4 RELEASE
Now with AJAX!

IShop

YOU NEED AN EXTERNAL CASH HACK FOR THIS TO WORK!
OMG YES IT WORKS WITH 3.6.X!!!

Works best with ICASH (also made by me)
I can actually give you support on the integration with ICash

By
Blaine0002

With help from:
Siradrian
Zachariah
eXtremetim
Ggiersdorf
Zero Tolerance


allows:
Your users to buy images with their money for their postbit or to have their own inventory

Features

+Multiple Shop Categories
+Unlimited Items
+Little Queries!
+Stock
+ICash Or EBux Integrated
+Detailed items/categories/shops stats(number of sold items, Stock)
+Item Donation
+Postbit Inventory and cash display
+Users sort items using AJAX
+Users may own multiple items of the same type
+Admin limits viewable icons in postbit!
+recipiant and admin notification on buy/sell/donate!


Database Tables

*[itemshop_cat]-Itemshop Categories stored here
*[itemshop_items]-Items That go in the categories
*[itemshop_stock]-Items left to buy


Installation

1.BACK UP YOUR DATABASE.
2.Import included XML file in main folder
3.Upload all files as is
4.Name Money field in VBulletin Options
5.Link to ishop.php


Upgrade from Ultra Imageshop To IShop:
1. Back up as normal
2. Delete all files that came with Ultra Imageshop, and rename 'Itemshop' directory to 'ishop'
3. upload all new files
4. upload XML file opting to overwrite
5. RE-SET options in ISHOP OPTIONS.
6. Re-do below template edit, if done.

Upgrade from V1.0.1 to V1.1.0!
Reupload all files,
Reimport XML, Prompt to overwrite.
WARNING:
In the previous version there was a bug where it would not add stock back to the shop when an item was sold.
If your Stock and Sold do not add up to your original stock for that item, you may upload countupdate.php from your DO NOT UPLOAD folder to your forum root. MAKE SURE YOU BACK UP YOUR DATABASE. Run the php from your browser , then DELETE IT!
WARNING: This will reset ALL of your items stock to 50! and then subtract items sold from this number. if your items did not have a stock of 50, you may want to edit the file and change the number, or edit the numbers in your database via PHPMYADMIN.



CLICK INSTALL!
Thanks!


Too add this to your navbar
open navbar template
find:

PHP Code:

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td> 


Add after:

PHP Code:

<td class="vbmenu_control"><a href="ishop.php$session[sessionurl_q]">iShop</a></td> 


[Blaine0002]

that has been answered plenty of times.

[Skateboard]

Will this work with vbullein 3.6.5?

[Blaine0002]

*sigh* not funny.

[Queball_Beast]

I read all post in this forum, tried many different things like re-uploading the ishop.php, re-importing the xml file and overwriting but, I cant get this to work. This error only occurs when someone tries to donate an item and clicks the donate button.
Thanks

Database error in vBulletin 3.6.5:
Invalid SQL:
select s.*,i.* from gpitemshop_stock s left join itemshop_items i on(i.id=s.item_id) where s.member_id='1' and i.id=4;
MySQL Error : Table '*******.itemshop_items' doesn't exist
Error Number : 1146
Date : Sunday, April 15th 2007 @ 03:41:12 PM
Script :
Referrer :
IP Address : ip
Username : name
Classname : vb_database

[Ceege]

Originally Posted by Blaine0002

that has been answered plenty of times.

So instead of a lame answer, could you give me a yes or no, since i wasn't able to find the answer?

[Blaine0002]

yes this works with all current versions of vbulletin.

[dai-kun]

Originally Posted by Queball_Beast

I read all post in this forum, tried many different things like re-uploading the ishop.php, re-importing the xml file and overwriting but, I cant get this to work. This error only occurs when someone tries to donate an item and clicks the donate button.
Thanks

Seems like the PREFIX of your mysql table is not set up correctly.

[pelican]

Originally Posted by Ceege

So instead of a lame answer, could you give me a yes or no, since i wasn't able to find the answer?

i think blaine mention in the description that it works in 3.6.5

however, it will be better if there is an entry in the 3.6.5 mod section.

[vhero]

installed however i put my money row as money in icash and in ishop yet ishop swears i dont have enough money even though i got plenty..

I got this when posting too
Invalid SQL:
UPDATE user SET money=money+ WHERE userid='1';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='1'' at line 1
Error Number : 1064

[Queball_Beast]

Do you mean the Prefix for the ishop? because everything else on the board works, this error only occured after I installed ishop. can you tell me how fix this please?

Originally Posted by dai-kun

Seems like the PREFIX of your mysql table is not set up correctly.