DB/Quests: Public Relations Agent - Quest Pooling

Closes #5124

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/world/2012_02_08_07_world_pool.sql b/sql/updates/world/2012_02_08_07_world_pool.sql
new file mode 100644
index 00000000000..8f43e1b3b03
--- /dev/null
+++ b/sql/updates/world/2012_02_08_07_world_pool.sql
@@ -0,0 +1,11 @@
+SET @pool_id := 348;
+
+DELETE FROM `pool_template` WHERE `entry` = @pool_id;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(@pool_id, 1, 'Public Relations Agent <Crown Chemical Co.> - Daily Quests');
+
+DELETE FROM `pool_quest` WHERE `entry` IN (24635, 24636, 24629) AND `pool_entry` = @pool_id;
+INSERT INTO `pool_quest` (`entry`, `pool_entry`, `description`) VALUES
+(24629, @pool_id, 'A Perfect Puff of Perfume'),
+(24635, @pool_id, 'A Cloudlet of Classy Cologne'),
+(24636, @pool_id, 'Bonbon Blitz');