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> 


[Err0r404]

oh im also gettign this error

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE itemshop_stock
SET iorder =
CASE
ELSE uid
END
WHERE uid IN ();

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 'ELSE uid
END
WHERE uid IN ()' at line 4
Error Number : 1064
Date : Wednesday, May 2nd 2007 @ 02:33:06 PM
Script : http://www.the-pr0xz.com/forums/isho...=doupdateorder
Referrer : http://www.the-pr0xz.com/forums/ishop.php
IP Address : Xx.XXx.XxX.
Username : Err0r404
Classname : vb_database


any ideas?

[4newbies]

Still need help with the following:

Does this replace Ultra Itemshop by the same developer? If not, what are the differences?

Also, I have installed iCash mod to my forum to work with iShop system. However, I don't really need to sell images that will showup in user's postbit. What I need is a page where people can redeem the points they have earned for real prizes and money. Like they go to the redemption page and say they want to purchase a mug with their points. Then the system deducts the points and notifies me that a user has purchased a mug. Is this possible to do with iShop?

So how often does the developer show up on this thread? Maybe him or someone else has some tips about how this can be done. I guess the more important priority for me at this point is to have the mod send a notification PM or automated post in the staff area every time someone purchases an item from the shop. This way I know instantly when I need to award a prize to someone.
Edit/Delete Message

It's been 7 days since my original post and no help. Are there any other Point / Store system alternatives available that I can download from somewhere?

[AzzidReign]

Not yet, but I've been informed that there will be. I'm keeping my eye out for it. I believe the point system will be called "PointIt", so you can be on the look out. I'll assume that the bank and store and labeled "StoreIt" and "BankIt"...but I'm only guessing.

[jonnycrick]

Originally Posted by Err0r404

oh im also gettign this error

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE itemshop_stock
SET iorder =
CASE
ELSE uid
END
WHERE uid IN ();

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 'ELSE uid
END
WHERE uid IN ()' at line 4
Error Number : 1064
Date : Wednesday, May 2nd 2007 @ 02:33:06 PM
Script : http://www.the-pr0xz.com/forums/isho...=doupdateorder
Referrer : http://www.the-pr0xz.com/forums/ishop.php
IP Address : Xx.XXx.XxX.
Username : Err0r404
Classname : vb_database


any ideas?

I'm getting the same error too. Help appreciated!

Let me know if you work it out

[Susp3nc3]

Any thought of putting up a message while giving a gift! other than that this thing is awesome! Only needs the personalized messages and it would be even cooler.

[deezelpope]

My members either send PMs or reputation to notify the recipient.

[MissKalunji]

same as mine

[rabbits slayer]

I get these errors when pressing the "update order" button:

Warning: Invalid argument supplied for foreach() in /ishop.php on line 95

Warning: array_keys() [function.array-keys]: The first argument should be an array in /ishop.php on line 100

Warning: implode() [function.implode]: Bad arguments. in /ishop.php on line 100

This only happen when there's nothing in inventory. Help pls? Other than that, it works fine.

[MissKalunji]

database error

Invalid SQL:

      UPDATE itemshop_stock
      SET iorder =
          CASE
                       WHEN uid = 8 THEN
                       WHEN uid = 9 THEN
                       WHEN uid = 11 THEN
                       WHEN uid = 19 THEN
                       WHEN uid = 21 THEN
                       WHEN uid = 31 THEN
                       WHEN uid = 50 THEN
                       WHEN uid = 69 THEN
                       WHEN uid = 75 THEN
                       WHEN uid = 76 THEN
                       WHEN uid = 88 THEN 1
              ELSE uid
          END
      WHERE uid IN (8,9,11,19,21,31,50,69,75,76,88);

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 'WHEN uid = 9 THEN
                       WHEN uid = 11 THEN
                       WHEN uid = 19 THEN
Error Number : 1064
Date         : Sunday, May 6th 2007 @ 11:51:21 AM
Script       : http://www.dancehallareaz.com/forum/ishop.php?do=doupdateorder

[rungok]

Is it possible to identify who the donation is from in CP or shop?