The Itemshop v5 (Original)

Again, I'm posting this for a friend. He is the original itemshop creator. (see this thread):

Let's start with the beginning. You may wonder why this thread has the word original in its name. Well, there are too many itemshops out there. So here's a short version of the itemshop history:

1. First of all, afterlab had the idea of an itemshop, which he also did, but it was pure text. People would have to talk to him to buy items, and he would have to manually substract the points.
2. Then, as a member of ffr, i started talking about how easy and convenient it would be to have an automated itemshop. People just click on the link, and the item is added, points substracted. Later that day, i did the very first version of the itemshop. Nothing big, just a buy function. The items were stored in an array.
3. I had released my itemshop on vb.org and afterlab was pretty unsatisfied that i hadn't given him any credit for the original idea. Actually i didn't even consider the itemshop a hack, it was more of a joke, something i had made for fun. I had no idea it would become so popular.
4. 2 days later, version 4: This one had error pages, improved buy and sell function. I was planning a database powered itemshop, with admin cp interface.
5. afterlab then pretty much copied my code 3 times, and released his first version "with item categories". It felt pretty unfair, while i was struggling to do something way more advanced, he was getting all the credit for something that was still 85% mine.
6. then my computer broke, just as I was working on the admin cp of my database version. I was also planning to do the battle system hack.
7. in the meantime, about one week later, afterlab released his itemshop 3 i think, database powered.
8. couple of weeks later afterlab started all the battle system stuff.
9. about 2 months after my computer crashed, it got finally fixed, and i began to work to complete my own itemshop.
10. So well, here it is.

nice story, isn't it?

here's a quick list of features:

