diff options
| -rw-r--r-- | sql/updates/world/master/2020_08_23_13_world_2017_09_01_00_world.sql | 94 |
1 files changed, 94 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_08_23_13_world_2017_09_01_00_world.sql b/sql/updates/world/master/2020_08_23_13_world_2017_09_01_00_world.sql new file mode 100644 index 00000000000..147536c5bfa --- /dev/null +++ b/sql/updates/world/master/2020_08_23_13_world_2017_09_01_00_world.sql @@ -0,0 +1,94 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (48308,48309,48310,68880,68881,68882,68883,68884,68885,68886,68887,68888,68889,68890,68891,68892,68893,68894,80503,80504,80505,80506,80507,80508,80509,80511,80512,80513,80514,80515,80516,80517,80518,80519,80520,80521,80523,80524,80525,80526,80527,80528,80530,80532,80533,80534,80535,80536); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) values +(48308, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6799.83, 1433.43, 390.812, 6.28299, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(48309, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6799.42, 1426.43, 390.812, 0.0389925, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(48310, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6799.22, 1420.2, 390.812, 0.0487044, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68880, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6797.68, 1420.19, 390.891, 6.27572, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68881, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6794.35, 1419.96, 390.891, 6.17665, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68882, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6795.52, 1420.04, 390.891, 6.27119, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68883, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6795.89, 1426.27, 390.891, 0.0536161, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68884, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6797.39, 1426.33, 390.891, 0.0492338, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68885, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6794.39, 1426.2, 390.891, 0.0581036, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68886, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6792.89, 1426.13, 390.891, 0.0623682, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68887, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6793.83, 1432.9, 390.921, 0.440551, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68888, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6798.33, 1432.92, 390.921, 0.424234, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68889, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6795.33, 1432.91, 390.921, 0.435067, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68890, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6796.83, 1432.92, 390.921, 0.4288, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(68891, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6873.45, 1596.78, 389.217, 1.50098, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(68892, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6870.81, 1603.06, 389.217, 0.10472, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(68893, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6873.86, 1577.83, 389.217, 0.349066, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(68894, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6903.14, 1551.82, 389.217, 2.68781, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80503, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6886.85, 1539.82, 389.217, 1.0821, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80504, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6905.55, 1564.58, 389.217, 1.11701, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80505, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6884.67, 1571.42, 389.217, 1.6057, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80506, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6878.18, 1541.64, 389.217, 5.75959, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80507, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6885.35, 1584.62, 389.217, 4.85202, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80508, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6908.27, 1591.38, 389.217, 4.55531, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80509, 32164, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6904.24, 1578.02, 389.217, 0.663225, 300, 0, 0, 11770, 0, 0, 0, 0, 0, 0), +(80511, 31150, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6812.83, 1449.62, 390.896, 4.64258, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80512, 31150, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6857.69, 1557.02, 389.133, 0.117134, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80513, 31150, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6764.16, 1555.59, 389.217, 0.575959, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80514, 31150, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6847.13, 1450.28, 390.896, 4.62512, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80515, 31150, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6849.24, 1583.35, 389.133, 0.0689424, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80516, 31145, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6805.28, 1426.08, 390.896, 3.31613, 300, 0, 0, 10080, 8814, 0, 0, 0, 0, 0), +(80517, 31145, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6776.43, 1446.4, 390.712, 4.505206, 300, 0, 0, 10080, 8814, 0, 0, 0, 0, 0), +(80518, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6773.39, 1439.27, 390.712, 1.40995, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80519, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6775, 1439.01, 390.712, 1.40995, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80520, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6774.78, 1440.47, 390.712, 1.93538, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80521, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6773.8, 1440.1, 390.712, 1.93538, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80523, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6774.71, 1437.71, 390.712, 1.93538, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80524, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6774.17, 1439.13, 390.712, 1.93538, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80525, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6775.48, 1439.63, 390.712, 1.93538, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80526, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6775.77, 1438.86, 390.712, 1.93538, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80527, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6775.93, 1437.79, 390.712, 1.93538, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80528, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6775.68, 1440.77, 390.712, 2.84566, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80530, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6776.52, 1439.91, 390.712, 2.84566, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80532, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6776.86, 1438.46, 390.712, 2.84566, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80533, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6777.74, 1439.04, 390.712, 2.84566, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80534, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6777.41, 1440.29, 390.712, 4.12619, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80535, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6776.19, 1441.2, 390.712, 4.12619, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(80536, 31281, 571, 0, 0, '0', 0, 0, 0, 0, 0, 6773.62, 1438.18, 390.712, 0.830504, 300, 0, 0, 12600, 0, 0, 0, 0, 0, 0); + +UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `guid`= 123928; +DELETE FROM `gameobject` WHERE `guid` IN (91, 93, 97, 99, 101,103,105,107,111,113,115,388,390,392,394,396,400,402,403,405,407); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(91, 193616, 571, 0, 0, '0', 0, 0, 0, 6884.59, 1573.85, 389.033, 0.0523589, 0, 0, 0, 0, 300, 0, 1, 0), +(93, 193616, 571, 0, 0, '0', 0, 0, 0, 6888.82, 1541.54, 389.033, 3.03684, 0, 0, 0, 0, 300, 0, 1, 0), +(97, 193616, 571, 0, 0, '0', 0, 0, 0, 6884.59, 1582, 389.033, -3.12412, 0, 0, 0, 0, 300, 0, 1, 0), +(99, 193616, 571, 0, 0, '0', 0, 0, 0, 6883.65, 1540.26, 389.033, 1.13446, 0, 0, 0, 0, 300, 0, 1, 0), +(101, 193616, 571, 0, 0, '0', 0, 0, 0, 6880.13, 1540.48, 389.033, -2.82743, 0, 0, 0, 0, 300, 0, 1, 0), +(103, 193616, 571, 0, 0, '0', 0, 0, 0, 6876.56, 1539.62, 389.033, -0.0698117, 0, 0, 0, 0, 300, 0, 1, 0), +(105, 193617, 571, 0, 0, '0', 0, 0, 0, 6875.71, 1601.95, 389.033, -2.67035, 0, 0, -0.965567, 0.260156, 300, 0, 1, 0), +(107, 193617, 571, 0, 0, '0', 0, 0, 0, 6879.49, 1578.34, 389.033, -3.10665, 0, 0, -0.999552, 0.0299169, 300, 0, 1, 0), +(111, 193617, 571, 0, 0, '0', 0, 0, 0, 6912.05, 1560.12, 389.033, 1.29154, 0, 0, 0, 0, 300, 0, 1, 0), +(113, 193617, 571, 0, 0, '0', 0, 0, 0, 6907.6, 1567.49, 389.033, -0.122173, 0, 0, 0, 0, 300, 0, 1, 0), +(115, 193617, 571, 0, 0, '0', 0, 0, 0, 6903.12, 1554.92, 389.033, 2.28638, 0, 0, 0, 0, 300, 0, 1, 0), +(388, 193618, 571, 0, 0, '0', 0, 0, 0, 6906.19, 1579.29, 389.033, 0.610864, 0, 0, 0, 0, 300, 0, 1, 0), +(390, 193618, 571, 0, 0, '0', 0, 0, 0, 6906.3, 1589.43, 389.033, 1.15192, 0, 0, 0, 0, 300, 0, 1, 0), +(392, 193618, 571, 0, 0, '0', 0, 0, 0, 6881.86, 1578.11, 389.033, 0.0523589, 0, 0, 0, 0, 300, 0, 1, 0), +(394, 193619, 571, 0, 0, '0', 0, 0, 0, 6872.97, 1600.56, 389.033, -2.61799, 0, 0, -0.965567, 0.260156, 300, 0, 1, 0), +(396, 193619, 571, 0, 0, '0', 0, 0, 0, 6875.82, 1580.98, 389.033, 3.10665, 0, 0, -0.999552, 0.0299169, 300, 0, 1, 0), +(400, 193619, 571, 0, 0, '0', 0, 0, 0, 6875.76, 1577.95, 389.033, -3.05433, 0, 0, -0.999552, 0.0299169, 300, 0, 1, 0), +(402, 193619, 571, 0, 0, '0', 0, 0, 0, 6874.19, 1598.21, 389.033, -2.61799, 0, 0, -0.965567, 0.260156, 300, 0, 1, 0), +(403, 193619, 571, 0, 0, '0', 0, 0, 0, 6876.02, 1575.36, 389.033, -2.9496, 0, 0, -0.999552, 0.0299169, 300, 0, 1, 0), +(405, 193619, 571, 0, 0, '0', 0, 0, 0, 6872.22, 1602.76, 389.033, -2.60054, 0, 0, -0.965567, 0.260156, 300, 0, 1, 0), +(407, 193620, 571, 0, 0, '0', 0, 0, 0, 6885.62, 1578.17, 389.033, -3.10665, 0, 0, 0, 0, 300, 0, 1, 0); + +UPDATE `creature` SET `position_x`=6648.01,`position_y`=1282.8,`position_z`=291.6626, `spawndist`=0, `MovementType`=0 WHERE `guid` IN (121653); +DELETE FROM `creature_addon` WHERE `guid`=121653; +DELETE FROM `creature_template_addon` WHERE `entry`= 31281; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) values (31281,0,0,0,1,0,'58951'); +UPDATE `creature` SET `spawndist`=0, `MovementType`=2 WHERE `guid` IN (80515, 80512); +DELETE FROM `creature_addon` WHERE `guid`=80515; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (80515,805150,0,0,0,0, '50106'); +DELETE FROM `waypoint_data` WHERE `id`=805150; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(805150,1,6868.6796, 1587.0093, 389.032, 0.037058,0,0,0,100,0), +(805150,2,6786.1420, 1584.6035, 389.032, 3.115034,0,0,0,100,0); +DELETE FROM `creature_addon` WHERE `guid`=80512; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (80512,805120,0,0,0,0, '50106'); +DELETE FROM `waypoint_data` WHERE `id`=805120; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(805120,1,6790.1362, 1558.1470, 389.033, 3.096658,0,0,0,100,0), +(805120,2,6870.9169, 1557.5908, 389.033, 0.047275,0,0,0,100,0); |