diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_02_13_05_world_335.sql | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_02_13_05_world_335.sql b/sql/updates/world/3.3.5/2020_02_13_05_world_335.sql new file mode 100644 index 00000000000..bb6a81bef92 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_02_13_05_world_335.sql @@ -0,0 +1,79 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN (9308, 9310, 9311, 9313, 9314, 9315, 9319, 9320, 9321); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(9308, 186709, 1, 14, 0, 1, 1, 814.4857, -4511.654, 7.606778, -1.466076, 0, 0, -0.6691303, 0.743145, 120, 255, 1, 12340), -- 186709 (Area: 0 - Difficulty: 0) +(9310, 186808, 1, 14, 0, 1, 1, 829.316, -4518.374, 5.778345, 1.431168, 0, 0, 0.6560583, 0.7547102, 120, 255, 1, 12340), -- 186808 (Area: 0 - Difficulty: 0) +(9311, 186809, 1, 14, 0, 1, 1, 815.2645, -4550.106, 4.980033, 1.832595, 0, 0, 0.7933531, 0.6087617, 120, 255, 1, 12340), -- 186809 (Area: 0 - Difficulty: 0) +(9313, 186709, 1, 14, 0, 1, 1, 824.7836, -4514.576, 6.920554, -0.4886912, 0, 0, -0.2419214, 0.9702958, 120, 255, 1, 12340), -- 186709 (Area: 0 - Difficulty: 0) +(9314, 186709, 1, 14, 0, 1, 1, 823.3483, -4507.215, 7.881104, 0.8203033, 0, 0, 0.3987484, 0.9170604, 120, 255, 1, 12340), -- 186709 (Area: 0 - Difficulty: 0) +(9315, 186331, 1, 14, 0, 1, 1, 818.7207, -4549.273, 4.924, 0.373065, 0, 0, -0.1218691, 0.9925462, 120, 255, 1, 12340), -- 186331 (Area: 1296 - Difficulty: 0) +(9319, 186717, 1, 14, 0, 1, 1, 832.1469, -4505.444, 7.002714, -0.06981169, 0, 0, -0.03489876, 0.9993908, 120, 255, 1, 12340), -- 186717 (Area: 0 - Difficulty: 0) +(9320, 186807, 1, 14, 0, 1, 1, 828.4379, -4508.498, 6.702892, -2.33874, 0, 0, -0.9205046, 0.3907318, 120, 255, 1, 12340), -- 186807 (Area: 0 - Difficulty: 0) +(9321, 186717, 1, 14, 0, 1, 1, 832.8605, -4512.396, 6.117729, 0.157079, 0, 0, 0.07845879, 0.9969174, 120, 255, 1, 12340); -- 186717 (Area: 0 - Difficulty: 0) + +DELETE FROM `creature` WHERE `guid` IN (119120, 119121, 119143, 123721, 124074, 124075, 124076, 124077, 124078, 124079, 124080, 124081, 124082, 124083, 124085, 124086, 124104, 124105, 124106, 124107, 124108, 124109, 124110, 200002); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(119120, 23706, 1, 14, 1296, 1, 1, 0, 0, 1222.903, -4296.746, 21.27534, 5.61996, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23706 (Area: 1296 - Difficulty: 0) +(119121, 23808, 1, 14, 1296, 1, 1, 0, 0, 1187.311, -4314.685, 21.31664, 1.489622, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23808 (Area: 1296 - Difficulty: 0) (possible waypoints or random movement) +(119143, 23808, 1, 14, 1296, 1, 1, 0, 0, 1220.107, -4298.071, 21.31664, 1.372651, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23808 (Area: 1296 - Difficulty: 0) (possible waypoints or random movement) +(123721, 23808, 1, 14, 1296, 1, 1, 0, 0, 1184.696, -4275.281, 21.27065, 3.134971, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23808 (Area: 1296 - Difficulty: 0) (possible waypoints or random movement) +(124074, 24109, 1, 14, 1296, 1, 1, 0, 0, 1182.202, -4359.772, 21.37942, 1.919862, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24109 (Area: 1296 - Difficulty: 0) +(124075, 24109, 1, 14, 1296, 1, 1, 0, 0, 1180.387, -4350.724, 21.37947, 4.834562, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24109 (Area: 1296 - Difficulty: 0) +(124076, 24372, 1, 14, 1296, 1, 1, 0, 0, 1184.316, -4314.621, 21.37921, 0.2792527, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24372 (Area: 1296 - Difficulty: 0) +(124077, 24766, 1, 14, 1296, 1, 1, 0, 0, 1204.837, -4296.609, 21.27519, 6.161012, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24766 (Area: 1296 - Difficulty: 0) +(124078, 24766, 1, 14, 1296, 1, 1, 0, 0, 1263.953, -4409.64, 25.77201, 3.246312, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24766 (Area: 1296 - Difficulty: 0) +(124079, 28329, 1, 14, 1296, 1, 1, 0, 0, 834.754, -4515.3037, 5.8039, 5.950273, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 28329 (Area: 1296 - Difficulty: 0) +(124080, 24373, 1, 14, 1296, 1, 1, 0, 0, 1182.845, -4273.276, 21.27497, 3.543018, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24373 (Area: 1296 - Difficulty: 0) +(124081, 23703, 1, 14, 1296, 1, 1, 0, 0, 1199.712, -4293.622, 21.31112, 5.602507, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23703 (Area: 1296 - Difficulty: 0) +(124082, 23706, 0, 1, 0, 1, 1, 0, 0, -5146.527, -576.4496, 397.2595, 3.804818, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23706 (Area: 0 - Difficulty: 0) +(124083, 23808, 0, 1, 809, 1, 1, 0, 0, -5183.954, -601.5804, 397.3012, 0.9062196, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23808 (Area: 809 - Difficulty: 0) (possible waypoints or random movement) +(124085, 23808, 0, 1, 809, 1, 1, 0, 0, -5159.305, -629.6109, 397.2245, 2.806662, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23808 (Area: 809 - Difficulty: 0) (possible waypoints or random movement) +(124086, 23808, 0, 1, 0, 1, 1, 0, 0, -5146.068, -579.8771, 397.3012, 2.30973, 120, 10, 0, 0, 0, 1, 0, 0, 0, 12340), -- 23808 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(124104, 24109, 0, 1, 0, 1, 1, 0, 0, -5167.119, -547.3276, 397.2595, 1.48353, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24109 (Area: 0 - Difficulty: 0) +(124105, 24109, 0, 1, 0, 1, 1, 0, 0, -5168.079, -538.463, 397.2599, 5.288348, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24109 (Area: 0 - Difficulty: 0) +(124106, 24766, 0, 1, 809, 1, 1, 0, 0, -5165.246, -603.4328, 398.0052, 2.530727, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24766 (Area: 809 - Difficulty: 0) +(124107, 24766, 0, 1, 0, 1, 1, 0, 0, -5209.471, -488.2339, 388.9122, 3.036873, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 24766 (Area: 0 - Difficulty: 0) +(124108, 23703, 0, 1, 0, 1, 1, 0, 0, -5152.337, -604.9965, 398.5365, 5.602507, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23703 (Area: 0 - Difficulty: 0) +(124109, 23700, 0, 1, 809, 1, 1, 0, 0, -5185.964, -599.7956, 397.4729, 0.122173, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 23700 (Area: 809 - Difficulty: 0) +(124110, 23702, 0, 1, 809, 1, 1, 0, 0, -5159.866, -631.8079, 397.263, 5.061455, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340); -- 23702 (Area: 809 - Difficulty: 0) + +UPDATE `creature_template_addon` SET `bytes2`=257, `auras`='44067' WHERE `entry` IN (24527); +UPDATE `creature` SET `position_x`=837.6661, `position_y`=-4508.808, `position_z`=6.147511, `orientation`=0.4014257 WHERE `id`=24527; + +DELETE FROM `game_event_gameobject` WHERE `guid` IN (9308, 9310, 9311, 9313, 9314, 9315, 9319, 9320, 9321); +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(24, 9308), +(24, 9310), +(24, 9311), +(24, 9313), +(24, 9314), +(24, 9315), +(24, 9319), +(24, 9320), +(24, 9321); + +DELETE FROM `game_event_creature` WHERE `guid` IN (119120, 119121, 119143, 123721, 124074, 124075, 124076, 124077, 124078, 124079, 124080, 124081, 124082, 124083, 124085, 124086, 124104, 124105, 124106, 124107, 124108, 124109, 124110, 200002); +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(24, 119120), +(24, 119121), +(24, 119143), +(24, 123721), +(24, 124074), +(24, 124075), +(24, 124076), +(24, 124077), +(24, 124078), +(24, 124079), +(24, 124080), +(24, 124081), +(24, 124082), +(24, 124083), +(24, 124085), +(24, 124086), +(24, 124104), +(24, 124105), +(24, 124106), +(24, 124107), +(24, 124108), +(24, 124109), +(24, 124110); |