diff options
| -rw-r--r-- | sql/updates/world/2011_02_04_0_world_mail_loot_template.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_04_0_world_mail_loot_template.sql b/sql/updates/world/2011_02_04_0_world_mail_loot_template.sql new file mode 100644 index 00000000000..2e07a483473 --- /dev/null +++ b/sql/updates/world/2011_02_04_0_world_mail_loot_template.sql @@ -0,0 +1,34 @@ +-- Reward from Treats for Greatfather Winter (horde) +SET @MAIL:=118; -- Set in DBC +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:=102; -- Set in DBC +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 (alliance) +SET @MAIL:=117; -- Set in DBC +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 (alliance) +SET @MAIL:=161; -- Set in DBC +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 + +-- Reward from Metzen the Reindeer (horde) +SET @MAIL:=122; -- Set in DBC +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 }}} |