aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2011-05-16 23:39:01 +0200
committerShauren <shauren.trinity@gmail.com>2011-05-16 23:39:01 +0200
commita29044373877b56825917e59bcfdaa74cbac70b8 (patch)
tree1b5ca978d38be714d3757f45430e68f93a1abbcc /sql/updates
parentdef928a3bd7500f12e6db4342eda9f85b39ae523 (diff)
Core/Creatures: Allow triggers to move and made all current triggers not move in db
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_05_16_00_world_creature.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/updates/world/2011_05_16_00_world_creature.sql b/sql/updates/world/2011_05_16_00_world_creature.sql
new file mode 100644
index 00000000000..54e23c90739
--- /dev/null
+++ b/sql/updates/world/2011_05_16_00_world_creature.sql
@@ -0,0 +1 @@
+UPDATE `creature` c LEFT JOIN `creature_template` ct ON c.id=ct.`Entry` SET c.`MovementType`=0,c.`spawndist`=0 WHERE (ct.flags_extra & 128)!=0;