diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-06-13 17:46:23 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-06-13 17:46:23 +0100 |
| commit | e6d764b82585f92eddbc7847c0f1ce38b05c5431 (patch) | |
| tree | aed21f2adb84a29002d8df507dce532835007294 | |
| parent | 21430746b62be066d333bf511c8725b3460f0082 (diff) | |
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
| -rw-r--r-- | sql/updates/world/3.3.5/2016_06_13_06_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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); |