DB/Creature: Add some spawns to the Temple of Atal'Hakkar

1 files changed, 35 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_10_16_00_world_335.sql b/sql/updates/world/3.3.5/2018_10_16_00_world_335.sql
new file mode 100644
index 00000000000..33385940377
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_16_00_world_335.sql
@@ -0,0 +1,35 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (90925,90926,90927,90978,90979,90980,90981,90982,91115,91116,91117,91118,91563,91564,91565,91566,91567,91568,91569,91570,91588,91589,91590,91591,91592,91616,91617,91618,91619,91620,91621,91690);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`,`spawndist`, `MovementType`) VALUES
+(90925,8336,109,1,1,0,0, -444.381, 285.018, -90.7172, 3.39459,7200,10,1), -- Hakkari Sapper
+(90926,8336,109,1,1,0,0, -447.429, 254.378, -90.6463, 1.92589,7200,10,1), -- Hakkari Sapper
+(90927,8336,109,1,1,0,0, -387.6473, 229.301, -90.874, 0.03543,7200,10,1), -- Hakkari Sapper
+(90978,8336,109,1,1,0,0, -546.188, 233.886, -90.8738, 4.70227,7200,10,1), -- Hakkari Sapper
+(90979,2914,109,1,1,0,0,-391.7645,92.71431,-90.86712,2.963046,7200,10,1), -- Snake
+(90980,2914,109,1,1,0,0,-297.3856,83.04854,-91.09061,5.10778,7200,10,1), -- Snake
+(90981,2914,109,1,1,0,0,-373.0406,75.03958,-131.447,6.026293,7200,10,1), -- Snake
+(90982,2914,109,1,1,0,0,-350.5063,130.2023,-148.9032,4.741959,7200,10,1), -- Snake
+(91115,2914,109,1,1,0,0,-362.848,19.92291,-69.3923,2.376379,7200,10,1), -- Snake
+(91116,2914,109,1,1,0,0,-385.5145,96.50134,-90.8524,0.9270402,7200,10,1), -- Snake
+(91117,2914,109,1,1,0,0,-335.1277,117.8011,-131.8474,4.69864,7200,10,1), -- Snake
+(91118,2914,109,1,1,0,0,-343.1481,147.2007,-69.48788,3.194419,7200,10,1), -- Snake
+(91563,2914,109,1,1,0,0,-370.7447,114.9868,-53.94633,3.545005,7200,10,1), -- Snake
+(91564,2914,109,1,1,0,0,-384.5314,144.2719,-131.0453,1.560693,7200,10,1), -- Snake
+(91565,2914,109,1,1,0,0,-330.103,91.94751,-131.8486,1.032488,7200,10,1), -- Snake
+(91566,2914,109,1,1,0,0,-453.8755,62.06911,-91.34988,0.01065614,7200,10,1), -- Snake
+(91567,2914,109,1,1,0,0,-380.4706,234.1404,-90.86153,5.561656,7200,10,1), -- Snake
+(91568,2914,109,1,1,0,0,-530.8884,173.2607,-54.09545,4.296912,7200,10,1), -- Snake
+(91569,2914,109,1,1,0,0,-471.3307,132.4887,-91.2021,5.689507,7200,10,1), -- Snake
+(91570,2914,109,1,1,0,0,-520.3876,101.4895,-91.3147,3.617042,7200,10,1), -- Snake
+(91588,2914,109,1,1,0,0,-410.2076,17.6556,-53.94635,1.266128,7200,10,1), -- Snake
+(91589,2914,109,1,1,0,0,-418.8355,10.57873,-90.85738,3.625298,7200,10,1), -- Snake
+(91590,2914,109,1,1,0,0,-561.3115,85.38955,-53.94634,1.311812,7200,10,1), -- Snake
+(91591,2914,109,1,1,0,0,-550.7628,238.5096,-90.85101,4.550307,7200,10,1), -- Snake
+(91592,2914,109,1,1,0,0,-553.0972,171.8572,-148.8329,5.010252,7200,10,1), -- Snake
+(91616,2914,109,1,1,0,0,-575.9153,173.6673,-69.40138,1.920732,7200,10,1), -- Snake
+(91617,2914,109,1,1,0,0,-599.1094,37.05124,-69.35283,3.874078,7200,10,1), -- Snake
+(91618,2914,109,1,1,0,0,-550.9071,-45.36851,-90.85987,1.508554,7200,10,1), -- Snake
+(91619,2914,109,1,1,0,0,-473.8655,-90.09864,-90.82753,0.8830038,7200,10,1), -- Snake
+(91620,2914,109,1,1,0,0,-586.1681,96.41691,-90.8886,2.928523,7200,10,1), -- Snake
+(91621,2914,109,1,1,0,0,-659.7747,98.07658,-90.83157,2.423705,7200,10,1), -- Snake
+(91690,4075,109,1,1,0,0,-410.339,127.792,-90.88896,5.410521,7200,5,1); -- Rat