aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/world
diff options
context:
space:
mode:
authorMikhail Redko <ovitnez@gmail.com>2018-03-21 11:05:17 +0200
committerShauren <shauren.trinity@gmail.com>2018-03-21 10:05:17 +0100
commit7c5b69d18bb315d369bf0bbfc16b795d63d0f73c (patch)
tree8d99ccbc026f25e1fc5d55d6062c23b03267b7dd /sql/updates/world
parent4af3c33d04b8ccaba7dc38ce4f2c757970b86156 (diff)
Core/Creatures: implement CREATURE_FLAG_EXTRA_NO_SELL_VENDOR (#21642)
* Add CREATURE_FLAG_EXTRA_NO_SELL_VENDOR and use it for a single no-sell vendor in game (there are more of them in later expansions)
Diffstat (limited to 'sql/updates/world')
-rw-r--r--sql/updates/world/3.3.5/2018_03_21_00_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_03_21_00_world.sql b/sql/updates/world/3.3.5/2018_03_21_00_world.sql
new file mode 100644
index 00000000000..d5a36cd23dd
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_03_21_00_world.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `flags_extra` = (`flags_extra` & ~0x1000);
+UPDATE `creature_template` SET `flags_extra` = (`flags_extra` | 0x1000) WHERE `entry` = 27914;