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

These ads disappear when you log in.

Results 1 to 2 of 2
  1. #1
    xhiris's Avatar Private
    Reputation
    2
    Join Date
    Dec 2008
    Posts
    2
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

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

    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

    These ads disappear when you log in.

  2. #2
    [IceCreaM]'s Avatar Master Sergeant
    Reputation
    4
    Join Date
    Nov 2008
    Posts
    77
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Thanks =)

Similar Threads

  1. WoW-V Items not working!
    By Donandi in forum WoW EMU Questions & Requests
    Replies: 8
    Last Post: 04-07-2009, 03:11 AM
  2. Stats from items not working
    By Shalitas in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 04-03-2009, 04:08 PM
  3. Custom Items not working!
    By cello1993 in forum WoW EMU Questions & Requests
    Replies: 4
    Last Post: 02-17-2009, 11:51 AM
  4. Items not working
    By Hewit in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 12-28-2008, 10:33 PM
  5. Need help, not working in game
    By C-Death in forum WoW ME Questions and Requests
    Replies: 4
    Last Post: 12-31-2007, 06:28 PM
All times are GMT -5. The time now is 02:23 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search