TrinityCore/TrinityCore — Issue #5175: Public Relations Agent - Quest Pooling
Author: mweinelt
Created: 2012-02-10 18:28:16+00:00
State: open

Love is in the Air Daily Questgiver
```sql
-- Public Relations Agent - Quest-Pooling
-- Source: http://www.wowhead.com/quest=24636#comments:id=968417
SET @pool_id := 350;

-- create new pool, allowing only 1 out of 3 dailys per day
DELETE FROM `pool_template` WHERE `entry` = @pool_id;
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(@pool_id, 1, 'Public Relations Agent - Daily Quests');

-- fill pools with the daily quests
DELETE FROM `pool_quest` WHERE `entry` IN (24629, 24635, 24636) 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');
```
Source: http://www.wowhead.com/quest=24636#comments:id=968417