aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMalcrom <malcromdev@gmail.com>2014-09-21 13:18:14 -0230
committerMalcrom <malcromdev@gmail.com>2014-09-21 13:18:14 -0230
commitdc814ed282ee954df8ec4d028e9445237b1b632c (patch)
tree3c2c199c4c2b17e55dcd56f2497bea4bc8aa11e3
parent1d8feb271c3c30858dd63bc9f402892d98a0458d (diff)
DB/Creature Model: Fix a few models by AriDEV
-rw-r--r--sql/updates/world/2014_09_21_07_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_21_07_world.sql b/sql/updates/world/2014_09_21_07_world.sql
new file mode 100644
index 00000000000..db11a7fa3d2
--- /dev/null
+++ b/sql/updates/world/2014_09_21_07_world.sql
@@ -0,0 +1,9 @@
+-- ModelID Fix For NPC: 21749
+-- Also Remove Dwarf ModelID From ModelID of 21749
+DELETE FROM `creature_model_info` WHERE `modelid` IN (20447, 20448, 20449, 20450, 18790);
+INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES
+(20447, 0.372, 1.5, 0, 20449), -- Male Green Orc
+(20448, 0.372, 1.5, 0, 20450), -- Male Dark Green Orc
+(20449, 0.236, 1.5, 1, 20448), -- Female Dark Green Orc
+(20450, 0.236, 1.5, 1, 20447), -- Female Green Orc
+(18790, 0.347, 1.5, 1, 18791); -- Dwarf