diff options
| -rw-r--r-- | sql/updates/world/2011_02_04_0_world_creature_631.sql | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_04_0_world_creature_631.sql b/sql/updates/world/2011_02_04_0_world_creature_631.sql new file mode 100644 index 00000000000..c9db3f6a929 --- /dev/null +++ b/sql/updates/world/2011_02_04_0_world_creature_631.sql @@ -0,0 +1,70 @@ +SET @GUID := 151761; +DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+64; +INSERT INTO creature + (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) +VALUES +(@GUID,37122,631,15,1,0,0,4365.98,2672.63,349.271,4.67748,604800,0,0,130330,4081,0,0,0,0,0), -- Captain Arnath +(@GUID+1,37123,631,15,1,0,0,4361.32,2675.74,349.389,4.64258,604800,0,0,130330,61215,0,0,0,0,0), -- Captain Brandon +(@GUID+2,37124,631,15,1,0,0,4349.95,2677.52,349.306,4.83962,604800,0,0,130330,0,0,0,0,0,0), -- Captain Grondel +(@GUID+3,37125,631,15,1,0,0,4347.03,2673.68,349.37,4.85202,604800,0,0,130330,0,0,0,0,0,0), -- Captain Rupert +(@GUID+4,37127,631,15,1,0,0,4346.72,2607.9,351.101,3.23426,7200,0,0,453600,8814,0,0,0,0,0), -- Ymirjar Frostbinder +(@GUID+5,37127,631,15,1,0,0,4371.41,2570.52,351.101,0.0808906,7200,0,0,453600,8814,0,0,0,0,0), -- Ymirjar Frostbinder +(@GUID+6,37129,631,15,1,0,0,4356.9,2673.27,349.47,4.76475,604800,0,0,278900,0,0,0,0,0,0), -- Crok Scourgebane +(@GUID+7,37132,631,15,1,0,0,4347.2,2637.91,351.1,1.34068,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+8,37132,631,15,1,0,0,4367.9,2638.14,351.1,1.77657,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+9,37132,631,15,1,0,0,4345.88,2577.64,351.101,1.52995,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+10,37132,631,15,1,0,0,4368.03,2578.97,351.101,1.69096,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+11,37132,631,15,1,0,0,4369.26,2525.06,358.433,1.78913,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+12,37132,631,15,1,0,0,4343.78,2525.43,358.433,1.26291,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+13,37133,631,15,1,0,0,4356.85,2636.39,351.101,1.56922,7200,0,0,630000,0,0,0,0,0,0), -- Ymirjar Warlord +(@GUID+14,37133,631,15,1,0,0,4346.98,2512.75,358.441,1.35716,7200,0,0,630000,0,0,0,0,0,0), -- Ymirjar Warlord +(@GUID+15,37133,631,15,1,0,0,4356.77,2524.27,358.433,1.50246,7200,0,0,630000,0,0,0,0,0,0), -- Ymirjar Warlord +(@GUID+16,37134,631,15,1,0,0,4351.66,2642.95,351.1,1.40351,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+17,37134,631,15,1,0,0,4362.18,2642.97,351.1,1.5331,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+18,37134,631,15,1,0,0,4363.48,2585.09,351.101,1.58493,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+19,37134,631,15,1,0,0,4349.36,2584.54,351.101,1.60849,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+20,37134,631,15,1,0,0,4350.65,2528.31,358.433,1.52995,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+21,37134,631,15,1,0,0,4362.76,2527.67,358.433,1.48282,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+22,37531,631,15,1,0,0,4362.85,2514.43,203.383,0.541144,7200,0,0,1134000,0,0,0,0,0,0), -- Frostwarden Handler +(@GUID+23,37531,631,15,1,0,0,4360.96,2454.38,203.384,5.7719,7200,0,0,1134000,0,0,0,0,0,0), -- Frostwarden Handler +(@GUID+24,37532,631,15,1,0,0,4389.66,2533.88,203.387,1.49305,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+25,37532,631,15,1,0,0,4379.52,2517.11,203.383,1.55823,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+26,37532,631,15,1,0,0,4379.45,2510.21,203.382,2.77324,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+27,37532,631,15,1,0,0,4377.98,2511.69,203.384,0.0361331,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+28,37532,631,15,1,0,0,4376.07,2508.98,203.384,0.95662,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+29,37532,631,15,1,0,0,4371.45,2514.37,203.383,3.35915,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+30,37532,631,15,1,0,0,4377.53,2519.25,203.384,5.76561,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+31,37532,631,15,1,0,0,4385.71,2530.45,203.387,3.85552,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+32,37532,631,15,1,0,0,4374.05,2457.47,203.382,4.73831,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+33,37532,631,15,1,0,0,4373.95,2461.52,203.382,3.47539,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+34,37532,631,15,1,0,0,4375.93,2455.54,203.383,4.69512,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+35,37532,631,15,1,0,0,4383.62,2529.27,203.386,5.19698,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+36,37532,631,15,1,0,0,4389.28,2528.94,203.386,6.22428,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+37,37532,631,15,1,0,0,4380.05,2456.41,203.382,0.00314776,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+38,37532,631,15,1,0,0,4376.26,2462.41,203.382,2.58318,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+39,37532,631,15,1,0,0,4378.17,2462.99,203.381,4.13827,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+40,37532,631,15,1,0,0,4383.05,2523.33,203.387,4.35504,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+41,37532,631,15,1,0,0,4372.52,2452.47,203.384,3.70002,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+42,37532,631,15,1,0,0,4381.59,2533.12,203.386,3.60734,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+43,37532,631,15,1,0,0,4386.49,2535.52,203.386,3.07248,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+44,37532,631,15,1,0,0,4385.64,2512.62,203.384,4.82235,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+45,37532,631,15,1,0,0,4373.77,2438.67,203.386,4.50819,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+46,37532,631,15,1,0,0,4370.54,2441.32,203.386,2.44731,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+47,37532,631,15,1,0,0,4376.09,2442.12,203.386,0.133524,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+48,37532,631,15,1,0,0,4379.22,2439.67,203.386,5.39491,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+49,37532,631,15,1,0,0,4380.51,2434.97,203.387,4.65585,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+50,37532,631,15,1,0,0,4382.9,2439.76,203.387,1.10506,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+51,37532,631,15,1,0,0,4381.45,2444.52,203.386,3.39057,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+52,38125,631,15,1,0,0,4369.75,2606.94,351.101,6.24627,7200,0,0,567000,3994,0,0,0,0,0), -- Ymirjar Deathbringer +(@GUID+53,38125,631,15,1,0,0,4340.83,2572.01,351.101,3.14394,7200,0,0,567000,3994,0,0,0,0,0), -- Ymirjar Deathbringer +(@GUID+54,38154,631,15,1,0,0,4360.11,2644.49,351.1,1.58808,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+55,38154,631,15,1,0,0,4355.22,2644.43,351.1,1.58415,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+56,38154,631,15,1,0,0,4359.36,2587.74,351.101,1.64776,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+57,38154,631,15,1,0,0,4354.53,2587.01,351.101,1.64383,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+58,38229,631,15,1,2177,0,4358.06,2608.39,351.184,2.86266,604800,5,0,13,0,0,1,0,0,0), -- Frozen Insect +(@GUID+59,38229,631,15,1,9829,0,4352.01,2664.59,350.18,6.12231,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+60,38229,631,15,1,2177,0,4356.72,2408.48,358.432,4.04586,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+61,38229,631,15,1,7511,0,4359.53,2656.51,351.101,0.198085,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+62,38229,631,15,1,7511,0,4351.09,2488.49,358.441,1.93736,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+63,38229,631,15,1,2177,0,4356.68,2525.39,358.432,1.69568,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+64,38229,631,15,1,2177,0,4352.72,2610.13,351.101,2.82663,604800,5,0,13,0,0,1,0,0,0); -- Frozen Insect |