Forked from sirikfoll/Midsummer_Fire_Festival_Missing_Spawns.sql
Last active
September 5, 2015 01:32
-
-
Save Demonid/e07020dc6c013ff2949a to your computer and use it in GitHub Desktop.
[DB/Events] Midsummer Fire Festival Missing Spawns
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Add missing spawns,misc changes gameobjects/creatures related to Midsummer event | |
| SET @CGUID = xxxxxx; -- 168 Required | |
| SET @OGUID = xxxxxx; -- 419 Required | |
| UPDATE `gameobject` SET `position_x`=-7596.67, `position_y`=-2079.81, `position_z`=125.968, `orientation`=3.20786, `rotation2`=0.999451, `rotation3`=-0.0331301 WHERE `guid`=52517 AND `id`=188021; | |
| UPDATE `gameobject` SET `position_x`=-7591.5, `position_y`=-2080.49, `position_z`=126.518 WHERE `guid`=50934 AND `id`=181307; | |
| UPDATE `creature` SET `orientation`=3.14884 WHERE `guid`=202758; | |
| UPDATE `creature` SET `modelid`=21085 WHERE `guid`=202746; | |
| UPDATE `creature` SET `modelid`=21086 WHERE `guid`=202749; | |
| UPDATE `creature` SET `modelid`=16436 WHERE `guid`=202748; | |
| DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+39; | |
| INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES | |
| (@OGUID+0, 181355, 1, 1, 1, -2335.13, -621.407, -7.62503, 5.5, 0, 0, 0.414693, 0.909961, 180, 100, 1), -- Mulgore | |
| (@OGUID+1, 188020, 1, 1, 1, -2327.16, -631.314, -8.68343, 5.5, 0, 0, 0.398749, 0.91706, 180, 100, 1), | |
| (@OGUID+2, 181605, 1, 1, 1, -2342.39, -609.245, -7.76984, 5.5, 0, 0, 0.25038, -0.968148, 0, 100, 1), | |
| (@OGUID+3, 181306, 1, 1, 1, -2323.77, -610.206, -9.16689, 5.5, 0, 0, 0.843391, 0.5373, 180, 100, 1), | |
| (@OGUID+4, 181302, 1, 1, 1, -2326.25, -610.633, -8.98158, 1.58409, 0, 0, 0.711791, 0.702392, 180, 100, 1), | |
| (@OGUID+5, 181302, 1, 1, 1, -2325.28, -608.627, -9.18096, 1.58409, 0, 0, 0.711791, 0.702392, 180, 100, 1), | |
| (@OGUID+6, 188020, 1, 1, 1, -2318.53, -608.976, -9.42005, 5.5, 0, 0, 0.469472, 0.882948, 180, 100, 1), | |
| (@OGUID+7, 188021, 1, 1, 1, -2326.65, -613.461, -8.78372, 1.19925, 0, 0, 0.564334, 0.825546, 180, 100, 1), | |
| (@OGUID+8, 181355, 1, 1, 1, -2330.4, -606.562, -8.87822, 5.5, 0, 0, 0.414693, 0.909961, 180, 100, 1), | |
| (@OGUID+9, 187965, 1, 1, 1, -2329.42, -624.806, -8.27507, 5.5, 0, 0, 0.766044, -0.642788, 0, 100, 1), | |
| (@OGUID+10, 181376, 1, 1, 1, -2329.42, -624.806, -6.27507, 5.5, 0, 0, -0.34202, 0.939693, 180, 0, 1), | |
| (@OGUID+11, 188020, 1, 1, 1, -2337.14, -602.794, -8.71659, 5.5, 0, 0, 0.477159, 0.878817, 180, 100, 1), | |
| (@OGUID+12, 181355, 1, 1, 1, -2320.03, -612.344, -9.38502, 5.5, 0, 0, 0.21644, -0.976296, 180, 100, 1), | |
| (@OGUID+13, 188020, 1, 1, 1, -2348.37, -615.991, -6.85173, 5.82288, 0, 0, 0.228128, -0.973631, 300, 0, 1), | |
| (@OGUID+14, 181305, 1, 1, 1, -2330.42, -611.458, -8.53482, 6.06204, 0, 0, 0.110346, -0.993893, 300, 0, 1), | |
| (@OGUID+15, 181307, 1, 1, 1, -2330.98, -609.979, -7.54302, 5.68898, 0, 0, 0.292752, -0.956188, 300, 0, 1), | |
| (@OGUID+16, 181305, 0, 1, 1, -7591.14, -2081, 125.519, 3.49137, 0, 0, 0.984746, -0.174, 300, 0, 1), -- Burning Steppes | |
| (@OGUID+17, 181302, 0, 1, 1, -7594.62, -2076.47, 126.604, 3.71993, 0, 0, 0.958482, -0.285154, 300, 0, 1), | |
| (@OGUID+18, 181355, 0, 1, 1, -6685.84, -2205.18, 249.466, 3.56287, 0, 0, 0.977897, -0.209085, 300, 0, 1),-- Badlands | |
| (@OGUID+19, 181355, 0, 1, 1, -6685.35, -2190.66, 247.391, 4.19511, 0, 0, 0.864441, -0.502734, 300, 0, 1), | |
| (@OGUID+20, 181355, 0, 1, 1, -6710.1, -2202.15, 248.991, 6.13819, 0, 0, 0.0724366, -0.997373, 300, 0, 1), | |
| (@OGUID+21, 188021, 0, 1, 1, -140.643, -811.518, 55.3504, 2.31117, 0, 0, 0.915031, 0.403384, 300, 0, 1),-- Hillsbrad Foothills | |
| (@OGUID+22, 188021, 530, 1, 1, -2238.65, -11884.9, 27.2942, 5.0887, 0, 0, 0.562366, -0.826888, 300, 0, 1),-- Bloodmyst Isle | |
| (@OGUID+23, 181355, 530, 1, 1, -2247.36, -11891.2, 27.273, 5.12561, 0, 0, 0.547009, -0.837127, 300, 0, 1), | |
| (@OGUID+24, 181376, 530, 1, 1, -2254.78, -11896.3, 27.4979, 5.24028, 0, 0, 0.498141, -0.867096, 300, 0, 1), | |
| (@OGUID+25, 187921, 530, 1, 1, -2254.78, -11896.3, 27.4979, 5.24028, 0, 0, 0.498141, -0.867096, 300, 0, 1), | |
| (@OGUID+26, 181355, 530, 1, 1, -2263.35, -11897.7, 27.4214, 4.9112, 0, 0, 0.633442, -0.77379, 300, 0, 1), | |
| (@OGUID+27, 188020, 530, 1, 1, -2267.6, -11910.3, 26.5801, 3.82107, 0, 0, 0.942842, -0.333239, 300, 0, 1), | |
| (@OGUID+28, 181305, 530, 1, 1, -2234.49, -11884.7, 29.2704, 2.36494, 0, 0, 0.925544, 0.378641, 300, 0, 1), | |
| (@OGUID+29, 181307, 530, 1, 1, -2233.15, -11884.7, 30.2608, 3.17861, 0, 0, 0.999829, -0.0185081, 300, 0, 1), | |
| (@OGUID+30, 181605, 530, 1, 1, -2232.01, -11915.4, 26.5822, 1.82694, 0, 0, 0.791628, 0.611003, 300, 0, 1), | |
| (@OGUID+31, 188020, 530, 1, 1, -2246.85, -11930.2, 27.0976, 3.92552, 0, 0, 0.92416, -0.382005, 300, 0, 1), | |
| (@OGUID+32, 181355, 530, 1, 1, -2229.91, -11931.1, 29.9614, 2.41049, 0, 0, 0.933927, 0.357465, 300, 0, 1), | |
| (@OGUID+33, 188020, 530, 1, 1, -2206.14, -11905.5, 29.0653, 0.581295, 0, 0, 0.286573, 0.958058, 300, 0, 1), | |
| (@OGUID+34, 188020, 530, 1, 1, -2218.01, -11884.8, 29.2497, 3.56425, 0, 0, 0.977754, -0.209757, 300, 0, 1), | |
| (@OGUID+35, 181355, 530, 1, 1, -2207.24, -11920.6, 31.7791, 1.97971, 0, 0, 0.835947, 0.548811, 300, 0, 1), | |
| (@OGUID+36, 181355, 530, 1, 1, -2224.91, -11879.8, 29.7914, 1.97971, 0, 0, 0.835947, 0.548811, 300, 0, 1), | |
| (@OGUID+37, 181302, 530, 1, 1, -2243.58, -11886.5, 28.3418, 0.455247, 0, 0, 0.225663, 0.974205, 300, 0, 1), | |
| (@OGUID+38, 181302, 530, 1, 1, -2241.55, -11887.8, 28.4584, 1.37809, 0, 0, 0.635801, 0.771853, 300, 0, 1), | |
| (@OGUID+39, 181306, 530, 1, 1, -2243.06, -11888.3, 28.1292, 1.35453, 0, 0, 0.626664, 0.77929, 300, 0, 1); | |
| DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID AND @CGUID+31; | |
| INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES | |
| (@CGUID, 16781, 1, 1, 1, 16446, 0, -2336.91, -619.347, -7.48957, 1.3426, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Mulgore | |
| (@CGUID+1, 16781, 1, 1, 1, 16438, 0, -2333.01, -607.47, -8.5825, 4.26458, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+2, 16781, 1, 1, 1, 16445, 0, -2336.15, -605.978, -8.47793, 5.03898, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+3, 16781, 1, 1, 1, 16438, 0, -2336.28, -611.022, -8.02869, 1.1973, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+4, 25994, 1, 1, 1, 23789, 1, -2344.99, -615.533, -7.06313, 0.976602, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+5, 16781, 0, 1, 1, 21083, 0, -8255.11, -2614.33, 133.154, 0.508745, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Burning Steppes | |
| (@CGUID+6, 16781, 0, 1, 1, 16413, 0, -8253.26, -2611.61, 133.154, 4.93446, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+7, 16781, 0, 1, 1, 16412, 0, -8262.75, -2643.66, 133.39, 5.27218, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+8, 16781, 0, 1, 1, 16435, 0, -8259.55, -2650.01, 133.476, 2.09132, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+9, 25962, 0, 1, 1, 23791, 0, -8245.74, -2607.85, 133.155, 3.51183, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+10, 25962, 0, 1, 1, 23791, 0, 992.05, -1438.97, 64.3942, 5.22073, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Western Plaguelands | |
| (@CGUID+11, 16781, 0, 1, 1, 16435, 0, 989.633, -1444.97, 63.2034, 0.579809, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+12, 16781, 0, 1, 1, 16447, 0, 1003.8, -1434.55, 63.5274, 3.86513, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+13, 16781, 0, 1, 1, 16412, 0, 997.675, -1428.17, 65.905, 4.35443, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+14, 16781, 0, 1, 1, 16431, 0, 1007.68, -1441.76, 62.6307, 2.69567, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+15, 25909, 0, 1, 1, 16339, 0, 1002.08, -1454.41, 61.1954, 5.05265, 300, 0, 0, 42, 0, 0, 0, 0, 0), | |
| (@CGUID+16, 16781, 530, 1, 1, 16414, 0, -2227.85, -11887.9, 28.3225, 4.4168, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Bloodmyst Isle | |
| (@CGUID+17, 16781, 530, 1, 1, 16434, 0, -2230.5, -11891.1, 27.6743, 0.651601, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+18, 16781, 530, 1, 1, 16412, 0, -2246.13, -11921, 25.4183, 6.15017, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+19, 16781, 530, 1, 1, 21083, 0, -2240.57, -11922.3, 26.6757, 2.72819, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+20, 25962, 530, 1, 1, 23791, 0, -2224.37, -11912.7, 26.95, 2.63237, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+21, 25962, 1, 1, 1, 23791, 0, -4426.59, 3463.45, 14.9376, 6.14436, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Feralas | |
| (@CGUID+22, 16781, 1, 1, 1, 16433, 0, -4406.22, 3458.47, 13.1618, 2.99649, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+23, 16781, 1, 1, 1, 16447, 0, -4408.65, 3454.41, 14.0291, 1.02042, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+24, 16781, 1, 1, 1, 16414, 0, -4411.13, 3457.27, 13.6321, 6.03912, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+25, 16781, 1, 1, 1, 16413, 0, -4417.18, 3487.8, 12.7708, 5.29378, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+26, 16781, 530, 1, 1, 16413, 0, -4204.91, -12289.1, 1.57936, 1.63705, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Azuremyst Isle | |
| (@CGUID+27, 16781, 530, 1, 1, 16412, 0, -4205.15, -12284.2, 2.51655, 4.81948, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+28, 16781, 530, 1, 1, 21084, 0, -4204.2, -12322.9, 2.18588, 1.49174, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+29, 16781, 530, 1, 1, 16433, 0, -4204.16, -12316.3, 1.96402, 4.73543, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+30, 16781, 530, 1, 1, 16448, 0, -4194.72, -12303.8, 0.665216, 3.58718, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+31, 25962, 530, 1, 1, 23791, 0, -4189.94, -12310.1, -0.885672, 3.28087, 300, 0, 0, 1524, 0, 0, 0, 0, 0); | |
| -- Outland Horde | |
| DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+40 AND @OGUID+73; | |
| INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES | |
| (@OGUID+40, 188021, 530, 1, 1, -3065.99, 2385.69, 62.3736, 2.08047, 0, 0, 0.862523, 0.506019, 300, 0, 1), -- Shadowmoon Valley | |
| (@OGUID+41, 188020, 530, 1, 1, -3045.07, 2384.62, 62.3369, 3.34888, 0, 0, 0.994634, -0.10346, 300, 0, 1), | |
| (@OGUID+42, 181605, 530, 1, 1, -3045.53, 2393.71, 61.5344, 3.48476, 0, 0, 0.985316, -0.170741, 300, 0, 1), | |
| (@OGUID+43, 181355, 530, 1, 1, -3051.54, 2384.15, 62.8406, 3.5845, 0, 0, 0.975579, -0.21965, 300, 0, 1), | |
| (@OGUID+44, 181376, 530, 1, 1, -3059.17, 2374.85, 65.1011, 2.03334, 0, 0, 0.850361, 0.526199, 300, 0, 1), | |
| (@OGUID+45, 187967, 530, 1, 1, -3059.17, 2374.85, 63.1011, 2.03334, 0, 0, 0.850361, 0.526199, 300, 0, 1), | |
| (@OGUID+46, 188020, 530, 1, 1, -3082.82, 2371.64, 62.3845, 0.325101, 0, 0, 0.161836, 0.986818, 300, 0, 1), | |
| (@OGUID+47, 181305, 530, 1, 1, -3067.53, 2387.47, 62.1022, 2.2666, 0, 0, 0.905816, 0.423671, 300, 0, 1), | |
| (@OGUID+48, 181307, 530, 1, 1, -3066.21, 2387.82, 63.0923, 2.58076, 0, 0, 0.96094, 0.276755, 300, 0, 1), | |
| (@OGUID+49, 181306, 530, 1, 1, -3061.06, 2385.06, 62.9053, 3.68032, 0, 0, 0.963941, -0.266117, 300, 0, 1), | |
| (@OGUID+50, 181302, 530, 1, 1, -3062.49, 2384.41, 62.8574, 3.88531, 0, 0, 0.931654, -0.363346, 300, 0, 1), | |
| (@OGUID+51, 181302, 530, 1, 1, -3062.11, 2386.29, 62.7605, 3.23892, 0, 0, 0.998816, -0.0486467, 300, 0, 1), | |
| (@OGUID+52, 181355, 530, 1, 1, -3083.01, 2388.64, 62.5579, 5.67117, 0, 0, 0.301252, -0.953545, 300, 0, 1), | |
| (@OGUID+53, 181355, 530, 1, 1, -3075.49, 2375.19, 61.7323, 5.22193, 0, 0, 0.506076, -0.862489, 300, 0, 1), | |
| (@OGUID+54, 181355, 530, 1, 1, -3065.87, 2401.47, 61.8687, 5.24138, 0, 0, 0.497663, -0.86737, 300, 0, 1), | |
| (@OGUID+55, 188020, 530, 1, 1, -3088.61, 2389.5, 61.8999, 0.53056, 0, 0, 0.26218, 0.965019, 300, 0, 1), | |
| (@OGUID+56, 188020, 530, 1, 1, -3062.43, 2404.35, 61.4089, 3.57398, 0, 0, 0.976721, -0.214514, 300, 0, 1), | |
| (@OGUID+57, 188021, 530, 1, 1, 2930.82, 3700.62, 143.562, 2.68546, 0, 0, 0.974105, 0.226094, 300, 0, 1),-- Netherstorm | |
| (@OGUID+58, 188020, 530, 1, 1, 2939, 3710.42, 143.775, 5.91502, 0, 0, 0.183045, -0.983104, 300, 0, 1), | |
| (@OGUID+59, 188020, 530, 1, 1, 2929.71, 3714.03, 144.258, 5.84826, 0, 0, 0.215752, -0.976448, 300, 0, 1), | |
| (@OGUID+60, 188020, 530, 1, 1, 2926.49, 3680.92, 143.656, 5.85611, 0, 0, 0.211916, -0.977288, 300, 0, 1), | |
| (@OGUID+61, 188020, 530, 1, 1, 2914.81, 3686.23, 144.3, 5.85611, 0, 0, 0.211916, -0.977288, 300, 0, 1), | |
| (@OGUID+62, 181355, 530, 1, 1, 2916.61, 3688.95, 144.099, 5.95036, 0, 0, 0.165644, -0.986186, 300, 0, 1), | |
| (@OGUID+63, 181355, 530, 1, 1, 2936.48, 3709.34, 143.92, 1.22619, 0, 0, 0.575402, 0.817871, 300, 0, 1), | |
| (@OGUID+64, 181355, 530, 1, 1, 2930.48, 3712.12, 144.464, 5.82155, 0, 0, 0.228773, -0.97348, 300, 0, 1), | |
| (@OGUID+65, 181355, 530, 1, 1, 2924.86, 3684.41, 143.645, 5.79079, 0, 0, 0.243717, -0.969846, 300, 0, 1), | |
| (@OGUID+66, 181376, 530, 1, 1, 2921.26, 3690.47, 145.838, 5.94709, 0, 0, 0.167258, -0.985913, 300, 0, 1), | |
| (@OGUID+67, 187949, 530, 1, 1, 2922.17, 3690.15, 143.809, 5.94709, 0, 0, 0.167258, -0.985913, 300, 0, 1), | |
| (@OGUID+68, 181605, 530, 1, 1, 2917.63, 3677.32, 144.166, 1.11217, 0, 0, 0.527867, 0.849327, 300, 0, 1), | |
| (@OGUID+69, 181305, 530, 1, 1, 2929.17, 3694.77, 143.652, 3.48177, 0, 0, 0.98557, -0.169269, 300, 0, 1), | |
| (@OGUID+70, 181307, 530, 1, 1, 2927.52, 3695.79, 144.646, 6.06337, 0, 0, 0.109686, -0.993966, 300, 0, 1), | |
| (@OGUID+71, 181302, 530, 1, 1, 2934.2, 3699.41, 143.281, 5.29132, 0, 0, 0.475852, -0.879525, 300, 0, 1), | |
| (@OGUID+72, 181302, 530, 1, 1, 2932.66, 3699.09, 143.42, 3.97499, 0, 0, 0.91443, -0.404745, 300, 0, 1), | |
| (@OGUID+73, 181306, 530, 1, 1, 2933.35, 3701.68, 143.353, 4.69363, 0, 0, 0.713707, -0.700444, 300, 0, 1); | |
| DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+32 AND @CGUID+47; | |
| INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES | |
| (@CGUID+32, 16781, 530, 1, 1, 21085, 0, -3061.44, 2392.12, 62.0978, 0.0381287, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Shadowmoon Valley | |
| (@CGUID+33, 16781, 530, 1, 1, 16438, 0, -3058.96, 2387.94, 62.7011, 1.21073, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+34, 16781, 530, 1, 1, 16443, 0, -3055.48, 2394.64, 61.4168, 3.79155, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+35, 16781, 530, 1, 1, 16432, 0, -3047.02, 2383.16, 62.5462, 2.35427, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+36, 25994, 530, 1, 1, 23789, 1, -3050.94, 2390.53, 61.9839, 0.536069, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+37, 16781, 530, 1, 1, 16444, 0, 2269.74, 6134.05, 137.055, 6.04866, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Blade's Edge | |
| (@CGUID+38, 16781, 530, 1, 1, 16442, 0, 2271.41, 6128.35, 137.214, 0.679679, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+39, 16781, 530, 1, 1, 21085, 0, 2271.34, 6158.77, 138.457, 0.683606, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+40, 16781, 530, 1, 1, 16436, 0, 2300.8, 6167.7, 136.322, 5.55072, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+41, 16781, 530, 1, 1, 21086, 0, 2304.68, 6161.6, 134.924, 1.72976, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+42, 25994, 530, 1, 1, 23789, 1, 2279.56, 6162.76, 137.703, 0.112621, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+43, 16781, 530, 1, 1, 16432, 0, 2933.41, 3708.45, 144.048, 5.94399, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Netherstorm | |
| (@CGUID+44, 16781, 530, 1, 1, 16431, 0, 2935.32, 3705.25, 143.374, 1.8505, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+45, 16781, 530, 1, 1, 16442, 0, 2917.5, 3683.52, 144.197, 0.0558533, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+46, 16781, 530, 1, 1, 16436, 0, 2922.56, 3684.94, 143.823, 3.96478, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+47, 25994, 530, 1, 1, 23789, 1, 2919.92, 3676.76, 144.123, 1.41695, 300, 0, 0, 1651, 0, 0, 0, 0, 0); | |
| -- Outland Alliance | |
| DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+74 AND @OGUID+142; | |
| INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES | |
| (@OGUID+74, 188020, 530, 1, 1, 3124.32, 3767.21, 141.72, 6.15712, 0, 0, 0.0629915, -0.998014, 300, 0, 1),-- Netherstorm | |
| (@OGUID+75, 188020, 530, 1, 1, 3118.47, 3768.31, 142, 5.99611, 0, 0, 0.143044, -0.989716, 300, 0, 1), | |
| (@OGUID+76, 188020, 530, 1, 1, 3128.04, 3723.67, 142.125, 3.6241, 0, 0, 0.971039, -0.238921, 300, 0, 1), | |
| (@OGUID+77, 181355, 530, 1, 1, 3129.41, 3728.35, 141.836, 3.15679, 0, 0, 0.999971, -0.00759801, 300, 0, 1), | |
| (@OGUID+78, 181355, 530, 1, 1, 3118.56, 3728.18, 145.543, 3.26674, 0, 0, 0.998043, -0.0625352, 300, 0, 1), | |
| (@OGUID+79, 181355, 530, 1, 1, 3106.03, 3725.62, 144.981, 3.3335, 0, 0, 0.9954, -0.0958082, 300, 0, 1), | |
| (@OGUID+80, 181605, 530, 1, 1, 3113, 3717.87, 144.699, 1.34645, 0, 0, 0.62351, 0.781815, 300, 0, 1), | |
| (@OGUID+81, 181302, 530, 1, 1, 3119, 3742.2, 142.069, 1.01658, 0, 0, 0.486685, 0.873577, 300, 0, 1), | |
| (@OGUID+82, 181302, 530, 1, 1, 3120.72, 3741.49, 141.941, 1.31503, 0, 0, 0.611153, 0.791512, 300, 0, 1), | |
| (@OGUID+83, 181306, 530, 1, 1, 3119.22, 3739.92, 141.977, 1.78627, 0, 0, 0.779042, 0.626972, 300, 0, 1), | |
| (@OGUID+84, 181376, 530, 1, 1, 3121.5, 3753.88, 141.851, 5.85856, 0, 0, 0.21072, -0.977546, 300, 0, 1), | |
| (@OGUID+85, 187942, 530, 1, 1, 3121.5, 3753.88, 141.851, 5.85856, 0, 0, 0.21072, -0.977546, 300, 0, 1), | |
| (@OGUID+86, 188021, 530, 1, 1, 3124.08, 3743.19, 141.84, 0.373246, 0, 0, 0.185542, 0.982636, 300, 0, 1), | |
| (@OGUID+87, 188021, 530, 1, 1, -2518.07, 7554.87, -1.84913, 5.25355, 0, 0, 0.492375, -0.870383, 300, 0, 1),-- Nagrand | |
| (@OGUID+88, 188020, 530, 1, 1, -2503.95, 7557.49, -1.08408, 5.53944, 0, 0, 0.363359, -0.931649, 300, 0, 1), | |
| (@OGUID+89, 181355, 530, 1, 1, -2508.99, 7559.45, -1.49399, 5.21507, 0, 0, 0.509029, -0.860749, 300, 0, 1), | |
| (@OGUID+90, 181305, 530, 1, 1, -2514.58, 7556.29, -1.9083, 3.55317, 0, 0, 0.9789, -0.204338, 300, 0, 1), | |
| (@OGUID+91, 181307, 530, 1, 1, -2514.36, 7557.85, -0.918236, 4.60717, 0, 0, 0.743311, -0.668946, 300, 0, 1), | |
| (@OGUID+92, 181302, 530, 1, 1, -2521.68, 7558.76, -1.93354, 5.38786, 0, 0, 0.43286, -0.901461, 300, 0, 1), | |
| (@OGUID+93, 181302, 530, 1, 1, -2520.13, 7560.14, -1.93178, 4.59147, 0, 0, 0.748542, -0.663088, 300, 0, 1), | |
| (@OGUID+94, 181306, 530, 1, 1, -2519.97, 7558.77, -1.99031, 3.1212, 0, 0, 0.999948, 0.0101965, 300, 0, 1), | |
| (@OGUID+95, 188020, 530, 1, 1, -2528.76, 7534.67, -0.445196, 5.47583, 0, 0, 0.392805, -0.919622, 300, 0, 1), | |
| (@OGUID+96, 181355, 530, 1, 1, -2530.75, 7540.66, -2.24676, 5.41692, 0, 0, 0.419715, -0.907656, 300, 0, 1), | |
| (@OGUID+97, 181376, 530, 1, 1, -2526.69, 7548.83, -2.23534, 5.32817, 0, 0, 0.459565, -0.888144, 300, 0, 1), | |
| (@OGUID+98, 187933, 530, 1, 1, -2526.69, 7548.83, -2.23534, 5.32817, 0, 0, 0.459565, -0.888144, 300, 0, 1), | |
| (@OGUID+99, 188020, 530, 1, 1, -2511.48, 7518.87, -1.20825, 2.42299, 0, 0, 0.936142, 0.351621, 300, 0, 1), | |
| (@OGUID+100, 181355, 530, 1, 1, -2506.01, 7514.91, -3.26091, 2.33267, 0, 0, 0.919314, 0.393525, 300, 0, 1), | |
| (@OGUID+101, 181355, 530, 1, 1, -2485.85, 7534.2, -1.6549, 2.33267, 0, 0, 0.919314, 0.393525, 300, 0, 1), | |
| (@OGUID+102, 188020, 530, 1, 1, -2489.07, 7542.57, -0.865097, 2.31931, 0, 0, 0.916666, 0.399654, 300, 0, 1), | |
| (@OGUID+103, 181605, 530, 1, 1, -2502.95, 7522.09, -2.46418, 2.29811, 0, 0, 0.912378, 0.40935, 300, 0, 1), | |
| (@OGUID+104, 188021, 530, 1, 1, -3953.72, 2048.88, 95.0652, 4.6418, 0, 0, 0.731618, -0.681714, 300, 0, 1),-- Shadowmoon Valley | |
| (@OGUID+105, 181376, 530, 1, 1, -3941.98, 2048.49, 95.0656, 4.87742, 0, 0, 0.646421, -0.762981, 300, 0, 1), | |
| (@OGUID+106, 187935, 530, 1, 1, -3941.98, 2048.49, 95.0656, 4.87742, 0, 0, 0.646421, -0.762981, 300, 0, 1), | |
| (@OGUID+107, 181355, 530, 1, 1, -3959.23, 2040.55, 95.0649, 1.26694, 0, 0, 0.591944, 0.805979, 300, 0, 1), | |
| (@OGUID+108, 181605, 530, 1, 1, -3965.24, 2039.3, 95.0659, 1.35098, 0, 0, 0.625278, 0.780402, 300, 0, 1), | |
| (@OGUID+109, 188020, 530, 1, 1, -3951.26, 2032.03, 95.1979, 1.40988, 0, 0, 0.647988, 0.761651, 300, 0, 1), | |
| (@OGUID+110, 181355, 530, 1, 1, -3947.07, 2032.04, 96.8815, 1.47585, 0, 0, 0.672754, 0.739866, 300, 0, 1), | |
| (@OGUID+111, 188020, 530, 1, 1, -3932.45, 2051.71, 95.072, 0.10612, 0, 0, 0.0530353, 0.998593, 300, 0, 1), | |
| (@OGUID+112, 188020, 530, 1, 1, -3931.76, 2044.1, 95.1721, 6.1741, 0, 0, 0.054514, -0.998513, 300, 0, 1), | |
| (@OGUID+113, 181305, 530, 1, 1, -3951.84, 2053.02, 95.0649, 4.37555, 0, 0, 0.815632, -0.578571, 300, 0, 1), | |
| (@OGUID+114, 181307, 530, 1, 1, -3953.39, 2052.79, 96.0565, 0.143821, 0, 0, 0.0718485, 0.997416, 300, 0, 1), | |
| (@OGUID+115, 181302, 530, 1, 1, -3956.31, 2051.68, 95.0653, 4.80752, 0, 0, 0.672688, -0.739927, 300, 0, 1), | |
| (@OGUID+116, 181302, 530, 1, 1, -3956.72, 2051.26, 96.3085, 0.346454, 0, 0, 0.172362, 0.985034, 300, 0, 1), | |
| (@OGUID+117, 181306, 530, 1, 1, -3958.88, 2051.04, 95.0648, 6.24637, 0, 0, 0.0184091, -0.999831, 300, 0, 1), | |
| (@OGUID+118, 188021, 530, 1, 1, 192.163, 6006.97, 22.1, 6.08217, 0, 0, 0.100341, -0.994953, 300, 0, 1),-- Zangarmarsh | |
| (@OGUID+119, 181376, 530, 1, 1, 194.982, 6019.23, 21.9713, 6.05151, 0, 0, 0.115576, -0.993299, 300, 0, 1), | |
| (@OGUID+120, 187941, 530, 1, 1, 192.209, 6015.13, 22.1067, 0.00709009, 0, 0, 0.00354504, 0.999994, 300, 0, 1), | |
| (@OGUID+121, 188020, 530, 1, 1, 179.856, 6024.08, 22.3978, 3.98117, 0, 0, 0.913175, -0.407568, 300, 0, 1), | |
| (@OGUID+122, 181355, 530, 1, 1, 182.649, 6013.91, 22.7399, 3.85237, 0, 0, 0.937511, -0.347954, 300, 0, 1), | |
| (@OGUID+123, 181305, 530, 1, 1, 191.325, 6003.18, 24.2265, 1.22679, 0, 0, 0.575647, 0.817698, 300, 0, 1), | |
| (@OGUID+124, 181307, 530, 1, 1, 190.107, 6002.77, 25.2167, 1.22679, 0, 0, 0.575647, 0.817698, 300, 0, 1), | |
| (@OGUID+125, 181302, 530, 1, 1, 187.76, 6009.34, 23.9554, 6.21407, 0, 0, 0.0345506, -0.999403, 300, 0, 1), | |
| (@OGUID+126, 181302, 530, 1, 1, 187.695, 6007.28, 24.1424, 0.567843, 0, 0, 0.280122, 0.959964, 300, 0, 1), | |
| (@OGUID+127, 181306, 530, 1, 1, 190.136, 6008.65, 23.9259, 4.04009, 0, 0, 0.900774, -0.434289, 300, 0, 1), | |
| (@OGUID+128, 181355, 530, 1, 1, 199.014, 6031.23, 20.5566, 3.50209, 0, 0, 0.983799, -0.179273, 300, 0, 1), | |
| (@OGUID+129, 188020, 530, 1, 1, 201.225, 6033.47, 20.1022, 3.0819, 0, 0, 0.999555, 0.0298411, 300, 0, 1), | |
| (@OGUID+130, 188020, 530, 1, 1, 201.553, 5989.88, 20.7907, 3.02849, 0, 0, 0.998401, 0.0565203, 300, 0, 1), | |
| (@OGUID+131, 181355, 530, 1, 1, 199.671, 5991.72, 21.7141, 0.161778, 0, 0, 0.0808006, 0.99673, 300, 0, 1), | |
| (@OGUID+132, 181605, 530, 1, 1, 188.262, 5991.39, 23.7141, 3.08425, 0, 0, 0.999589, 0.0286686, 300, 0, 1), | |
| (@OGUID+133, 188020, 530, 1, 1, 177.593, 5991.78, 22.1575, 6.11588, 0, 0, 0.0835527, -0.996503, 300, 0, 1), | |
| (@OGUID+134, 181355, 530, 1, 1, 180.409, 5994.73, 22.8062, 5.91168, 0, 0, 0.184688, -0.982797, 300, 0, 1), | |
| (@OGUID+135, 188021, 530, 1, 1, -3005.53, 4160.88, 4.18469, 0.149162, 0, 0, 0.0745119, 0.99722, 300, 0, 1),-- Terokkar | |
| (@OGUID+136, 181376, 530, 1, 1, -3004.07, 4152.48, 3.64988, 1.75455, 0, 0, 0.769001, 0.639247, 300, 0, 1), | |
| (@OGUID+137, 187937, 530, 1, 1, -3004.07, 4152.48, 3.64988, 1.75455, 0, 0, 0.769001, 0.639247, 300, 0, 1), | |
| (@OGUID+138, 188020, 530, 1, 1, -3007.02, 4177.26, 4.07658, 4.79326, 0, 0, 0.677945, -0.735112, 300, 0, 1), | |
| (@OGUID+139, 181355, 530, 1, 1, -3006.14, 4169.56, 3.93771, 6.15906, 0, 0, 0.0620252, -0.998075, 300, 0, 1), | |
| (@OGUID+140, 181355, 530, 1, 1, -3000.22, 4138.67, 2.05751, 1.71684, 0, 0, 0.756811, 0.653634, 300, 0, 1), | |
| (@OGUID+141, 188020, 530, 1, 1, -2996.65, 4116.85, 4.33362, 1.75611, 0, 0, 0.769498, 0.638649, 300, 0, 1), | |
| (@OGUID+142, 181605, 530, 1, 1, -2988.84, 4126.66, 4.88284, 3.26329, 0, 0, 0.998149, -0.0608107, 300, 0, 1); | |
| DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+48 AND @CGUID+76; | |
| INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES | |
| (@CGUID+48, 16781, 530, 1, 1, 21084, 0, 3105.5, 3720.48, 144.815, 0.250816, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Netherstorm | |
| (@CGUID+49, 16781, 530, 1, 1, 16435, 0, 3115.55, 3726.49, 145.316, 4.10869, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+50, 16781, 530, 1, 1, 16447, 0, 3120.66, 3721, 145.281, 2.74995, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+51, 16781, 530, 1, 1, 16412, 0, 3125.3, 3727.87, 142.621, 5.58132, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+52, 25962, 530, 1, 1, 23791, 0, 3106.88, 3712.88, 144.328, 0.980452, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+53, 16781, 530, 1, 1, 16412, 0, -2504.03, 7528.3, -0.64438, 0.776008, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Nagrand | |
| (@CGUID+54, 16781, 530, 1, 1, 16447, 0, -2500.29, 7532.45, -0.97989, 2.51488, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+55, 16781, 530, 1, 1, 16413, 0, -2507.02, 7550.21, -0.997479, 1.49936, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+56, 16781, 530, 1, 1, 16431, 0, -2508.9, 7555.52, -1.63478, 4.96375, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+57, 25962, 530, 1, 1, 23791, 0, -2488.89, 7531.11, -2.0437, 2.29261, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+58, 16781, 530, 1, 1, 16431, 0, -3965.57, 2049.6, 95.0651, 0.431277, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Shadowmoon Valley | |
| (@CGUID+59, 16781, 530, 1, 1, 21084, 0, -3960.94, 2053.54, 95.0651, 3.89645, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+60, 16781, 530, 1, 1, 16434, 0, -3972.67, 2034.69, 95.0653, 0.376299, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+61, 16781, 530, 1, 1, 16447, 0, -3968.36, 2038.44, 95.0653, 3.94672, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+62, 25962, 530, 1, 1, 23791, 0, -3962.59, 2045.64, 95.0653, 4.66928, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+63, 16781, 530, 1, 1, 16434, 0, 183.656, 6001.85, 23.9098, 5.76245, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Zangarmarsh | |
| (@CGUID+64, 16781, 530, 1, 1, 16433, 0, 183.666, 5998.61, 23.7887, 1.12075, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+65, 16781, 530, 1, 1, 16435, 0, 181.842, 5991.56, 22.9939, 0.808944, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+66, 16781, 530, 1, 1, 16433, 0, 184.16, 5995.16, 23.7236, 4.20658, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+67, 25962, 530, 1, 1, 23791, 0, 191.919, 5998.19, 24.2443, 4.56315, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+68, 25962, 530, 1, 1, 23791, 0, 2050.24, 6603.09, 138.073, 3.04753, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Blade's Edge | |
| (@CGUID+69, 16781, 530, 1, 1, 16412, 0, 2048.81, 6582.75, 135.962, 2.2637, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+70, 16781, 530, 1, 1, 16434, 0, 2044.15, 6588.86, 135.588, 5.3888, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+71, 16781, 530, 1, 1, 16448, 0, 2035.12, 6612.1, 138.394, 1.97939, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+72, 16781, 530, 1, 1, 16433, 0, 2031.53, 6616.98, 138.934, 5.30162, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+73, 25962, 530, 1, 1, 23791, 0, -2986.96, 4130.72, 5.04767, 2.64597, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Terokkar | |
| (@CGUID+74, 16781, 530, 1, 1, 16448, 0, -2999.23, 4136.4, 2.31857, 4.96681, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+75, 16781, 530, 1, 1, 16434, 0, -2997.71, 4131.23, 3.04313, 1.92339, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+76, 16781, 530, 1, 1, 16442, 0, -2992.17, 4134.37, 3.88179, 3.20281, 300, 0, 0, 1524, 0, 0, 0, 0, 0); | |
| -- Northrend Horde | |
| DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+143 AND @OGUID+268; | |
| INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES | |
| (@OGUID+143, 188021, 571, 1, 1, 4454.99, 5625.29, 56.8959, 4.29074, 0, 0, 0.839423, -0.543479, 300, 0, 1),-- Borean Tundra | |
| (@OGUID+144, 188020, 571, 1, 1, 4425.93, 5623.18, 54.1981, 1.06747, 0, 0, 0.508751, 0.860913, 300, 0, 1), | |
| (@OGUID+145, 188020, 571, 1, 1, 4438.21, 5646.36, 59.8882, 4.28367, 0, 0, 0.841339, -0.540508, 300, 0, 1), | |
| (@OGUID+146, 188020, 571, 1, 1, 4476.71, 5632.46, 60.6755, 4.46182, 0, 0, 0.789922, -0.613208, 300, 0, 1), | |
| (@OGUID+147, 188020, 571, 1, 1, 4470.92, 5609.85, 56.8847, 4.46182, 0, 0, 0.789922, -0.613208, 300, 0, 1), | |
| (@OGUID+148, 181605, 571, 1, 1, 4470.25, 5621.62, 58.661, 1.19849, 0, 0, 0.56402, 0.825761, 300, 0, 1), | |
| (@OGUID+149, 181355, 571, 1, 1, 4472.86, 5630.19, 59.8352, 4.29296, 0, 0, 0.838819, -0.54441, 300, 0, 1), | |
| (@OGUID+150, 181355, 571, 1, 1, 4468.37, 5613.21, 57.1389, 1.30374, 0, 0, 0.606674, 0.794951, 300, 0, 1), | |
| (@OGUID+151, 181355, 571, 1, 1, 4429.57, 5625.52, 54.9768, 1.37443, 0, 0, 0.634385, 0.773017, 300, 0, 1), | |
| (@OGUID+152, 181355, 571, 1, 1, 4438.18, 5641.68, 58.4478, 1.00136, 0, 0, 0.480023, 0.877256, 300, 0, 1), | |
| (@OGUID+153, 194033, 571, 1, 1, 4441.05, 5627.71, 56.3487, 4.54665, 0, 0, 0.763211, -0.646149, 300, 0, 1), | |
| (@OGUID+154, 181376, 571, 1, 1, 4441.05, 5627.71, 58.3487, 4.69194, 0, 0, 0.714298, -0.699841, 300, 0, 1), | |
| (@OGUID+155, 181305, 571, 1, 1, 4457.34, 5627.04, 57.2747, 0.298436, 0, 0, 0.148665, 0.988888, 300, 0, 1), | |
| (@OGUID+156, 181307, 571, 1, 1, 4457.69, 5628.67, 58.2895, 4.7218, 0, 0, 0.703772, -0.710426, 300, 0, 1), | |
| (@OGUID+157, 181302, 571, 1, 1, 4450.11, 5628.14, 56.7657, 1.65482, 0, 0, 0.73618, 0.676786, 300, 0, 1), | |
| (@OGUID+158, 181302, 571, 1, 1, 4451.86, 5626.77, 56.7422, 0.725691, 0, 0, 0.354936, 0.934891, 300, 0, 1), | |
| (@OGUID+159, 181306, 571, 1, 1, 4450.1, 5626.02, 56.6652, 1.32259, 0, 0, 0.614141, 0.789196, 300, 0, 1), | |
| (@OGUID+160, 188021, 571, 1, 1, 3776.27, 1479.31, 91.7672, 3.0495, 0, 0, 0.99894, 0.0460317, 300, 0, 1),-- Dragonblight | |
| (@OGUID+161, 188020, 571, 1, 1, 3773.6, 1491.79, 90.9616, 4.7656, 0, 0, 0.688046, -0.725667, 300, 0, 1), | |
| (@OGUID+162, 188020, 571, 1, 1, 3779.89, 1492.12, 90.4649, 4.7656, 0, 0, 0.688046, -0.725667, 300, 0, 1), | |
| (@OGUID+163, 181355, 571, 1, 1, 3778.33, 1469.59, 92.0022, 4.64779, 0, 0, 0.729573, -0.683903, 300, 0, 1), | |
| (@OGUID+164, 181355, 571, 1, 1, 3771.26, 1470.33, 92.3044, 1.40802, 0, 0, 0.64728, 0.762252, 300, 0, 1), | |
| (@OGUID+165, 194037, 571, 1, 1, 3773.85, 1464.02, 92.4174, 6.10863, 0, 0, 0.087167, -0.996194, 300, 0, 1), | |
| (@OGUID+166, 181376, 571, 1, 1, 3773.85, 1464.02, 94.4174, 6.10863, 0, 0, 0.087167, -0.996194, 300, 0, 1), | |
| (@OGUID+167, 181305, 571, 1, 1, 3781.69, 1479.45, 91.1799, 3.55216, 0, 0, 0.979003, -0.203846, 300, 0, 1), | |
| (@OGUID+168, 181307, 571, 1, 1, 3781.29, 1478.05, 92.1919, 4.88734, 0, 0, 0.642628, -0.766178, 300, 0, 1), | |
| (@OGUID+169, 181302, 571, 1, 1, 3777.92, 1483, 91.6054, 3.43435, 0, 0, 0.989306, -0.145857, 300, 0, 1), | |
| (@OGUID+170, 181302, 571, 1, 1, 3776.35, 1482.86, 91.7922, 4.69099, 0, 0, 0.714632, -0.699501, 300, 0, 1), | |
| (@OGUID+171, 181306, 571, 1, 1, 3777.17, 1481, 91.7202, 2.13923, 0, 0, 0.877016, 0.480461, 300, 0, 1), | |
| (@OGUID+172, 181605, 571, 1, 1, 3776.57, 1488.67, 91.3695, 0.109765, 0, 0, 0.0548551, 0.998494, 300, 0, 1), | |
| (@OGUID+173, 181358, 571, 1, 1, 3807.96, 1478.17, 90.0332, 3.09271, 0, 0, 0.999701, 0.0244413, 300, 0, 1), | |
| (@OGUID+174, 188021, 571, 1, 1, 3367.71, -2126.35, 124.935, 0.20145, 0, 0, 0.100555, 0.994932, 300, 0, 1),-- Grizzly Hills | |
| (@OGUID+175, 188020, 571, 1, 1, 3378.53, -2152.36, 124.326, 1.7272, 0, 0, 0.760187, 0.649704, 300, 0, 1), | |
| (@OGUID+176, 188020, 571, 1, 1, 3364.78, -2153.98, 124.066, 1.67615, 0, 0, 0.743357, 0.668895, 300, 0, 1), | |
| (@OGUID+177, 188020, 571, 1, 1, 3368.13, -2094.44, 122.167, 4.85309, 0, 0, 0.655653, -0.755062, 300, 0, 1), | |
| (@OGUID+178, 188020, 571, 1, 1, 3358.46, -2095.84, 122.702, 4.85702, 0, 0, 0.65417, -0.756348, 300, 0, 1), | |
| (@OGUID+179, 181355, 571, 1, 1, 3360.44, -2102.71, 123.301, 4.93556, 0, 0, 0.623972, -0.781447, 300, 0, 1), | |
| (@OGUID+180, 181355, 571, 1, 1, 3366.44, -2142.59, 124.385, 0.12135, 0, 0, 0.060638, 0.99816, 300, 0, 1), | |
| (@OGUID+181, 181355, 571, 1, 1, 3372.23, -2141.88, 124.779, 0.12135, 0, 0, 0.060638, 0.99816, 300, 0, 1), | |
| (@OGUID+182, 181305, 571, 1, 1, 3368.46, -2120.32, 124.972, 4.52273, 0, 0, 0.770885, -0.636974, 300, 0, 1), | |
| (@OGUID+183, 181307, 571, 1, 1, 3367.51, -2120.73, 125.963, 0.112713, 0, 0, 0.0563269, 0.998412, 300, 0, 1), | |
| (@OGUID+184, 181302, 571, 1, 1, 3364.09, -2126.28, 124.594, 1.64817, 0, 0, 0.733926, 0.67923, 300, 0, 1), | |
| (@OGUID+185, 181302, 571, 1, 1, 3363.96, -2124.64, 124.71, 0.774805, 0, 0, 0.377785, 0.925894, 300, 0, 1), | |
| (@OGUID+186, 181306, 571, 1, 1, 3365.8, -2125.85, 124.807, 4.92171, 0, 0, 0.629368, -0.777107, 300, 0, 1), | |
| (@OGUID+187, 181355, 571, 1, 1, 3368.61, -2102.49, 122.991, 3.15926, 0, 0, 0.999961, -0.00883358, 300, 0, 1), | |
| (@OGUID+188, 181605, 571, 1, 1, 3370.82, -2150.59, 124.43, 1.7102, 0, 0, 0.754638, 0.656142, 300, 0, 1), | |
| (@OGUID+189, 194042, 571, 1, 1, 3368.48, -2135.25, 124.53, 0.20224, 0, 0, 0.100948, 0.994892, 300, 0, 1), | |
| (@OGUID+190, 181376, 571, 1, 1, 3366.29, -2135.71, 126.592, 0.275273, 0, 0, 0.137202, 0.990543, 300, 0, 1), | |
| (@OGUID+191, 188021, 571, 1, 1, 2598.68, -4341.88, 275.709, 4.15841, 0, 0, 0.873519, -0.48679, 300, 0, 1),-- Howling Fjord | |
| (@OGUID+192, 188020, 571, 1, 1, 2568.84, -4325.53, 277.908, 0.773361, 0, 0, 0.377116, 0.926166, 300, 0, 1), | |
| (@OGUID+193, 181355, 571, 1, 1, 2573.18, -4321.63, 277.706, 5.89809, 0, 0, 0.191362, -0.981519, 300, 0, 1), | |
| (@OGUID+194, 181355, 571, 1, 1, 2585.37, -4330.36, 276.802, 5.59728, 0, 0, 0.336267, -0.941767, 300, 0, 1), | |
| (@OGUID+195, 188020, 571, 1, 1, 2583.94, -4336.2, 275.877, 4.28332, 0, 0, 0.841436, -0.540357, 300, 0, 1), | |
| (@OGUID+196, 194039, 571, 1, 1, 2579.72, -4325.59, 276.934, 5.77529, 0, 0, 0.251227, -0.967928, 300, 0, 1), | |
| (@OGUID+197, 181376, 571, 1, 1, 2577.57, -4325.97, 278.995, 0.226445, 0, 0, 0.112981, 0.993597, 300, 0, 1), | |
| (@OGUID+198, 188020, 571, 1, 1, 2601.28, -4351.41, 275.622, 3.9414, 0, 0, 0.921098, -0.389331, 300, 0, 1), | |
| (@OGUID+199, 188020, 571, 1, 1, 2610.63, -4359.39, 276.012, 3.96889, 0, 0, 0.91566, -0.401954, 300, 0, 1), | |
| (@OGUID+200, 181355, 571, 1, 1, 2585.83, -4354.56, 276.176, 0.915263, 0, 0, 0.441825, 0.897101, 300, 0, 1), | |
| (@OGUID+201, 181355, 571, 1, 1, 2593.08, -4361.44, 275.514, 2.42794, 0, 0, 0.93701, 0.349302, 300, 0, 1), | |
| (@OGUID+202, 181605, 571, 1, 1, 2584.82, -4363.27, 275.305, 0.908194, 0, 0, 0.438651, 0.898658, 300, 0, 1), | |
| (@OGUID+203, 181302, 571, 1, 1, 2598.83, -4338.72, 276.13, 1.4619, 0, 0, 0.667577, 0.744541, 300, 0, 1), | |
| (@OGUID+204, 181302, 571, 1, 1, 2597, -4339.46, 275.976, 1.84439, 0, 0, 0.796929, 0.604073, 300, 0, 1), | |
| (@OGUID+205, 181306, 571, 1, 1, 2598.77, -4340.42, 275.851, 3.60996, 0, 0, 0.972704, -0.23205, 300, 0, 1), | |
| (@OGUID+206, 181305, 571, 1, 1, 2602.92, -4344.35, 275.756, 3.60446, 0, 0, 0.973338, -0.229375, 300, 0, 1), | |
| (@OGUID+207, 181307, 571, 1, 1, 2603.7, -4344.96, 276.749, 3.60446, 0, 0, 0.973338, -0.229375, 300, 0, 1), | |
| (@OGUID+208, 188021, 571, 1, 1, 5285.44, -2771.26, 292.418, 2.22832, 0, 0, 0.897541, 0.440932, 300, 0, 1),-- Zul'Drak | |
| (@OGUID+209, 188020, 571, 1, 1, 5305.23, -2759.31, 292.211, 2.32649, 0, 0, 0.918095, 0.396361, 300, 0, 1), | |
| (@OGUID+210, 188020, 571, 1, 1, 5300.14, -2753.37, 292.419, 2.27937, 0, 0, 0.908502, 0.417882, 300, 0, 1), | |
| (@OGUID+211, 188020, 571, 1, 1, 5272.4, -2788.86, 292.419, 2.16077, 0, 0, 0.88214, 0.470987, 300, 0, 1), | |
| (@OGUID+212, 188020, 571, 1, 1, 5267.47, -2781.49, 292.419, 2.16077, 0, 0, 0.88214, 0.470987, 300, 0, 1), | |
| (@OGUID+213, 181605, 571, 1, 1, 5276.31, -2779.24, 292.419, 0.767265, 0, 0, 0.374292, 0.927311, 300, 0, 1), | |
| (@OGUID+214, 181355, 571, 1, 1, 5273.81, -2783.22, 292.419, 2.0506, 0, 0, 0.854871, 0.518841, 300, 0, 1), | |
| (@OGUID+215, 181355, 571, 1, 1, 5280.99, -2777.12, 292.419, 2.19198, 0, 0, 0.88938, 0.457168, 300, 0, 1), | |
| (@OGUID+216, 181376, 571, 1, 1, 5294.92, -2761.88, 292.419, 2.12359, 0, 0, 0.873231, 0.487306, 300, 0, 1), | |
| (@OGUID+217, 194048, 571, 1, 1, 5294.92, -2761.88, 292.419, 2.12359, 0, 0, 0.873231, 0.487306, 300, 0, 1), | |
| (@OGUID+218, 181305, 571, 1, 1, 5289.89, -2768.68, 292.419, 6.05528, 0, 0, 0.113708, -0.993514, 300, 0, 1), | |
| (@OGUID+219, 181307, 571, 1, 1, 5290.46, -2768.24, 293.42, 0.654878, 0, 0, 0.321619, 0.946869, 300, 0, 1), | |
| (@OGUID+220, 181302, 571, 1, 1, 5285.31, -2775.88, 292.419, 1.63505, 0, 0, 0.729456, 0.684028, 300, 0, 1), | |
| (@OGUID+221, 181302, 571, 1, 1, 5282.75, -2774.74, 292.419, 2.02383, 0, 0, 0.847848, 0.53024, 300, 0, 1), | |
| (@OGUID+222, 181306, 571, 1, 1, 5283.45, -2776.25, 292.419, 5.98302, 0, 0, 0.149522, -0.988758, 300, 0, 1), | |
| (@OGUID+223, 188021, 571, 1, 1, 5504.05, 4879.15, -198.169, 6.24464, 0, 0, 0.0192691, -0.999814, 300, 0, 1),-- Sholazar Basin | |
| (@OGUID+224, 194034, 571, 1, 1, 5499.12, 4869.82, -197.467, 5.88414, 0, 0, 0.198201, -0.980161, 300, 0, 1), | |
| (@OGUID+225, 181376, 571, 1, 1, 5497.1, 4868.86, -195.368, 0.418565, 0, 0, 0.207758, 0.97818, 300, 0, 1), | |
| (@OGUID+226, 188020, 571, 1, 1, 5500.69, 4859.37, -197.247, 0.114598, 0, 0, 0.0572678, 0.998359, 300, 0, 1), | |
| (@OGUID+227, 188020, 571, 1, 1, 5525.06, 4861.98, -197.564, 0.106744, 0, 0, 0.0533468, 0.998576, 300, 0, 1), | |
| (@OGUID+228, 188020, 571, 1, 1, 5516.82, 4892.55, -196.273, 3.38578, 0, 0, 0.992556, -0.121792, 300, 0, 1), | |
| (@OGUID+229, 188020, 571, 1, 1, 5496.17, 4892.9, -198.774, 3.03235, 0, 0, 0.998509, 0.0545924, 300, 0, 1), | |
| (@OGUID+230, 181355, 571, 1, 1, 5495.91, 4883.4, -198.56, 6.25326, 0, 0, 0.0149618, -0.999888, 300, 0, 1), | |
| (@OGUID+231, 181355, 571, 1, 1, 5515.37, 4883.68, -197.054, 0.0242677, 0, 0, 0.0121336, 0.999926, 300, 0, 1), | |
| (@OGUID+232, 181605, 571, 1, 1, 5515.33, 4863.4, -198.357, 4.06043, 0, 0, 0.896311, -0.443427, 300, 0, 1), | |
| (@OGUID+233, 181302, 571, 1, 1, 5507.71, 4879.47, -198.299, 0.657298, 0, 0, 0.322765, 0.946479, 300, 0, 1), | |
| (@OGUID+234, 181302, 571, 1, 1, 5505.69, 4877.91, -198.203, 0.292873, 0, 0, 0.145914, 0.989297, 300, 0, 1), | |
| (@OGUID+235, 181306, 571, 1, 1, 5507.58, 4877.19, -198.261, 2.40952, 0, 0, 0.933753, 0.357918, 300, 0, 1), | |
| (@OGUID+236, 181305, 571, 1, 1, 5505.18, 4882.54, -198.365, 3.11481, 0, 0, 0.99991, 0.0133924, 300, 0, 1), | |
| (@OGUID+237, 181307, 571, 1, 1, 5505.92, 4882.53, -197.375, 3.13444, 0, 0, 0.999994, 0.00357527, 300, 0, 1), | |
| (@OGUID+238, 188021, 571, 1, 1, 5537.66, -737.121, 149.903, 3.31719, 0, 0, 0.996148, -0.0876849, 300, 0, 1),-- Crystalsong Forest | |
| (@OGUID+239, 188020, 571, 1, 1, 5545.47, -751.288, 152.872, 3.29205, 0, 0, 0.997172, -0.0751598, 300, 0, 1), | |
| (@OGUID+240, 188020, 571, 1, 1, 5534.63, -751.743, 152.043, 6.26479, 0, 0, 0.0091994, -0.999958, 300, 0, 1), | |
| (@OGUID+241, 188020, 571, 1, 1, 5528.85, -718.125, 149.06, 0.120616, 0, 0, 0.0602714, 0.998182, 300, 0, 1), | |
| (@OGUID+242, 188020, 571, 1, 1, 5538.1, -716.912, 150.739, 0.277696, 0, 0, 0.138402, 0.990376, 300, 0, 1), | |
| (@OGUID+243, 181355, 571, 1, 1, 5521.75, -729.266, 148.2, 0.10176, 0, 0, 0.050858, 0.998706, 300, 0, 1), | |
| (@OGUID+244, 181355, 571, 1, 1, 5523.81, -747.375, 150.338, 6.06293, 0, 0, 0.109904, -0.993942, 300, 0, 1), | |
| (@OGUID+245, 181376, 571, 1, 1, 5531.08, -726.827, 148.981, 5.3977, 0, 0, 0.428418, -0.903581, 300, 0, 1), | |
| (@OGUID+246, 194046, 571, 1, 1, 5530.53, -726.151, 148.904, 5.3977, 0, 0, 0.428418, -0.903581, 300, 0, 1), | |
| (@OGUID+247, 181605, 571, 1, 1, 5539.79, -749.386, 152.047, 1.77309, 0, 0, 0.774893, 0.632092, 300, 0, 1), | |
| (@OGUID+248, 181302, 571, 1, 1, 5540.05, -734.53, 149.889, 1.3152, 0, 0, 0.611221, 0.79146, 300, 0, 1), | |
| (@OGUID+249, 181302, 571, 1, 1, 5539.56, -736.342, 150.01, 0.0978369, 0, 0, 0.048899, 0.998804, 300, 0, 1), | |
| (@OGUID+250, 181306, 571, 1, 1, 5541.73, -735.983, 150.224, 2.34957, 0, 0, 0.922608, 0.385739, 300, 0, 1), | |
| (@OGUID+251, 181305, 571, 1, 1, 5544.59, -739.644, 150.773, 3.64391, 0, 0, 0.968625, -0.248527, 300, 0, 1), | |
| (@OGUID+252, 181307, 571, 1, 1, 5544.71, -740.658, 151.776, 4.72383, 0, 0, 0.70305, -0.711141, 300, 0, 1), | |
| (@OGUID+253, 188021, 571, 1, 1, 6151.36, -1017.1, 407.519, 1.69575, 0, 0, 0.749875, 0.66158, 300, 0, 1),-- The Storm Peaks | |
| (@OGUID+254, 188020, 571, 1, 1, 6132.71, -1015.73, 409.439, 1.61878, 0, 0, 0.723865, 0.689942, 300, 0, 1), | |
| (@OGUID+255, 188020, 571, 1, 1, 6132.91, -1025.75, 409.86, 1.60476, 0, 0, 0.719011, 0.694998, 300, 0, 1), | |
| (@OGUID+256, 188020, 571, 1, 1, 6175.57, -1021.52, 408.539, 1.75031, 0, 0, 0.767644, 0.640876, 300, 0, 1), | |
| (@OGUID+257, 188020, 571, 1, 1, 6173.75, -1011.53, 407.582, 1.75031, 0, 0, 0.767644, 0.640876, 300, 0, 1), | |
| (@OGUID+258, 181355, 571, 1, 1, 6159.65, -1016.22, 407.636, 3.2465, 0, 0, 0.998625, -0.0524288, 300, 0, 1), | |
| (@OGUID+259, 181355, 571, 1, 1, 6136.52, -1021.34, 409.514, 3.30462, 0, 0, 0.99668, -0.0814223, 300, 0, 1), | |
| (@OGUID+260, 181355, 571, 1, 1, 6153.47, -1027.3, 408.786, 1.79116, 0, 0, 0.780572, 0.625066, 300, 0, 1), | |
| (@OGUID+261, 181302, 571, 1, 1, 6150.61, -1022.3, 408.201, 1.04268, 0, 0, 0.498041, 0.867154, 300, 0, 1), | |
| (@OGUID+262, 181302, 571, 1, 1, 6151.6, -1020.59, 407.992, 2.47524, 0, 0, 0.945009, 0.327045, 300, 0, 1), | |
| (@OGUID+263, 181306, 571, 1, 1, 6152.41, -1022.41, 408.186, 3.21273, 0, 0, 0.999367, -0.0355623, 300, 0, 1), | |
| (@OGUID+264, 181305, 571, 1, 1, 6155.09, -1017.04, 407.54, 0.888738, 0, 0, 0.429888, 0.902882, 300, 0, 1), | |
| (@OGUID+265, 181307, 571, 1, 1, 6155.22, -1018.19, 408.53, 1.70398, 0, 0, 0.752593, 0.658486, 300, 0, 1), | |
| (@OGUID+266, 181605, 571, 1, 1, 6169.62, -1017.84, 408.118, 3.12084, 0, 0, 0.999946, 0.0103772, 300, 0, 1), | |
| (@OGUID+267, 181376, 571, 1, 1, 6142.18, -1020.42, 408.493, 1.81865, 0, 0, 0.789088, 0.61428, 300, 0, 1), | |
| (@OGUID+268, 194043, 571, 1, 1, 6142.19, -1020.44, 408.496, 1.91604, 0, 0, 0.818053, 0.575142, 300, 0, 1); | |
| DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+77 AND @CGUID+117; | |
| INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES | |
| (@CGUID+77, 16781, 571, 1, 1, 16438, 0, 4464.65, 5615.53, 56.9756, 0.761036, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Borean Tundra | |
| (@CGUID+78, 16781, 571, 1, 1, 16443, 0, 4463.64, 5619.44, 57.2937, 0.348702, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+79, 16781, 571, 1, 1, 16432, 0, 4468.31, 5631.88, 59.2365, 4.61106, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+80, 16781, 571, 1, 1, 16438, 0, 4431.68, 5629.68, 55.7222, 0.687992, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+81, 16781, 571, 1, 1, 16444, 0, 4437.48, 5636.46, 57.3127, 4.94564, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+82, 25994, 571, 1, 1, 23789, 1, 4469.26, 5627.85, 59.0877, 4.69872, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+83, 25994, 571, 1, 1, 23789, 1, 3779.24, 1486.12, 91.2991, 1.70099, 300, 0, 0, 1651, 0, 0, 0, 0, 0), -- Dragonblight | |
| (@CGUID+84, 16781, 571, 1, 1, 16436, 0, 3769.56, 1489.51, 91.3562, 6.25787, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+85, 16781, 571, 1, 1, 16432, 0, 3769.51, 1485.73, 92.0116, 0.944649, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+86, 16781, 571, 1, 1, 16443, 0, 3781.98, 1488.53, 90.6925, 3.65584, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+87, 16781, 571, 1, 1, 21086, 0, 3361.63, -2146.48, 124.113, 6.12412, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Grizzly Hills | |
| (@CGUID+88, 16781, 571, 1, 1, 16442, 0, 3362.85, -2143.59, 124.017, 5.52722, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+89, 16781, 571, 1, 1, 16445, 0, 3365.06, -2149.12, 124.395, 2.17279, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+90, 16781, 571, 1, 1, 16438, 0, 3376.29, -2142.8, 124.829, 3.63755, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+91, 25994, 571, 1, 1, 23789, 1, 3374.3, -2153.8, 123.999, 2.2042, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+92, 16781, 571, 1, 1, 16436, 0, 2611.27, -4353.51, 276.147, 2.90625, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Howling Fjord | |
| (@CGUID+93, 16781, 571, 1, 1, 16442, 0, 2607.34, -4349.77, 275.811, 4.8831, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+94, 16781, 571, 1, 1, 16431, 0, 2591.12, -4366.18, 275.385, 1.70773, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+95, 16781, 571, 1, 1, 16443, 0, 2589.82, -4356.76, 275.862, 4.90509, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+96, 16781, 571, 1, 1, 21086, 0, 2582.78, -4356.01, 276.146, 6.05884, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+97, 25994, 571, 1, 1, 23789, 1, 2586.97, -4359.34, 275.729, 4.3074, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+98, 16781, 571, 1, 1, 16446, 0, 5271.7, -2776.47, 292.419, 5.91363, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Zul'Drak | |
| (@CGUID+99, 16781, 571, 1, 1, 16438, 0, 5271.27, -2780.54, 292.419, 1.37088, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+100, 25994, 571, 1, 1, 23789, 1, 5276.13, -2771.1, 292.419, 4.75359, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+101, 16781, 571, 1, 1, 16436, 0, 5508.26, 4891.52, -197.537, 3.49338, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Sholazar Basin | |
| (@CGUID+102, 16781, 571, 1, 1, 16442, 0, 5503.99, 4886.98, -198.356, 1.25892, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+103, 16781, 571, 1, 1, 16445, 0, 5500.44, 4895, -198.054, 5.57939, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+104, 16781, 571, 1, 1, 16436, 0, 5513.58, 4886.29, -197.178, 2.68991, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+105, 16781, 571, 1, 1, 16444, 0, 5511.2, 4870.94, -198.257, 4.65341, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+106, 25994, 571, 1, 1, 23789, 1, 5509.13, 4864.95, -198.144, 6.08048, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+107, 16781, 571, 1, 1, 16446, 0, 5523.19, -720.827, 148.211, 5.25948, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Crystalsong Forest | |
| (@CGUID+108, 16781, 571, 1, 1, 16438, 0, 5520.46, -724.236, 148.091, 0.741081, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+109, 16781, 571, 1, 1, 16443, 0, 5525.58, -732.861, 148.853, 5.66631, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+110, 16781, 571, 1, 1, 16438, 0, 5535.22, -748.433, 151.399, 5.70637, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+111, 16781, 571, 1, 1, 16438, 0, 5540.74, -753.426, 153.249, 2.39199, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+112, 25994, 571, 1, 1, 23789, 1, 5544.48, -746.126, 151.578, 3.61956, 300, 0, 0, 1651, 0, 0, 0, 0, 0), | |
| (@CGUID+113, 16781, 571, 1, 1, 16438, 0, 6166.94, -1008.14, 407.495, 4.42539, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- The Storm Peaks | |
| (@CGUID+114, 16781, 571, 1, 1, 16442, 0, 6161.54, -1013.07, 407.498, 6.11635, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+115, 16781, 571, 1, 1, 21086, 0, 6164.34, -1020.92, 408.305, 1.35684, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+116, 16781, 571, 1, 1, 29243, 0, 6150.78, -1024.97, 408.505, 2.09119, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+117, 25994, 571, 1, 1, 23789, 1, 6171.72, -1022.75, 408.506, 1.97024, 300, 0, 0, 1651, 0, 0, 0, 0, 0); | |
| -- Northrend Alliance | |
| DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+269 AND @OGUID+379; | |
| INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES | |
| (@OGUID+269, 188021, 571, 1, 1, 4132.22, 5395.21, 25.7191, 5.17561, 0, 0, 0.525913, -0.850539, 300, 0, 1), -- Borean Tundra | |
| (@OGUID+270, 181376, 571, 1, 1, 4122.37, 5390.27, 27.8408, 5.32484, 0, 0, 0.461047, -0.887376, 300, 0, 1), | |
| (@OGUID+271, 194032, 571, 1, 1, 4122.37, 5390.27, 27.8408, 5.32484, 0, 0, 0.461047, -0.887376, 300, 0, 1), | |
| (@OGUID+272, 188020, 571, 1, 1, 4129.22, 5405.02, 28.1789, 0.481285, 0, 0, 0.238326, 0.971185, 300, 0, 1), | |
| (@OGUID+273, 188020, 571, 1, 1, 4151.06, 5414.97, 28.6058, 3.52863, 0, 0, 0.981333, -0.192314, 300, 0, 1), | |
| (@OGUID+274, 181355, 571, 1, 1, 4156.95, 5401.1, 26.3092, 3.55219, 0, 0, 0.979, -0.203861, 300, 0, 1), | |
| (@OGUID+275, 181355, 571, 1, 1, 4146.21, 5396.35, 26.6994, 3.55219, 0, 0, 0.979, -0.203861, 300, 0, 1), | |
| (@OGUID+276, 181355, 571, 1, 1, 4142.18, 5405.59, 27.1525, 3.55219, 0, 0, 0.979, -0.203861, 300, 0, 1), | |
| (@OGUID+277, 181355, 571, 1, 1, 4153.32, 5410.39, 28.7987, 3.52313, 0, 0, 0.981858, -0.189615, 300, 0, 1), | |
| (@OGUID+278, 181605, 571, 1, 1, 4150.05, 5405.28, 27.8774, 5.08058, 0, 0, 0.565718, -0.824599, 300, 0, 1), | |
| (@OGUID+279, 181305, 571, 1, 1, 4135.12, 5397.23, 25.5887, 3.85927, 0, 0, 0.936306, -0.351186, 300, 0, 1), | |
| (@OGUID+280, 181307, 571, 1, 1, 4135.05, 5398.94, 26.5787, 4.14594, 0, 0, 0.876539, -0.481331, 300, 0, 1), | |
| (@OGUID+281, 181306, 571, 1, 1, 4129.8, 5391.77, 26.5704, 0.0579356, 0, 0, 0.0289637, 0.99958, 300, 0, 1), | |
| (@OGUID+282, 181302, 571, 1, 1, 4131.99, 5391.45, 26.3998, 2.4746, 0, 0, 0.944904, 0.327349, 300, 0, 1), | |
| (@OGUID+283, 181302, 571, 1, 1, 4131.99, 5391.45, 27.643, 2.4746, 0, 0, 0.944904, 0.327349, 300, 0, 1), | |
| (@OGUID+284, 188020, 571, 1, 1, 3931.83, -573.606, 240.92, 4.44752, 0, 0, 0.794288, -0.607542, 300, 0, 1), -- Dragonblight | |
| (@OGUID+285, 188021, 571, 1, 1, 3935.16, -604.422, 242.038, 0.314754, 0, 0, 0.156728, 0.987642, 300, 0, 1), | |
| (@OGUID+286, 188020, 571, 1, 1, 3945.42, -581.269, 241.426, 3.2757, 0, 0, 0.997753, -0.0670037, 300, 0, 1), | |
| (@OGUID+287, 194036, 571, 1, 1, 3936.15, -583.456, 240.5, 4.0611, 0, 0, 0.896162, -0.443727, 300, 0, 1), | |
| (@OGUID+288, 181605, 571, 1, 1, 3943.7, -620.329, 242.649, 4.94546, 0, 0, 0.620095, -0.784527, 300, 0, 1), | |
| (@OGUID+289, 181355, 571, 1, 1, 3939.36, -612.531, 242.424, 0.532305, 0, 0, 0.263021, 0.96479, 300, 0, 1), | |
| (@OGUID+290, 181355, 571, 1, 1, 3935.15, -599.189, 241.726, 3.43592, 0, 0, 0.989191, -0.146634, 300, 0, 1), | |
| (@OGUID+291, 181302, 571, 1, 1, 3932.46, -602.261, 241.839, 4.80251, 0, 0, 0.674536, -0.738242, 300, 0, 1), | |
| (@OGUID+292, 181302, 571, 1, 1, 3933.35, -604.422, 242.14, 5.11746, 0, 0, 0.550417, -0.83489, 300, 0, 1), | |
| (@OGUID+293, 181306, 571, 1, 1, 3930.72, -604.611, 242.786, 0.606916, 0, 0, 0.298822, 0.954309, 300, 0, 1), | |
| (@OGUID+294, 181305, 571, 1, 1, 3937.87, -603.327, 241.851, 0.273907, 0, 0, 0.136526, 0.990636, 300, 0, 1), | |
| (@OGUID+295, 181307, 571, 1, 1, 3937.11, -604.845, 242.841, 1.2478, 0, 0, 0.584205, 0.811606, 300, 0, 1), | |
| (@OGUID+296, 188020, 571, 1, 1, 3951.62, -594.388, 242.067, 3.25449, 0, 0, 0.998407, -0.0564201, 300, 0, 1), | |
| (@OGUID+297, 188020, 571, 1, 1, 3956.41, -622.677, 240.615, 3.44377, 0, 0, 0.988608, -0.150516, 300, 0, 1), | |
| (@OGUID+298, 181376, 571, 1, 1, 3938.9, -583.532, 241.562, 3.02279, 0, 0, 0.998236, 0.0593654, 300, 0, 1), | |
| (@OGUID+299, 188020, 571, 1, 1, 3395.09, -2897.63, 202.415, 3.91647, 0, 0, 0.92588, -0.377817, 300, 0, 1), -- Grizzly Hills | |
| (@OGUID+300, 188020, 571, 1, 1, 3386.89, -2887.49, 201.433, 3.52822, 0, 0, 0.981373, -0.192111, 300, 0, 1), | |
| (@OGUID+301, 188021, 571, 1, 1, 3411.02, -2887.95, 200.943, 2.32304, 0, 0, 0.917409, 0.397946, 300, 0, 1), | |
| (@OGUID+302, 181376, 571, 1, 1, 3403.4, -2896.41, 201.988, 2.32303, 0, 0, 0.917408, 0.397948, 300, 0, 1), | |
| (@OGUID+303, 194040, 571, 1, 1, 3403.4, -2896.41, 201.988, 2.32303, 0, 0, 0.917408, 0.397948, 300, 0, 1), | |
| (@OGUID+304, 188020, 571, 1, 1, 3407.51, -2863.88, 200.72, 0.993352, 0, 0, 0.476506, 0.879171, 300, 0, 1), | |
| (@OGUID+305, 188020, 571, 1, 1, 3417.07, -2866.24, 201.045, 1.32715, 0, 0, 0.615936, 0.787796, 300, 0, 1), | |
| (@OGUID+306, 181355, 571, 1, 1, 3402.62, -2873.88, 201.036, 5.86281, 0, 0, 0.208643, -0.977992, 300, 0, 1), | |
| (@OGUID+307, 181355, 571, 1, 1, 3420.67, -2873.09, 201.803, 6.15576, 0, 0, 0.0636678, -0.997971, 300, 0, 1), | |
| (@OGUID+308, 181605, 571, 1, 1, 3418.83, -2879.6, 202.108, 2.79897, 0, 0, 0.985362, 0.170475, 300, 0, 1), | |
| (@OGUID+309, 181305, 571, 1, 1, 3412.23, -2891.48, 201.275, 5.57692, 0, 0, 0.345838, -0.938294, 300, 0, 1), | |
| (@OGUID+310, 181307, 571, 1, 1, 3411.04, -2891.93, 202.266, 5.61226, 0, 0, 0.329204, -0.944259, 300, 0, 1), | |
| (@OGUID+311, 181302, 571, 1, 1, 3413.25, -2886.38, 200.913, 5.401, 0, 0, 0.426929, -0.904285, 300, 0, 1), | |
| (@OGUID+312, 181302, 571, 1, 1, 3415.21, -2887.65, 201.016, 0.378376, 0, 0, 0.188062, 0.982157, 300, 0, 1), | |
| (@OGUID+313, 181306, 571, 1, 1, 3415.86, -2885.54, 201.257, 2.86024, 0, 0, 0.990121, 0.140215, 300, 0, 1), | |
| (@OGUID+314, 188021, 571, 1, 1, 5613.46, -2625.78, 292.419, 1.55992, 0, 0, 0.703251, 0.710942, 300, 0, 1), -- Zul'Drak | |
| (@OGUID+315, 181355, 571, 1, 1, 5603.68, -2629.45, 293.617, 4.60018, 0, 0, 0.745644, -0.666345, 300, 0, 1), | |
| (@OGUID+316, 181355, 571, 1, 1, 5626.09, -2630.44, 292.882, 1.48451, 0, 0, 0.675952, 0.736946, 300, 0, 1), | |
| (@OGUID+317, 188020, 571, 1, 1, 5636.45, -2626.42, 292.419, 6.27937, 0, 0, 0.00190917, -0.999998, 300, 0, 1), | |
| (@OGUID+318, 188020, 571, 1, 1, 5636.13, -2618.64, 292.199, 0.0786426, 0, 0, 0.0393112, 0.999227, 300, 0, 1), | |
| (@OGUID+319, 188020, 571, 1, 1, 5582.98, -2620.34, 292.42, 0.0385866, 0, 0, 0.0192921, 0.999814, 300, 0, 1), | |
| (@OGUID+320, 188020, 571, 1, 1, 5581.71, -2626.78, 292.419, 6.27386, 0, 0, 0.00466193, -0.999989, 300, 0, 1), | |
| (@OGUID+321, 181605, 571, 1, 1, 5587.73, -2625.06, 292.41, 0.0409415, 0, 0, 0.0204693, 0.99979, 300, 0, 1), | |
| (@OGUID+322, 181305, 571, 1, 1, 5616.57, -2625.53, 292.41, 0.749368, 0, 0, 0.365978, 0.930623, 300, 0, 1), | |
| (@OGUID+323, 181307, 571, 1, 1, 5616.55, -2626.93, 293.402, 1.55676, 0, 0, 0.702126, 0.712053, 300, 0, 1), | |
| (@OGUID+324, 181302, 571, 1, 1, 5611.85, -2625.48, 292.361, 4.696, 0, 0, 0.712879, -0.701287, 300, 0, 1), | |
| (@OGUID+325, 181302, 571, 1, 1, 5609.81, -2625.66, 292.34, 5.23792, 0, 0, 0.499163, -0.866508, 300, 0, 1), | |
| (@OGUID+326, 181306, 571, 1, 1, 5610.02, -2623.6, 292.418, 0.308762, 0, 0, 0.153769, 0.988107, 300, 0, 1), | |
| (@OGUID+327, 181376, 571, 1, 1, 5626.92, -2622.29, 292.417, 1.6785, 0, 0, 0.744143, 0.668021, 300, 0, 1), | |
| (@OGUID+328, 194049, 571, 1, 1, 5626.92, -2622.29, 292.417, 1.6785, 0, 0, 0.744143, 0.668021, 300, 0, 1), | |
| (@OGUID+329, 188021, 571, 1, 1, 5357.4, 4835.99, -195.101, 1.59976, 0, 0, 0.717272, 0.696793, 300, 0, 1), -- Sholazar Basin | |
| (@OGUID+330, 181376, 571, 1, 1, 5369.18, 4842.41, -197.357, 4.53948, 0, 0, 0.765523, -0.643408, 300, 0, 1), | |
| (@OGUID+331, 194035, 571, 1, 1, 5369.18, 4842.41, -197.357, 4.53948, 0, 0, 0.765523, -0.643408, 300, 0, 1), | |
| (@OGUID+332, 181355, 571, 1, 1, 5359.07, 4827.41, -197.019, 0.176586, 0, 0, 0.0881781, 0.996105, 300, 0, 1), | |
| (@OGUID+333, 181355, 571, 1, 1, 5357.57, 4845.13, -195.788, 1.41909, 0, 0, 0.651487, 0.75866, 300, 0, 1), | |
| (@OGUID+334, 181605, 571, 1, 1, 5357.67, 4855.99, -193.827, 2.00813, 0, 0, 0.843662, 0.536875, 300, 0, 1), | |
| (@OGUID+335, 188020, 571, 1, 1, 5364.57, 4869.43, -193.105, 4.59916, 0, 0, 0.745985, -0.665963, 300, 0, 1), | |
| (@OGUID+336, 188020, 571, 1, 1, 5354.34, 4871.09, -189.818, 4.65099, 0, 0, 0.728478, -0.685069, 300, 0, 1), | |
| (@OGUID+337, 188021, 571, 1, 1, 2464.17, -4907.57, 263.922, 1.71737, 0, 0, 0.756984, 0.653433, 300, 0, 1), -- Howling Fjord | |
| (@OGUID+338, 181305, 571, 1, 1, 2466.21, -4913.1, 264.166, 1.87838, 0, 0, 0.807079, 0.590443, 300, 0, 1), | |
| (@OGUID+339, 181307, 571, 1, 1, 2466.44, -4913.46, 265.097, 2.75802, 0, 0, 0.981666, 0.190611, 300, 0, 1), | |
| (@OGUID+340, 181302, 571, 1, 1, 2461.97, -4910.5, 263.936, 2.04881, 0, 0, 0.854405, 0.519608, 300, 0, 1), | |
| (@OGUID+341, 181302, 571, 1, 1, 2462.99, -4912.18, 264.014, 2.58759, 0, 0, 0.96188, 0.273472, 300, 0, 1), | |
| (@OGUID+342, 181306, 571, 1, 1, 2460.13, -4911.21, 263.948, 0.18113, 0, 0, 0.0904413, 0.995902, 300, 0, 1), | |
| (@OGUID+343, 181376, 571, 1, 1, 2454.19, -4910.31, 263.893, 1.66082, 0, 0, 0.738208, 0.674573, 300, 0, 1), | |
| (@OGUID+344, 194038, 571, 1, 1, 2454.19, -4910.31, 263.893, 1.66082, 0, 0, 0.738208, 0.674573, 300, 0, 1), | |
| (@OGUID+345, 188020, 571, 1, 1, 2440.82, -4917.07, 264.587, 3.04862, 0, 0, 0.99892, 0.0464672, 300, 0, 1), | |
| (@OGUID+346, 188020, 571, 1, 1, 2438.66, -4906.68, 263.066, 3.01328, 0, 0, 0.997943, 0.0641126, 300, 0, 1), | |
| (@OGUID+347, 188020, 571, 1, 1, 2484.02, -4906.27, 266.191, 3.40989, 0, 0, 0.991016, -0.133745, 300, 0, 1), | |
| (@OGUID+348, 188020, 571, 1, 1, 2480.96, -4899.1, 265.064, 3.50885, 0, 0, 0.983188, -0.182596, 300, 0, 1), | |
| (@OGUID+349, 181605, 571, 1, 1, 2477.58, -4905.4, 265.055, 3.54262, 0, 0, 0.979964, -0.199174, 300, 0, 1), | |
| (@OGUID+350, 181355, 571, 1, 1, 2444.4, -4912.06, 263.951, 4.8615, 0, 0, 0.652474, -0.757811, 300, 0, 1), | |
| (@OGUID+351, 181355, 571, 1, 1, 2479.59, -4904.05, 265.144, 5.29976, 0, 0, 0.472136, -0.881526, 300, 0, 1), | |
| (@OGUID+352, 188021, 571, 1, 1, 5136.25, -701.964, 172.182, 5.14116, 0, 0, 0.540484, -0.841354, 300, 0, 1), -- Crystalsong Forest | |
| (@OGUID+353, 181376, 571, 1, 1, 5144.94, -695.736, 171.284, 5.22017, 0, 0, 0.506833, -0.862045, 300, 0, 1), | |
| (@OGUID+354, 194045, 571, 1, 1, 5144.94, -695.736, 171.284, 5.22017, 0, 0, 0.506833, -0.862045, 300, 0, 1), | |
| (@OGUID+355, 188020, 571, 1, 1, 5157.7, -692.213, 168.342, 3.56062, 0, 0, 0.978132, -0.207985, 300, 0, 1), | |
| (@OGUID+356, 181355, 571, 1, 1, 5153.61, -694.632, 169.363, 0.505421, 0, 0, 0.250029, 0.968238, 300, 0, 1), | |
| (@OGUID+357, 188020, 571, 1, 1, 5122.22, -708.294, 175.114, 0.416673, 0, 0, 0.206832, 0.978376, 300, 0, 1), | |
| (@OGUID+358, 181355, 571, 1, 1, 5126.09, -706.472, 174.339, 3.55198, 0, 0, 0.979021, -0.203758, 300, 0, 1), | |
| (@OGUID+359, 181605, 571, 1, 1, 5151.54, -709.361, 169.826, 2.02988, 0, 0, 0.849448, 0.527672, 300, 0, 1), | |
| (@OGUID+360, 181305, 571, 1, 1, 5133.04, -698.409, 172.585, 2.84669, 0, 0, 0.989149, 0.146918, 300, 0, 1), | |
| (@OGUID+361, 181307, 571, 1, 1, 5134.11, -697.857, 173.575, 3.61874, 0, 0, 0.971676, -0.236315, 300, 0, 1), | |
| (@OGUID+362, 181302, 571, 1, 1, 5130.8, -703.896, 173.441, 0.0954414, 0, 0, 0.0477026, 0.998862, 300, 0, 1), | |
| (@OGUID+363, 181302, 571, 1, 1, 5130.87, -703.854, 174.684, 0.535265, 0, 0, 0.264449, 0.9644, 300, 0, 1), | |
| (@OGUID+364, 181306, 571, 1, 1, 5131.38, -705.369, 173.303, 0.248594, 0, 0, 0.123977, 0.992285, 300, 0, 1), | |
| (@OGUID+365, 188021, 571, 1, 1, 6071.62, -1109.83, 419.2, 0.405097, 0, 0, 0.201166, 0.979557, 300, 0, 1), -- Storm Peaks | |
| (@OGUID+366, 181305, 571, 1, 1, 6068.33, -1111.01, 420.335, 0.181236, 0, 0, 0.0904939, 0.995897, 300, 0, 1), | |
| (@OGUID+367, 181307, 571, 1, 1, 6068.13, -1112.28, 421.326, 1.41274, 0, 0, 0.649077, 0.760723, 300, 0, 1), | |
| (@OGUID+368, 181302, 571, 1, 1, 6075.71, -1107.72, 419.811, 0.0485033, 0, 0, 0.0242493, 0.999706, 300, 0, 1), | |
| (@OGUID+369, 181302, 571, 1, 1, 6074.48, -1109.44, 419.993, 0.613205, 0, 0, 0.301821, 0.953365, 300, 0, 1), | |
| (@OGUID+370, 181306, 571, 1, 1, 6076.77, -1109.03, 419.873, 0.174952, 0, 0, 0.0873647, 0.996176, 300, 0, 1), | |
| (@OGUID+371, 188020, 571, 1, 1, 6087.35, -1102.33, 417.415, 1.96409, 0, 0, 0.831634, 0.555324, 300, 0, 1), | |
| (@OGUID+372, 181355, 571, 1, 1, 6088.04, -1106.9, 418.348, 3.61421, 0, 0, 0.972209, -0.234116, 300, 0, 1), | |
| (@OGUID+373, 181355, 571, 1, 1, 6083.72, -1098.45, 417.139, 3.61421, 0, 0, 0.972209, -0.234116, 300, 0, 1), | |
| (@OGUID+374, 188020, 571, 1, 1, 6052.44, -1113.82, 420.864, 1.8769, 0, 0, 0.806644, 0.591038, 300, 0, 1), | |
| (@OGUID+375, 181355, 571, 1, 1, 6052.45, -1106.76, 421.632, 0.193794, 0, 0, 0.0967457, 0.995309, 300, 0, 1), | |
| (@OGUID+376, 181355, 571, 1, 1, 6056.56, -1118.19, 420.868, 0.130963, 0, 0, 0.0654346, 0.997857, 300, 0, 1), | |
| (@OGUID+377, 181605, 571, 1, 1, 6061.69, -1112.97, 420.771, 5.40099, 0, 0, 0.426933, -0.904283, 300, 0, 1), | |
| (@OGUID+378, 181376, 571, 1, 1, 6081.58, -1107.81, 419.498, 5.2117, 0, 0, 0.510478, -0.859891, 300, 0, 1), | |
| (@OGUID+379, 194044, 571, 1, 1, 6081.58, -1107.81, 419.498, 5.2117, 0, 0, 0.510478, -0.859891, 300, 0, 1); | |
| DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+118 AND @CGUID+156; | |
| INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES | |
| (@CGUID+118, 25962, 571, 1, 1, 23791, 0, 4141.22, 5399.12, 26.8254, 0.573149, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Borean | |
| (@CGUID+119, 16781, 571, 1, 1, 16434, 0, 4142.22, 5389.34, 26.5072, 1.07266, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+120, 16781, 571, 1, 1, 16435, 0, 4141.25, 5394.58, 27.4716, 5.24156, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+121, 16781, 571, 1, 1, 16412, 0, 4147.28, 5407.75, 28.0446, 1.51327, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+122, 16781, 571, 1, 1, 16413, 0, 4145.26, 5412.3, 28.2783, 5.25177, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+123, 16781, 571, 1, 1, 21084, 0, 3946.4, -634.725, 242.332, 2.18478, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Dragonblight | |
| (@CGUID+124, 16781, 571, 1, 1, 16435, 0, 3944.54, -631.516, 242.718, 5.2062, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+125, 16781, 571, 1, 1, 16434, 0, 3942.9, -606.703, 241.48, 2.36464, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+126, 16781, 571, 1, 1, 21083, 0, 3940.65, -603.007, 241.622, 5.10253, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+127, 25962, 571, 1, 1, 23791, 0, 3954.38, -609.752, 240.94, 3.62441, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+128, 25962, 571, 1, 1, 23791, 0, 3417.9, -2882.62, 201.901, 2.50837, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Grizzly Hills | |
| (@CGUID+129, 16781, 571, 1, 1, 21083, 0, 3410.97, -2879.33, 201.095, 0.0940601, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+130, 16781, 571, 1, 1, 16435, 0, 3413.05, -2875.08, 200.954, 4.47815, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+131, 16781, 571, 1, 1, 16414, 0, 3416.95, -2876.6, 201.513, 3.22073, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+132, 25962, 571, 1, 1, 23791, 0, 5605.14, -2622.99, 292.418, 3.07023, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Zul'Drak | |
| (@CGUID+133, 16781, 571, 1, 1, 21083, 0, 5598.5, -2620.43, 292.418, 3.79122, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+134, 16781, 571, 1, 1, 16412, 0, 5595.44, -2624.43, 292.418, 0.957505, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+135, 16781, 571, 1, 1, 16448, 0, 5591.45, -2618.79, 292.418, 5.53402, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+136, 16781, 571, 1, 1, 16414, 0, 5608.18, -2627.1, 292.38, 2.59506, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+137, 16781, 571, 1, 1, 16433, 0, 5350.19, 4865.15, -189.023, 5.81181, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Sholazar Basin | |
| (@CGUID+138, 16781, 571, 1, 1, 21084, 0, 5349.94, 4860.03, -189.519, 5.81181, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+139, 16781, 571, 1, 1, 16412, 0, 5359.3, 4851.5, -195.433, 2.15971, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+140, 16781, 571, 1, 1, 16434, 0, 5361.68, 4857.43, -195.012, 2.85086, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+141, 25962, 571, 1, 1, 23791, 0, 5359.25, 4865.19, -192.408, 4.29363, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+142, 16781, 571, 1, 1, 21084, 0, 2475.51, -4899.2, 264.631, 4.34609, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Howling Fjord | |
| (@CGUID+143, 16781, 571, 1, 1, 16412, 0, 2473.2, -4903.93, 264.472, 1.13459, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+144, 16781, 571, 1, 1, 16434, 0, 2470.25, -4897.93, 264.079, 5.37967, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+145, 16781, 571, 1, 1, 16435, 0, 2460.73, -4908.81, 263.856, 1.98283, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+146, 25962, 571, 1, 1, 23791, 0, 2474.94, -4910.43, 265.088, 1.51708, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+147, 16781, 571, 1, 1, 16448, 0, 5158.08, -705.974, 168.467, 3.02341, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Crystal Song | |
| (@CGUID+148, 16781, 571, 1, 1, 16434, 0, 5156.52, -702.266, 168.843, 4.44812, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+149, 16781, 571, 1, 1, 16433, 0, 5151.8, -705.612, 169.955, 0.254876, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+150, 16781, 571, 1, 1, 21084, 0, 5128.25, -708.394, 173.711, 1.15808, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+151, 25962, 571, 1, 1, 23791, 0, 5145.91, -709.484, 170.821, 0.499922, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+152, 16781, 571, 1, 1, 16434, 0, 6065.56, -1113.57, 420.54, 4.16241, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Storm Peaks | |
| (@CGUID+153, 16781, 571, 1, 1, 16412, 0, 6066.28, -1119.17, 420.628, 1.60201, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+154, 16781, 571, 1, 1, 16442, 0, 6061.11, -1119.26, 420.736, 0.384647, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+155, 16781, 571, 1, 1, 16447, 0, 6057.52, -1108.18, 421.177, 5.5188, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+156, 25962, 571, 1, 1, 23791, 0, 6055.79, -1113.41, 420.965, 0.639908, 300, 0, 0, 1524, 0, 0, 0, 0, 0); | |
| -- Add missing objects and creatures from capital cities and fix some minor misc on already spawned ones | |
| DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+380 AND @OGUID+418; | |
| INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES | |
| (@OGUID+380, 181376, 530, 1, 1, -3794.02, -11502.1, -134.74, 5.00689, 0, 0, 0.59571, -0.8032, 300, 0, 1),-- The Exodar | |
| (@OGUID+381, 188128, 530, 1, 1, -3794.02, -11502.1, -134.74, 5.00689, 0, 0, 0.59571, -0.8032, 300, 0, 1), | |
| (@OGUID+382, 181305, 530, 1, 1, -3794.46, -11519.8, -134.94, 1.89985, 0, 0, 0.813373, 0.581743, 300, 0, 1), | |
| (@OGUID+383, 181307, 530, 1, 1, -3795.81, -11519.3, -133.928, 0.0211825, 0, 0, 0.010591, 0.999944, 300, 0, 1), | |
| (@OGUID+384, 181302, 530, 1, 1, -3800.48, -11515.8, -134.966, 6.21562, 0, 0, 0.0337776, -0.999429, 300, 0, 1), | |
| (@OGUID+385, 181302, 530, 1, 1, -3800.87, -11517.1, -135.02, 2.979, 0, 0, 0.996697, 0.0812088, 300, 0, 1), | |
| (@OGUID+386, 181302, 530, 1, 1, -3800.86, -11516.4, -133.722, 2.56666, 0, 0, 0.958966, 0.283523, 300, 0, 1), | |
| (@OGUID+387, 181306, 530, 1, 1, -3799.04, -11517.6, -134.986, 3.29551, 0, 0, 0.99704, -0.0768831, 300, 0, 1), | |
| (@OGUID+388, 188020, 530, 1, 1, -3793.84, -11533.9, -134.975, 5.90226, 0, 0, 0.189314, -0.981916, 300, 0, 1), | |
| (@OGUID+389, 188020, 530, 1, 1, -3774.53, -11496.2, -134.493, 2.69547, 0, 0, 0.975225, 0.221214, 300, 0, 1), | |
| (@OGUID+390, 181355, 530, 1, 1, -3772.21, -11491.7, -134.447, 4.23172, 0, 0, 0.855095, -0.518471, 300, 0, 1), | |
| (@OGUID+391, 181355, 530, 1, 1, -3797.16, -11540.5, -134.957, 1.12154, 0, 0, 0.531839, 0.846846, 300, 0, 1), | |
| (@OGUID+392, 187708, 530, 1, 1, -3768.73, -11511.2, -134.479, 2.70805, 0, 0, 0.976597, 0.215078, 300, 0, 1), | |
| (@OGUID+393, 187708, 530, 1, 1, -3773.26, -11519.4, -134.56, 2.53526, 0, 0, 0.954396, 0.298543, 300, 0, 1), | |
| (@OGUID+394, 187708, 530, 1, 1, -3776.32, -11511.5, -134.569, 5.69256, 0, 0, 0.291037, -0.956712, 300, 0, 1), | |
| (@OGUID+395, 187708, 530, 1, 1, -3775.23, -11506.7, -134.539, 5.79074, 0, 0, 0.243745, -0.969839, 300, 0, 1), | |
| (@OGUID+396, 187708, 530, 1, 1, -3780.47, -11514.1, -134.626, 5.66115, 0, 0, 0.30603, -0.952022, 300, 0, 1), | |
| (@OGUID+397, 181306, 530, 1, 1, 9791.79, -7248.75, 26.0815, 4.80477, 0, 0, 0.673703, -0.739003, 300, 0, 1), -- Silvermoon | |
| (@OGUID+398, 187708, 530, 1, 1, 9817.67, -7227.84, 26.1104, 3.89843, 0, 0, 0.929251, -0.36945, 300, 0, 1), | |
| (@OGUID+399, 187708, 530, 1, 1, 9810.38, -7226.95, 26.0582, 0.898206, 0, 0, 0.434157, 0.900837, 300, 0, 1), | |
| (@OGUID+400, 187708, 530, 1, 1, 9819.87, -7234.51, 26.1176, 0.898206, 0, 0, 0.434157, 0.900837, 300, 0, 1), | |
| (@OGUID+401, 187708, 530, 1, 1, 9823.56, -7229.12, 26.1209, 3.78847, 0, 0, 0.948148, -0.317829, 300, 0, 1), | |
| (@OGUID+402, 187708, 530, 1, 1, 9817.55, -7221.36, 26.1142, 3.80025, 0, 0, 0.946259, -0.323409, 300, 0, 1), | |
| (@OGUID+403, 188020, 530, 1, 1, 9819.17, -7251.91, 26.1485, 5.37496, 0, 0, 0.438667, -0.89865, 300, 0, 1), | |
| (@OGUID+404, 188020, 530, 1, 1, 9795.99, -7270.21, 26.3648, 2.06541, 0, 0, 0.858689, 0.512496, 300, 0, 1), | |
| (@OGUID+405, 188021, 0, 1, 1, 1802.13, 222.644, 59.9682, 1.02433, 0, 0, 0.490064, 0.871686, 300,100,1),-- Undercity and Ironforge | |
| (@OGUID+406, 188021, 0, 1, 1, -4711.33, -1224.68, 501.66, 3.95557, 0, 0, 0.918317, -0.395846, 300,100,1), | |
| (@OGUID+407, 181376, 0, 1, 1, -4700.28, -1224.34, 501.659, -2.14675, 0, 0, 0.878817, -0.477159, 180,100,1), | |
| (@OGUID+408, 181305, 0, 1, 1, -8833.44, 875.047, 98.5645, 3.04849, 0, 0, 0.998917, 0.0465366, 300, 0, 1),-- Stormwind and Darnassus | |
| (@OGUID+409, 181307, 0, 1, 1, -8832.66, 876.386, 99.5549, 4.18967, 0, 0, 0.865805, -0.500381, 300, 0, 1), | |
| (@OGUID+410, 181302, 0, 1, 1, -8831.75, 880.124, 98.4636, 4.62321, 0, 0, 0.737923, -0.674885, 300, 0, 1), | |
| (@OGUID+411, 181302, 0, 1, 1, -8829.84, 879.278, 98.5062, 5.90498, 0, 0, 0.187978, -0.982173, 300, 0, 1), | |
| (@OGUID+412, 181302, 0, 1, 1, -8830.09, 879.49, 99.7495, 3.72942, 0, 0, 0.957117, -0.289703, 300, 0, 1), | |
| (@OGUID+413, 181306, 0, 1, 1, -8830.36, 881.029, 98.4529, 4.14019, 0, 0, 0.877919, -0.478809, 300, 0, 1), | |
| (@OGUID+414, 187708, 0, 1, 1, -8816.54, 854.183, 98.882, 4.34518, 0, 0, 0.824323, -0.56612, 300, 0, 1), | |
| (@OGUID+415, 187708, 0, 1, 1, -8815.11, 860.487, 98.96, 4.75751, 0, 0, 0.690976, -0.722877, 300, 0, 1), | |
| (@OGUID+416, 187708, 0, 1, 1, -8818.01, 865.253, 98.9761, 4.47084, 0, 0, 0.787149, -0.616763, 300, 0, 1), | |
| (@OGUID+417, 181306, 1, 1, 1, 8705.34, 970.3, 12.2316, 5.19882, 0, 0, 0.516009, -0.856583, 300, 0, 1), | |
| (@OGUID+418, 181307, 1, 1, 1, 8703.78, 967.116, 13.6598, 4.10868, 0, 0, 0.885353, -0.46492, 300, 0, 1); | |
| DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+157 AND @CGUID+167; | |
| INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES | |
| (@CGUID+157, 26221, 530, 1, 1, 0, 1, -3796.67, -11496.8, -134.748, 2.2101, 300, 0, 0, 8982, 3155, 0, 0, 0, 0),-- The Exodar | |
| (@CGUID+158, 16781, 530, 1, 1, 0, 0, -3814.35, -11505.7, -138.534, 2.81721, 120, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+159, 16781, 530, 1, 1, 0, 0, -3816.08, -11510.3, -138.573, 1.88337, 120, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+160, 26124, 530, 1, 1, 0, 0, 9790.85, -7250.58, 26.1002, 5.48896, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Silvermoon | |
| (@CGUID+161, 16781, 0, 1, 1, 16434, 0, -8823.33, 857.655, 99.0305, 1.57502, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Stormwind and Darnassus | |
| (@CGUID+162, 16781, 0, 1, 1, 16433, 0, -8824.21, 861.431, 98.9968, 4.82972, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+163, 16781, 0, 1, 1, 16433, 0, -8826.99, 859.058, 99.0299, 0.149527, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+164, 16781, 1, 1, 1, 16434, 0, 8720.84, 963.484, 11.851, 1.43676, 300, 0, 0, 1524, 0, 0, 0, 0, 0), | |
| (@CGUID+165, 26221, 0, 1, 1, 0, 1, -8832.81, 861.687, 98.8931, 0.880735, 300, 0, 0, 8982, 3155, 0, 0, 0, 0), | |
| (@CGUID+166, 26123, 0, 1, 1, 0, 0, -8827.68, 875.783, 98.6689, 4.60823, 300, 0, 0, 3052, 0, 0, 0, 0, 0), | |
| (@CGUID+167, 16817, 0, 1, 1, 16354, 0, -8831.73, 854.756, 99.1285, 5.71407, 300, 0, 0, 3052, 0, 0, 0, 0, 0); | |
| DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` BETWEEN @CGUID AND @CGUID+167; | |
| INSERT INTO `game_event_creature` (`eventEntry`,`guid`) VALUES | |
| (1,@CGUID+0), | |
| (1,@CGUID+1), | |
| (1,@CGUID+2), | |
| (1,@CGUID+3), | |
| (1,@CGUID+4), | |
| (1,@CGUID+5), | |
| (1,@CGUID+6), | |
| (1,@CGUID+7), | |
| (1,@CGUID+8), | |
| (1,@CGUID+9), | |
| (1,@CGUID+10), | |
| (1,@CGUID+11), | |
| (1,@CGUID+12), | |
| (1,@CGUID+13), | |
| (1,@CGUID+14), | |
| (1,@CGUID+15), | |
| (1,@CGUID+16), | |
| (1,@CGUID+17), | |
| (1,@CGUID+18), | |
| (1,@CGUID+19), | |
| (1,@CGUID+20), | |
| (1,@CGUID+21), | |
| (1,@CGUID+22), | |
| (1,@CGUID+23), | |
| (1,@CGUID+24), | |
| (1,@CGUID+25), | |
| (1,@CGUID+26), | |
| (1,@CGUID+27), | |
| (1,@CGUID+28), | |
| (1,@CGUID+29), | |
| (1,@CGUID+30), | |
| (1,@CGUID+31), | |
| (1,@CGUID+32), | |
| (1,@CGUID+33), | |
| (1,@CGUID+34), | |
| (1,@CGUID+35), | |
| (1,@CGUID+36), | |
| (1,@CGUID+37), | |
| (1,@CGUID+38), | |
| (1,@CGUID+39), | |
| (1,@CGUID+40), | |
| (1,@CGUID+41), | |
| (1,@CGUID+42), | |
| (1,@CGUID+43), | |
| (1,@CGUID+44), | |
| (1,@CGUID+45), | |
| (1,@CGUID+46), | |
| (1,@CGUID+47), | |
| (1,@CGUID+48), | |
| (1,@CGUID+49), | |
| (1,@CGUID+50), | |
| (1,@CGUID+51), | |
| (1,@CGUID+52), | |
| (1,@CGUID+53), | |
| (1,@CGUID+54), | |
| (1,@CGUID+55), | |
| (1,@CGUID+56), | |
| (1,@CGUID+57), | |
| (1,@CGUID+58), | |
| (1,@CGUID+59), | |
| (1,@CGUID+60), | |
| (1,@CGUID+61), | |
| (1,@CGUID+62), | |
| (1,@CGUID+63), | |
| (1,@CGUID+64), | |
| (1,@CGUID+65), | |
| (1,@CGUID+66), | |
| (1,@CGUID+67), | |
| (1,@CGUID+68), | |
| (1,@CGUID+69), | |
| (1,@CGUID+70), | |
| (1,@CGUID+71), | |
| (1,@CGUID+72), | |
| (1,@CGUID+73), | |
| (1,@CGUID+74), | |
| (1,@CGUID+75), | |
| (1,@CGUID+76), | |
| (1,@CGUID+77), | |
| (1,@CGUID+78), | |
| (1,@CGUID+79), | |
| (1,@CGUID+80), | |
| (1,@CGUID+81), | |
| (1,@CGUID+82), | |
| (1,@CGUID+83), | |
| (1,@CGUID+84), | |
| (1,@CGUID+85), | |
| (1,@CGUID+86), | |
| (1,@CGUID+87), | |
| (1,@CGUID+88), | |
| (1,@CGUID+89), | |
| (1,@CGUID+90), | |
| (1,@CGUID+91), | |
| (1,@CGUID+92), | |
| (1,@CGUID+93), | |
| (1,@CGUID+94), | |
| (1,@CGUID+95), | |
| (1,@CGUID+96), | |
| (1,@CGUID+97), | |
| (1,@CGUID+98), | |
| (1,@CGUID+99), | |
| (1,@CGUID+100), | |
| (1,@CGUID+101), | |
| (1,@CGUID+102), | |
| (1,@CGUID+103), | |
| (1,@CGUID+104), | |
| (1,@CGUID+105), | |
| (1,@CGUID+106), | |
| (1,@CGUID+107), | |
| (1,@CGUID+108), | |
| (1,@CGUID+109), | |
| (1,@CGUID+110), | |
| (1,@CGUID+111), | |
| (1,@CGUID+112), | |
| (1,@CGUID+113), | |
| (1,@CGUID+114), | |
| (1,@CGUID+115), | |
| (1,@CGUID+116), | |
| (1,@CGUID+117), | |
| (1,@CGUID+118), | |
| (1,@CGUID+119), | |
| (1,@CGUID+120), | |
| (1,@CGUID+121), | |
| (1,@CGUID+122), | |
| (1,@CGUID+123), | |
| (1,@CGUID+124), | |
| (1,@CGUID+125), | |
| (1,@CGUID+126), | |
| (1,@CGUID+127), | |
| (1,@CGUID+128), | |
| (1,@CGUID+129), | |
| (1,@CGUID+130), | |
| (1,@CGUID+131), | |
| (1,@CGUID+132), | |
| (1,@CGUID+133), | |
| (1,@CGUID+134), | |
| (1,@CGUID+135), | |
| (1,@CGUID+136), | |
| (1,@CGUID+137), | |
| (1,@CGUID+138), | |
| (1,@CGUID+139), | |
| (1,@CGUID+140), | |
| (1,@CGUID+141), | |
| (1,@CGUID+142), | |
| (1,@CGUID+143), | |
| (1,@CGUID+144), | |
| (1,@CGUID+145), | |
| (1,@CGUID+146), | |
| (1,@CGUID+147), | |
| (1,@CGUID+148), | |
| (1,@CGUID+149), | |
| (1,@CGUID+150), | |
| (1,@CGUID+151), | |
| (1,@CGUID+152), | |
| (1,@CGUID+153), | |
| (1,@CGUID+154), | |
| (1,@CGUID+155), | |
| (1,@CGUID+156), | |
| (1,@CGUID+157), | |
| (1,@CGUID+158), | |
| (1,@CGUID+159), | |
| (1,@CGUID+160), | |
| (1,@CGUID+161), | |
| (1,@CGUID+162), | |
| (1,@CGUID+163), | |
| (1,@CGUID+164), | |
| (1,@CGUID+165), | |
| (1,@CGUID+166), | |
| (1,@CGUID+167); | |
| DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` BETWEEN @OGUID AND @OGUID+418; | |
| INSERT INTO `game_event_gameobject` (`eventEntry`,`guid`) VALUES | |
| (1,@OGUID+0), | |
| (1,@OGUID+1), | |
| (1,@OGUID+2), | |
| (1,@OGUID+3), | |
| (1,@OGUID+4), | |
| (1,@OGUID+5), | |
| (1,@OGUID+6), | |
| (1,@OGUID+7), | |
| (1,@OGUID+8), | |
| (1,@OGUID+9), | |
| (1,@OGUID+10), | |
| (1,@OGUID+11), | |
| (1,@OGUID+12), | |
| (1,@OGUID+13), | |
| (1,@OGUID+14), | |
| (1,@OGUID+15), | |
| (1,@OGUID+16), | |
| (1,@OGUID+17), | |
| (1,@OGUID+18), | |
| (1,@OGUID+19), | |
| (1,@OGUID+20), | |
| (1,@OGUID+21), | |
| (1,@OGUID+22), | |
| (1,@OGUID+23), | |
| (1,@OGUID+24), | |
| (1,@OGUID+25), | |
| (1,@OGUID+26), | |
| (1,@OGUID+27), | |
| (1,@OGUID+28), | |
| (1,@OGUID+29), | |
| (1,@OGUID+30), | |
| (1,@OGUID+31), | |
| (1,@OGUID+32), | |
| (1,@OGUID+33), | |
| (1,@OGUID+34), | |
| (1,@OGUID+35), | |
| (1,@OGUID+36), | |
| (1,@OGUID+37), | |
| (1,@OGUID+38), | |
| (1,@OGUID+39), | |
| (1,@OGUID+40), | |
| (1,@OGUID+41), | |
| (1,@OGUID+42), | |
| (1,@OGUID+43), | |
| (1,@OGUID+44), | |
| (1,@OGUID+45), | |
| (1,@OGUID+46), | |
| (1,@OGUID+47), | |
| (1,@OGUID+48), | |
| (1,@OGUID+49), | |
| (1,@OGUID+50), | |
| (1,@OGUID+51), | |
| (1,@OGUID+52), | |
| (1,@OGUID+53), | |
| (1,@OGUID+54), | |
| (1,@OGUID+55), | |
| (1,@OGUID+56), | |
| (1,@OGUID+57), | |
| (1,@OGUID+58), | |
| (1,@OGUID+59), | |
| (1,@OGUID+60), | |
| (1,@OGUID+61), | |
| (1,@OGUID+62), | |
| (1,@OGUID+63), | |
| (1,@OGUID+64), | |
| (1,@OGUID+65), | |
| (1,@OGUID+66), | |
| (1,@OGUID+67), | |
| (1,@OGUID+68), | |
| (1,@OGUID+69), | |
| (1,@OGUID+70), | |
| (1,@OGUID+71), | |
| (1,@OGUID+72), | |
| (1,@OGUID+73), | |
| (1,@OGUID+74), | |
| (1,@OGUID+75), | |
| (1,@OGUID+76), | |
| (1,@OGUID+77), | |
| (1,@OGUID+78), | |
| (1,@OGUID+79), | |
| (1,@OGUID+80), | |
| (1,@OGUID+81), | |
| (1,@OGUID+82), | |
| (1,@OGUID+83), | |
| (1,@OGUID+84), | |
| (1,@OGUID+85), | |
| (1,@OGUID+86), | |
| (1,@OGUID+87), | |
| (1,@OGUID+88), | |
| (1,@OGUID+89), | |
| (1,@OGUID+90), | |
| (1,@OGUID+91), | |
| (1,@OGUID+92), | |
| (1,@OGUID+93), | |
| (1,@OGUID+94), | |
| (1,@OGUID+95), | |
| (1,@OGUID+96), | |
| (1,@OGUID+97), | |
| (1,@OGUID+98), | |
| (1,@OGUID+99), | |
| (1,@OGUID+100), | |
| (1,@OGUID+101), | |
| (1,@OGUID+102), | |
| (1,@OGUID+103), | |
| (1,@OGUID+104), | |
| (1,@OGUID+105), | |
| (1,@OGUID+106), | |
| (1,@OGUID+107), | |
| (1,@OGUID+108), | |
| (1,@OGUID+109), | |
| (1,@OGUID+110), | |
| (1,@OGUID+111), | |
| (1,@OGUID+112), | |
| (1,@OGUID+113), | |
| (1,@OGUID+114), | |
| (1,@OGUID+115), | |
| (1,@OGUID+116), | |
| (1,@OGUID+117), | |
| (1,@OGUID+118), | |
| (1,@OGUID+119), | |
| (1,@OGUID+120), | |
| (1,@OGUID+121), | |
| (1,@OGUID+122), | |
| (1,@OGUID+123), | |
| (1,@OGUID+124), | |
| (1,@OGUID+125), | |
| (1,@OGUID+126), | |
| (1,@OGUID+127), | |
| (1,@OGUID+128), | |
| (1,@OGUID+129), | |
| (1,@OGUID+130), | |
| (1,@OGUID+131), | |
| (1,@OGUID+132), | |
| (1,@OGUID+133), | |
| (1,@OGUID+134), | |
| (1,@OGUID+135), | |
| (1,@OGUID+136), | |
| (1,@OGUID+137), | |
| (1,@OGUID+138), | |
| (1,@OGUID+139), | |
| (1,@OGUID+140), | |
| (1,@OGUID+141), | |
| (1,@OGUID+142), | |
| (1,@OGUID+143), | |
| (1,@OGUID+144), | |
| (1,@OGUID+145), | |
| (1,@OGUID+146), | |
| (1,@OGUID+147), | |
| (1,@OGUID+148), | |
| (1,@OGUID+149), | |
| (1,@OGUID+150), | |
| (1,@OGUID+151), | |
| (1,@OGUID+152), | |
| (1,@OGUID+153), | |
| (1,@OGUID+154), | |
| (1,@OGUID+155), | |
| (1,@OGUID+156), | |
| (1,@OGUID+157), | |
| (1,@OGUID+158), | |
| (1,@OGUID+159), | |
| (1,@OGUID+160), | |
| (1,@OGUID+161), | |
| (1,@OGUID+162), | |
| (1,@OGUID+163), | |
| (1,@OGUID+164), | |
| (1,@OGUID+165), | |
| (1,@OGUID+166), | |
| (1,@OGUID+167), | |
| (1,@OGUID+168), | |
| (1,@OGUID+169), | |
| (1,@OGUID+170), | |
| (1,@OGUID+171), | |
| (1,@OGUID+172), | |
| (1,@OGUID+173), | |
| (1,@OGUID+174), | |
| (1,@OGUID+175), | |
| (1,@OGUID+176), | |
| (1,@OGUID+177), | |
| (1,@OGUID+178), | |
| (1,@OGUID+179), | |
| (1,@OGUID+180), | |
| (1,@OGUID+181), | |
| (1,@OGUID+182), | |
| (1,@OGUID+183), | |
| (1,@OGUID+184), | |
| (1,@OGUID+185), | |
| (1,@OGUID+186), | |
| (1,@OGUID+187), | |
| (1,@OGUID+188), | |
| (1,@OGUID+189), | |
| (1,@OGUID+190), | |
| (1,@OGUID+191), | |
| (1,@OGUID+192), | |
| (1,@OGUID+193), | |
| (1,@OGUID+194), | |
| (1,@OGUID+195), | |
| (1,@OGUID+196), | |
| (1,@OGUID+197), | |
| (1,@OGUID+198), | |
| (1,@OGUID+199), | |
| (1,@OGUID+200), | |
| (1,@OGUID+201), | |
| (1,@OGUID+202), | |
| (1,@OGUID+203), | |
| (1,@OGUID+204), | |
| (1,@OGUID+205), | |
| (1,@OGUID+206), | |
| (1,@OGUID+207), | |
| (1,@OGUID+208), | |
| (1,@OGUID+209), | |
| (1,@OGUID+210), | |
| (1,@OGUID+211), | |
| (1,@OGUID+212), | |
| (1,@OGUID+213), | |
| (1,@OGUID+214), | |
| (1,@OGUID+215), | |
| (1,@OGUID+216), | |
| (1,@OGUID+217), | |
| (1,@OGUID+218), | |
| (1,@OGUID+219), | |
| (1,@OGUID+220), | |
| (1,@OGUID+221), | |
| (1,@OGUID+222), | |
| (1,@OGUID+223), | |
| (1,@OGUID+224), | |
| (1,@OGUID+225), | |
| (1,@OGUID+226), | |
| (1,@OGUID+227), | |
| (1,@OGUID+228), | |
| (1,@OGUID+229), | |
| (1,@OGUID+230), | |
| (1,@OGUID+231), | |
| (1,@OGUID+232), | |
| (1,@OGUID+233), | |
| (1,@OGUID+234), | |
| (1,@OGUID+235), | |
| (1,@OGUID+236), | |
| (1,@OGUID+237), | |
| (1,@OGUID+238), | |
| (1,@OGUID+239), | |
| (1,@OGUID+240), | |
| (1,@OGUID+241), | |
| (1,@OGUID+242), | |
| (1,@OGUID+243), | |
| (1,@OGUID+244), | |
| (1,@OGUID+245), | |
| (1,@OGUID+246), | |
| (1,@OGUID+247), | |
| (1,@OGUID+248), | |
| (1,@OGUID+249), | |
| (1,@OGUID+250), | |
| (1,@OGUID+251), | |
| (1,@OGUID+252), | |
| (1,@OGUID+253), | |
| (1,@OGUID+254), | |
| (1,@OGUID+255), | |
| (1,@OGUID+256), | |
| (1,@OGUID+257), | |
| (1,@OGUID+258), | |
| (1,@OGUID+259), | |
| (1,@OGUID+260), | |
| (1,@OGUID+261), | |
| (1,@OGUID+262), | |
| (1,@OGUID+263), | |
| (1,@OGUID+264), | |
| (1,@OGUID+265), | |
| (1,@OGUID+266), | |
| (1,@OGUID+267), | |
| (1,@OGUID+268), | |
| (1,@OGUID+269), | |
| (1,@OGUID+270), | |
| (1,@OGUID+271), | |
| (1,@OGUID+272), | |
| (1,@OGUID+273), | |
| (1,@OGUID+274), | |
| (1,@OGUID+275), | |
| (1,@OGUID+276), | |
| (1,@OGUID+277), | |
| (1,@OGUID+278), | |
| (1,@OGUID+279), | |
| (1,@OGUID+280), | |
| (1,@OGUID+281), | |
| (1,@OGUID+282), | |
| (1,@OGUID+283), | |
| (1,@OGUID+284), | |
| (1,@OGUID+285), | |
| (1,@OGUID+286), | |
| (1,@OGUID+287), | |
| (1,@OGUID+288), | |
| (1,@OGUID+289), | |
| (1,@OGUID+290), | |
| (1,@OGUID+291), | |
| (1,@OGUID+292), | |
| (1,@OGUID+293), | |
| (1,@OGUID+294), | |
| (1,@OGUID+295), | |
| (1,@OGUID+296), | |
| (1,@OGUID+297), | |
| (1,@OGUID+298), | |
| (1,@OGUID+299), | |
| (1,@OGUID+300), | |
| (1,@OGUID+301), | |
| (1,@OGUID+302), | |
| (1,@OGUID+303), | |
| (1,@OGUID+304), | |
| (1,@OGUID+305), | |
| (1,@OGUID+306), | |
| (1,@OGUID+307), | |
| (1,@OGUID+308), | |
| (1,@OGUID+309), | |
| (1,@OGUID+310), | |
| (1,@OGUID+311), | |
| (1,@OGUID+312), | |
| (1,@OGUID+313), | |
| (1,@OGUID+314), | |
| (1,@OGUID+315), | |
| (1,@OGUID+316), | |
| (1,@OGUID+317), | |
| (1,@OGUID+318), | |
| (1,@OGUID+319), | |
| (1,@OGUID+320), | |
| (1,@OGUID+321), | |
| (1,@OGUID+322), | |
| (1,@OGUID+323), | |
| (1,@OGUID+324), | |
| (1,@OGUID+325), | |
| (1,@OGUID+326), | |
| (1,@OGUID+327), | |
| (1,@OGUID+328), | |
| (1,@OGUID+329), | |
| (1,@OGUID+330), | |
| (1,@OGUID+331), | |
| (1,@OGUID+332), | |
| (1,@OGUID+333), | |
| (1,@OGUID+334), | |
| (1,@OGUID+335), | |
| (1,@OGUID+336), | |
| (1,@OGUID+337), | |
| (1,@OGUID+338), | |
| (1,@OGUID+339), | |
| (1,@OGUID+340), | |
| (1,@OGUID+341), | |
| (1,@OGUID+342), | |
| (1,@OGUID+343), | |
| (1,@OGUID+344), | |
| (1,@OGUID+345), | |
| (1,@OGUID+346), | |
| (1,@OGUID+347), | |
| (1,@OGUID+348), | |
| (1,@OGUID+349), | |
| (1,@OGUID+350), | |
| (1,@OGUID+351), | |
| (1,@OGUID+352), | |
| (1,@OGUID+353), | |
| (1,@OGUID+354), | |
| (1,@OGUID+355), | |
| (1,@OGUID+356), | |
| (1,@OGUID+357), | |
| (1,@OGUID+358), | |
| (1,@OGUID+359), | |
| (1,@OGUID+360), | |
| (1,@OGUID+361), | |
| (1,@OGUID+362), | |
| (1,@OGUID+363), | |
| (1,@OGUID+364), | |
| (1,@OGUID+365), | |
| (1,@OGUID+366), | |
| (1,@OGUID+367), | |
| (1,@OGUID+368), | |
| (1,@OGUID+369), | |
| (1,@OGUID+370), | |
| (1,@OGUID+371), | |
| (1,@OGUID+372), | |
| (1,@OGUID+373), | |
| (1,@OGUID+374), | |
| (1,@OGUID+375), | |
| (1,@OGUID+376), | |
| (1,@OGUID+377), | |
| (1,@OGUID+378), | |
| (1,@OGUID+379), | |
| (1,@OGUID+380), | |
| (1,@OGUID+381), | |
| (1,@OGUID+382), | |
| (1,@OGUID+383), | |
| (1,@OGUID+384), | |
| (1,@OGUID+385), | |
| (1,@OGUID+386), | |
| (1,@OGUID+387), | |
| (1,@OGUID+388), | |
| (1,@OGUID+389), | |
| (1,@OGUID+390), | |
| (1,@OGUID+391), | |
| (1,@OGUID+392), | |
| (1,@OGUID+393), | |
| (1,@OGUID+394), | |
| (1,@OGUID+395), | |
| (1,@OGUID+396), | |
| (1,@OGUID+397), | |
| (1,@OGUID+398), | |
| (1,@OGUID+399), | |
| (1,@OGUID+400), | |
| (1,@OGUID+401), | |
| (1,@OGUID+402), | |
| (1,@OGUID+403), | |
| (1,@OGUID+404), | |
| (1,@OGUID+405), | |
| (1,@OGUID+406), | |
| (1,@OGUID+407), | |
| (1,@OGUID+408), | |
| (1,@OGUID+409), | |
| (1,@OGUID+410), | |
| (1,@OGUID+411), | |
| (1,@OGUID+412), | |
| (1,@OGUID+413), | |
| (1,@OGUID+414), | |
| (1,@OGUID+415), | |
| (1,@OGUID+416), | |
| (1,@OGUID+417), | |
| (1,@OGUID+418); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment