Determining what skill is used for an item

[junk]

I can't seem to figure out how I can determine which skill a particular item uses from data in the itemdump. I originally thought it had something to do with the itemtype field, and if it does, what is it indexed against? I would have thought it would be indexed against the skills list (where 0=1H Blunt, 1=1H Slashing, 36=Piercing, etc), but Frostwrath (http://www.everquestserver.com/item.php?id=MzUyNy41OTkzNDc0MQ==) would be 1H Blunt under that logic (for example). What am I missing?

[mangoo]

I believe the ItemType field runs off a different list, you can find this list in my item editor.

[tbigg]

Yes, and just to add a bit more clarification:

In the skillmodtype column, 0 = 1HB
In the itemtype column, 0 = 1HS

So you need 2 different lookup tables for those 2 columns.

[junk]

(Edit: in reply to mangoo, tbigg responded after I had started my reply)
Love to, but every time I attempt to connect to my DB (running MySQL 4.0.13 in Gentoo Linux on a separate host), the program crashes. If I have incorrect information for the DB login, the program won't crash. Of course, I also can't play around with any of the fields unless I'm connected to a DB. As soon as I enter the correct information and try to connect, it crashes. I figured it might be a rogue libmySQL.dll somewhere on my machine, didn't find one. Made a new MySQL user, set the appropriate permissions, reloaded MySQL, used new user, still crashed. So basically, I can't use your program to find the data I want. :( Anyone else have somewhere I can find the list?

[mangoo]

I don't run linux anymore so I am unable to replicate your error, sorry. Maybe someone else that runs linux can shine some light on the issue, but anyways, here's the list:

0: 1HS
1: 2HS
2: Piercing
3: 1HB
4: 2HB
5: Archery
7: Throwing
8: Bash
10: Clothing
11: Generic Item
12: Lockpick
14: Food
15: Drink
16: Lightsource
17: Generic Item2
18: Bandage
19: Throwing2
20: Spell/Song Scroll
21: Potion
23: Wind Instruments
24: Stringed Instruments
25: Brass Instruments
27: Arrow
29: Jewellery
30: Jeweled Skull
31: Book
32: Note
33: Key
34: Coin/Card
35: 2H Piercing
36: Fishing Rod
37: Bait
38: Fish
39: Key2
40: Compass
42: Poison Component
45: Hand to Hand
122: Percussion Instruments

[junk]

Thank you very much, mangoo!

If you'd like me to send you crash dumps or anything I'd be more than happy to.

[ric0h]

add to that list

50: Singing

[tbigg]

Add to the list:

26 - Percussion Instrument
52 - Charm
54 - Augmentation
55 - Augmentation Solvent

Also, my list shows 17 = Combinable (though no items have this value)
38 should be Alcohol, not Fish