diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_20_37_world_2020_01_28_00_world.sql | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_20_37_world_2020_01_28_00_world.sql b/sql/updates/world/master/2021_12_20_37_world_2020_01_28_00_world.sql new file mode 100644 index 00000000000..0d0091e6a06 --- /dev/null +++ b/sql/updates/world/master/2021_12_20_37_world_2020_01_28_00_world.sql @@ -0,0 +1,50 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (/*44340, 44341, 44343, 44344, 44345, 44346,*/ 44347, 44348, 44349, 44376, 44378, /*106338, 119106, 119107, 119108, 119109, 119110,*/ 119111, 119114, 119115, 119116, 119117); +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 +-- (44340, 15893, 0, 0, 0, '0', 0, 0, 0, 1642.07, 239.839, 62.6749, 0.802851, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (44341, 15893, 1, 0, 0, '0', 0, 0, 0, -1031.95, -230.513, 160.243, 3.9619, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (44343, 15893, 1, 0, 0, '0', 0, 0, 0, 1983.05, -4255.89, 31.7698, 2.07694, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (44344, 15893, 0, 0, 0, '0', 0, 0, 0, -4663.16, -956.235, 500.46, 0.05236, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (44345, 15893, 0, 0, 0, '0', 0, 0, 0, -8748.48, 1074.25, 90.6194, 0.471239, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (44346, 15893, 1, 0, 0, '0', 0, 0, 0, 10150.5, 2602.14, 1330.91, 1.5708, 120, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +(44347, 15893, 530, 0, 0, '0', 0, 0, 0, -4017.51, -11837.7, 0.159306, 4.39823, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(44348, 15893, 571, 0, 0, '0', 0, 0, 0, 5821.92, 642.784, 648.11, 5.16617, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(44349, 15893, 530, 0, 0, '0', 0, 0, 0, -1804.34, 5492.79, -12.3448, 5.37561, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(44376, 15893, 530, 0, 0, '0', 0, 0, 0, -1778.06, 5439.69, -12.3448, 4.41568, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(44378, 15893, 530, 0, 0, '0', 0, 0, 0, 9479.26, -7295.21, 14.4095, 4.39823, 120, 0, 0, 1, 0, 0, 0, 0, 0), +-- (106338, 15894, 0, 0, 0, '0', 0, 0, 0, 1642.07, 239.839, 62.6749, 0.802851, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (119106, 15894, 1, 0, 0, '0', 0, 0, 0, -1031.95, -230.513, 160.243, 3.9619, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (119107, 15894, 1, 0, 0, '0', 0, 0, 0, 1983.05, -4255.89, 31.7698, 2.07694, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (119108, 15894, 0, 0, 0, '0', 0, 0, 0, -4663.16, -956.235, 500.46, 0.05236, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (119109, 15894, 0, 0, 0, '0', 0, 0, 0, -8748.48, 1074.25, 90.6194, 0.471239, 180, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +-- (119110, 15894, 1, 0, 0, '0', 0, 0, 0, 10150.5, 2602.14, 1330.91, 1.5708, 120, 0, 0, 1, 0, 0, 0, 0, 0), -- 3.3.5 only +(119111, 15894, 530, 0, 0, '0', 0, 0, 0, -4017.51, -11837.7, 0.159306, 4.39823, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(119114, 15894, 571, 0, 0, '0', 0, 0, 0, 5821.92, 642.784, 648.11, 5.16617, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(119115, 15894, 530, 0, 0, '0', 0, 0, 0, -1804.34, 5492.79, -12.3448, 5.37561, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(119116, 15894, 530, 0, 0, '0', 0, 0, 0, -1778.06, 5439.69, -12.3448, 4.41568, 120, 0, 0, 1, 0, 0, 0, 0, 0), +(119117, 15894, 530, 0, 0, '0', 0, 0, 0, 9479.26, -7295.21, 14.4095, 4.39823, 120, 0, 0, 1, 0, 0, 0, 0, 0); + +DELETE FROM `game_event_creature` WHERE `guid` IN (/*44340, 44341, 44343, 44344, 44345, 44346,*/ 44347, 44348, 44349, 44376, 44378, /*106338, 119106, 119107, 119108, 119109, 119110,*/ 119111, 119114, 119115, 119116, 119117) AND `eventEntry`=7; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +-- (7, 44340), -- 3.3.5 only +-- (7, 44341), -- 3.3.5 only +-- (7, 44343), -- 3.3.5 only +-- (7, 44344), -- 3.3.5 only +-- (7, 44345), -- 3.3.5 only +-- (7, 44346), -- 3.3.5 only +(7, 44347), +(7, 44348), +(7, 44349), +(7, 44376), +(7, 44378), +-- (7, 106338), -- 3.3.5 only +-- (7, 119106), -- 3.3.5 only +-- (7, 119107), -- 3.3.5 only +-- (7, 119108), -- 3.3.5 only +-- (7, 119109), -- 3.3.5 only +-- (7, 119110), -- 3.3.5 only +(7, 119111), +(7, 119114), +(7, 119115), +(7, 119116), +(7, 119117); |