IShop - Simple, Flexible, and Integrateable.

[Blaine0002]

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:
<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

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

[Blaine0002]

reserventated.

open Postbit template (either or)
Find:
----------

<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>



Add after:
----------

<!-- show inventory -->
<fieldset><legend><a href="ishop.php?do=ViewMember&id=$post[userid]" title="$post[username]'s Inventory">$post[username]'s Inventory</a></legend>
<div>
$post[invrow]
<br>
</div>
</fieldset>
<!-- /show inventory -->

[waza]

Can you post screens or a demo, cause I don't really get the idea.
thx,
seba

[Blaine0002]

added ;) forgot.

screenshot on the left is ubar old and the screenshot on the right is what you can do with your postbit.

[nvhlinh]

Request: Gift feature

[Blaine0002]

well i think ecash has gifts so you can use it with that. :)

[Michael_Tree]

u rock blane if this works

[Michael_Tree]

error :(

Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO itemshop_cat (cid, cname, cdescr, csold, cprofit, citems) VALUES (1, 'Test Category', 'Get your items here!', 0, 0, 0);

MySQL Error : Table 'habbsus1_forumHEREWEGO.itemshop_cat' doesn't exist
Error Number : 1146
Date : Sunday, March 5th 2006 @ 04:54:20 PM
Script : http://www.habbotrades.us/admincp/plugin.php
Referrer : http://www.habbotrades.us/admincp/plugin.php?do=productadd
IP Address : 172.149.33.49
Username : Skatea
Classname : vb_database

[Blaine0002]

already been fixed :) try installing the newest verison.

[Blaine0002]

Latest version should be stable :)

[MissKalunji]

i dont get the idea either...

[Blaine0002]

idea is after people get points by posting, they can go into this itemshop where they can "buy" images (made by you) to show off in their postbit or inventory. it has no real reason, but its quite fun.

[CongTuDepTrai]

can we put the item below signature? if yes, please show me how


so i have to hack the ebux first which is the one:

https://vborg.vbsupport.ru/showthread.php?t=106953&highlight=ebux

then i have to hack this mod right?

[Reeve of shinra]

Good mod, thank you for sharing.

Is it possible to have this show up on certain pages only? I'd like to use this but I'm not sure yet if I want it in the postbit.

[Blaine0002]

currently i havent released the postbit code, i will in a bit, but as of now each person has a seperate itemshop "inventory"

as for having it below the signature, im not at home right now so this is right off the top of my head, but try checking your postbit code and right under the signature php create a new table, and paste the code i will soon supply into there.

[CongTuDepTrai]

do i have to hack the ebux md to work with this code?

[Gizmo5h1t3]

whilst it looks a decent hack, its got its work cut out with eshop.

[Blaine0002]

this sells diffrent items, and ill work on the postbit when i get home

you only need to install ecash and eshop before installing this

[CongTuDepTrai]

ecash is this code right?

https://vborg.vbsupport.ru/showthread.php?t=106953

[Blaine0002]

yep!

[my3shadows]

Ok, stupid question... but when you say Donation in the list of features, are you talking about donating an image to someone else or are you talking about just being able to donate cash or points, or both?

My users loved the ability in the original ushop to buy a gift (image) for someone else and attach a message to it (which showed up as a tooltip)...and that's what I've been waiting for before I install a new store system. So if this does the same thing, then it looks like I'll be busy installing hacks this weekend. :nervous:

[theorigin]

I love this..but I have a question. When you release the postbit/signature code, is there anyway to limit the items that show up in the postbit/signature? My items are bigger than others, and I really don't want the signatures to take up an entire page because there's so many items. XMB had an option where you could limit the amount and then a 3-dotted link would take you to your profile where it showed all of your purchased items. I realize this would involve creating a table in the member profile, so hopefully it wouldn't take too much. If you need an example, I could provide one. :nervous:

[Blaine0002]

i understand what you mean, and believe it can be done fairly easily.

[Blaine0002]

Ok, stupid question... but when you say Donation in the list of features, are you talking about donating an image to someone else or are you talking about just being able to donate cash or points, or both?

My users loved the ability in the original ushop to buy a gift (image) for someone else and attach a message to it (which showed up as a tooltip)...and that's what I've been waiting for before I install a new store system. So if this does the same thing, then it looks like I'll be busy installing hacks this weekend. :nervous:

yes, you can do this, but you cant attach a message yet.

also each person can only have 1 of each item, so make sur the people donate before the person you are buying the item for buys it themselves :D

[BrentW]

I'll post the requests I had in the old thread...

1. All users automatically have a 'profile.'
2. An equip feature like in RPG Infero -- equiped items displayed in postbit.

[Blaine0002]

all users automaticly DO have an itemshop inventory. i can also try adding an equip. Would the unequip items still show in their inventory and not their postbit?

[Holidazed]

reserventated.

open Posbit (not legacy)
Find:
----------

<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>



Add after:
----------

<!-- show inventory -->
<fieldset><legend><a href="itemshop.php?do=ViewMember&id=$post[userid]" title="$post[username]'s Inventory">$post[username]'s Inventory</a></legend>
<div>
$post[invname]
$post[inventory]
<br>
$post[invcash]
</div>
</fieldset>
<!-- /show inventory -->

I did the change to my postbit template, but when I di, it whacks out the look of my site. See the attachment. The first post comes up kinda ok, the rest is fubared. It does not matter where I put your code either. I put it under the signature and it whacks out the page too.

[Blaine0002]

now THAT shouldnt happen, if you take it out does it go back?

[Holidazed]

now THAT shouldnt happen, if you take it out does it go back?First thing I checked.

Yes, if I take it out, it goes back.

Here is a link to that exact same post without the modification in it.
http://www.hidingplace.com/vbb350/showthread.php?t=925

[Blaine0002]

ah

replace everything in itemshop_invpostbit_end template with


<br>
{$themember['username']} has {$themember[$vbulletin->options['itemshop_pointfield']]} {$vbulletin->options['moneyname']} On Hand

[Holidazed]

ah

replace everything in itemshop_invpostbit_end template with


<br>
{$themember['username']} has {$themember[$vbulletin->options['itemshop_pointfield']]} {$vbulletin->options['moneyname']} On Hand

That did it. Thanks

[theorigin]

Alright, I fixed it so that I could have the items under the signature, but now my question is, is there a way to choose which items show in the sigs and which just show in the inventory?

Also, when adding items, is there any way to make them listed alphabetical? I realize you could do it by inputting them in alphabetically to begin with, but when you add new items later, that could become a problem.

[Chaotican]

Im having issues getting this one installed. When I try to import the XML, I get an error similar to the one previously mentioned:

