diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_11_56_world_2019_06_23_19_world.sql | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_11_56_world_2019_06_23_19_world.sql b/sql/updates/world/master/2021_12_11_56_world_2019_06_23_19_world.sql new file mode 100644 index 00000000000..7301e1fee29 --- /dev/null +++ b/sql/updates/world/master/2021_12_11_56_world_2019_06_23_19_world.sql @@ -0,0 +1,38 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN(9216,9218,9222) AND `id` IN (192474,192475,192473); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(9216, 192474, 571, '0', 0, 7370.37, 4879.1, 1.0929, 2.92342, 0, 0, 0.994056, 0.10887, 300, 255, 1), +(9218, 192475, 571, '0', 0, 7362.43, 4853.38, 0.244615, 2.86233, 0, 0, 0.990267, 0.139178, 300, 255, 1), +(9222, 192473, 571, '0', 0, 7816.62, 4705.44, 0.338167, 1.57952, 0, 0, 0.710184, 0.704016, 300, 255, 1); + +DELETE FROM `creature` WHERE `guid` IN (111106, 111111, 111112, 111127, 111128, 111129, 111130, 111131, 111132, 111133, 111134, 111135, 111136, 111138, 111139, 111141, 111142, 111144, 111167) AND `id` IN (29330,29338,29329); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES +(111106, 29330, 571, 0, 0, '0', 0, 0, 1, 7369.12, 4869.77, 1.72863, 2.74042, 300, 0, 0, 12175, 0, 0, 0, 0, 0), +(111111, 29330, 571, 0, 0, '0', 0, 0, 1, 7367.12, 4866.47, 1.70856, 2.74042, 300, 0, 0, 12175, 0, 0, 0, 0, 0), +(111112, 29330, 571, 0, 0, '0', 0, 0, 1, 7366.77, 4862.94, 2.58352, 2.74042, 300, 0, 0, 12600, 0, 0, 0, 0, 0), +(111127, 29338, 571, 0, 0, '0', 0, 0, 1, 7370.76, 4863.02, 2.46999, 2.58353, 300, 0, 0, 10080, 8814, 0, 0, 0, 0), +(111128, 29338, 571, 0, 0, '0', 0, 0, 1, 7372.27, 4866.47, 1.96164, 2.77233, 300, 0, 0, 10080, 8814, 0, 0, 0, 0), +(111129, 29330, 571, 0, 0, '0', 0, 0, 1, 7333.77, 4832.87, 1.18764, 0.376084, 300, 0, 0, 12600, 0, 0, 0, 0, 0), +(111130, 29330, 571, 0, 0, '0', 0, 0, 1, 7334.38, 4836.51, 0.922947, 5.90293, 300, 0, 0, 12600, 0, 0, 0, 0, 0), +(111131, 29338, 571, 0, 0, '0', 0, 0, 1, 7339.65, 4837.68, 1.03617, 4.38083, 300, 0, 0, 9740, 8636, 0, 0, 0, 0), +(111132, 29329, 571, 0, 0, '0', 0, 0, 1, 7338.27, 4829.94, 1.56251, 1.45297, 300, 0, 0, 12175, 3893, 0, 0, 0, 0), +(111133, 29330, 571, 0, 0, '0', 0, 0, 1, 7342.16, 4832.92, 1.49471, 2.96879, 300, 0, 0, 12600, 0, 0, 0, 0, 0), +(111134, 29330, 571, 0, 0, '0', 0, 0, 1, 7370.51, 4905.15, 2.21898, 3.19985, 300, 0, 0, 12175, 0, 0, 0, 0, 0), +(111135, 29330, 571, 0, 0, '0', 0, 0, 1, 7369.92, 4898.99, 1.87871, 2.54012, 300, 0, 0, 12175, 0, 0, 0, 0, 0), +(111136, 29330, 571, 0, 0, '0', 0, 0, 1, 7362.2, 4904.13, 1.56021, 5.90006, 300, 0, 0, 12175, 0, 0, 0, 0, 0), +(111138, 29329, 571, 0, 0, '0', 0, 0, 1, 7365.78, 4908.53, 1.81832, 4.8382, 300, 0, 0, 12600, 3994, 0, 0, 0, 0), +(111139, 29338, 571, 0, 0, '0', 0, 0, 1, 7364.82, 4898.25, 1.37546, 1.07614, 300, 0, 0, 9740, 8636, 0, 0, 0, 0), +(111141, 29330, 571, 0, 0, '0', 0, 0, 1, 7849.05, 4729.17, 0.183427, 5.5724, 300, 0, 0, 12600, 0, 0, 0, 0, 0), +(111142, 29330, 571, 0, 0, '0', 0, 0, 1, 7808.31, 4692.79, 0.237622, 1.58257, 300, 0, 0, 12600, 0, 0, 0, 0, 0), +(111144, 29330, 571, 0, 0, '0', 0, 0, 1, 7825.13, 4706.11, 0.914293, 3.21699, 300, 0, 0, 12175, 0, 0, 0, 0, 0), +(111167, 29338, 571, 0, 0, '0', 0, 0, 1, 7807.4, 4710.85, 0.495033, 6.09547, 300, 0, 0, 9740, 8636, 0, 0, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (111142,111144,111141); +INSERT INTO `creature_addon` (`guid`,`bytes1`,`bytes2`, `emote`) VALUES +(111142,0,1,69), +(111141,0,1,69), +(111144,1,1,0); + +DELETE FROM `creature_template_addon` WHERE `entry`=29338; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(29338,0,0,1,0, "48154"); |