From 4a8382d9059186b7e5c4132f86b2fb75dcc2cc35 Mon Sep 17 00:00:00 2001 From: offl Date: Sat, 2 May 2020 17:43:13 +0200 Subject: DB/Loot: Add missing bandages to Arathi Basin care packages Closes #24533 --- sql/updates/world/3.3.5/2020_05_02_00_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_05_02_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_05_02_00_world.sql b/sql/updates/world/3.3.5/2020_05_02_00_world.sql new file mode 100644 index 00000000000..e91401a3510 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_05_02_00_world.sql @@ -0,0 +1,9 @@ +-- Add missing bandages to Arathi Basin care packages +DELETE FROM `item_loot_template` WHERE `Item` IN (20065,20066,20067); +INSERT INTO `item_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES +(20230,20065,0,100,0,1,0,20,20), +(20236,20065,0,100,0,1,0,20,20), +(20228,20066,0,100,0,1,0,20,20), +(20231,20066,0,100,0,1,0,20,20), +(20229,20067,0,100,0,1,0,20,20), +(20233,20067,0,100,0,1,0,20,20); -- cgit v1.2.3