From e6d764b82585f92eddbc7847c0f1ce38b05c5431 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Mon, 13 Jun 2016 17:46:23 +0100 Subject: DB/Loot: Swift thistle Add chance for swift thistle to drop to the other version of Mageroyal and Briarthorn which current does not have chance to drop swiftthistle as there is two of each but only one had chance even though according to wowhead. http://www.wowhead.com/object=1621/briarthorn http://www.wowhead.com/object=3729/briarthorn http://www.wowhead.com/object=1620/mageroyal http://www.wowhead.com/object=3727/mageroyal --- sql/updates/world/3.3.5/2016_06_13_06_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_06_13_06_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2016_06_13_06_world.sql b/sql/updates/world/3.3.5/2016_06_13_06_world.sql new file mode 100644 index 00000000000..4ca697f1266 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_06_13_06_world.sql @@ -0,0 +1,5 @@ +DELETE FROM `gameobject_loot_template` WHERE `Entry` in(2515,2514) AND `Item`=2452; + +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(2515, 2452, 0, 40, 0, 1, 0, 1, 2, NULL), +(2514, 2452, 0, 20, 0, 1, 0, 1, 2, NULL); -- cgit v1.2.3