Make Custom Items Work

[litttleman10]

First off, i searched the forums and did not find a guide for this the way im doing it so...if there is one and i missed it meaning this is a repost then im sorry

And the way i'm doing it is a custom patch

Also, I am doing this with arcemu, so if you have another emu then you can just modify the sql query to fit your emu.

Needed Programs
A database editor - I use hedisql
CSVed
DBCUtil
Ladik's MPQ Editor
Notepad++
First, enter this sql query into your world database

select entry, class, subclass, field4, quality, displayid, inventorytype, sheathid
from items

Next, right click the stuff that comes up and click export as CSV and save it to your desktop(I'm using hedisql, not sure how to do it with another db editor)



After that, open the csv in notepad++ and delete the top line which is "entry";"class";"subclass";"field4";"quality";"displayid";"inventorytype";"sheat hid"

Then click ctr+f and replace " with nothing...hit replace all



NOTE: this will take some time depending on the speed of your pc, just let it go

Then click ctr+f again and replace ; with , ...hit replace all



save it.
take item.dbc from yourrepacksfolder/arcemu/dbc and put it in your DBCUtil folder
- Make sure the only thing in that folder is DBCutil.exe, MSVCR71.dll, and your item.dbc.
Run DBCUtil.exe then open item.dbc.csv with CSVed

click open text editor



After that the text editor will show up, click Open Current CSV file

copy the first line, (long,long,long,long,long,long,long,long,) then click ctr+a then backspace (to delete everything) then paste what we copied back on (long,long,long,long,long,long,long,long,)

after that go back to our first csv (the one we edited in notepad++) and copy everything and paste it under the long,long,long,long,long,long,long,long, in item.dbc.csv after that click Save CSV File (or ctr+s), and close form.

now you will be back at the original screan (were you were before you opened the text editor)
do this in order...click refresh then save.



now go back to your DBCUtil folder and delete item.dbc, leaving item.dbc.csv there.
Drag item.dbc.csv over DBCUtil.exe and a new item.dbc should appear

Lastly open Ladik's MPQ Editor and create a new MPQ in world of warcraft/data/en** named patch-en**-9.mpq (make the en** match your world of warcraft/data/en**

Then inside that create a folder named DBFilesClient and inside that folder drag your new item.dbc which is located in your DBCUtil folder and your settings must match this for it to work



Then...nothing! Your done, give it out to your players

oh yea...tell your players that they need to rename it also to match their en** for it to work.

And btw, this is my first tut so plz don't flame me until i cry =D

[dragonowner]

THIS GUIDE IS COMPLETELY F'ING HORRIBLE. I HOPE YOU DO CRY FROM THIS MESSAGE WHEN YOU READ IT, because I can actually follow it. It's detailed, I might actually try it. This fixes the whole "must have a mele weapon" right? There are other guides for this, but this one is pretty small and straight forward. Thanks

[alynatrill]

Wow.. **** you Blizzard all this work for 1 item

[dragonowner]

Wow.. **** you Blizzard all this work for 1 item

Actually doing it from the cache/dbc makes the items load a whole lot faster. Loading from the db would take too long. Since the cache is a cache its already stored info that the client can easily call, without it the client has to manually make a whole new temp file to know how the items work.

[litttleman10]

Yes this does fix the "requires melee weapon" bug thing...and its not to much work, takes less than 5 minutes once you know what to do. And another thing, you dont have to enter the stuff into the dbc manually with this, basicly you are just copying all the required stuff out of the db with no effort at all.

[sjustin1996]

Still works - Bump.

I use this often, and I believe a lot of smaller servers would have a much easier time using this than searching through lists of unused items (which often bug out).

[Erux]

I came, I saw, peanuts .