Invalid SQL:
INSERT INTO itemshop_cat (cid, cname, cdescr, csold, cprofit, citems) VALUES (1, 'Test Category', 'Get your items here!', 0, 0, 0);

Im trying to install file currently listed above, have tried redownloading and installing again, but with the same issue.

Im anxious to get this working, as its what im lacking to get my eStore working for the purpose I put it in for. Any help with this issue would be much apperciated.

Also, what is the name of the default money field for eBux/eStore?

[Blaine0002]

Also, what is the name of the default money field for eBux/eStore?
ebux, its the defaut value added

The easiest way to reinstal fresh is to delete the 'Install' code in the xml file and import it. Once its installed, uninstall it to rid your boards of bad tables and stuff, then reinstall the xml WITH the install part.

[CongTuDepTrai]

we waiting for you to move the item from postbit down to signature. thanks

[Blaine0002]

this can easily be achieved by moving the part of the postbit template anywhere in your postbit.

[lairnoc]

ok installed it, but no items in the shop and i cannot choose anything :(

[Blaine0002]

:) you need to make them in your admincp

[mikeylikesitz]

does this work with vbplaza?

[lairnoc]

:) you need to make them in your admincp

weird now i see the options those were not there earlier maybe somehing with history refresh or so

[Blaine0002]

yes when you first install the plugin it will not have it because your navbar has not refreshed :P

and it should work with vbplaza, just change the row name or whatever to whatever it uses.

[DragoZERO]

Is anyone else having database issues? Could we possible get the database query in a seperate text and an xml w/o the sql stuff?

[dai-kun]

Templates are not cached:

Uncached templates: itemshop_invpostbit_begenning (3)
Uncached templates: itemshop_invpostbit_end (3)

had to add both to showthread.php, fine now.

also is there any way we can limit how much shows up in postbit?

[BrentW]

all users automaticly DO have an itemshop inventory. i can also try adding an equip. Would the unequip items still show in their inventory and not their postbit?

Correct. ;)

[CongTuDepTrai]

it moved to below signature yet?

[BrentW]

it moved to below signature yet?

You can move it yourself. Simply post the code in the signature template instead of the postbit.

[theorigin]

Any word on the option being added where new items added will automatically be alphabetized within their respective categories?

[GrendelKhan{TSU]

sorry for the stupid n00b question but...

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


what images?

ie: where are the images coming from?

(again, sorry...first time I'm seeing this).

[baradaarab]

Any way to make it so that the images show up in the profile rather than the postbit?

MGM out

[inkdot]

what's the default money field for vbplaza? nvm it's vbbux!

[baradaarab]

Any way to make it so that the images show up in the profile rather than the postbit?

MGM out
Any help on answering this question would be welcome... I'm trying to wait patiently but ... :p

MGM out

[Nova99]

Is it possible to get this one to show max X number of items in the postbit and to let the members arrange the order of the items themselves??

I would really like to see something like that on this great hack.. :)

[BrentW]

Is it possible to get this one to show max X number of items in the postbit and to let the members arrange the order of the items themselves??

I would really like to see something like that on this great hack.. :)

Yeah...we need an equip feature like in RPG Inferno.
And a Jobs feature, just like in RPG Inferno. ;)

Once those features are working I will gladly send a $50 donation.

[Blaine0002]

equip and jobs? examples?

and i will be working more on this hack, once i get out of school!

[BrentW]

equip and jobs? examples?
and i will be working more on this hack, once i get out of school!

Are you familiar with the Jobs mod and Equip features in RPG Inferno?

Download and install RPG Infero Lite to see. Equip lets you choose which items will be displayed in the postbit. In the profile view, there should be two columns: one for all items (ncluding equiped items), and one for equiped items only.

The jobs feature lets you choose a "job" based on how many posts you have. It pays you a "salary" each specified time period.

[emtee]

This hack seems to use a lot of queries for me when I move it down to above signature in postbit. It shows 3 uncached templates for EACH POST: itemshop_invpostbit_begenning, itemshop_invpostbit_end, itemshop_invpostbit_item. So when someboy view a thread with 25 posts, it would use 100+ queries just for that thread view alone!

Do you have any fix for this?

By the way, in a later release, can you change itemshop.php to imageshop.php because this hack is incompatible with the RPG Integration hack because both use the same itemshop.php filename.

Many thanks in advance.

[dai-kun]

This hack seems to use a lot of queries for me when I move it down to above signature in postbit. It shows 3 uncached templates for EACH POST: itemshop_invpostbit_begenning, itemshop_invpostbit_end, itemshop_invpostbit_item. So when someboy view a thread with 25 posts, it would use 100+ queries just for that thread view alone!

Do you have any fix for this?

By the way, in a later release, can you change itemshop.php to imageshop.php because this hack is incompatible with the RPG Integration hack because both use the same itemshop.php filename.

Many thanks in advance.


Do a file edit in showthread.php

Look for


'editor_clientscript',
'editor_jsoptions_font',
'editor_jsoptions_size',
);


replace with


'editor_clientscript',
'editor_jsoptions_font',
'editor_jsoptions_size',
'itemshop_invpostbit_begenning',
'itemshop_invpostbit_end',
'itemshop_invpostbit_item',
);


you may also want to add it to showpost.php

[emtee]

So that is one of the way to cache templates? I'll try it. Thanks a lot dai-kun! :D

Edit: caching templates doesn't help getting rid of the queries. I had to uninstall this hack because of the 3 queries it add to every single post in a thread.

I might reinstall it later if the queries got cut drastically.

[Blaine0002]

hmm im not sure how to reduce queries like that, and i dont have much time to work on this hack with school and all, butonly 2 weeks left and i would be working on it again,

[Carlos2]

Request:

Hi, in a next version, can you put an item that give you money all months or something similar???

For example: You buy a Casino Item, or a Restaurant Item for 20.000 euros, and this item give you 1200 euros for month. ;)

Items that give you profits if you buy them, and you can choose the money profit that you want. Thanks :cool:

[inkdot]

is 'itemshop_invpostbit_begenning' a missing template? maybe a typo?
i only see itemshop_invpostbit_beginning

[BrentW]

Database error in vBulletin 3.5.2:

Invalid SQL:
INSERT INTO itemshop_cat (cid, cname, cdescr, csold, cprofit, citems) VALUES (1, 'Test Category', 'Get your items here!', 0, 0, 0);

MySQL Error : Table 'coc.itemshop_cat' doesn't exist
Error Number : 1146
Date : Tuesday, May 16th 2006 @ 08:36:23 PM

................

I get the above whenever I try adding the product

EDIT: I got it working by removing the " . TABLE_PREFIX . " from the script

[northernstar]

is there anyway to limit the items that show up in the postbit/signature?

