diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_03_27_01_world_335.sql | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_03_27_01_world_335.sql b/sql/updates/world/3.3.5/2020_03_27_01_world_335.sql new file mode 100644 index 00000000000..d1c96906426 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_03_27_01_world_335.sql @@ -0,0 +1,67 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (128907, 128908, 128909, 128911, 128912, 128913, 128914, 128915, 128916, 128917, 128918, 128920, 128921, 128922, 128926, 128928, 128929, 128930, 128931, 128932, 128933, 128937, 128938, 128940, 128941, 128942, 128943, 128944, 128945, 128947, 128950, 128951, 128952, 128953, 128954, 128955, 128956, 128958, 128959, 128960, 128961, 128962, 128963, 128964, 128965, 128966, 128967, 128968, 128969, 128970, 128971, 128972, 128973, 128975, 128976, 128977, 128978, 128979); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(128907, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6733.524, -7507.143, 135.0884, 1.815142, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 0 - Difficulty: 0) +(128908, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6737.246, -7542.648, 136.4377, 5.61996, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128909, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6728.034, -7547.981, 134.7065, 4.118977, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128911, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6717.894, -7548.413, 130.3475, 6.003932, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128912, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6751.983, -7555.144, 126.2431, 6.108652, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128913, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6710.248, -7548.349, 131.0916, 2.6529, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128914, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6733.176, -7524.163, 149.4111, 6.056293, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128915, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6763.377, -7548.288, 126.2045, 5.201081, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128916, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6743.279, -7565.824, 126.6241, 3.630285, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128917, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6711.274, -7539.663, 136.6431, 5.742133, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128918, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6743.703, -7546.709, 130.9521, 1.099557, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128920, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6743.825, -7522.063, 136.8107, 3.700098, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128921, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6735.063, -7563.102, 127.515, 0.1745329, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128922, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6743.558, -7532.399, 136.9386, 2.600541, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128926, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6745.086, -7510.544, 130.0613, 2.007129, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128928, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6731.822, -7530.354, 150.1324, 4.729842, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128929, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6730.871, -7533.367, 148.853, 4.886922, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128930, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6723.319, -7534.905, 149.1803, 1.361357, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128931, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6740.805, -7517.562, 137.6342, 1.727876, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128932, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6737.625, -7570.733, 127.2271, 1.047198, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128933, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6749.511, -7544.932, 128.156, 3.263766, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128937, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6736.104, -7547.665, 130.1274, 2.373648, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128938, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6729.538, -7541.351, 140.0154, 4.572762, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128940, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6733.276, -7528.404, 149.4194, 2.059489, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128941, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6751.229, -7520.547, 130.2144, 1.448623, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128942, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6734.164, -7543.616, 136.616, 5.235988, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128943, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6738.067, -7528.796, 143.0863, 4.24115, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128944, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6733.69, -7525.793, 149.0001, 4.520403, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128945, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6747.819, -7574.272, 127.3716, 1.954769, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128947, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6750.131, -7556.323, 126.2317, 5.183628, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128950, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6726.721, -7538.983, 143.0069, 1.22173, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128951, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6756.315, -7550.757, 126.2304, 3.420845, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128952, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6719.127, -7530.586, 149.696, 4.380776, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128953, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6729.935, -7528.341, 156.399, 5.742133, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128954, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6749.385, -7565.681, 126.4881, 5.026548, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128955, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6762.896, -7566.955, 126.9341, 5.969026, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128956, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6753.799, -7541.531, 126.2293, 0.9424778, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128958, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6729.032, -7534.51, 149.1907, 0.08726646, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128959, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6723.139, -7545.024, 136.9881, 4.590216, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128960, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6729.135, -7529.51, 157.4464, 1.064651, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128961, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6753.506, -7533.313, 127.2006, 1.710423, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128962, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6739.924, -7552.51, 126.5525, 5.67232, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128963, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6731.415, -7530.935, 150.0135, 0.08726646, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128964, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6736.174, -7557.457, 141.2811, 1.989675, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128965, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6744.292, -7538.554, 140.0559, 5.288348, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128966, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6720.032, -7550.589, 144.775, 6.213372, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128967, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6738.282, -7537.181, 139.0485, 5.689773, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128968, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6730.887, -7531.316, 150.0909, 6.073746, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128969, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6761.365, -7557.158, 126.3121, 4.153883, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128970, 23746, 530, 3433, 3517, 1, 1, 0, 0, 6757.071, -7519.971, 127.0573, 4.974188, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23746 (Area: 3517 - Difficulty: 0) +(128971, 23747, 530, 3433, 3517, 1, 1, 0, 0, 6754.189, -7573.991, 127.3143, 4.046139, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23747 (Area: 3517 - Difficulty: 0) (possible waypoints or random movement) +(128972, 23766, 530, 3433, 3517, 1, 1, 0, 1, 6742.246, -7556.369, 126.2342, 2.164208, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23766 (Area: 3517 - Difficulty: 0) +(128973, 25145, 530, 3433, 3517, 1, 1, 0, 1, 6741.154, -7621.194, 126.437, 1.144044, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 25145 (Area: 3517 - Difficulty: 0) +(128975, 25145, 530, 3433, 3517, 1, 1, 0, 1, 6786.622, -7619.711, 128.3298, 6.178465, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 25145 (Area: 3517 - Difficulty: 0) +(128976, 23747, 530, 3433, 3517, 1, 1, 0, 0, 6777.938, -7569.957, 127.7917, 5.082421, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23747 (Area: 3517 - Difficulty: 0) (possible waypoints or random movement) +(128977, 25145, 530, 3433, 3517, 1, 1, 0, 1, 6738.161, -7604.249, 126.6531, 0.2617994, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 25145 (Area: 3517 - Difficulty: 0) +(128978, 23745, 530, 3433, 3517, 1, 1, 0, 1, 6774.364, -7632.227, 127.4824, 4.014257, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23745 (Area: 3517 - Difficulty: 0) (possible waypoints or random movement) +(128979, 25145, 530, 3433, 3517, 1, 1, 0, 1, 6779.608, -7651.695, 127.4116, 5.148721, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340); -- 25145 (Area: 3517 - Difficulty: 0) + +UPDATE `creature` SET `position_x`=6766.7163, `position_y`=-7616.01123, `position_z`=128.28227, `orientation`=0.129591 WHERE `id`= 23761; +UPDATE `creature` SET `position_x`=6774.1254, `position_y`=-7611.43701, `position_z`=128.71919, `orientation`=3.738494 WHERE `id`= 23559; +UPDATE `creature` SET `position_x`=6741.0483, `position_y`=-7614.48144, `position_z`=126.00965, `orientation`=2.591816 WHERE `id`= 23724; +UPDATE `creature` SET `position_x`=6791.5605, `position_y`=-7541.28320, `position_z`=126.10881, `orientation`=4.461057 WHERE `id`= 23748; +UPDATE `creature_template_addon` SET `auras`="32951" WHERE `entry` IN (23565); |