diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_04_02_world_335.sql | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_04_02_world_335.sql b/sql/updates/world/3.3.5/2019_04_04_02_world_335.sql new file mode 100644 index 00000000000..9732f2cda0b --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_04_02_world_335.sql @@ -0,0 +1,67 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (60872, 60873, 60874, 60875, 60876, 60877, 60878, 60879, 60880, 60847, 60848, 60849, 60850, 60851, 60852, 60853, 60854, 60856, 60858, 60859, 60860, 60861, 60862, 60863, 60864, 60865, 60866, 60867, 60868, 60869, 60870, 60871, 60815, 60816, 60817, 60818, 60819, 60820, 60821, 60822, 60823, 60824, 60825, 60826, 60827, 60828, 60829, 60830, 60831, 60832, 60833, 60834, 60835, 60836, 60837, 60838, 60839, 60840, 60841, 60842, 60843, 60844, 60845, 60846); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(60815, 12123, 0, 1, 1, 0, 0, 536.509, 581.44, 32.354, 5.349, 900, 15, 0, 1563, 0, 1), +(60816, 12123, 0, 1, 1, 0, 0, 546.05, 499.079, 23.215, 3.984, 900, 15, 0, 1563, 0, 1), +(60817, 12123, 0, 1, 1, 0, 0, 546.606, 421.038, 29.098, 3.391, 900, 15, 0, 1563, 0, 1), +(60818, 12123, 0, 1, 1, 0, 0, 561.966, 356.591, 21.723, 5.129, 900, 15, 0, 1563, 0, 1), +(60819, 12123, 0, 1, 1, 0, 0, 644.573, 264.149, 23.835, 4.854, 900, 15, 0, 1563, 0, 1), +(60820, 12123, 0, 1, 1, 0, 0, 710.756, 124.868, 25.219, 4.143, 900, 15, 0, 1563, 0, 1), +(60821, 12123, 0, 1, 1, 0, 0, 755.543, 416.689, 25.132, 1.282, 900, 15, 0, 1563, 0, 1), +(60822, 12123, 0, 1, 1, 0, 0, 766.382, 492.396, 23.03, 1.134, 900, 15, 0, 1563, 0, 1), +(60823, 12123, 0, 1, 1, 0, 0, 769.299, 1937.9, -1, 1.325, 900, 15, 0, 1563, 0, 1), +(60824, 12123, 0, 1, 1, 0, 0, 778.513, 32.748, 28.2, 5.513, 900, 15, 0, 1563, 0, 1), +(60825, 12123, 0, 1, 1, 0, 0, 835.404, 300.741, 26.666, 1.726, 900, 15, 0, 1563, 0, 1), +(60826, 12123, 0, 1, 1, 0, 0, 896.506, 270.493, 26.541, 2.148, 900, 15, 0, 1563, 0, 1), +(60827, 12123, 0, 1, 1, 0, 0, 899.453, 1962.21, -1, 5.517, 900, 15, 0, 1563, 0, 1), +(60828, 12123, 0, 1, 1, 0, 0, 916.189, 53.677, 26.993, 1.01, 900, 15, 0, 1563, 0, 1), +(60829, 12123, 0, 1, 1, 0, 0, 1003.72, 72.59, -7, 5.811, 900, 15, 0, 1563, 0, 1), +(60830, 12123, 0, 1, 1, 0, 0, 1061.58, 2115.83, -1, 3.681, 900, 15, 0, 1563, 0, 1), +(60831, 12123, 0, 1, 1, 0, 0, 1084.64, 156.658, 26.153, 2.47, 900, 15, 0, 1563, 0, 1), +(60832, 12123, 0, 1, 1, 0, 0, 1094.23, 47.914, -8, 0.064, 900, 15, 0, 1563, 0, 1), +(60833, 12123, 0, 1, 1, 0, 0, 1123.38, 2157.27, -1, 1.12, 900, 15, 0, 1563, 0, 1), +(60834, 12123, 0, 1, 1, 0, 0, 1132.63, 104.252, 25.101, 1.073, 900, 15, 0, 1563, 0, 1), +(60835, 12123, 1, 1, 1, 0, 0, 3573.6, 1690.85, -69, 1.893, 900, 15, 0, 1563, 0, 1), +(60836, 12123, 1, 1, 1, 0, 0, 3598.23, 1496.97, -59, 2.947, 900, 15, 0, 1563, 0, 1), +(60837, 12123, 1, 1, 1, 0, 0, 3934.92, 1520.13, -82, 2.908, 900, 15, 0, 1563, 0, 1), +(60838, 12123, 1, 1, 1, 0, 0, 4371.19, 1238.92, -52, 2.548, 900, 15, 0, 1563, 0, 1), +(60839, 12123, 1, 1, 1, 0, 0, 4162.36, 1611.14, -57.7048, 6.23635, 900, 15, 0, 1563, 0, 1), +(60840, 12123, 1, 1, 1, 0, 0, 3725.16, 1596.94, -79.314, 3.44137, 900, 15, 0, 1563, 0, 1), +(60841, 12123, 0, 1, 1, 0, 0, -11327.4, 2292.78, -48.1677, 5.9158, 900, 15, 0, 1563, 0, 1), +(60842, 12123, 0, 1, 1, 0, 0, -10638.2, 2354.37, -49.2443, 0.663808, 900, 15, 0, 1563, 0, 1), +(60843, 12123, 0, 1, 1, 0, 0, -9985.74, 2374.5, -49.2355, 3.07988, 900, 15, 0, 1563, 0, 1), +(60844, 12123, 0, 1, 1, 0, 0, -9783.67, 2353.35, -49.3094, 0.719519, 900, 15, 0, 1563, 0, 1), +(60845, 12123, 0, 1, 1, 0, 0, 764.92, 2122.22, -49.1087, 2.98233, 900, 15, 0, 1563, 0, 1), +(60846, 12123, 0, 1, 1, 0, 0, 1073.79, 2203.23, -27.7753, 3.81475, 900, 15, 0, 1563, 0, 1), +(60847, 12124, 1, 1, 1, 0, 0, -10270, -4498, -10, 3.351, 900, 15, 0, 8022, 0, 1), +(60848, 12124, 1, 1, 1, 0, 0, -9950, -2766, -5, 1.549, 900, 15, 0, 8022, 0, 1), +(60849, 12124, 1, 1, 1, 0, 0, -9918, -3272, -10, 5.504, 900, 15, 0, 8022, 0, 1), +(60850, 12124, 1, 1, 1, 0, 0, -9257, -4765, -6, 2.538, 900, 15, 0, 8022, 0, 1), +(60851, 12124, 1, 1, 1, 0, 0, -9031, -4754, -2, 5.21, 900, 15, 0, 8022, 0, 1), +(60852, 12124, 1, 1, 1, 0, 0, -8967, -4736, -14, 4.379, 900, 15, 0, 8022, 0, 1), +(60853, 12124, 1, 1, 1, 0, 0, -8683, -5351, -67, 2.421, 900, 15, 0, 8022, 0, 1), +(60854, 12124, 1, 1, 1, 0, 0, -8556, -5368, -7, 4.522, 900, 15, 0, 8022, 0, 1), +(60856, 12124, 1, 1, 1, 0, 0, -8260, -5424, -6, 2.441, 900, 15, 0, 8022, 0, 1), +(60858, 12124, 1, 1, 1, 0, 0, -8146, -5495, -11, 2.867, 900, 15, 0, 8022, 0, 1), +(60859, 12124, 1, 1, 1, 0, 0, -7877, -5452, -9, 5.159, 900, 15, 0, 8022, 0, 1), +(60860, 12124, 1, 1, 1, 0, 0, -7862, -5524, -9, 4.881, 900, 15, 0, 8022, 0, 1), +(60861, 12124, 1, 1, 1, 0, 0, -7621, -5110, -21, 5.424, 900, 15, 0, 8022, 0, 1), +(60862, 12124, 1, 1, 1, 0, 0, -7620, -5040, -15, 4.437, 900, 15, 0, 8022, 0, 1), +(60863, 12124, 1, 1, 1, 0, 0, -10531.1, -4098.5, -47.3247, 5.2446, 900, 15, 0, 8022, 0, 1), +(60864, 12124, 1, 1, 1, 0, 0, -10054.6, -4651.05, -82.2836, 0.0316, 900, 15, 0, 8022, 0, 1), +(60865, 12124, 1, 1, 1, 0, 0, -9870.3, -4875.37, -65.6569, 4.53916, 900, 15, 0, 8022, 0, 1), +(60866, 12124, 1, 1, 1, 0, 0, -8994.03, -4864.52, -75.1901, 5.30168, 900, 15, 0, 8022, 0, 1), +(60867, 12124, 1, 1, 1, 0, 0, -8776.63, -5152.86, -84.8627, 2.13332, 900, 15, 0, 8022, 0, 1), +(60868, 12124, 1, 1, 1, 0, 0, -8429.36, -5566.23, -60.2951, 0.728435, 900, 15, 0, 8022, 0, 1), +(60869, 12124, 1, 1, 1, 0, 0, -7793.1, -5573.22, -60.2456, 0.0753537, 900, 15, 0, 8022, 0, 1), +(60870, 12124, 1, 1, 1, 0, 0, -7578.31, -5245.54, -51.6413, 4.34747, 900, 15, 0, 8022, 0, 1), +(60871, 12124, 0, 1, 1, 0, 0, -894.288, -4853.98, -48.1651, 1.19278, 900, 15, 0, 8022, 0, 1), +(60872, 12125, 1, 1, 1, 0, 0, 2260.87, -7392.35, -39.3942, 1.46946, 900, 15, 0, 10796, 0, 1), +(60873, 12125, 1, 1, 1, 0, 0, 2141.54, -7237.98, -32.0054, 1.83467, 900, 15, 0, 10796, 0, 1), +(60874, 12125, 1, 1, 1, 0, 0, 3575.07, -6375.8, -33.5823, 4.58606, 900, 15, 0, 10796, 0, 1), +(60875, 12125, 1, 1, 1, 0, 0, 5107.84, -6557.01, -22.213, 5.69849, 900, 15, 0, 10796, 0, 1), +(60876, 12125, 1, 1, 1, 0, 0, 2607.06, -7393.85, -36.409, 3.158925, 900, 15, 0, 10796, 0, 1), +(60877, 12125, 1, 1, 1, 0, 0, 4146.76, -6796.36, -12.9569, 1.08111, 900, 15, 0, 10796, 0, 1), +(60878, 12125, 1, 1, 1, 0, 0, 4029.04, -6521.56, -11.6539, 2.93048, 900, 15, 0, 10796, 0, 1), +(60879, 12125, 1, 1, 1, 0, 0, 2807.91, -7145.15, -24.6603, 1.25786, 900, 15, 0, 10796, 0, 1), +(60880, 12125, 1, 1, 1, 0, 0, 5164.87, -6681.64, -30.195, 5.30724, 900, 15, 0, 10796, 0, 1); |