Would love to see this as well!

And I second the request to allow users to choose the order, or even just pick their top 5 or something. Great hack!

edit: And also when you're viewing someone's inventory, it'd be nice to have a column showing who gave them the item.

[jacks0_0]

how to put the limit of buying the items? ^ ^ Such as one person just can buy 5 or 10 items, because when the users buy a lot of items, it impact the template of the forum...

[tienkhom]

i can not import the xml file,
Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO itemshop_cat (cid, cname, cdescr, csold, cprofit, citems) VALUES (1, 'Test Category', 'Get your items here!', 0, 0, 0);

MySQL Error : Table 'mynameuser_forum.itemshop_cat' doesn't exist
Error Number : 1146
Date : Wednesday, June 7th 2006 @ 06:24:51 AM
Script : http://www.my domain.com/admincp/plugin.php
Referrer : http://www.my domain.com/admincp/plugin.php?do=productadd
IP Address : my ip
Username : my name
Classname : vB_Database

[dashaka2]

**clicks install**

[Blaine0002]

i will work on updating this once i finish with my 2 other hacks. :) just hold on a little longer.

[dashaka2]

Some things that I noticed where:

**When I tried adding an image that ended with .JPG it wouldn't work, I had to change it to lowercase .jpg

**Also it would be nice to have a feature that allowed u to add multiple items.

**Please have a button to Alphabetize the items or better yet pick the order inwhich u want them in as well as the categories

**Is there a way to allow people to purchase more than 1 of the same item?
(Might be cool to have a switch to turn this on and off)

**Allow users to choose maybe top 5 or so pics to show in sig or postbit, My users will have a few hundred items, the only way I know of to keep this clean would be to turn off pics in postbit.. But I would like it to show a few. Maybe a couple then the .... to show that there is more.

**also if possible to see a thumbnail of the pic in the postbit, but when we go to their inventory you can see the full image.


looking forward to the update :)

[Blaine0002]

Some things that I noticed where:

**When I tried adding an image that ended with .JPG it wouldn't work, I had to change it to lowercase .jpg

**Also it would be nice to have a feature that allowed u to add multiple items.

**Please have a button to Alphabetize the items or better yet pick the order inwhich u want them in as well as the categories

**Is there a way to allow people to purchase more than 1 of the same item?
(Might be cool to have a switch to turn this on and off)

**Allow users to choose maybe top 5 or so pics to show in sig or postbit, My users will have a few hundred items, the only way I know of to keep this clean would be to turn off pics in postbit.. But I would like it to show a few. Maybe a couple then the .... to show that there is more.

**also if possible to see a thumbnail of the pic in the postbit, but when we go to their inventory you can see the full image.


looking forward to the update :)


More great ideas :) i will take a break from my auction script and work on this and hopefully get many of these problems fixed :)

[dashaka2]

cool an auction script :)
do u have a beta version yet?
I am in need of an auction script or a virtual store :up:

[Blaine0002]

heh no, still working on backend. will release an early beta in about a week or so.

[Blaine0002]

wow, i just looked through this code, and im seriously suprised it works at ALL

(lol)

this is what i will be working on tomorrow, expect a release soon.

[Vi3t4Lov3]

Thanks for the mod. It is quite fun.

Suggestion:
- Now, to sell back the value is hard set at 33%. Can this value be made as a variable to be set in ACP? Thanks,
- Can it be worked with a percentage discount for different usergroup? (like Ebux/Vbplaza). Like right now, in ebux, I have it set that admin has 50%, s-mod has 40%, mod has 25% discount on all items.

Thanks,
I truly enjoy this mod.

[Blaine0002]

Updated, Fully works. No new features added, but users should upgrade anyway.

[chkdgate]

Blaine, as you already know, this is something that I've been waiting for a long time. I followed all the directions and the postbit edit on post #1 but this is not showing up for me. I have the version you've updated yesterday. Any thoughts? Btw, step #5 is not quite clear to me. Thanks for your help.

**clicks install**

[edeline]

what happen if i use it in postbit_legacy ??

[Blaine0002]

Blaine, as you already know, this is something that I've been waiting for a long time. I followed all the directions and the postbit edit on post #1 but this is not showing up for me. I have the version you've updated yesterday. Any thoughts? Btw, step #5 is not quite clear to me. Thanks for your help.

**clicks install**
This is probably what you are missing, What external cash mod are you using?

You need to go into the IShop general options and make sure your money row is correct.

If not are you sure you edited the correct postbit template?

@edeline
it should work just fine. I am using it on my forums :)

[chkdgate]

I'm using your ICash of course! Let me go ahead and install it from scratch.

[chkdgate]

Okay, I installed it again from scratch and once again I'm not getting this hack to work. Also, when I go to ishop's settings I get the following error shown below.

[Blaine0002]

whoops i guess i forgot to upload new version. hold on.

[chkdgate]

Blaine, when I remove the ishop plugin and undo the postbit edit, I still have the ishop option in my acp. Is that supposed to do that? I thought that once you remove a plugin, then it doesn't show up anymore in your CP. Weird.

[Blaine0002]

hmm, are you sure ypu uploaded all files to the admincp dir?

[chkdgate]

Wait, I always upload all vb hacks in my forums root folder. Is that not right? I never before had to put it into the admincp dir. Let me go ahead and try that out right now.

[Blaine0002]

nono, i mean are you sure you uploaded all files in the upload/admincp to the admincp directory :P

[chkdgate]

These are all the files I'm uploading to the forum root folder.

[lightwave]

how can i make this so it uses the rpg_inferno money. i want this as a feature of my forum.

[Blaine0002]

simply point the money row at the row used by rpg inferno.

CHKDGATE
your problem dosent seem to have anything to do with the script, as you can see, it is looking for the admin file in "upload/admincp/ishop_control.php", and the upload directory isnt specified in any of my files.
Best i can reallly say is try uninstalling and reinstalling the product completely.

[chkdgate]

I pm'd you a request. Blaine, I hope this doesn't seem stupid but can you elaborate on step #5, link to itemshop.php? I think this is what I'm missing. Also, in my post #79 screenshot, I didn't get that error this time around which got me thinking I installed it right but I got happy too early. Still nothing.:confused:

[Blaine0002]

ok, in order to link to ishop.php you need to edit your navbar template, find where you want the link and insert

<a href="ishop.php>IShop</a>


As for your postbit, ill help you out with that individually.

[chkdgate]

Ok, I wasn't doing step #5 which is probably why I didn't see it in my navbar. Can this be placed anywhere in the navbar template or is it location specific?

[Blaine0002]

wherever you want :)

[chkdgate]

