How to remove Class gear requirements

[thehsvdude]

I need help Removing class gear reqirements For my mop 5.1 server Anyone know what to do

[ThaiCargo]

Depends on what emulator you are using, but you should be able to do this in the database unless the itemset has a req class, then you will have to do it in c++.

If you look in TrinityCores item_template there is a column called 'AllowableClass'


Try erasing the value in that column, restart the server, delete your cache or WDB folder, start wow and see if it works.

[Ascathos]

Erase the value in that column, restart the server, delete your cache or WDB folder, start wow and it works.

Fixed that for you.

[Milly]

I'm on TrinityCore 4.3.4 and this is the query you'll need for your MySQL database:

UPDATE item_template SET AllowableClass='-1'

Unfortunately, this won't change much, because after WotLK most items are handled in item-sparse.db2. Item_template is useless now. I'm pretty sure you can do basically the same thing but I think there's only one db2 editor and it's in French.

I believe this is what you'll need: https://code.google.com/p/cntc2/downloa ... r&can=2&q=

If only somebody would make a csv to db2 converter...

Edit: Strange, that db2 editor no longer works for me  "This program has been disabled, it can no longer be used."

Edit: I found an alternative posted by osler a while back. A pain in the ass to set up but once you have it, it works.

DB2 to SQL: http://code.google.com/p/cntc2/download ... r&can=2&q=
SQL to DB2: http://code.google.com/p/cntc2/download ... r&can=2&q=

Tricky thing with this method is that it exports SQL -> DB2 to the D drive. I didn't have a D drive on my computer, so I had to change the letter of my flashdrive using this from Microsoft: http://windows.microsoft.com/en-us/wind ... =windows-7