Remove Requirements

[moltn]

Is there any way to remove all requirements for item levels? IE: Levels, Armor Profession, Professions, and class Required items. (I'll posted a link of each item)

LEVELS

Level Requirement "13": Blackened Defias Gloves - Item - World of Warcraft

ARMOR PROFESSION

Armor Profession "Leather": Aged Core Leather Gloves - Item - World of Warcraft

PROFESSION

Profession "Engineering": Annihilator Holo-Gogs - Item - World of Warcraft

CLASS REQUIRED ITEM

Class Required item "Warr/Rog": Warglaive of Azzinoth - Item - World of Warcraft


Thanks for taking notice of this post. =)

[doublehex]

in your database there are columns that contain that information

[Power of Illuminati]

Code fixed for JUST the items you wanted. (That Clain did is for all items if you want that.)

update items set requiredlevel = '0' where entry = '10401';
update items set RequiredSkill = '0' and RequiredSkillRank = '0' where entry = '18823';
update items set RequiredSkill = '0' and RequiredSkillRank = '0' where entry = '34847';
update items set allowableclass = '9' where entry = '32838';

[Clain]

All Level :
update items set requiredlevel=0;

All Profession :
update items set requiredskill=0 and requiredskillrank=0;

All Classes :
update items set allowableclass=-1;

All Races :
update items set allowablerace=-1;

Bai me :O

[~ViVo~]

Oooh, Dis helped meh

[moltn]

Lol, yeah - I meant for all of the items in the whole database. =P Not just hose items. Lol Sorry for listing the items, but they were just "EXAMPLES" Hehe. +Rep, thanks!

[latruwski]

update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0;

for all items....
if you wnt more values to be disabled just add one in the query for example:
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0, ArenaRankRequirement = 0;

easy as shit...

[moltn]

What about making the pvp gear only PvP Ranks and not marks and honor / money?

[j9sjam3]

Your best bet it to mess around in your database...
Its how I found out how to do lots of things

[moltn]

But I don't really want to risk anything important nor delete anything.

I also have another question and I know that this doesn't have anything to do with removing anything, but can somebody make me a little SQL about have a couple a bosses in AV? I wanted to have some bosses in AV to make an AV event. Two Bosses for the Alliance and two Bosses for the Horde. Which ever faction kills both bosses first wins the event.
I think that wouls be a good event. =P
Can anybody do this for me?