aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-09-24 00:58:16 +0200
committerShauren <shauren.trinity@gmail.com>2021-11-10 23:46:47 +0100
commita97d4326c6918a1aa104fa240f30f5879dad60df (patch)
tree22793302c62343af88a44ec0a8cd18a3ae1d8e04
parent4ea51384a715ea55e15dda834dde712efa6c89ea (diff)
DB/Creature: Fix some npcflags and gossips
(cherry picked from commit 3b520b971f90fc541d316fa9ad2757f7196c4bf0)
-rw-r--r--sql/updates/world/master/2021_11_10_03_world_2018_09_23_07_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_10_03_world_2018_09_23_07_world.sql b/sql/updates/world/master/2021_11_10_03_world_2018_09_23_07_world.sql
new file mode 100644
index 00000000000..5eaa340889d
--- /dev/null
+++ b/sql/updates/world/master/2021_11_10_03_world_2018_09_23_07_world.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`IN (1735,37589,10676,14369,17827,22258,23101,25078,25093,28209,28210,24956,26547,33642,29778,29143,29145,29728,20165);
+-- UPDATE `creature_template` SET `npcflag`=65537,`type_flags`=134217728 WHERE `entry`=3628;
+UPDATE `creature_template` SET `gossip_menu_id`=0 WHERE `entry` IN (5835,21859,5627,17764,25924);