Database driven
Full Template Set (everything that is outputted is generted through templates)
Infinite items categories and items
Items and category descriptions
Stock (idea by Crono)
Detailed items/categories/shops stats (number of sold items, profit)
All the item and category adding/editing/deleting and option editing is done through the cp.
Special icon column for different item display possibilities
!!!! Personal Shops !!! (members can create their own shops and sell items. You can specify how much it costs through the cp. while each category has it's own slot, all the personal shops work under one slot. That means, you can only have one item from all the personal shops)
An own donation system included

what it adds:

The itemshop adds 4 tables to the vbulletin database:

• [items] - This is where all the items are stored
• [items_cats] - This is where all the categories are stored
• [items_options] - This is where the configuration data is stored
• [items_user] - This is where all the user stuff and items he bought, are stored

26 templates to the main template set:

• itemshop
  
• itemshop_buypers
  
• itemshop_delpers
  
• itemshop_donate
  
• itemshop_donate-error
  
• itemshop_donate-more
  
• itemshop_donate-self
  
• itemshop_donate-thanks
  
• itemshop_error-nosell
  
• itemshop_error-noshop
  
• itemshop_info
  
• itemshop_its
  
• itemshop_itsbits
  
• itemshop_own
  
• itemshop_pers
  
• itemshop_persform
  
• itemshop_personal
  
• itemshop_pheader
  
• itemshop_redir-del
  
• itemshop_redir-edit
  
• itemshop_redir-sell
  
• itemshop_redir-thanks
  
• itemshop_tablebottom
  
• itemshop_tablemiddle
  
• itemshop_tabletop
  
• itemshop_view

Like i said, anything there is to edit can be edited through templates

File and Template Modifications:
there are 4 file modifications, but only one of them is neccessary.
and one template modification: postbit, wherever you want the donation link to be.
important!!!!: remember to change your points field and remove any old itemshop templates!!!

Installation method
First of all, be sure to back up your database!! This is a fairly large hack. Adds a lot of stuff to the database.

the installation is done through the install script install_itemshop.php. It will guide you through 5 easy steps.
the only manual edits you'll have to do are the ones above, file and template edits.

Included Files

readme.htm - general information
root/itemshop.php - main itemshop file
admin/itemadmin.php - itemshop admin interface
admin/install_itemshop.php - itemshop installation file
images/itemshop - itemshop image file. This is where you will have to upload all coresponding graphics.

Contact Information
mail: gheghe@rnc.ro
aim: MewtwoAlx

If you wish to colaborate with me in continuing this hack or to add item descriptions for further versions please contact me.
This hack can easily be used not only for rpg boards.. As an example: you add computer categories: cpu, hdd, monitor etc, replace points with $ and let people on your forum build themselves a computer!


I've already got a list of stuff i gotta update in the next version, but if there's any request feel free to ask.
The shop is 100% functional, but i want to improve stuff, make it more efficient.

[And please, before releasing any new mod/edit/version to this hack ask for permission] - If you agree to that condition you are allowed to freely use and distribute the zip below, as long asthe copyright and author information remains intact.
By not agreeing, you are not allowed to use this hack, nor will you get any support.
- Thank you! That was just to prevent my hours hard work on the itemshop to be stolen

Whoa, that was a lot of typing! I hope you like it! Attached file below.


screenshots attached:
https://vborg.vbsupport.ru/showthrea...268#post246268

https://vborg.vbsupport.ru/showthrea...277#post246277


*** update
all bugs reported by Kaelon are fixed.
i've also added some extra stuff:
ascending or descending order
postbit edit: well, for the postbit, i couldn't just put the imgs, cause all the items of the same type have the same image. so i put the image and a link to a separate item info page.
1 new template required for the item info page.
added remove feature in installation script. ( note: it will simply drop the tables and remove the templates).
75% faster!!! and less stress on your server
***

***
new update: bank hack integrated!!!
***

***

[Jacko]

i tried that but i get nothing there.. same with the items.

[Jacko]

ok i fixed the items not showing on the postbit.. but i still can get my points to show up..

[Frank-kun]

Hello everyone,

Well, this one's been a much-traveled hack. I installed this on version 2.2.8, even knowing there were problems, because I wanted to see if I could find out some way of helping with a couple of the problems - this is a very cool hack and I hate to see it go to waste.

One of the main concerns appears to be the query load. Because of the way the hack works, even with Link's fix, there is an insane amount of queries -per post- to process the display of items.

Vivi actually saw that this was a problem and posted a fix wayyy back in the early pages of the thread. However, the fix missed a step, and I wasn't able to properly get a good display going without the load until recently.

Basically, I applied Vivi's fix, and included the one step he missed when he first posted it. I believe this should help on the server load and reduce the queries to nil.

Since I have limited experience with php and mySQL, try this out at your own risk. Be sure to backup the files you're hacking.

1. showthread.php edits (do this step TWICE since there are two instances in the code)

In showthread.php, find the following:

post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."

replace it with:

post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,items_user.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."

find:

LEFT JOIN userfield ON userfield.userid=user.userid

add this BELOW:

LEFT JOIN items_user ON items_user.userid=user.userid

2. admin/functions.php edits

find the original hack of functions.php for the item shop, as instructed by the installer. It should be something like this (link's fix is similar-looking):

global $DB_site;
$nr=1;
while ($nr <= 50) {
$catstuff=$DB_site->query_first("SELECT * FROM items_cats WHERE id=$nr");
$its=$DB_site->query("SELECT * FROM items WHERE cat=$nr ORDER BY name $asds");
if(sizeof($catstuff)==16) {
if($catstuff[type]==1) {
$uid=$DB_site->query_first("SELECT item0,points0,description0,icon0,itid0 FROM items_user WHERE userid=$post[userid]");
if($uid[0]!='No Item') {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"https://vborg.vbsupport.ru/greentek/itemshop/prs.gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<img src=\"https://vborg.vbsupport.ru/greentek/itemshop/No Item.gif\" border=\"0\"> ";
}
} else {
$uid=$DB_site->query_first("SELECT item$nr,points$nr,description$nr,icon$nr,itid$nr FROM items_user WHERE userid=$post[userid]");
if($uid[0]!='No Item') {
if(empty($uid[3])) {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"https://vborg.vbsupport.ru/greentek/itemshop/$uid[0].gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"https://vborg.vbsupport.ru/greentek/itemshop/$uid[3].gif\" border=\"0\"></a> ";
}
} else {
$post[items] .= "<img src=\"https://vborg.vbsupport.ru/greentek/itemshop/No Item.gif\" border=\"0\"> ";
}
}
} else {
break;
}

$nr++;
}

replace it with:

if($post[item0]!='No Item') {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[itid0]\"><img src=\"https://vborg.vbsupport.ru/greentek/itemshop/prs.gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<img src=\"https://vborg.vbsupport.ru/greentek/itemshop/No Item.gif\" border=\"0\"> ";
}


$nr=1;
while ($nr <= 3) {
$xc="item$nr";
if($post[$xc]!='No Item') {
$xvv = "item$nr";
$xv = "itid$nr";
$xvvv = "icon$nr";
if(empty($post[$xvvv])) {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"https://vborg.vbsupport.ru/greentek/itemshop/$post[$xvv].gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"https://vborg.vbsupport.ru/greentek/itemshop/$post[$xvvv].gif\" border=\"0\"></a> ";
}
} else {
$post[items] .= "<img src=\"https://vborg.vbsupport.ru/greentek/itemshop/No Item.gif\" border=\"0\"> ";
}
$nr++;
}

(NOTE: be sure to change https://vborg.vbsupport.ru/greentek to imagesfolder, i.e. the word "imagesfolder" enclosed in curly braces, when you cut and paste this!)

You should now have a less bloated bunch of code to process the images and items for each poster in a thread. As an added bonus, since the items_user is now LEFT JOIN'd to the $post array, you can individually call items by fieldname in the array. I do this because I don't like to see icons, but names. It varies depending on your categories and such, but if you use

$post[item1]

When editing your postbit, you should get the text name for the item in that category in your postbit, if you want a different one, try [item2], [item3], etc.

I hope this works and that it helps some of you out.

[Jacko]

is it possible to show the users items in a seperate page with no other PHP at all???

will use a button then to pop up a window displaying the items...

any help would be appreciated...

and wont this lower the amount of query loads on the showthread????

and if this can go into a new page what can i delete of the old hacked php code to gt rid or reduce the query load??

all thanks

[mewgood]

can anyone make an add on to this hack
like when a memner is opening a store, he can upload mini images his self which will put beside the item he wants it to be.

[mewgood]

anyone?

[Jacko]

i think this thread is dead mate... try posting a new topic??

[Jacko]

can i not mod this hack so that all the users items can be viewable in a pop up page??

if anyone can please tell me,

Thanx

[LOD-squa]

question how can I reset the money on the bank?

[Ninth Dimension]

Originally posted by Jacko
can i not mod this hack so that all the users items can be viewable in a pop up page??

if anyone can please tell me,

Thanx

Do you mean insted of the postbit??? I'm sure that this can be done, but would require some coding of your own, unless you can somehow grab the function that generates the items and use it in a diffrent file for the pop-up.

so basicly, in theory, yes, but it would need some work on your behalf.