aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2023-04-06 17:43:39 +0200
committerGitHub <noreply@github.com>2023-04-06 17:43:39 +0200
commit1af961b9a2b7336a00e3971d7f1bf8bf8eee03c1 (patch)
tree0a2bb4c44e7eafdeeddc25ecb03df478a4d89c36 /sql
parenteeaa3ee3e526609e69df7f993ec4a4382639efcb (diff)
DB/Quest: Emergency Measures
Remove incorrect flag. Update drop chance. by CraftedRO closes #28697
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2023_04_06_04_world.sql5
1 files changed, 5 insertions, 0 deletions
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;