TrinityCore/TrinityCore — Issue #5434: Argent Tournament: Silver Covenant / Sunreavers Quest-Pooling and RequiredClasses for DK-Quests
Author: mweinelt
Created: 2012-02-26 02:36:44+00:00
State: open

```mysql
-- Sunreaver / Silver Covenant Quest Pooling
SET @pool_narasi := XY;
SET @pool_savinia := XY;
SET @pool_girana := XY;
SET @pool_tylos := XY;

DELETE FROM `pool_template` WHERE `entry` IN (@pool_narasi, @pool_savinia, @pool_girana, @pool_tylos);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(@pool_narasi, 1, 'Narasi Snowdawn - Daily Quests'),
(@pool_savinia, 1, 'Savinia Loresong - Daily Quests'),
(@pool_girana, 1, 'Girana the Blooded - Daily Quests'),
(@pool_tylos, 1, 'Tylos Dawnrunner - Daily Quests');

DELETE FROM `pool_quest` WHERE `entry` IN (SELECT quest FROM creature_questrelation WHERE id IN (34771, 34912, 34771, 34914));
INSERT INTO `pool_quest` (`entry`, `pool_entry`, `description`) VALUES
-- Narasi Snowdawn
(14074, @pool_narasi, 'A Leg Up'),
(14152, @pool_narasi, 'Rescue at Sea'),
(14080, @pool_narasi, 'Stop The Aggressors'),
(14077, @pool_narasi, 'The Light''s Mercy'),
(14096, @pool_narasi, 'You''ve Really Done It This Time, Kul'),
-- Savinia
(14076, @pool_savinia, 'Breakfast of Champions'),
(14090, @pool_savinia, 'Gormok Wants His Snobolds'),
(14112, @pool_savinia, 'What Do You Feed a Yeti, Anyway?'),
-- Girana
(14143, @pool_girana, 'A Leg Up'),
(14136, @pool_girana, 'Rescue at Sea'),
(14140, @pool_girana, 'Stop The Aggressors'),
(14144, @pool_girana, 'The Light''s Mercy'),
(14142, @pool_girana, 'You''ve Really Done It This Time, Kul'),
-- Tylos
(14092, @pool_savinia, 'Breakfast of Champions'),
(14141, @pool_savinia, 'Gormok Wants His Snobolds'),
(14145, @pool_savinia, 'What Do You Feed a Yeti, Anyway?');

-- Argent Tournament: Separate Death-Knight quests from those of other classes

-- Set Quests to DK only
UPDATE `quest_template` SET `RequiredClasses` = 32 WHERE `id` IN
(13863, 13864, -- Battle Before The Citadel
13788, 13812, -- Threat From Above
13793, 13814, -- Among The Champions
13791, 13813); -- Taking Battle To The Enemy

-- Set quests to NON-DK only
UPDATE `quest_template` SET `RequiredClasses` = 1+2+4+8+16+64+128+256+512 WHERE `id` IN
(13790, 13811, -- Among the Champions
13861, 13862, -- Battle Before The Citadel
13682, 13809, -- Threat From Above
13789, 13810); -- Taking Battle To The Enemy
```