diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_02_09_01_world_335.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_02_09_01_world_335.sql b/sql/updates/world/3.3.5/2019_02_09_01_world_335.sql new file mode 100644 index 00000000000..b222a644c56 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_02_09_01_world_335.sql @@ -0,0 +1,15 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (76265,86173,86174,97406,97407,97408,97431); +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 +(76265, 4772, 0, 1, 1, 0, 1, -5523.24, -1333.6, 398.555, 2.68781, 120, 0, 0, 0, 0, 0), +(86173, 12372, 0, 1, 1, 0, 0, -5509.63, -1323.89, 397.516, 2.32328, 120, 1, 0, 0, 0, 1), +(86174, 12373, 0, 1, 1, 0, 0, -5505.42, -1320.18, 397.516, 3.25541, 120, 1, 0, 0, 0, 1), +(97406, 12374, 0, 1, 1, 0, 0, -5499.52, -1322.37, 397.516, 0.224179, 120, 1, 0, 0, 0, 1), +(97407, 14546, 0, 1, 1, 0, 0, -5508.02, -1334.34, 397.516, 5.21587, 120, 1, 0, 0, 0, 1), +(97408, 14547, 0, 1, 1, 0, 0, -5497.96, -1332.61, 397.516, 0.488367, 120, 1, 0, 0, 0, 1), +(97431, 14548, 0, 1, 1, 0, 0, -5502.12, -1335.15, 397.516, 0.569738, 120, 1, 0, 0, 0, 1); +DELETE FROM `game_event_creature` WHERE `eventEntry` IN (-25,25) AND `guid` IN (76265,86173,86174,97406,97407,97408,97431, 4149,4148,4147,4155,4154,4156,4150); +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(25,76265),(25,86173),(25,86174),(25,97406),(25,97407),(25,97408),(25,97431),(-25,4149),(-25,4148),(-25,4147),(-25,4155),(-25,4154),(-25,4156),(-25,4150); +UPDATE `creature` SET `MovementType`=1, `spawndist`=4 WHERE `guid` IN(4149,4148,4147,4155,4154,4156); +UPDATE `creature` SET `Orientation`=3.172219 WHERE `guid` IN(4152); |