- when i try to edit an item from the itemshop admin like the price or something... i get this error.


Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE items_user SET item4='', points4='0', description4='', icon4='' WHERE itid4=71
mysql error: Unknown column 'itid4' in 'where clause'

mysql error number: 1054

Date: Saturday 22nd of March 2003 02:14:58 PM
Script: http://xlash.org/forums/forums/admin/itemadmin.php
Referer: http://xlash.org/forums/admin/itemadmin.php?action=edit


- for a personal item shop... there is no option to add your own icons..

- when you add categories to the itemshop. it don't show on the main itemshop page.

When this hack is bug free I have made about 50 battle scenes.
They are top of the range and I can pics if requested.
I have also tweaked the templates an aweful lot.
If anyone is interested just post, and if you like what u see bitsys then I will glady give you everything so you can add it to the hack.
I am not good at all the tech stuff but I can at least help with what I have made.

Hey man, that's great. I was just thinking that it could use more battle scenes. I'll be looking forward to the official release of this hack.

Ya post your custom stuff.

You just buy magic spells. You can't "learn" them, per se.

What is the exact error?

What does the screen look like after you buy an item?

What is the structure of your items_user table?

User's cannot upload their own pictures.

Did you go to Edit Item Types and assign the items a particular class type?

If a category doesn't have any items in it, then it won't show up.

I will post about 5 of the battle scenes I made to see what people think.
I also have about 150 different item icons.
-Post back soon

so u kind of just add them as items up to the itemshop?


mysql> show columns from items_user;
+--------------+------------------+------+-----+--------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+--------------------------+-------+
| userid | int(10) unsigned | | PRI | 0 | |
| bankval | int(10) unsigned | | | 0 | |
| btime | int(11) | | | 0 | |
| item0 | char(250) | | | No Item | |
| points0 | int(5) | | | 0 | |
| description0 | char(250) | | | No Description Available | |
| icon0 | char(250) | | | | |
| itid0 | int(11) | | | 0 | |
| item1 | char(250) | | | No Item | |
| points1 | int(5) | | | 0 | |
| description1 | char(250) | | | No Description Available | |
| icon1 | char(250) | | | | |
| itid1 | int(11) | | | 0 | |
| item2 | char(250) | | | No Item | |
| points2 | int(5) | | | 0 | |
| description2 | char(250) | | | No Description Available | |
| icon2 | char(250) | | | | |
| itid2 | int(11) | | | 0 | |
| item3 | char(250) | | | No Item | |
| points3 | int(5) | | | 0 | |
| description3 | char(250) | | | No Description Available | |
| icon3 | char(250) | | | | |
| itid3 | int(11) | | | 0 | |
| item9 | char(250) | | | No Item | |
| points9 | int(5) | | | 0 | |
| description9 | char(250) | | | No Description Available | |
| icon9 | char(250) | | | | |
| itid9 | int(5) | | | 0 | |
+--------------+------------------+------+-----+--------------------------+-------+
28 rows in set (0.00 sec)



ah thx... it worked... now in your current status right at the top of the screen... it do not show the item u just bought from the new category

and again... thanks for replying all the questions =)

Yes.



Which userid is that information from? Is it the same userid that you took the pic with?

yes

slashboy, What are the values of all the IDs from the items_cats table? Also, do you have any presonal itemshops?

I have been able to reproduce the error artificially, so I think I know how to fix it after the error occurs. However, I still have not located the bug that causes the error.