Shattrath Dungeon Daily Quest Pooling

Quest Pooling for both normal and heroic daily dungeon quests in outland.

[CODE]-- Nether Stalker Mah’duun: non-heroic dungeon daily pool
SET @nh_daily_pool := 20200;

DELETE FROM pool_template WHERE entry = @nh_daily_pool;
INSERT INTO pool_template (entry, max_limit, description) VALUES
(@nh_daily_pool, ‘1’, ‘Quest Pool: Nether-Stalker Mah'duun’);

DELETE FROM pool_quest WHERE pool_entry = @nh_daily_pool AND entry IN (11389, 11371, 11376, 11383, 11364, 11500, 11385, 11387);
INSERT INTO pool_quest (entry, pool_entry, description) VALUES
(‘11389’, @nh_daily_pool, ‘Wanted: Arcatraz Sentinels’),
(‘11371’, @nh_daily_pool, ‘Wanted: Coilfang Myrmidons’),
(‘11376’, @nh_daily_pool, ‘Wanted: Malicious Instructors’),
(‘11383’, @nh_daily_pool, ‘Wanted: Rift Lords’),
(‘11364’, @nh_daily_pool, ‘Wanted: Shattered Hand Centurions’),
(‘11500’, @nh_daily_pool, ‘Wanted: Sisters of Torment’),
(‘11385’, @nh_daily_pool, ‘Wanted: Sunseeker Channelers’),
(‘11387’, @nh_daily_pool, ‘Wanted: Tempest-Forge Destroyers’);

– Wind Trader Zhareem: heroic dungeon daily pool
SET @hc_daily_pool := 20201;

DELETE FROM pool_template WHERE entry = @hc_daily_pool;
INSERT INTO pool_template (entry, max_limit, description) VALUES
(@hc_daily_pool, ‘1’, ‘Quest Pool: Wind Trader Zhareem’);

DELETE FROM pool_quest WHERE pool_entry = @hc_daily_pool AND entry IN (11369, 11384, 11382, 11363, 11362, 11375, 11354, 11386, 11373, 11378, 11374, 11372, 11368, 11388, 11499, 11370);
INSERT INTO pool_quest (entry, pool_entry, description) VALUES
(‘11369’, @hc_daily_pool, ‘Wanted: A Black Stalker Egg’),
(‘11384’, @hc_daily_pool, ‘Wanted: A Warp Splinter Clipping’),
(‘11382’, @hc_daily_pool, ‘Wanted: Aeonus's Hourglass’),
(‘11363’, @hc_daily_pool, ‘Wanted: Bladefist's Seal’),
(‘11362’, @hc_daily_pool, ‘Wanted: Keli'dan's Feathered Stave’),
(‘11375’, @hc_daily_pool, ‘Wanted: Murmur's Whisper’),
(‘11354’, @hc_daily_pool, ‘Wanted: Nazan's Riding Crop’),
(‘11386’, @hc_daily_pool, ‘Wanted: Pathaleon's Projector’),
(‘11373’, @hc_daily_pool, ‘Wanted: Shaffar's Wondrous Pendant’),
(‘11378’, @hc_daily_pool, ‘Wanted: The Epoch Hunter's Head’),
(‘11374’, @hc_daily_pool, ‘Wanted: The Exarch's Soul Gem’),
(‘11372’, @hc_daily_pool, ‘Wanted: The Headfeathers of Ikiss’),
(‘11368’, @hc_daily_pool, ‘Wanted: The Heart of Quagmirran’),
(‘11388’, @hc_daily_pool, ‘Wanted: The Scroll of Skyriss’),
(‘11499’, @hc_daily_pool, ‘Wanted: The Signet Ring of Prince Kael'thas’),
(‘11370’, @hc_daily_pool, ‘Wanted: The Warlord's Treatise’);[/sql][/CODE]

same for Cooking and Fishing

[sql]-- Shattrath Cooking Daily Pool
– 11380, 11377, 11379, 11381
SET @pool := 11377;

DELETE FROM pool_template WHERE entry = @pool;
INSERT INTO pool_template (entry, max_limit, description) VALUES
(@pool, 1, ‘Shattrath Cooking Daily (1 of 4)’);

DELETE FROM pool_quest WHERE entry IN (11380, 11377, 11379, 11381) AND pool_entry = @pool;
INSERT INTO pool_quest (entry, pool_entry, description) VALUES
(11380, @pool, ‘Manalicious’),
(11377, @pool, ‘Revenge is Tasty’),
(11381, @pool, ‘Soup for the Soul’),
(11379, @pool, ‘Super Hot Stew’);

– Shattrath Fishing Daily Pool
– 11667, 11668, 11666, 11665, 11669
SET @pool := 11665;

DELETE FROM pool_template WHERE entry = @pool;
INSERT INTO pool_template (entry, max_limit, description) VALUES
(@pool, 1, ‘Shattrath Fishing Daily (1 of 5)’);

DELETE FROM pool_quest WHERE entry IN (11667, 11668, 11666, 11665, 11669) AND pool_entry = @pool;
INSERT INTO pool_quest (entry, pool_entry, description) VALUES
(11667, @pool, ‘The One That Got Away’),
(11668, @pool, ‘Shrimpin' Ain't Easy’),
(11666, @pool, ‘Bait Bandits’),
(11665, @pool, ‘Crocolisks in the City’),
(11669, @pool, ‘Felblood Filet’);
Sources are primarily wowhead comments; has been tested.

looks good for me, if it works ingame i see no problems with it

Tested on TDB335.11.46 updated to 2012_02_23_00

Please use the above fix for bc heroic dungeons, it works fine.

Also the cooking and fishing dailys for shat AND dal plus the raid dailys have already been added to the pool in the above revision just not the bc heroic dailys.