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> 


[AuroraStorm]

Originally Posted by AuroraStorm

Okay Blaine this is where I was confused. The question posed by chkdgate was:



So is the code <a href='ishop.php>IShop</a> or itemshop.php?

That's all I wanted to know...I've said it before I'm not a coder and everybody who is speaks the lingo and I just wanna make sure I'm doing this right and understanding...

[MissKalunji]

So how's the update coming along?

[Blaine0002]

its coming along very nicely actually, im working to get over one or two hurdles at the moment to get it released, the hardest part now will be reducing the amount of queries per post. Already reduced it by one, but its still one per post, trying to make it 1 per THREAD.

[Blaine0002]

Updated, added Item order, Maximum items in postbit, Items per row in postbit.

[tehPARADOX]

Database error in vBulletin 3.6.5:

Invalid SQL:
select s.*,i.*
from itemshop_stock s
left join itemshop_items i
on(i.id=s.item_id)
where s.member_id='1'
ORDER BY s.iorder ASC LIMIT 4;

MySQL Error : Unknown column 's.iorder' in 'order clause'

This database error occurs when viewing postbits of people with items. Any idea what's wrong? This is after the update btw.

[Evolution06]

just installed got this db error when I click on a thread

PHP Code:

select s.*,i.*
                  from vb_itemshop_stock s
                  left join vb_itemshop_items i 
                  on(i.id=s.item_id)
                  where s.member_id='1'  
                  ORDER BY s.iorder ASC LIMIT 10;

MySQL Error  : Unknown column 's.iorder' in 'order clause'
Error Number : 1054
Date         : Thursday, March 29th 2007 @ 08:49:49 PM
Script       : http://www.criticalfx.net/forums/showthread.php?p=223
Referrer     : http://www.criticalfx.net/forums/index.php
IP Address   : 69.225.252.163
Username     : NightHaze
Classname    : vb_database 


[Blaine0002]

bah. im so stupid i forget to put new rows into the update script

updated. try now.

[tehPARADOX]

Originally Posted by Blaine0002

bah. im so stupid i forget to put new rows into the update script

updated. try now.

Thanks for the update, that fixed the db issue. Any plans on continuing work on a fix for IBank?

[Blaine0002]

yeah, its next on my list, and in great need

[dai-kun]

Thanks a lot for the new features. Been waiting for what seems like forever.

Can you make a page where a user can click to see all the items of that person?

Donated btw