I tried placing it towards the very bottom of the navbar tamplate but it makes the board look way out of whack and still no ishop link in sight. I removed the navbar edit for now until I get word from you or another successful user. Thanks for your patience Blaine.

[Blaine0002]

sure man, no problem, everyones new at this sometimes, but once you get it down it goes much easier :) Troubleshooting is just somthing you need to do on a regular basis
Try this: in navbar template
find:

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

replace with

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

[chkdgate]

Holy crap it worked!! You're the man dude! Thank you so much for your help. Well deserved. Do you think anyone else ran into this problem?

Edit:
Finally, you helped me into getting this to work! I have 2 concerns which I'm not sure if they're bugs or not.

1. I can't get any of the purchased items to show in my postbit.

2. When I'm inside ishop and I sell an item from my inventory, it just dissappears with no further confirmation.

Whatever you did worked fine and all my ishop options in my acp work great but my postbit is just blank.

[Blaine0002]

did you do the edit on the second post of this thread?
https://vborg.vbsupport.ru/showthread.php?t=109515

[chkdgate]

Yes, I made sure of that. Let me try legacy.

Edit: It worked by placing it in postbit legacy. I thought it wasn't neccessary?

[chkdgate]

Request:

1. The ability to purchase icash points in ishop through paypal. For example: for every $1 (you set the amount) you buy in ishop, you get XX amount of icash points. This is a great way for Admins to pay for hosting.

2. The ability to view one's inventory in their profile.

Awesome hack!

[Blaine0002]

i can work on the first one, but the second one should work, try clicking on 'this users Inventory' in their postbit.

[chkdgate]

Blaine, that will be an amazing update if you can make that happen. But as far as request #2, I mean make it viewable in the user's actual public profile and not just their postbit. You know what I mean?:up:

[Blaine0002]

ah, ok, shouldnt be that hard to add :) kinda bogged down right now tho.

[chkdgate]

Is there any way you can make the user's inventory not display if it's empty? You know, until the user buys something, only then can everyone see it.

[Blaine0002]

yes i can look into that

[chkdgate]

Awesome, because it's kind of an eyesore to look at someone's empty inventory. Although it's also a reminder as to why they should visit the shop but then again they can see everyone else's and figure it out that way.

[vitnuce]

Is it possible to get this one to show max X number of items in the postbit and to let the members arrange the order of the items themselves??

I would really like to see something like that on this great hack.. :)
Blaine0002, would u plz do it :)

Thanks!

[chkdgate]

^^That's a really great idea.

[Blaine0002]

Am currently working on it :)

[JD210]

I installed this and I love it, it is exactly what I was looking for. I have a question though. I didn't want to add the inventory to the postbits or signature, as I thought it could clutter them up, so I set up a field for the inventory in the profile, below Additional Information/Group Memberships. Problem is none of the images for the items show up there. Any ideas on to get them to show up on the profile page?

[Blaine0002]

you will need to change the hook location of the one whos title mentions inventory. im not sure what you would change it to though.

[zane99]

installed all fine but just doesnt show up on my postbit at all.

i have it intergrated wiv ur icash successfully. everything works. just doesnt shwo up! help!!!

[chkdgate]

installed all fine but just doesnt show up on my postbit at all.

i have it intergrated wiv ur icash successfully. everything works. just doesnt shwo up! help!!!

I was having the same problems as you. Just start reading from post #78 on forward and see if that helps.

[zane99]

I was having the same problems as you. Just start reading from post #78 on forward and see if that helps.

i so knew ud have to put it in postbit legacy even though it says u dont!

thanks


good hack, i luv these simple version of the other complex hacks. im far too lazy to install those hahaha

these suit me fine :D

[Blaine0002]

I personally do not like the additonal file edits and template edits when they are not needed. Anyways, on vacation, another 5 days for any support :) sorry.

[david05]

i can not import the xml file,
Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO itemshop_cat (cid, cname, cdescr, csold, cprofit, citems) VALUES (1, 'Test Category', 'Get your items here!', 0, 0, 0);

MySQL Error : Table 'mynameuser_forum.itemshop_cat' doesn't exist
Error Number : 1146
Date : Wednesday, June 7th 2006 @ 06:24:51 AM
Script : http://www.my domain.com/admincp/plugin.php
Referrer : http://www.my domain.com/admincp/plugin.php?do=productadd
IP Address : my ip
Username : my name
Classname : vB_Database


I got the same problem with this mate and I already read through to the end of this thread but nobody help him with this issues. Now I got this problem :hurt: Would someone please help me?

I did step by step in the instructions, but I don't know what I did wrong????

[Blaine0002]

all i can say is try uninstalling the product and installing it again. not sure what the problem would be....

[Nova99]

a request for future versions:
The ability to sort the items by their names in the categories.
Now they only seem to be displayed in the order they were entered.

[Xbizcafe]

How we do to delete an items after buy in the account of member ?

In case for example the member buy item for receive anything, he receive, and after it's necessary to delete for a clear management.

[ArabSQuad]

hello ..
I have some problem In Donating page ... :S :S
, The donater isn't able to Donate Any money or items to Other members !! ...
.. See these images (the image is better than thousand trades : D)

https://vborg.vbsupport.ru/external/2006/08/16.jpg

in case i wanted to send the donation money or the item there's no button to click on .. just a text box :surprised:

[Xbizcafe]

How we do to delete an items after buy in the account of member ?

In case for example the member buy item for receive anything, he receive, and after it's necessary to delete for a clear management.

Nobody have solution for my problem ? :confused:

[ArabSQuad]

