DB/Misc: Some Cosmetics in Shattrath

1 files changed, 56 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_01_08_00_world.sql b/sql/updates/world/3.3.5/2020_01_08_00_world.sql
new file mode 100644
index 00000000000..069609e20ce
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_01_08_00_world.sql
@@ -0,0 +1,56 @@
+-- 
+UPDATE `creature` SET `id`=25115, `equipment_id`=-1, `position_x`=-1865.195, `position_y`=5519.567, `position_z`=-12.42813, `MovementType`=2, `spawntimesecs`=2 WHERE `guid`=96657;
+UPDATE `creature` SET `position_x`=-1778.39929, `position_y`=5430.0888, `position_z`=-12.4280, `MovementType`=2, `spawntimesecs`=4 WHERE `guid`=96658;
+UPDATE `creature` SET `position_x`=-1941.18994, `position_y`=5486.8999, `position_z`=-12.3448, `MovementType`=2, `spawntimesecs`=7 WHERE `guid`=96656;
+UPDATE `creature` SET `position_x`=-1775.78552, `position_y`=5492.1049, `position_z`=-12.4282, `MovementType`=2, `spawntimesecs`=12 WHERE `guid`=96593;
+
+DELETE FROM `waypoint_data` WHERE `id` IN (966570,966580,966560,965930);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(966570, 1, -1865.195, 5519.567, -12.42813, 0, 0, 0, 0, 100, 0),
+(966570, 2, -1866.180, 5519.394, -12.42813, 0, 0, 0, 0, 100, 0),
+(966570, 3, -1889.286, 5514.188, -12.42813, 0, 0, 0, 0, 100, 0),
+(966570, 4, -1897.085, 5497.141, -12.42813, 0, 0, 0, 0, 100, 0),
+(966570, 5, -1876.342, 5471.396, -12.42812, 0, 0, 0, 0, 100, 0),
+(966570, 6, -1856.188, 5471.471, -12.42811, 0, 0, 0, 0, 100, 0),
+(966570, 7, -1850.9967, 5480.94, -12.4282, 0, 0, 0, 0, 100, 0),
+(966570, 8, -1845.269, 5496.979, -12.45687, 0, 0, 0, 0, 100, 0),
+(966570, 9, -1840.907, 5499.918, -12.42801, 0, 0, 0, 0, 100, 0),
+(966570, 10, -1840.907, 5499.918, -12.42801, 0, 2000, 0, 1188, 100, 0),
+(966580, 1, -1778.399292, 5430.088867, -12.428075, 0, 0, 0, 0, 100, 0),
+(966580, 2, -1757.908936, 5428.303223, -12.428164, 0, 0, 0, 0, 100, 0),
+(966580, 3, -1761.839966, 5456.084961, -12.428164, 0, 0, 0, 0, 100, 0),
+(966580, 4, -1775.222778, 5467.199219, -12.428164, 0, 0, 0, 0, 100, 0),
+(966580, 5, -1799.759521, 5461.987305, -12.428164, 0, 0, 0, 0, 100, 0),
+(966580, 6, -1823.131226, 5450.023438, -12.428164, 0, 0, 0, 0, 100, 0),
+(966580, 7, -1831.939941, 5459.100098, -12.428300, 0, 0, 0, 0, 100, 0),
+(966580, 8, -1847.006104, 5470.152344, -12.428164, 0, 0, 0, 0, 100, 0),
+(966580, 9, -1840.989990, 5493.669922, -12.428100, 0, 0, 0, 0, 100, 0),
+(966580,10, -1840.239990, 5498.819824, -12.427400, 0, 2000, 0, 1188, 100, 0),
+(966560, 1,-1941.18994, 5486.8999, -12.3448, 0, 0, 0, 0, 100, 0),
+(966560, 2,-1922.83398, 5502.5971, -12.4275, 0, 0, 0, 0, 100, 0),
+(966560, 3,-1905.53808, 5508.8178, -12.4275, 0, 0, 0, 0, 100, 0),
+(966560, 4,-1890.22290, 5483.4902, -12.4275, 0, 0, 0, 0, 100, 0),
+(966560, 5,-1883.03515, 5470.7153, -12.4275, 0, 0, 0, 0, 100, 0),
+(966560, 6,-1849.79394, 5471.0424, -12.4275, 0, 0, 0, 0, 100, 0),
+(966560, 7,-1840.98999, 5493.6699, -12.4281, 0, 0, 0, 0, 100, 0),
+(966560, 8,-1840.23999, 5498.8198, -12.4274, 0, 2000, 0, 1188, 100, 0),
+(965930, 1,-1775.78552, 5492.10498, -12.42821, 0, 0, 0, 0, 100, 0),
+(965930, 2,-1790.54882, 5469.54101, -12.42821, 0, 0, 0, 0, 100, 0),
+(965930, 3,-1821.18725, 5449.80517, -12.42821, 0, 0, 0, 0, 100, 0),
+(965930, 4,-1831.93994, 5459.10009, -12.42830, 0, 0, 0, 0, 100, 0),
+(965930, 5,-1848.20520, 5473.39257, -12.42821, 0, 0, 0, 0, 100, 0),
+(965930, 6,-1840.98999, 5493.66992, -12.42810, 0, 0, 0, 0, 100, 0),
+(965930, 7,-1840.23999, 5498.81982, -12.42740, 0, 2000, 0, 1188, 100, 0);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (96657,96658,96656,96593,96667,96670);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(96657, 966570, 0, 0, 1, 0, ''),
+(96658, 966580, 0, 0, 1, 0, ''),
+(96656, 966560, 0, 0, 1, 0, ''),
+(96593, 965930, 0, 0, 1, 0, ''),
+(96667, 0, 0, 0, 1, 0, ''),
+(96670, 0, 0, 0, 1, 0, '');
+
+DELETE FROM `creature` WHERE `guid`=68464;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(68464, 17076, 530, 3703, 0, 1, 1, 0, 0, -1884.44, 5419.771, -12.42816, 0.282832, 120, 0, 0, 0, 0, 0, 0, 0, 0, 15354); -- 17076 (Area: 0 - Difficulty: 0)