From 1af961b9a2b7336a00e3971d7f1bf8bf8eee03c1 Mon Sep 17 00:00:00 2001
From: Aokromes <Aokromes@users.noreply.github.com>
Date: Thu, 6 Apr 2023 17:43:39 +0200
Subject: DB/Quest: Emergency Measures

Remove incorrect flag.
Update drop chance.

by CraftedRO closes #28697
---
 sql/updates/world/3.3.5/2023_04_06_04_world.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2023_04_06_04_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2023_04_06_04_world.sql b/sql/updates/world/3.3.5/2023_04_06_04_world.sql
new file mode 100644
index 00000000000..47b0d57d8f1
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_04_06_04_world.sql
@@ -0,0 +1,5 @@
+-- Remove PvPFlags for Cavedweller Worg
+UPDATE `creature_template_addon` SET `PvPFlags`=0 WHERE `entry`=30164;
+
+-- update worg fur drop rate
+UPDATE `creature_loot_template` SET `Chance`=27 WHERE `Item`=42510 AND `Entry`=30164;
-- 
cgit v1.2.3