Tradeskills needing items not working? Check your database, especially if running 3.0

[xhiris]

SHORT VERSION:

- Make sure your database structure matches the emulator you're using. If there are database patches included, apply them all.

- When using the WOTLK client, update TotemCategory for 'tool' items.

After three days of struggle, I finally got tradeskills that require 'tools' to work on my copy of ArcEmu. I was getting "Skinning Knife" required when I definitely had one. Other tradeskills had similar problems.

It came down to two things:

1) The items table structure didn't match the emulator.
2) TotemCategories have changed in WOTLK.

The last one was a PITA to figure out. If you're running a WOTLK client, check the TotemCategory field in your items table.

This must match one of the following values, EXCEPT the three marked (OLD) below. For example, if your item has ItemCategory 1, change it to 166.

1 Skinning Knife (OLD)
2 Earth Totem
3 Air Totem
4 Fire Totem
5 Water Totem
6 Runed Copper Rod
7 Runed Silver Rod
8 Runed Golden Rod
9 Runed Truesilver Rod
10 Runed Arcanite Rod
11 Mining Pick (OLD)
12 Philosopher's Stone
13 Blacksmith Hammer (OLD)
14 Arclight Spanner
15 Gyromatic Micro-Adjustor
21 Master Totem
41 Runed Fel Iron Rod
62 Runed Adamantite Rod
63 Runed Eternium Rod
81 Hollow Quill
101 Runed Azurite Rod
121 Virtuoso Inking Set
141 Drums
161 Gnomish Army Knife
162 Blacksmith Hammer
165 Mining Pick
166 Skinning Knife
167 Hammer Pick
168 Bladed Pickaxe
169 Flint and Tinder
189 Runed Cobalt Rod
190 Runed Titanium Rod

Here are queries for an ArcEmu database that will fix Skinning Knife, Mining Pick and Blacksmith Hammer. It's probably similar for Mangos and others (may be called tool category instead)

UPDATE items SET TotemCategory=166 WHERE TotemCategory=1
UPDATE items SET TotemCategory=166 WHERE TotemCategory=11
UPDATE items SET TotemCategory=166 WHERE TotemCategory=13

Gnomish Army Knife is a special case - this acts as a Skinning Knife, Blacksmith Hammer and various other things. Make sure its TotemCategory is 161.

For similar items, make sure it matches one of the above values.

Posting this in hopes it saves someone else the trouble.

-- Xhiris

[[IceCreaM]]

Thanks =)