DB/Creature: Add missing creatures before Lord Marrowgar on 25 difficulties

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_07_12_00_world.sql b/sql/updates/world/3.3.5/2016_07_12_00_world.sql
new file mode 100644
index 00000000000..dd910e8c712
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_07_12_00_world.sql
@@ -0,0 +1,24 @@
+-- 
+UPDATE `creature` SET `position_x`=-138.96708, `position_y`=2216.8854, `position_z`=35.23352 WHERE `guid`=201066;
+UPDATE `creature` SET `position_x`=-139.10365, `position_y`=2206.1518, `position_z`=35.23352 WHERE `guid`=200966;
+UPDATE `creature` SET `position_x`=-170.46333, `position_y`=2211.5104, `position_z`=35.23444, `orientation`=0.0573 WHERE `guid`=201107;
+UPDATE `creature` SET `position_x`=-173.38168, `position_y`=2205.6416, `position_z`=35.23344, `orientation`=0.0573 WHERE `guid`=201146;
+UPDATE `creature` SET `position_x`=-215.74542, `position_y`=2210.8286, `position_z`=35.23345 WHERE `guid`=201080;
+UPDATE `creature` SET `spawnMask`=10, `position_x`=-240.49464, `position_y`=2216.4948, `position_z`=42.56450 WHERE `guid`=201090;
+
+SET @Guid:=86240;
+DELETE FROM `creature` WHERE `guid` BETWEEN @Guid AND @Guid+12;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@Guid+0, 37011, 631, 0, 0, 15, 1, 0, 0, -118.939, 2191.25, 32.522, 5.48788, 300, 0, 0, 1575000, 0, 0, 0, 0, 0, 0),
+(@Guid+1, 37011, 631, 0, 0, 15, 1, 0, 0, -103.527, 2211.8, 31.0923, 6.22616, 300, 0, 0, 1575000, 0, 0, 0, 0, 0, 0),
+(@Guid+2, 37011, 631, 0, 0, 15, 1, 0, 0, -117.35, 2230.88, 32.3868, 0.894935, 300, 0, 0, 1575000, 0, 0, 0, 0, 0, 0),
+(@Guid+3, 37011, 631, 0, 0, 15, 1, 0, 0, -172.569, 2217.53, 35.2335, 6.24856, 300, 0, 0, 1575000, 0, 0, 0, 0, 0, 0),
+(@Guid+4, 37011, 631, 0, 0, 10, 1, 0, 0, -167.622, 2166.53, 37.9851, 2.00976, 300, 0, 0, 1575000, 0, 0, 0, 0, 0, 0),
+(@Guid+5, 37011, 631, 0, 0, 10, 1, 0, 0, -161.425, 2256.88, 37.9853, 4.01646, 300, 0, 0, 1575000, 0, 0, 0, 0, 0, 0),
+(@Guid+6, 37012, 631, 0, 0, 10, 1, 0, 1, -198.303, 2215.24, 35.2334, 0.0689005, 300, 0, 0, 1134000, 0, 0, 0, 0, 0, 0),
+(@Guid+7, 37012, 631, 0, 0, 10, 1, 0, 1, -197.742, 2207.1, 35.2334, 0.0689005, 300, 0, 0, 1134000, 0, 0, 0, 0, 0, 0),
+(@Guid+8, 36724, 631, 0, 0, 10, 1, 0, 0, -212.28, 2222.43, 35.2335, 6.20612, 300, 0, 0, 1260000, 99850, 0, 0, 0, 0, 0),
+(@Guid+9, 36724, 631, 0, 0, 10, 1, 0, 0, -213.399, 2199.63, 35.234, 6.1472, 300, 0, 0, 1260000, 99850, 0, 0, 0, 0, 0),
+(@Guid+10, 36724, 631, 0, 0, 10, 1, 0, 0, -240.447, 2207.22, 42.5645, 0.00512781, 300, 0, 0, 1260000, 99850, 0, 0, 0, 0, 0),
+(@Guid+11, 37012, 631, 0, 0, 10, 1, 0, 1, -303.076, 2225.2, 41.9796, 6.12287, 300, 0, 0, 1134000, 0, 0, 0, 0, 0, 0),
+(@Guid+12, 37012, 631, 0, 0, 10, 1, 0, 1, -302.821, 2198.51, 41.9806, 6.26345, 300, 0, 0, 1134000, 0, 0, 0, 0, 0, 0);