From 9de707d235414057414110ed6d4e6c4d3f9275f2 Mon Sep 17 00:00:00 2001 From: Jon Date: Wed, 21 Dec 2011 20:11:09 +0200 Subject: [Winter Veil] Mail loot templates for Winter Veil events --- .../world/2011_12_21_00_world_mail_loot_template.sql | 14 ++++++-------- 1 file changed, 6 insertions(+), 8 deletions(-) (limited to 'sql') diff --git a/sql/updates/world/2011_12_21_00_world_mail_loot_template.sql b/sql/updates/world/2011_12_21_00_world_mail_loot_template.sql index ae27643d9ea..742cd890420 100644 --- a/sql/updates/world/2011_12_21_00_world_mail_loot_template.sql +++ b/sql/updates/world/2011_12_21_00_world_mail_loot_template.sql @@ -1,43 +1,41 @@ --- Fix based on https://github.com/TrinityCore/TrinityCore/issues/43 and https://github.com/TrinityCore/TrinityCore/issues/4429 - -- Reward from Treats for Greatfather Winter (horde) SET @mail:=102; -- Set in DBC -UPDATE quest_template SET RewardMailTemplateId=@mail, RewardMailDelay=86400 WHERE ID IN (6962); -- Set mail delivery +UPDATE quest_template SET RewMailTemplateId=@mail, RewMailDelaySecs=86400 WHERE entry IN (6962); -- Set mail delivery DELETE FROM mail_loot_template WHERE entry=@mail; INSERT INTO mail_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES (@mail,17685,100,1,0,1,1); -- Attach item to mail -- Reward from Treats for Greatfather Winter (alliance) SET @mail:=118; -- Set in DBC -UPDATE quest_template SET RewardMailTemplateId=@mail, RewardMailDelay=86400 WHERE ID IN (7025); -- Set mail delivery +UPDATE quest_template SET RewMailTemplateId=@mail, RewMailDelaySecs=86400 WHERE entry IN (7025); -- Set mail delivery DELETE FROM mail_loot_template WHERE entry=@mail; INSERT INTO mail_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES (@mail,17685,100,1,0,1,1); -- Attach item to mail -- Reward from Stolen Winter Veil Treats (horde) SET @mail:=108; -- Set in DBC -UPDATE quest_template SET RewardMailTemplateId=@mail, RewardMailDelay=86400 WHERE ID IN (6963); -- Set mail delivery +UPDATE quest_template SET RewMailTemplateId=@mail, RewMailDelaySecs=86400 WHERE entry IN (6963); -- Set mail delivery DELETE FROM mail_loot_template WHERE entry=@mail; INSERT INTO mail_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES (@mail,17712,100,1,0,1,1); -- Attach item to mail -- Reward from Stolen Winter Veil Treats (alliance) SET @mail:=117; -- Set in DBC -UPDATE quest_template SET RewardMailTemplateId=@mail, RewardMailDelay=86400 WHERE ID IN (7042); -- Set mail delivery +UPDATE quest_template SET RewMailTemplateId=@mail, RewMailDelaySecs=86400 WHERE entry IN (7042); -- Set mail delivery DELETE FROM mail_loot_template WHERE entry=@mail; INSERT INTO mail_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES (@mail,17712,100,1,0,1,1); -- Attach item to mail -- Reward from Metzen the Reindeer (horde) SET @mail:=122; -- Set in DBC -UPDATE quest_template SET RewardMailTemplateId=@mail, RewardMailDelay=86400 WHERE ID IN (8746); -- Set mail delivery +UPDATE quest_template SET RewMailTemplateId=@mail, RewMailDelaySecs=86400 WHERE entry IN (8746); -- Set mail delivery DELETE FROM mail_loot_template WHERE entry=@mail; INSERT INTO mail_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES (@mail,21216,100,1,0,1,1); -- Attach item to mail -- Reward from Metzen the Reindeer (alliance) SET @mail:=161; -- Set in DBC -UPDATE quest_template SET RewardMailTemplateId=@mail, RewardMailDelay=86400 WHERE ID IN (8762); -- Set mail delivery +UPDATE quest_template SET RewMailTemplateId=@mail, RewMailDelaySecs=86400 WHERE entry IN (8762); -- Set mail delivery DELETE FROM mail_loot_template WHERE entry=@mail; INSERT INTO mail_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES (@mail,21216,100,1,0,1,1); -- Attach item to mail \ No newline at end of file -- cgit v1.2.3