diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-06-13 17:46:23 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-01-13 00:59:33 +0100 |
| commit | de0acec48a973444c74b0a97a3765997851558a8 (patch) | |
| tree | 5936d07da2139da73c8207eb75508bf457108297 | |
| parent | 1f1c9d33e0c556cb5155a23009cca53f1351b2dc (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
(cherry picked from commit e6d764b82585f92eddbc7847c0f1ce38b05c5431)
| -rw-r--r-- | sql/updates/world/master/2017_01_12_33_world_2016_06_13_04_world.sql (renamed from sql/updates/world/master/2017_01_12_33_2016_06_13_04_world.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/master/2017_01_12_34_world_2016_06_13_05_world.sql (renamed from sql/updates/world/3.3.5/2016_06_13_05_world.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/master/2017_01_12_35_world_2016_06_13_06_world.sql | 5 |
3 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_12_33_2016_06_13_04_world.sql b/sql/updates/world/master/2017_01_12_33_world_2016_06_13_04_world.sql index d2ad9c21b39..d2ad9c21b39 100644 --- a/sql/updates/world/master/2017_01_12_33_2016_06_13_04_world.sql +++ b/sql/updates/world/master/2017_01_12_33_world_2016_06_13_04_world.sql diff --git a/sql/updates/world/3.3.5/2016_06_13_05_world.sql b/sql/updates/world/master/2017_01_12_34_world_2016_06_13_05_world.sql index b19f167a81a..b19f167a81a 100644 --- a/sql/updates/world/3.3.5/2016_06_13_05_world.sql +++ b/sql/updates/world/master/2017_01_12_34_world_2016_06_13_05_world.sql diff --git a/sql/updates/world/master/2017_01_12_35_world_2016_06_13_06_world.sql b/sql/updates/world/master/2017_01_12_35_world_2016_06_13_06_world.sql new file mode 100644 index 00000000000..4ca697f1266 --- /dev/null +++ b/sql/updates/world/master/2017_01_12_35_world_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); |