diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_09_01_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_09_01_world.sql b/sql/updates/world/3.3.5/2019_04_09_01_world.sql new file mode 100644 index 00000000000..ad54714ff40 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_09_01_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `fishing_loot_template` WHERE `Item` IN (45323,45328,45903); +DELETE FROM `reference_loot_template` WHERE `Item` IN (45328); +INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(11024, 45328, 0, 10, 1, 1, 2, 1, 1, ""); +DELETE FROM `conditions` WHERE `SourceGroup` IN (11026) AND `SourceTypeOrReferenceId`=10 AND `SourceEntry`=45328; +UPDATE `fishing_loot_template` SET `GroupID`=0 WHERE `entry` IN (4567,4560); +UPDATE `reference_loot_template` SET `GroupID`=1 WHERE `entry` IN (11024,11026); +UPDATE `reference_loot_template` SET `Chance`=6 WHERE `entry` IN (11024) AND `Item` IN (43658,43695,43696); +UPDATE `reference_loot_template` SET `GroupID`=2 WHERE `Item` IN (45328,45903); |