From ce9d4fac9b88be4027a729ce19acd2da26da19d4 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 13 Jun 2016 02:34:27 +0200 Subject: DB/Loot: Fix drop chance and quantity for Rough/Coarse Stone and Copper/Tin ore from mining veins Closes #17341 By SnapperRy (cherry picked from commit ab184414ae2a462c89433a8c0678bae1e69dee85) --- sql/updates/world/3.3.5/2016_06_13_00_world.sql | 2 -- sql/updates/world/3.3.5/2016_06_13_01_world.sql | 3 --- sql/updates/world/master/2017_01_12_31_world_2016_06_13_01_world.sql | 3 +++ sql/updates/world/master/2017_01_12_32_world_2016_06_13_00_world.sql | 2 ++ 4 files changed, 5 insertions(+), 5 deletions(-) delete mode 100644 sql/updates/world/3.3.5/2016_06_13_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2016_06_13_01_world.sql create mode 100644 sql/updates/world/master/2017_01_12_31_world_2016_06_13_01_world.sql create mode 100644 sql/updates/world/master/2017_01_12_32_world_2016_06_13_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_06_13_00_world.sql b/sql/updates/world/3.3.5/2016_06_13_00_world.sql deleted file mode 100644 index 287fb53747e..00000000000 --- a/sql/updates/world/3.3.5/2016_06_13_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `smart_scripts` SET `event_flags` = 1 WHERE `entryorguid`= 5710 AND `source_type`= 0 AND `id`= 0 AND `link`= 1; diff --git a/sql/updates/world/3.3.5/2016_06_13_01_world.sql b/sql/updates/world/3.3.5/2016_06_13_01_world.sql deleted file mode 100644 index 85d48c5a742..00000000000 --- a/sql/updates/world/3.3.5/2016_06_13_01_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 19512; -INSERT INTO `spell_linked_spell` VALUES (19512, -19502, 1, 'Apply Salve - Sickly Critter Aura'); diff --git a/sql/updates/world/master/2017_01_12_31_world_2016_06_13_01_world.sql b/sql/updates/world/master/2017_01_12_31_world_2016_06_13_01_world.sql new file mode 100644 index 00000000000..85d48c5a742 --- /dev/null +++ b/sql/updates/world/master/2017_01_12_31_world_2016_06_13_01_world.sql @@ -0,0 +1,3 @@ +-- +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 19512; +INSERT INTO `spell_linked_spell` VALUES (19512, -19502, 1, 'Apply Salve - Sickly Critter Aura'); diff --git a/sql/updates/world/master/2017_01_12_32_world_2016_06_13_00_world.sql b/sql/updates/world/master/2017_01_12_32_world_2016_06_13_00_world.sql new file mode 100644 index 00000000000..287fb53747e --- /dev/null +++ b/sql/updates/world/master/2017_01_12_32_world_2016_06_13_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `event_flags` = 1 WHERE `entryorguid`= 5710 AND `source_type`= 0 AND `id`= 0 AND `link`= 1; -- cgit v1.2.3