aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-05-02 17:43:13 +0200
committerKillyana <morphone1@gmail.com>2020-05-02 17:43:13 +0200
commit4a8382d9059186b7e5c4132f86b2fb75dcc2cc35 (patch)
tree6bd760c0d93e2db2a09de484dcb3fe1b4605cacb
parenteedb2d3343bd64d664b0e7e9b29fc13761f20b7b (diff)
DB/Loot: Add missing bandages to Arathi Basin care packages
Closes #24533
-rw-r--r--sql/updates/world/3.3.5/2020_05_02_00_world.sql9
1 files changed, 9 insertions, 0 deletions
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);