[Release] SQl Removes vendor restrictions

bulle7proof

New Member
Joined
Feb 10, 2009
Messages
344
Reaction score
68
Code:
--Allow Item on Every Map
UPDATE item_template SET Map=0 WHERE Map <> 0;
--Allow All Races
UPDATE item_template SET AllowableRace=-1 WHERE AllowableRace <> -1;
--Allow All Classes
UPDATE item_template SET AllowableClass=-1 WHERE AllowableClass <> -1;
--Remove Spell
UPDATE item_template SET requiredspell=0 WHERE requiredspell > 0;
--Remove Skill
UPDATE item_template SET RequiredSkill=0 WHERE RequiredSkill > 0;
--Remove Skill Rank
UPDATE item_template SET RequiredSkillRank=0 WHERE RequiredSkillRank > 0;
--Remove Reputation Rank
UPDATE item_template SET RequiredReputationFaction=0, RequiredReputationRank=0 WHERE RequiredReputationFaction > 0 AND RequiredReputationRank > 0;
--Allow > 1 Unique Weapons, Gems and Armor
UPDATE item_template SET maxcount=0 WHERE maxcount > 0 AND class BETWEEN 2 AND 4;
--Remove "Unique"-ness
UPDATE item_template SET Flags=0 WHERE Flags=Flags|524288;
--Remove NPC Vendor time constraints
UPDATE npc_vendor SET incrtime=0 WHERE incrtime > 0;
--Remove NPC Vendor limits
UPDATE npc_vendor SET maxcount=0 WHERE maxcount > 0;
--Remove Duration
UPDATE item_template SET Duration=0;
--Remove Delay
UPDATE item_template SET delay=0 WHERE delay > 0;


have fun ;)!