From 01b7827729607caf71652b44f169b5efbbdaa0f4 Mon Sep 17 00:00:00 2001 From: mweinelt Date: Wed, 8 Feb 2012 17:12:22 +0000 Subject: DB/Quests: High Crusader Adelard - Quest Pooling Closes #5124 --- sql/updates/world/2012_02_08_08_world_pool.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2012_02_08_08_world_pool.sql (limited to 'sql') diff --git a/sql/updates/world/2012_02_08_08_world_pool.sql b/sql/updates/world/2012_02_08_08_world_pool.sql new file mode 100644 index 00000000000..96124ec2540 --- /dev/null +++ b/sql/updates/world/2012_02_08_08_world_pool.sql @@ -0,0 +1,16 @@ +-- Pool quests from High Crusader Adelard +-- Source: http://www.wowwiki.com/High_Crusader_Adelard +SET @pool_id := 349; + +-- create new pool, allowing only 1 out of 4 dailys per day +DELETE FROM `pool_template` WHERE `entry` = @pool_id; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@pool_id, 1, 'High Crusader Adelard - Daily Quests'); + +-- fill pools with the daily quests +DELETE FROM `pool_quest` WHERE `entry` IN (14101, 14102, 14104, 14105) AND `pool_entry` = @pool_id; +INSERT INTO `pool_quest` (`entry`, `pool_entry`, `description`) VALUES +(14101, @pool_id, 'Drottinn Hrothgar'), +(14102, @pool_id, 'Mistcaller Yngvar'), +(14104, @pool_id, 'Ornolf The Scarred'), +(14105, @pool_id, 'Deathspeaker Kharos'); -- cgit v1.2.3