Any 1 ? :(

[Blaine0002]

Arab squad: im not quite sure, might have somthing to do with your board language, have you tried it on an english board?

Xbiz i will need to add this in the future.

[Xbizcafe]

Xbiz i will need to add this in the future.

Thx.
For moment we can't do it by sql for delete it ?

[novelidea]

I keep getting database errors when I try to add categories, items, etc.

[novelidea]

I can't get this to work at all. :(

[Sim9]

Very cool modification! I'd very much like to see the following features (as otherwise I would have to code them in myself before deploying the modification on my own forums :():
Equip - Let users choose their favorite X items and display only those in their postbit
Trade - A mechanism to allow users to trade with each other. IE: A user can propose to another user to trade X item for Y points, or trade X item for items Y and Z. User 2 can accept or decline this trade.
Items in Profile - Shows all items
Trade / Donate Restrictions - Mark some items as untradeable / undonateable. Some items, like a contest trophy, should not be tradeable.
Paycheck - Every week, members receive X points for up to Y posts per day that week
Item Actions - Allow items to do simple actions. For instance, a fortune cookie action could display a random fortune. Provide an easy way for developers to add custom actions, such as a documented PHP script file with a few example actions. Individual forum admins can then extend this to add forum-specific functionality.

(Update several months later - please see this thread (https://vborg.vbsupport.ru/showthread.php?t=134409) for more information on this project :))

[BrentW]

Very cool modification! I'd very much like to see the following features (as otherwise I would have to code them in myself before deploying the modification on my own forums :():
Equip - Let users choose their favorite X items and display only those in their postbit
Trade - A mechanism to allow users to trade with each other. IE: A user can propose to another user to trade X item for Y points, or trade X item for items Y and Z. User 2 can accept or decline this trade.
Items in Profile - Shows all items
Trade / Donate Restrictions - Mark some items as untradeable / undonateable. Some items, like a contest trophy, should not be tradeable.
Paycheck - Every week, members receive X points for up to Y posts per day that week
Item Actions - Allow items to do simple actions. For instance, a fortune cookie action could display a random fortune. Provide an easy way for developers to add custom actions, such as a documented PHP script file with a few example actions. Individual forum admins can then extend this to add forum-specific functionality.

If those features can be developed within 2 months (starting today), I will pay the developer 100 dollars. Serious.

[Sim9]

Really? Sweet! That would provide me some extra incentive to work it ;)

Considering Blaine0002 started this mod, I'd like to hear if he's interested in working on it more first before I write something from scratch that could be a competitor to his modification. :)

[BrentW]

Well, if you ADD those features to Blaine's mod, I will pay you 100 bucks. I don't want a separate mod because that would get rid of the items users have already collected. :)

[Sim9]

Hm, I see your problem. :)

For now, I still have hope Blaine would be interested in writing this functionality himself and collecting your $100 :)

[Nokia Tech]

Could not get it to work, All admin CP area was working ok, nothing on forum side

[Ntfu2]

Database error in vBulletin 3.6.0:

Invalid SQL:
select s.*,i.*
from itemshop_stock s
left join itemshop_items i on(i.id=s.item_id)
where s.member_id='223';

MySQL Error : Table 'ntfu2_forums.itemshop_stock' doesn't exist
Error Number : 1146
Date : Tuesday, August 29th 2006 @ 10:42:22 PM
Script : http://nowthatsxxxxdup2.com/forums/showthread.php?p=65904
Referrer : http://nowthaxxxxxxxxedup2.com/forums/forumdisplay.php?f=1
IP Address : 2xxxxx
Username : xxxxx
Classname : vB_Database

[dai-kun]

MySQL Error : Table 'ntfu2_forums.itemshop_stock' doesn't exist

Make sure that that's what the table's name is in your database.
I think the itemshop did not use the table 'prefix' so when you try to upgrade to ishop (which uses table prefix), it couldn't find the tables.

[soletrader]

Does this allow the admin to know what the users bought? Also is there a way to disable the sell function?

[MotMann]

Where are screens ore a demo?

[cd1986]

How easy would it be to add items such as those found in things like vbPlaza - where memebers can use points to purchase thread stickys, thread coloring options etc.

I like the idea of using iCash and iShop together, rather than the bulky vbPlaza, but i do like the built in purchase options, which i don't think this mod comes with as standard?

[Ntfu2]

adding those options would make this the same as vBPlazza, so why would you want to

[cd1986]

Because there are certain other things about vbPlaza i don't like, and i'd rather build something up from simple building blocks like iCash and iShop. Having those options is not very important to my setup, but i'd still be interested in knowing how it could be done.

Allows your users to buy images with their money for their postbit
This isn't much different from allowing them to buy other thread / forum options either...

[gamesmastervide]

any chance of you making an addon so members can buy avatar use and sig use?

[z8xmaster]

How can I make ISHOP intergrated with ICASH ? I installed the two of them but I still can't use the point from ICASH to buy things in ISHOP. I used vbb 3.6.0

nevermind, I've finally found that !! Thanks for the hack !!

[gamesmastervide]

man peoples inventorys are getting too big on my forums an arrange feature for users to only show there top 10 with a link to show others or even a drop down box to show inventorys?? I'm thinking the second idea could be easier?

[doogie88]

Would it be easy to mod and get it to PM me when and what someone buys?
And also in the admin CP, how easy would it be to have multiple fields to donate at the same time, instead of name donate name donate name donate, etc.

[yingzhou]

Very cool modification! I'd very much like to see the following features (as otherwise I would have to code them in myself before deploying the modification on my own forums :():
Equip - Let users choose their favorite X items and display only those in their postbit
Trade - A mechanism to allow users to trade with each other. IE: A user can propose to another user to trade X item for Y points, or trade X item for items Y and Z. User 2 can accept or decline this trade.
Items in Profile - Shows all items
Trade / Donate Restrictions - Mark some items as untradeable / undonateable. Some items, like a contest trophy, should not be tradeable.
Paycheck - Every week, members receive X points for up to Y posts per day that week
Item Actions - Allow items to do simple actions. For instance, a fortune cookie action could display a random fortune. Provide an easy way for developers to add custom actions, such as a documented PHP script file with a few example actions. Individual forum admins can then extend this to add forum-specific functionality.


This is very nice mod. How long is it? Did you completed this mod? I like it so much!

[yingzhou]

I suggest this thing:

- No need to show User's Inventory for who dont have anything in their inventory. This will help alot for not slow down the site because a lot of query use.

- Can order the categorie via ACP. Some Categorie need be first or some need place below.

- Equip Item: Let users choose their favorite X items and display only those in their postbit. Like the Upper post I say. Because a lot of image will slow down the page. :(

- I think we just let 4 slot to equip the item in their Postbit. More will slow down.

- More Information about Items: when I click on the Item Icon or their name, this will show me other page with their full information. This will help alot.

- Items in Profile - Shows all items. This will be cool.

- The admin can remove the item of member via Usercontrol.

- The Statistics for this shop will be usefull to see how member buy/sell the item.

- The Option to change the rate of "sell"

- The option to hide the item for guest!

Will add more suggestion. :D This mod will be cool. Where is the author? :|

[yingzhou]

No one interest in this Mod now? :(

[Sim9]

Very cool modification! I'd very much like to see the following features (as otherwise I would have to code them in myself before deploying the modification on my own forums ):

* Equip - Let users choose their favorite X items and display only those in their postbit
* Trade - A mechanism to allow users to trade with each other. IE: A user can propose to another user to trade X item for Y points, or trade X item for items Y and Z. User 2 can accept or decline this trade.
* Items in Profile - Shows all items
* Trade / Donate Restrictions - Mark some items as untradeable / undonateable. Some items, like a contest trophy, should not be tradeable.
* Paycheck - Every week, members receive X points for up to Y posts per day that week
* Item Actions - Allow items to do simple actions. For instance, a fortune cookie action could display a random fortune. Provide an easy way for developers to add custom actions, such as a documented PHP script file with a few example actions. Individual forum admins can then extend this to add forum-specific functionality.
This is very nice mod. How long is it? Did you completed this mod? I like it so much!

Actually, I did finish it recently. I'll make a seperate thread to show it off if you're interested :)

[yingzhou]

Actually, I did finish it recently. I'll make a seperate thread to show it off if you're interested :)

