From 65e37a4f1d78eb621129e6f3805af4322eb21f87 Mon Sep 17 00:00:00 2001 From: Shocker Date: Sat, 24 Dec 2011 14:31:23 +0200 Subject: Correct SQL naming after recent pull --- .../2011_12_21_00_world_mail_loot_template.sql | 41 ---------------------- .../2011_12_24_01_world_mail_loot_template.sql | 41 ++++++++++++++++++++++ 2 files changed, 41 insertions(+), 41 deletions(-) delete mode 100644 sql/updates/world/2011_12_21_00_world_mail_loot_template.sql create mode 100644 sql/updates/world/2011_12_24_01_world_mail_loot_template.sql (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 deleted file mode 100644 index 742cd890420..00000000000 --- a/sql/updates/world/2011_12_21_00_world_mail_loot_template.sql +++ /dev/null @@ -1,41 +0,0 @@ --- Reward from Treats for Greatfather Winter (horde) -SET @mail:=102; -- 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:=118; -- 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 (horde) -SET @mail:=108; -- Set in DBC -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 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 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 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 diff --git a/sql/updates/world/2011_12_24_01_world_mail_loot_template.sql b/sql/updates/world/2011_12_24_01_world_mail_loot_template.sql new file mode 100644 index 00000000000..fecff071e66 --- /dev/null +++ b/sql/updates/world/2011_12_24_01_world_mail_loot_template.sql @@ -0,0 +1,41 @@ +-- Reward from Treats for Greatfather Winter (horde) +SET @mail:=102; -- 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:=118; -- 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 (horde) +SET @mail:=108; -- Set in DBC +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 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 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 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 -- cgit v1.2.3