diff options
| -rw-r--r-- | sql/updates/world/master/2018_03_11_06_world_2016_11_27_04_world.sql | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_03_11_06_world_2016_11_27_04_world.sql b/sql/updates/world/master/2018_03_11_06_world_2016_11_27_04_world.sql new file mode 100644 index 00000000000..71ae665161e --- /dev/null +++ b/sql/updates/world/master/2018_03_11_06_world_2016_11_27_04_world.sql @@ -0,0 +1,70 @@ +-- +SET @guid:=1215; +SET @guid1:=1237; +DELETE FROM `creature` WHERE `guid` IN (@guid, @guid1); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES +(@guid, 14386, 429, 2, 0, 0, 560.917, 545.409, -25.3172, 1.00548, 86400, 0, 0, 305, 0, 2, 0, 0, 0), +(@guid1, 14386, 429, 2, 0, 0, 446.833, 542.643, -21.8128, 3.26136, 86400, 0, 0, 305, 0, 2, 0, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (@guid, @guid1); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@guid, @guid*10, 0, 0, 0, 0, ''), +(@guid1, @guid1*10, 0, 0, 0, 0, ''); + +DELETE FROM `waypoint_data` WHERE `id` IN (@guid*10, @guid1*10); +INSERT INTO `waypoint_data`(`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@guid1*10, 1, 428.587, 550.354, -18.3306), +(@guid1*10, 2, 413.248, 549.204, -18.3306), +(@guid1*10, 3, 410.805, 537.981, -18.0049), +(@guid1*10, 4, 399.84, 525.571, -12.77510), +(@guid1*10, 5, 389.687, 500.698, -12.0153), +(@guid1*10, 6, 385.387, 475.186, -7.21953), +(@guid1*10, 7, 395.807, 468.872, -7.21953), +(@guid1*10, 8, 396.182, 455.417, -7.21953), +(@guid1*10, 9, 388.528, 448.807, -7.21954), +(@guid1*10, 10, 384.207, 434.841, -5.5531), +(@guid1*10, 11, 384.522, 423.362, -3.1280), +(@guid1*10, 12, 385.296, 413.909, -1.6721), +(@guid1*10, 13, 384.207, 434.841, -5.5531), +(@guid1*10, 14, 388.528, 448.807, -7.2195), +(@guid1*10, 15, 396.182, 455.417, -7.2195), +(@guid1*10, 16, 395.807, 468.872, -7.2195), +(@guid1*10, 17, 385.387, 475.186, -7.2195), +(@guid1*10, 18, 389.687, 500.698, -12.015), +(@guid1*10, 19, 399.657, 525.364, -12.775), +(@guid1*10, 20, 410.805, 537.981, -18.004), +(@guid1*10, 21, 413.248, 549.204, -18.330), +(@guid1*10, 22, 428.587, 550.354, -18.330), +(@guid1*10, 23, 445.971, 542.539, -21.565), +(@guid1*10, 24, 494.681, 542.877, -25.387), +(@guid1*10, 25, 445.971, 542.539, -21.565), +(@guid*10, 1, 577.104, 570.924, -25.40200), +(@guid*10, 2, 572.076, 582.988, -25.40200), +(@guid*10, 3, 544.652, 593.181, -25.40200), +(@guid*10, 4, 500.831, 579.024, -25.40100), +(@guid*10, 5, 484.037, 575.841, -25.4018), +(@guid*10, 6, 476.537, 584.739, -25.4036), +(@guid*10, 7, 494.385, 591.692, -20.3989), +(@guid*10, 8, 534.313, 590.416, -4.75477), +(@guid*10, 9, 550.691, 591.401, -4.75477), +(@guid*10, 10, 568.851, 584.212, -4.7547), +(@guid*10, 11, 581.867, 574.685, -4.7557), +(@guid*10, 12, 587.157, 556.043, -1.7186), +(@guid*10, 13, 587.022, 535.885, 6.77017), +(@guid*10, 14, 568.928, 535.351, 13.0908), +(@guid*10, 15, 545.493, 534.378, 25.6657), +(@guid*10, 16, 568.928, 535.351, 13.0908), +(@guid*10, 17, 587.022, 535.885, 6.77017), +(@guid*10, 18, 587.157, 556.043, -1.7186), +(@guid*10, 19, 581.867, 574.685, -4.7557), +(@guid*10, 20, 568.851, 584.212, -4.7547), +(@guid*10, 21, 550.691, 591.401, -4.7547), +(@guid*10, 22, 534.313, 590.416, -4.7547), +(@guid*10, 23, 494.385, 591.692, -20.398), +(@guid*10, 24, 481.761, 590.614, -25.407), +(@guid*10, 25, 484.037, 575.841, -25.401), +(@guid*10, 26, 500.831, 579.024, -25.401), +(@guid*10, 27, 544.652, 593.181, -25.402), +(@guid*10, 28, 572.076, 582.988, -25.402), +(@guid*10, 29, 577.104, 570.924, -25.402), +(@guid*10, 30, 563.542, 547.683, -25.399); |