Really interested in this mod. Thank for answer here! Hope you soon finish it. Merry Xmas!;)

[yingzhou]

I have 1 problem. I want to know how many point my member had pay for the shop. May I have a option to view the summary of that.

1 more problem is, If member sell the item. Where that point going to? Can I know how many of it?

All I want is the Statistics for this shop. :D

[Blaine0002]

Well, it seems i got here too late :-/ lol

[yingzhou]

Well, it seems i got here too late :-/ lol

Bravo man. The author is comeback.;) Have you read my post about some Option for this mod? :D What do you think about that? :)

[Blaine0002]

I would start on it, but it seems to me like somone has already completed it. lol

[yingzhou]

And now we stay for Sim9 to release his version.

1 more thing is can we have the Statistics for this shop! with this I can see how many point they are pay for the item.

Where I can change the rate for "sell"?

Guest can see the image of item. :( I think this wil overload our server. Can we hide the item for guest?

[Sim9]

I would start on it, but it seems to me like somone has already completed it. lol

By all means, proceed Blaine (and welcome back)! For one, I don't intend to publicly release mine, but may do a private commercial release to a very small group if there is interest. What I meant by my post is that I would create a new thread to discuss and show off my project there instead of hi-jacking your thread. A second point is that my project is from scratch, so it is not compatible with iShop. Thus anyone currently using iShop who wants to keep their data would want to stick with your project :)

I'm pretty proud of my small project, so I'll make a seperate thread about it and link here, if that's alright with you, Blaine. :)

[Blaine0002]

Go for it, i guess ill upgrade ishop after the next version of vbay is released.

[yingzhou]

Thank for Upgrade this usefull Mod. :D

Good Works Coder! :D

[Sim9]

Thanks Blaine and Yingzhou! :)

I've posted my project in this thread (https://vborg.vbsupport.ru/showthread.php?t=134409) if you're interested :)

[Quotealex]

Can we use this script to give out real items (like Ipods, DVDs, etc) to members with enough points to buy them?

[yingzhou]

How to Hide to Inventory for guest?

to Blaine0002: When you begin to work for next version of Ishop? I think about some option need for Ishop. :D

[Stifler]

installed on 3.5.7 with icash already installed and in Admin I get tons of MySQL errors when trying to view the options that arent about the money field.. do i need to change the name of the table its called to add the prefix vb_ to the table named money?

Database error in vBulletin 3.5.7:

Invalid SQL:
select * from itemshop_cat;

MySQL Error : Table 'XXXX.itemshop_cat' doesn't exist
Error Number : 1146
Date : --
Script : .../forums/admincp/ishop_control.php?act=add
Referrer : .../forums/admincp/index.php?do=nav
Classname : vB_Database

[Blaine0002]

installed on 3.5.7 with icash already installed and in Admin I get tons of MySQL errors when trying to view the options that arent about the money field.. do i need to change the name of the table its called to add the prefix vb_ to the table named money?

Stupid question but did you import the XML file?

[yingzhou]

Hello Blaine0002. When you'll start the next version of Ishop? :D

[Blaine0002]

Hello Blaine0002. When you'll start the next version of Ishop? :D

Soon, almost have vbay stable.

[Stifler]

Stupid question but did you import the XML file?
Yes I did.

[Blaine0002]

00ps. stupid mistake by me, redownload ishop.zip and reupload all files.

[Stifler]

well now thats fixed, when i try to view threads i get this mysql error:

select s.*,i.*
from itemshop_stock s
left join itemshop_items i on(i.id=s.item_id)
where s.member_id='1';

MySQL Error : Table 'XXXX.itemshop_stock' doesn't exist

[Blaine0002]

thats no good, ill get this fixed ASAP

[Stifler]

thats no good, ill get this fixed ASAP
Thanks Blaine! Your the best :D

[Zowners]

hey does the Ishop work for vbulletin 3.6?

[Blaine0002]

yes

[Frank-kun]

This is a great mod, thanks for creating it.

My one issue is that I have mods and admins who went nuts and gave themselves tons of money and items. The items in the postbit now make their posts scroll the screen sideways. I know you return the inventory via $post[invrow], but I totally am drawing a blank on how to modify the inventory so that it only shows a limit on items - or at the very least divides them into multiple rows! Is there a quick fix for this? I could yank the items away from my forum staff but I'd rather not if possible.

Thanks!

[yingzhou]

