diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_12_09_00_world.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_12_09_00_world.sql b/sql/updates/world/3.3.5/2019_12_09_00_world.sql new file mode 100644 index 00000000000..d89d2379106 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_12_09_00_world.sql @@ -0,0 +1,32 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (120429, 120430, 120431, 120432, 120496, 120516, 120517, 120524, 120525, 120527, 120528, 120529, 120530, 120531, 120532, 120535, 120536, 120537, 120538, 120539, 120540, 120541, 120542); +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 +(120429, 31435, 571, 0, 0, 1, 8, 0, 1, 5879.417, 2100.573, 509.0201, 3.560472, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) +(120430, 31435, 571, 0, 0, 1, 8, 0, 1, 5891.056, 2021.512, 512.9142, 2.565634, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) +(120431, 31435, 571, 0, 0, 1, 8, 0, 1, 5893.938, 2024.526, 513.2369, 2.600541, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) +(120432, 31435, 571, 0, 0, 1, 8, 0, 1, 5885.642, 1991.998, 514.4342, 2.80998, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) +(120496, 31435, 571, 0, 0, 1, 8, 0, 1, 5848.652, 2096.577, 503.949, 3.368485, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120516, 31435, 571, 0, 0, 1, 8, 0, 1, 5863.017, 2051.382, 504.0689, 2.80998, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120517, 31435, 571, 0, 0, 1, 8, 0, 1, 5863.935, 2122.72, 507.8875, 3.630285, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120524, 31435, 571, 0, 0, 1, 8, 0, 1, 5848.652, 2096.577, 503.949, 3.368485, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120525, 31435, 571, 0, 0, 1, 8, 0, 1, 5705.1, 2164.94, 506.448, 5.14872, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120527, 31435, 571, 0, 0, 1, 8, 0, 1, 5744.73, 2172.21, 505.841, 3.46446, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120528, 31435, 571, 0, 0, 1, 8, 0, 1, 5788.44, 2198.33, 513.466, 4.15388, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120529, 31435, 571, 0, 0, 1, 8, 0, 1, 5780.13, 2200.04, 513.765, 4.45059, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(120530, 31646, 571, 0, 0, 1, 8, 0, 0, 5818.827, 2034.414, 503.4009, 0.9773844, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344) +(120531, 31646, 571, 0, 0, 1, 8, 0, 0, 5815.766, 2043.798, 503.3762, 4.153883, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344) +(120532, 31646, 571, 0, 0, 1, 8, 0, 0, 5788.609, 1993.956, 435.3794, 3.612832, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344) +(120535, 31646, 571, 0, 0, 1, 8, 0, 0, 5784.868, 2020.841, 491.8832, 0.4363323, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344) +(120536, 31646, 571, 0, 0, 1, 8, 0, 0, 5763.881, 2043.713, 493.9036, 3.106686, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344) +(120537, 31646, 571, 0, 0, 1, 8, 0, 0, 5764.212, 2045.802, 501.5097, 5.166174, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344) +(120538, 31646, 571, 0, 0, 1, 8, 0, 0, 5767.917, 2058.603, 475.9332, 4.433136, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344) +(120539, 31646, 571, 0, 0, 1, 8, 0, 0, 5703.195, 1997.119, 120.5905, 3.665191, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) +(120540, 31646, 571, 0, 0, 1, 8, 0, 0, 5685.622, 2088.298, 279.9338, 3.804818, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) +(120541, 31646, 571, 0, 0, 1, 8, 0, 0, 5680.397, 2073.604, -20.91908, 1.48353, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) +(120542, 31646, 571, 0, 0, 1, 8, 0, 0, 5688.017, 2092.321, 455.6302, 2.460914, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007); -- 31646 (Area: -1 - Difficulty: 0) + +DELETE FROM `creature_template_addon` WHERE `entry` IN (31435); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(31435, 0, 0, 0, 1, 425, ''); -- 31435 + +UPDATE `creature` SET `position_x`=5907.302, `position_y`=1998.576, `position_z`=517.1657, `orientation`=2.792527 WHERE `id`=31440; |