diff options
| author | ZxBiohazardZx <none@none> | 2011-02-04 07:41:48 -0700 |
|---|---|---|
| committer | runningnak3d <runningnak3d@gmail.com> | 2011-02-04 07:41:48 -0700 |
| commit | da4d38b00c994d564bbb1813b88937a9c86015f6 (patch) | |
| tree | 3c7b99d934f5eeef0e7fd5ce50373eca9e62de14 | |
| parent | c32555300074346e55948407c89a2f867084f451 (diff) | |
DB/Loot: Winter Veil mail rewards
Closes #1
| -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 }}} |