[??] Display ID change not working & "Must have melee wep" for Custom Weapons

[saga2305]

yeah I've been adding a lot to the dbc, all working just fine (can be equipped, no "?" signs, correct item table) except weapons not displaying when they're on sheath, still trying to figure this one out, haven't got any answers so far

[Kiev]

Im going to presume there is a column in the DBC that handles the sheath, if not, its something in your database to configure it to sheath, some weapons like this use to happen in 3.2 i think, where it wouldn't show in the sheathed, but it would all the other times, i cant rememeber what people did to fix this though.

[saga2305]

well guess I'm gonna have to try to work on this one out again then.. thanks for the insight

[CoDHeRo]

how did u figure it out?? PLZZZ

[Kiev]

Read all the posts in this thread, they all provide information on what you need to do, do some research, learn a few techniques.

[Quinouin]

the numbers mean this in their row order:
ENTRYID,CLASS,SUBCLASS,(leave this at -1),QUALITY,DISPLAYID,SLOT,FLAGS,
Now here is an example to help you out:
70000,2,8,-1,5,46609,17,0,(Important: Remember the "," after the FLAGS number.)

This makes my custom item with the entryid "70000" work like a blizz item, as long as all the columns match!
Class: 2=Weapon,
Subclass: 8=2hSword,
-1,
Quality: 5=Legendary,
DisplayID: 46609=Frostmourne's DisplayID! It will look like Frostmourne!
Slot: 17= Two Hands,
Flags: 0,

I found this whole thread very helpful in figuring out the custon items issue, especially covet_cat's post. But, when I edited my item.dbc file using the above fields, I got several errors when I ran mangosd.exe (which unfortunately are not in the error log file anymore since I've fixed them, but they looked something like this BUT related to material and sheath location being wrong):

ERROR:Item (Entry: 18584) not correct 17 inventory type, must be 13 (still using DB value)

So, as I started looking through the other entries in the item.dbc file, I realized that two of the fields outlined above are not correct. As far as I can tell (and I think it's right since it fixed all my issues), Quality should actually be Material (which appears to be "1" or "2" for weapons) and Flags is actually Sheath Location (i.e. "1" for a 2H weapon that you would sheath on your back). So, as far as I can tell, the columns in the item.dbc file go like this:

Item ID,
Class: 2=Weapon,
Subclass: 8=2hSword,
Unk0: -1,
Material:* 1=some weapons and other things (sometimes a weapon may be a 2, though)
Display ID,
Slot: 17= Two Hands,
Sheath Location: 1=Back,

*values for material field range from -1 to 8 -- I do not know what "materials" may be referring to but weapons all seem to have a value of 1 or 2. In any case, if you created an sql file from wow-v and executed it into yogsql or whatever you use the value will appear there since there is a column for materials and you just have to make it match.

Anyway, hopefully this will be useful to someone who may be having issues with custom weapons.

[Jotey]

So true, good you take this up

[secretdragon008]

Omg!....stupid blizz no wonder i got "?" on my custom items all the time.
Thank god for this guide then, very helpful, thank you a lot.

[rudydimacali]

I have this problem except... no one else on the server does I can't use custom weapons because it will say I don't have a melee weapon equipped, because it is custom. I have deleted my cache, but to no avail.

[Baltazarz]

Actually, there's an easier solution for this. It is posted in the guides section, but those who are too lazy to look inside there, just use one of these given, unused ENTRY IDs given here