I have one problem. I cant buy the same item 2 times. :( Can you add the option to buy the same items for some.

[Stifler]

thats no good, ill get this fixed ASAP
blaine you ever get that fixed?

[Blaine0002]

oops, i forgot to upload fix, download the zip and reupload files, no need to reimport product. Thx for reminding me :D

[ArchangelX]

I'm still very intersted in this mod...some of those additional improvements would be really nice! I encourage you to keep going! :D

[Frank-kun]

I actually solved my own problem.

Got people going nuts with buying items, making the screen scroll over? This quick fix should solve the problem.

Before doing any code modification, go into your Templates Manager and create a new template. I used the name "ishop_invpostbit_itemreturn".

In that template, you just need to put this:
<br>

Go into the \plugins\inventory.php file.

Find:
foreach ($myitem as $the_item) {

Before that put:
$i = 0;

Find:
eval('$post[invrow] .= "' . fetch_template('ishop_invpostbit_item') . '";');

And after it put:

$i++;
if ($i == 8) {
eval('$post[invrow] .= "' . fetch_template('ishop_invpostbit_itemreturn') . '";');
$i = 0;
}

In this snippet of code, the number that $i is set to is the number of items the inventory will display before skipping to the next line. I chose 8 items. You can pick any number you want.

Upload the inventory.php file to the plugins directory and you're set!

You can see this in action at our forum:
http://the-reactor.org/forums

This should work until the developer can come up with a cleaner fix. :)

[apthost]

I see no real point to this system. I need some type of point system where people can buy things that I make up, then I can view their profile and see what they have bought. So say they want a domain name after getting so many points, so I would like to be able to view their profile, see that they ordered that and then pm them and ask them about what domain name they want for example.

A whole system designed just so little icons could be displayed in the users inventory I think is just a waste of space.

[Blaine0002]

thanks for your thaughts but many people do want this for forums, maybe not buisness based, but community based. you know there are forums like that right?

[Frank-kun]

I see no real point to this system. I need some type of point system where people can buy things that I make up, then I can view their profile and see what they have bought. So say they want a domain name after getting so many points, so I would like to be able to view their profile, see that they ordered that and then pm them and ask them about what domain name they want for example.

A whole system designed just so little icons could be displayed in the users inventory I think is just a waste of space.

Well, that's the thing - just because it isn't a fit for your needs doesn't mean it doesn't fit for someone else's.

In the forums I run, they are as Blaine says, more community-building tools than anything else. We don't want them to just be about what the site is about or how to conduct business, but also to be fun too. You're right - there isn't a "point" to the system. It's just a fun little diversion and a way to get people to post more on our forums by earning virtual cash towards items.

You'd be surprised how much "little icons displayed in the user's inventory" is a status symbol. That's how online communities build themselves.

At some point in the future, at least for the forums I linked in my last post, we're looking to move to something more complex like the RPG integration system in the future. We're testing the waters to see how these fun little tools will have a positive effect on our users.

[snowlion]

how do i intergrate Isho with vbplaza ?
someone help me

[WiiBeyond]

Hello, my friend has something like this for IPB and he has options that you can allow users to buy special permissions on the boards, such as the ability to delete their own posts and so on. Is it possible to do that with this as well?

[WiiBeyond]

by the way, i was reading frank-kun's post... RPG sounds AWESOME

[Blaine0002]

Im not sure if vbplaza works with anything but vbbux, i am not able to download it, so i can not test it out :( sorry.

WiiBeyond, This hack will most likely stay as it is, with no additional features being added, just because of its simplicity. Although, you should feel free to contact some coders on this website and request an addon that allows them to do just that :D

[WiiBeyond]

One mroe question, I was wondering if it is possible to send a PM to a user when he/she donates to them. I was planning on having a user donate the item to me, and when I get the PM that that particular user sent me the item, then i can go change their options, or send them a game or w/e it is that the item represents.

[yingzhou]

The member who buy alot of item will break the Page. Can you add the "More" option. The inventory only show up the number of Items like 2 items. You must click on More to see all the items.

Can you work for the option to chose if what item they like to show and what item they can hide.

I cant buy the second of the same Item. :D

[MissKalunji]

Im not sure if vbplaza works with anything but vbbux, i am not able to download it, so i can not test it out :( sorry.

WiiBeyond, This hack will most likely stay as it is, with no additional features being added, just because of its simplicity. Although, you should feel free to contact some coders on this website and request an addon that allows them to do just that :D

Works fine :) with vbplaza here

[MissKalunji]

this is good but i can't seem to figure out WHY it brings about 30 extra queries

[Blaine0002]

on what page does this happen?

[MissKalunji]

showthread when i remove the pluging inventory.php it drops back to the normal (wich of course wont show the icons)

[Blaine0002]

thats odd, it should only run one query...

[MissKalunji]

well i dont know momment i readd that query it adds about 30 queries sometimes more....and thats on pages where there is NO members that has icons....

if in that page theres ppl with icons it adds more....

would running this with vbplaza be aproblem? Right now im running it but i disabled the inventory.php plugin and just using the link
and also what code should i add to only show the inventory link IF that person has bought any?

[Blaine0002]

running it with vbplaza shouldnt affect it much, ill look into it, 30 queries is bad :P

[MissKalunji]

lol tell me about it i saw at one point went to 70 i was like wow....

what about my second question?

[tfusion]

Is this mod similar to Vbplaza? since , i need the default products such as , username color etc..

Please help.

[Blaine0002]

this does not include adding visual aspects to you site, except for postbit icons.

and no, this should work fine with vbplaza.

[dai-kun]

The member who buy alot of item will break the Page. Can you add the "More" option. The inventory only show up the number of Items like 2 items. You must click on More to see all the items.

Can you work for the option to chose if what item they like to show and what item they can hide.

I cant buy the second of the same Item. :D

I've asked for this request like a year ago and am still waiting.. :)

[Blaine0002]

somone posted a fix to that earlier on this thread.

[dai-kun]

Hm.. i don't really see the "fix".. is it "the Archive" hack that was mentioned?
I'm already using ur hack for almost a year so my users have spent a lot of time buying the stuff already. Don't want to move over to something else if I cannot have it ported. I will donate if u ever finish those features for ur hack.

I couldn't find any info on where to download it or where to even get it either way.

[Mys]

Hi Blaine:

I've installed Ibank, Icash and Ishop with 3.6.4. Now testing. So, I purchase a plushie in Ishop and system tells me purchase was completed. However, the items are not showing up in my postbit or user profile. Doesn't seem right to me. Am I doing something wrong? Can you offer any advice to resolve? I am not using the legacy postbit.

Also, I'm interested in the Ultra Itemshop mod. Since I have Ishop, does Ultra offer me anything?

Thanks so much,
:D

[Blaine0002]

Ultra itemshop is an older version of Ishop and will actually offer less than what you currently have.

Make sure you have done the postbit edit to the correct postbit template, or even both just to be safe.

[MissKalunji]

Did you come up with any solution for my problem?

[Paultiscali]

Installed the hack but how do i get it to show up on my navigation menu were i have usercp, arcade etc

[hitboy]

Hey is there anyway you can add feature where we can add digital products and members can trade there points for a digital product.

So first the points would be sent to the admin or somewhere.
Then they would recieve the product through email or they would be redirected to a secure download page?

Is this possible?

[hippiesimz]

is there any easy easy way to upload at once all the item or we have to add it up one by one ? thanks.

[hippiesimz]

How the user can do shopping ? is there any chance it will be displayed on USER CP Menu or The User need to click his own post to be able to see the shop ? thanks.

[Blaine0002]

you can just put the link on your navbar.

I am workin on updating this next

[Blaine0002]

so i am planning on updating with the following

User able to edit item order,
Limit items in postbit to first items in order,
Buying multiple of the same item,
Enhanced code.

Anything else you guys can recommend?

[AuroraStorm]

Well, that's the thing - just because it isn't a fit for your needs doesn't mean it doesn't fit for someone else's.

In the forums I run, they are as Blaine says, more community-building tools than anything else. We don't want them to just be about what the site is about or how to conduct business, but also to be fun too. You're right - there isn't a "point" to the system. It's just a fun little diversion and a way to get people to post more on our forums by earning virtual cash towards items.

You'd be surprised how much "little icons displayed in the user's inventory" is a status symbol. That's how online communities build themselves.

At some point in the future, at least for the forums I linked in my last post, we're looking to move to something more complex like the RPG integration system in the future. We're testing the waters to see how these fun little tools will have a positive effect on our users.

I totally agree with you. My posters had so much fun with the gifts and point system - the stealing points alone took it to another level once they figured out how to do that. When I learned how to upload my own gifts in, like images of Gucci perfume, bling gifts and the like, it made shopping real fun. Anybody can host a forum to just "talk" but with the vbPlaza and the Arcade, it gave the community more pizazz and made things more interesting. I miss vbPlaza but if this Icash and Ishop will work just as well, I might download them and see what happens...

[MissKalunji]

so i am planning on updating with the following

User able to edit item order,
Limit items in postbit to first items in order,
Buying multiple of the same item,
Enhanced code.

Anything else you guys can recommend?

what about the queries problem?

[Blaine0002]

will be fixd along with the postbit edit.

[MissKalunji]

cant wait then

[WEBDosser]

maybe i will use this soon.

[DNMASTER]

I've just downloaded this file and how do i make a table for it on the database?

Thank you

EDIT : Newbie question lmao sorry :( :eek:

[Vinyljunky]

Will this MOD ever be deemed as Supported for 3.6.5 (As in what it says in the top of the post)

It sounds like just the interaction that I need for my site, and I have just installed iCash :)

Thanks

VinylJunky

[Blaine0002]

This mod does work with 3.6.5

[Vinyljunky]

This mod does work with 3.6.5

Thats great, but, not quite what I asked ;)

Maybe its because Im a Newbie to VB, but Im nervous to install anything where it says "https://vborg.vbsupport.ru/external/2011/01/24.gif Unsupported" in the MOD Description :confused:

What does it mean? (Sorry as Im sure it seems a dumb question)

Thanks for your time

VJ

[AuroraStorm]

How do I link this to Itemshop.php? Maybe it's simple but I'm looking too deeply at it to understand...

[Blaine0002]

aurorastorm, that has been posted earlier in the thread, look back a few pages.

Oh, Sorry Vinyl, it should say supported now, it dosent mean much in the first place though, it only means the author will reply to your support queries on this website.

[hitboy]

so i am planning on updating with the following

User able to edit item order,
Limit items in postbit to first items in order,
Buying multiple of the same item,
Enhanced code.

Anything else you guys can recommend?

Hey is there anyway you can add feature where we can add digital products and members can trade there points for a digital product.

So first the points would be sent to the admin or somewhere.
Then they would recieve the product through email or they would be redirected to a secure download page?

Is this possible?
Edit/Delete Message

[Kleptomaniac]

Hi, nice mod blaine. I'm getting the following error when trying to donate an item to a member though.



Invalid SQL:
select s.*,i.* from vitemshop_stock s left join itemshop_items i on(i.id=s.item_id) where s.member_id='1' and i.id=2;

MySQL Error : Table 'xxxxxx_xxxx.itemshop_items' doesn't exist

It acts like its not looking for the right table maybe? I dont know much about this stuff.

[Blaine0002]

hmm, i might have forgotten a table prefix, do you have one?

[Blaine0002]

Hi, nice mod blaine. I'm getting the following error when trying to donate an item to a member though.



Invalid SQL:
select s.*,i.* from vitemshop_stock s left join itemshop_items i on(i.id=s.item_id) where s.member_id='1' and i.id=2;

MySQL Error : Table 'xxxxxx_xxxx.itemshop_items' doesn't exist

It acts like its not looking for the right table maybe? I dont know much about this stuff.
hmm i looked through my code and it seems correct, could you maybe try reuploading your ishop.php file?

[Kleptomaniac]

I redownloaded the mod and then reuploaded the ishop.php file, I still get the same error. Any other ideas? Its just this one area that I have problems, the rest of the mod works great for me.

[Blaine0002]

very odd, is it when you go to t he donate screen, or when you hit the donate button?

[Kleptomaniac]

The donate screen works ok. After I select the item I want to donate, and then type the person I'm donating to... I hit the donate button, and thats when I get the error.

[Kleptomaniac]

Anyone else have any ideas? Any help is very much appreciated. :)

