Last items

[Blackstorm]

Hi,

Another update for items. This is the first pass. I still have an issue with some database inserts (usally items with bad string typo in the effets' columns) so i probably miss hundred of items...
But you should find some new.

ref: Added to my parser all opcodes using the items_struct array like (OP_ServerTradeAddOtherItem (509), OP_ServerMailItem (1302), OP_ServerLootRoll (1707) or OP_ServerHouseItems (414))

I still do not have crossed the other opcodes to eventually find other references but i should update this post after that. (some weeks)

This SQL file have 37571 items.
NB: i'm not sure for the item_id 4294967295 if it's an error or a real item... and take care, i needed to change some colums type (usually from varchar to text) to be more flexible on the capture.

raw_item.zip

[Xinux]

There were 1357 items i was able to add to the DB that had 0 modifiers the other 773 items which had modifers i cannot add to the DB since the items would be messed up without the additional modifier and attachment table data.

[Blackstorm]

ok Xinux,
Happy to help ^^

i'm cleaning my duplicated entries on the attachments and modifiers tables, and i will publish an additionnal file for the missing content.

[Blackstorm]

Attachments & Modifiers tables.
I've extracted manualy each table after a DISTINCT.

If you need a full version without FK check, just ask me ^^

[Blackstorm]

New file with 37574 items, 5522 attachments and 92856 modifiers.

The file contain only insert requests and bypass foreign keys check.

items.zip

[Xinux]

So combining your's and the parse i just got done doing while removing the bad values this is the final count for items.

Items: 37602
attachments: 5498
Modifiers: 84480