aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKinzcool <kinzzcool@hotmail.com>2014-08-21 20:33:38 -0400
committerKinzcool <kinzzcool@hotmail.com>2014-08-21 20:33:38 -0400
commitd90d0fb6140ec1f149954d6422dee383dbb953ab (patch)
tree66b568372eaa8bfe0fced5f40e4dd22e342650dc /sql
parentbf526c0797db0f02ff2e2831449e8c44c0144076 (diff)
DB/Creatures: Fixed the InhabitType of some water creatures (fishes shouldn't walk)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_08_22_02_world_creature_template.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_22_02_world_creature_template.sql b/sql/updates/world/2014_08_22_02_world_creature_template.sql
new file mode 100644
index 00000000000..8895c032b48
--- /dev/null
+++ b/sql/updates/world/2014_08_22_02_world_creature_template.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `InhabitType`=2 WHERE `entry` IN (1224, 2188, 3642, 4830, 5936, 6145, 8236, 15118, 15526, 18284, 21217, 23928, 24285, 24637, 24899, 25204, 25226, 26510, 26511, 26522, 2743827617, 28010, 28847, 29392, 29834, 30642, 32664, 33497, 34116);
+UPDATE `creature_template` SET `InhabitType`=3 WHERE `entry`=21689;