Spawns

[Bafoon]

wow thats awesome....it just makes me wanna play even more

[Zcoretri]

There are currently over 12,000 items in the current database that is sent to all worlds when they are created. Unless you messed around with your settings or deleted them, you have all of them. In addition, items do work and do show up on your character if you update the item's appearance id.

I don't see a column in the items table for an appearance id.
Been trying to get equipped items to show on my character to no avail

[LethalEncounter]

try the item_appearances table

[Zcoretri]

try the item_appearances table

I have tried the item_appearances table...still no go
On another note...is there a reason why there are duplicate and triplicate of some items?

[LethalEncounter]

Something might be wrong with your client or server then. Summon item 14368 and equip it. Your client should see the equipped item. If it doesn't then something is wrong. If it does, then use that as an example and do the same thing for the item that you wish to view. Make sure that the item id and equip type is correct in the item_appearances table or it wont work.

[Zcoretri]

OK...must be something wrong on my end. I did use that item id as an example, actually tried equipping those items in the item_appearances table and they did not show.
Thanks LE

[LethalEncounter]

We have a db team creating a database right now. When they are done you should have a large variety of items that look correct when equipped. In the mean time if you still want to mess around with it, make sure that the equip type is equal to the appearance_id in the appearances table for the item you wish to modify.

[alfa]

Example of DB Team works ^^