From cef65cbdab5e216cfa593cd3fbe9865fc7f108c3 Mon Sep 17 00:00:00 2001
From: souler <souler@trinity.contrib>
Date: Thu, 19 Jan 2012 08:45:58 +0100
Subject: DB/Quest: set RequiredClasses for A Victory for The... quests

closes #4815
---
 .../world/2012_01_19_00_world_quest_template.sql        | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 sql/updates/world/2012_01_19_00_world_quest_template.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2012_01_19_00_world_quest_template.sql b/sql/updates/world/2012_01_19_00_world_quest_template.sql
new file mode 100644
index 00000000000..f1af6e7eedd
--- /dev/null
+++ b/sql/updates/world/2012_01_19_00_world_quest_template.sql
@@ -0,0 +1,17 @@
+-- Non sword wielders quests
+UPDATE `quest_template` SET `RequiredClasses`=`RequiredClasses`
+|16 -- Priest
+|64 -- Shaman
+|1024 -- Druid
+WHERE `Id` IN (24795,24798,24798);
+
+-- Sword wielders quests
+UPDATE `quest_template` SET `RequiredClasses`=`RequiredClasses`
+|1 -- Warrior
+|2 -- Paladin
+|4 -- Hunter
+|8 -- Rouge
+|32 -- Death Kinght
+|128 -- Mage
+|256 -- Warlock
+WHERE `Id` IN (24796,24800,24801);
-- 
cgit v1.2.3