[sinisterpain]

The ishop_invpostbit_item templete is uncached

[Blaine0002]

I am working on updating this as we speak.

[CPK]

I want to edit my Navigation with a link to icash and ishop.

Can somone supply me some codes to go in
Style Manager > Edit Styles > Navbar/Breadcrumbs template > navbar

[ktutorials]

does this supports vB 3.6.5

[AuroraStorm]

ok, in order to link to ishop.php you need to edit your navbar template, find where you want the link and insert

<a href="ishop.php>IShop</a>


As for your postbit, ill help you out with that individually.

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

I pm'd you a request. Blaine, I hope this doesn't seem stupid but can you elaborate on step #5, link to itemshop.php? I think this is what I'm missing.

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

[Blaine0002]

the one i posted.

[tehPARADOX]

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?

It is ishop.php, the instructions were not updated yet I guess.

[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

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]

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 :)

[Blaine0002]

yup, in the postbit you will see a box and at the top it will say "USERS Inventory" you just have to click that link :)

[dai-kun]

nvm.. im blind
thanks!

[MissKalunji]

Ok i installed it theres 2 uncache templates (i've cached them). Thanks for the update

About the queries When theres only
2 Posts in the thread i get 17 queries
3 posts = 19 queries
6 posts = 26 queries
11 Posts = 37 Queries

hope this helps to narrow the problem

[Blaine0002]

what are the uncached templates? im also working on making it into only 1 query per thread.

[MissKalunji]

oh ok i thought you didnt know...

ishop_invpostbit_item and ishop_invpostbit_return are the uncache template

[MissKalunji]

you're doing a great work btw

[dai-kun]

Hey.. the items I use on my forum are "cards"... and this is the problem I been getting from my users:

" I was able to send the Edward card without problems to the user, but i can't send the Fye card to arachne13, it says 'You do not own this item to be able to send to anyone!' even if i already bought it and it shows up in my inventory too."

It would be nice if we can lower the queries # .. which is crazy.. i get like 30's lol

[Blaine0002]

Hmm, so you say that your users are not showing up as owning the item when they donate it? i will look into this

Thanks for your donation by the way!

[ThreeD]

hmmm I love this installation, one problem though. When I try to click on the "buy" icon in the ishop nothing happens. When I hover my pointer over the "buy" link it shows "Not enough money to buy this item" :(

I am also using iCash and I have both rows set to "money"...any idea why it won't let me purchase anything?

I looked in the source code of the browser and this is what I found:

<br><a disabled=true href='javascript:;' title='Not Enough money To Buy This Item'>Buy</a>

I have 10000 bux available and this item only costs 10 bux..

[MissKalunji]

did you make sure you put hte SAME variable as ICASH in money?

like for Vbplaza the money field is : vbux....in Istore i have to put vbux