http://www.invoid.net/forum/itemshop.php

Everything is default from the install file. I'd say, 50 items total?

Also, does anyone know how to solve Post #378? Can anyone send me the install file they used so I can compare? Or an older version to admin@invoid.net?

Sorry, I wasn't very clear with my question. What I meant was, which items has your RPG character bought from the itemshop?

Lightning Staff
Diamond Gloves
Ore

My mistake. I accidentally had you comment out the line
Just add
above my code, as seen in my edited post above. That should fix it.

One more problem, now it doesnt show "Ore" or anything from the 3rd category.

That is caused by a typo from the original installation of the Itemshop. The field name in the table `items_user` says "Item3" when it should say "item3" with a lower case "i". An easy way to fix this is to go into phpmyadmin and manually change the field name to make it lowercase. If you don't have phpmyadmin, and you don't know how to change it with a database query, then let me know.

I have phpMyAdmin, but I dont know the query string.

In phpmyadmin v2.2.2, here is the manual way of changing the field name:

• Click on your vBulletin Database so that the list of tables drops down.
• Click on the table called `items_user`
• In the far left column, look for a field called "Item3". Click on the "Change" link across from this field. It should bring you to a screen that lets you change the name of the field.
• Change the name of the field from "Item3" to "item3".
• Click "Save". The field name should now be correct.

If you are running a different version, or can't figure it out, then here is another way to change it:

In your vBulletin database, run the following query:

One of those two methods should work.

Works perfectly. Thanks a lot! Since you seem to be familiar with this stuff, do you know why I get this when donating?

Invalid SQL: SELECT field5 FROM userfield WHERE userid=Array
mysql error: Unknown column 'Array' in 'where clause'

mysql error number: 1054

Its the only bug I have on the board >_<

Sorry, but I can't help ya on that one. I have never had that error before, nor have any of my members. I looked over the files, and there wasn't anything that looked out of place. :ermm:

Sorry. :(