aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-08-14 16:52:30 +0300
committeroffl <offl@users.noreply.github.com>2021-08-14 16:52:30 +0300
commit02131d6f8c55164f4a1c18919bedbda09ecc12c6 (patch)
treecb433d1536329d789f75284d647b9959d4264965
parent16fcbf07f88030d64271fa01b458679cbb2244c7 (diff)
DB/Creature: Revert changes to some of type & family & exp fields
Ref #2963 #3234 #24464
-rw-r--r--sql/updates/world/3.3.5/2021_08_14_02_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_08_14_02_world.sql b/sql/updates/world/3.3.5/2021_08_14_02_world.sql
new file mode 100644
index 00000000000..3b014f04661
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_08_14_02_world.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `creature_template` SET `minlevel` = 73, `maxlevel` = 73, `exp` = 1 WHERE `entry` = 28521;
+UPDATE `creature_template` SET `type` = 10 WHERE `entry` IN (21861,28535,28536,28537,28539,28540);
+UPDATE `creature_template` SET `family` = 0 WHERE `entry` IN (28535,28536,28537,28539,28540);