diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_12_16_00_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_12_16_00_world.sql b/sql/updates/world/3.3.5/2017_12_16_00_world.sql new file mode 100644 index 00000000000..12ff8116a91 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_12_16_00_world.sql @@ -0,0 +1,12 @@ +-- +UPDATE `reference_loot_template` SET `Entry`=34210 WHERE `Item` IN (42117,46373,42116,42075,42074,42073,42072,42071,42070,42069,42040,42039,42038,42037,42036,42035,42034,42017,42005,41971,41959,41940,41927,41909,41903,41898,41893,41885,41881,41874,41864,41840,41836,41832,41773,41767,41667,41655,41640,41635,41630,41625,41621,41617,41304,41298,41293,41287,41235,41230,41225,41205,41199,41143,41137,41075,41070,41065,41060,41055,41051,41033,41027,41007,41001,40983,40977,40976,40939,40927,40889,40882,40881,40849,40848,40847,40809,40808,40807) AND entry=34204; +UPDATE `creature_loot_template` SET `MaxCount`=1 WHERE `Entry`=35013 AND `Item`=1 AND `Reference`=34204; +DELETE FROM `creature_loot_template` WHERE `Entry`=35013 AND `Item`=3 AND `Reference`=34210; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`) VALUES +(35013, 3, 34210, 100, 0, 1, 0, 1, 1); + +UPDATE `reference_loot_template` SET `Entry`=34211 WHERE `item` IN (41972,42006,41960,41941,41928,41034,41144,41028,41008,41002,40940,41200,41206,40928,40852,41875,41865,40851,40850,40812,40811,41288,41774,41768,41668,41656,41294,41299,41138,42018,40810,41305,41618,41626,41631,41636,41641,41833,41236,41231,41226,41837,41841,41882,41886,41894,41899,41904,41910,46374,42119,41076,41071,42118,42082,41066,41061,42081,42080,41056,41052,42079,42078,42077,42076,40984,40979,40978,42047,42046,40890,40884,40883,42045,42044,42043,42042,42041,41622) AND entry=34205; +UPDATE `creature_loot_template` SET `MaxCount`=2 WHERE `Entry`=35360 AND `Item`=1 AND `Reference`=34205; +DELETE FROM `creature_loot_template` WHERE `Entry`=35360 AND `Item`=3 AND `Reference`=34211; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`) VALUES +(35360, 3, 34211, 100, 0, 1, 0, 1, 2); |