diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-10-09 12:25:43 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-09-05 12:10:28 +0200 |
| commit | 0b37dc3c76f49799dc6a7a3caa47168c0f5fda4e (patch) | |
| tree | b9bc8215f0a4f9412b6a4d2c508b369ac94afc04 | |
| parent | 49c131a57e71c47c9a97be855d2212e28308f5e9 (diff) | |
DB/Loot: Dustbringer.
(cherry picked from commit b60b0d927bb1d9f81a650748901293fce93de3cf)
| -rw-r--r-- | sql/updates/world/master/2017_09_05_09_world_2016_10_09_02_world.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_09_05_09_world_2016_10_09_02_world.sql b/sql/updates/world/master/2017_09_05_09_world_2016_10_09_02_world.sql new file mode 100644 index 00000000000..18b368cf9d9 --- /dev/null +++ b/sql/updates/world/master/2017_09_05_09_world_2016_10_09_02_world.sql @@ -0,0 +1,37 @@ +-- +SET @Dustbringer := 44505; + +DELETE FROM `gameobject_loot_template` WHERE `Item`= @Dustbringer; +INSERT INTO `gameobject_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(25662, @Dustbringer, 0, 1, 0, 1, 4, 1, 1, 'Dustbringer'), +(25663, @Dustbringer, 0, 1, 0, 1, 4, 1, 1, 'Dustbringer'), +(25664, @Dustbringer, 0, 1, 0, 1, 4, 1, 1, 'Dustbringer'), +(25665, @Dustbringer, 0, 1, 0, 1, 4, 1, 1, 'Dustbringer'), +(25668, @Dustbringer, 0, 1, 0, 1, 4, 1, 1, 'Dustbringer'), +(25670, @Dustbringer, 0, 1, 0, 1, 4, 1, 1, 'Dustbringer'), +(25671, @Dustbringer, 0, 1, 0, 1, 8, 1, 1, 'Dustbringer'), +(25673, @Dustbringer, 0, 1, 0, 1, 5, 1, 1, 'Dustbringer'), +(25674, @Dustbringer, 0, 1, 0, 1, 4, 1, 1, 'Dustbringer'); + +DELETE FROM `fishing_loot_template` WHERE `Item`= @Dustbringer; +INSERT INTO `fishing_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(65, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(394, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(2817, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(3711, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(3980, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(3982, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(3994, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(3999, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4001, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4002, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4039, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4043, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4055, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4058, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4059, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4071, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4109, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4134, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4263, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'), +(4479, @Dustbringer, 0, 1, 0, 1, 2, 1, 1, 'Dustbringer'); |