diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_12_25_01_world.sql | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_12_25_01_world.sql b/sql/updates/world/3.3.5/2019_12_25_01_world.sql new file mode 100644 index 00000000000..3b5183eea91 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_12_25_01_world.sql @@ -0,0 +1,82 @@ +-- +UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `guid` IN (66811,66812,66880,66810,66877,67245,66876,67244,67133,67091,67097,67096,67098,67099,66860); +UPDATE `creature` SET `position_x`=-287.625336, `position_y`=-248.157379, `position_z`=15.033414, `orientation`=5.400887 WHERE `guid`= 67133; +UPDATE `creature` SET `position_x`=-287.953674, `position_y`=-290.882690, `position_z`=20.455458, `orientation`=4.992473 WHERE `guid`= 67149; +UPDATE `creature` SET `position_x`=-251.959885, `position_y`=-279.733002, `position_z`=15.209331 WHERE `guid`= 66880; + +DELETE FROM `creature_addon` WHERE `guid` IN (85584,67088,67087); +DELETE FROM `creature` WHERE `guid` IN (85584,67088,67087); +DELETE FROM `linked_respawn` WHERE `guid` IN (85584,67088,67087); + + +DELETE FROM `creature_equip_template` WHERE `Creatureid` IN (18794,22407,25115); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`) VALUES +(18794, 4, 19980, 19980, 0), -- 18794 +(18794, 3, 12421, 0, 0), -- 18794 +(18794, 2, 13718, 0, 0), -- 18794 +(18794, 1, 14618, 0, 0), -- 18794 +(22407, 6, 1910, 13610, 2551), -- 22407 +(22407, 5, 3367, 13610, 2551), -- 22407 +(22407, 4, 2695, 13610, 2551), -- 22407 +(22407, 3, 1902, 13610, 2551), -- 22407 +(22407, 2, 3346, 13610, 2551), -- 22407 +(22407, 1, 3362, 13610, 2551), -- 22407 +(25115, 2, 34596, 34590, 0), -- 25115 +(25115, 1, 31743, 34588, 0); -- 25115 + +UPDATE `creature` SET `equipment_id`=-1 WHERE `id` IN (18794,22407,25115); +DELETE FROM `creature` WHERE `guid` IN (66844,66849,66853,66854,66883, 66888, 66893, 67087, 67088, 68738); +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 +(66844, 18631, 555, 3, 1, 0, 1, -360.47573, -261.38497, 12.68642, 6.201027, 7200, 0, 0, 0, 0, 0), +(66849, 18631, 555, 3, 1, 0, 1, -360.35812, -268.02179, 12.68686, 0.122045, 7200, 0, 0, 0, 0, 0), +(66853, 18631, 555, 3, 1, 0, 1, -313.30258, -268.90744, 12.68361, 3.209616, 7200, 0, 0, 0, 0, 0), +(66854, 18796, 555, 3, 1, 0, 1, -431.59906, -196.09413, 12.68912, 1.51927, 7200, 0, 0, 0, 0, 2), +(66883, 18794, 555, 3, 1, 0, -1,-138.49711, -71.4171, 8.0668, 4.649072, 7200, 0, 0, 0, 0, 0), +(66888, 18794, 555, 3, 1, 0, -1,-174.36454, -71.2073, 8.0672, 4.707983, 7200, 0, 0, 0, 0, 0), +(66893, 18794, 555, 3, 1, 0, -1,-157.13359, -51.8795, 8.0718, 4.645149, 7200, 0, 0, 0, 0, 0), +(67087, 18794, 555, 3, 1, 0, -1,-157.09144, -13.0580, 8.0718, 4.660861, 7200, 0, 0, 0, 0, 0), +(67088, 18794, 555, 3, 1, 0, -1,-138.56492, 6.409202, 8.0718, 4.598028, 7200, 0, 0, 0, 0, 0), +(68738, 18794, 555, 3, 1, 0, -1,-174.35505, 6.896342, 8.0718, 4.688349, 7200, 0, 0, 0, 0, 0); + +UPDATE `creature` SET `orientation`=0.022214 WHERE `guid` IN (66853, 67245, 66877, 66810); +UPDATE `creature` SET `MovementType`=2, `spawndist`=0 WHERE `guid` IN (67248); + +DELETE FROM `creature_addon` WHERE `guid` IN (66854,66844,66849,66853,66810,67248,66880); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`,`bytes2`) VALUES +(66854, 668540, 0, 1), +(66844, 0, 8, 1), +(66849, 0, 8, 1), +(66853, 0, 8, 1), +(66810, 0, 8, 1), +(66880, 0, 0, 1), +(67248, 672480, 0, 1); + +DELETE FROM `waypoint_data` WHERE `id` IN (668540,672480); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(668540, 1, -431.59899, -196.09399, 12.68910, 1.519270, 0, 0, 0, 100, 0), +(668540, 2, -427.69046, -173.98111, 12.85872, 1.586018, 0, 0, 0, 100, 0), +(668540, 3, -429.15615, -156.17640, 12.81885, 1.472135, 0, 0, 0, 100, 0), +(668540, 4, -421.06964, -138.27380, 13.30665, 1.279713, 0, 0, 0, 100, 0), +(668540, 5, -427.66757, -114.31536, 12.68915, 2.210410, 0, 0, 0, 100, 0), +(668540, 6, -434.12530, -128.57087, 12.70553, 4.499842, 0, 0, 0, 100, 0), +(668540, 7, -437.27182, -152.70719, 12.36017, 4.558748, 0, 0, 0, 100, 0), +(668540, 8, -430.35965, -164.06910, 12.53223, 5.261678, 0, 0, 0, 100, 0), +(668540, 9, -436.86901, -180.61929, 13.03278, 4.374177, 0, 0, 0, 100, 0), +(672480,1, -249.33099, -281.855, 16.4914, 5.309800, 0, 0, 0, 100, 0), +(672480,2, -237.70388, -278.939, 17.0863, 0.483321, 0, 0, 0, 100, 0), +(672480,3, -231.84585, -269.813, 17.0863, 1.622149, 0, 0, 0, 100, 0), +(672480,4, -233.26937, -254.501, 17.0863, 1.845988, 0, 0, 0, 100, 0), +(672480,5, -245.76385, -245.834, 17.0863, 2.682437, 0, 0, 0, 100, 0), +(672480,6, -258.52417, -246.559, 12.6796, 3.283267, 0, 0, 0, 100, 0), +(672480,7, -274.94870, -250.880, 12.6817, 3.617061, 0, 0, 0, 100, 0), +(672480,8, -281.15856, -263.627, 12.6817, 4.610585, 0, 0, 0, 100, 0), +(672480,9, -274.11102, -275.567, 12.6817, 5.423469, 0, 0, 0, 100, 0), +(672480,10, -274.11102, -275.567, 12.6817, 5.423469, 0, 0, 0, 100, 0), +(672480,11, -262.74783, -279.464, 12.6817, 6.004661, 0, 0, 0, 100, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (67248); +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(67248,67248,0,0,515,0,0), +(67248,66811,2,90,515,0,0), +(67248,66812,2,270,515,0,0), +(67248,66880,4,270,515,0,0); |