diff options
| -rw-r--r-- | sql/updates/world/2012_02_08_07_world_pool.sql | 11 |
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'); |