Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Serverside Modding => Topic started by: thehsvdude on January 26, 2014, 04:35:03 am

Title: How to remove Class gear requirements
Post by: thehsvdude on January 26, 2014, 04:35:03 am

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

Title: Re: How to remove Class gear requirements
Post by: ThaiCargo on February 10, 2014, 09:33:02 pm

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.

Title: Re: How to remove Class gear requirements
Post by: Ascathos on February 11, 2014, 12:24:51 am

Quote from: "ThaiCargo"

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

Fixed that for you.

Title: Re: How to remove Class gear requirements
Post by: Milly on February 11, 2014, 04:04:29 am

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= (https://code.google.com/p/cntc2/downloads/detail?name=DB2Editor_v1.4.rar&can=2&q=" onclick="window.open(this.href);return false;)

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= (http://code.google.com/p/cntc2/downloads/detail?name=Dbc2ConverSQL.rar&can=2&q=" onclick="window.open(this.href);return false;)
SQL to DB2: http://code.google.com/p/cntc2/download ... r&can=2&q= (http://code.google.com/p/cntc2/downloads/detail?name=SQLtoDB2%20.rar&can=2&q=" onclick="window.open(this.href);return false;)

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 (http://windows.microsoft.com/en-us/windows/change-add-remove-drive-letter#1TC=windows-7" onclick="window.open(this.href);return false;)