DB/Creature: Add missing spawn to Gimorak's Den

1 files changed, 39 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_01_11_14_world.sql b/sql/updates/world/3.3.5/2017_01_11_14_world.sql
new file mode 100644
index 00000000000..98ef7e7783e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_01_11_14_world.sql
@@ -0,0 +1,39 @@
+-- Gimorak's Den spawns
+DELETE FROM `creature` WHERE `guid` IN (3137, 3239, 3243, 3246, 3255, 3257, 3258, 3261, 3262, 3548, 3551,3552,3554,3558,3565,3566,3567,3570,3573,3574,3578,3583,46968,46996,47013);
+INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(3137,30148, 571, 26263, 0, 7636.73, -1516.25, 972.399, 3.24843, 300, 10, 0, 12600, 0, 1),
+(3239,30148, 571, 26263, 0, 7618.51, -1547.65, 972.876, 2.15279, 300, 10, 0, 12600, 0, 1),
+(3243,30148, 571, 26263, 0, 7652.66, -1559.21, 970.045, 2.46695, 300, 10, 0, 12600, 0, 1),
+(3246,30148, 571, 26263, 0, 7667.78, -1602.91, 965.248, 2.3295, 300, 10, 0, 12600, 0, 1),
+(3255,30148, 571, 26263, 0, 7697.22, -1659.77, 953.957, 5.83626, 300, 10, 0, 12600, 0, 1),
+(3257,30148, 571, 26263, 0, 7755.26, -1597.29, 943.701, 4.20267, 300, 10, 0, 12600, 0, 1),
+(3258,30148, 571, 26263, 0, 7831.83, -1525.77, 931.193, 3.67253, 300, 10, 0, 12600, 0, 1),
+(3261,30148, 571, 26263, 0, 7900.51, -1559.21, 919.154, 1.69016, 300, 10, 0, 12600, 0, 1),
+(3262, 30148, 571, 26263, 0, 7571.78, -1487.62, 979.011, 0.894555, 300, 10, 0, 12600, 0, 1),
+(3548, 30148, 571, 26263, 0, 7556.45, -1452.86, 965.559, 6.17792, 300, 10, 0, 12600, 0, 1),
+(3551, 30177, 571, 0, 0, 7662.565, -1562.819, 968.522, 3.202834, 300, 0, 0, 0, 0, 0),
+(3552, 30177, 571, 0, 0, 7644.909, -1557.646, 971.718, 2.333397, 300, 0, 0, 0, 0, 0),
+(3554, 30177, 571, 0, 0, 7616.342, -1536.386, 972.824, 2.496760, 300, 0, 0, 0, 0, 0),
+(3558, 30164, 571, 0, 0, 7690.036, -1594.692, 965.279, 3.657587, 300, 10, 0, 0, 0, 1),
+(3565, 30164, 571, 0, 0, 7661.549, -1569.356, 968.239, 2.535253, 300, 0, 0, 0, 0, 0),
+(3566, 30164, 571, 0, 0, 7665.350, -1561.808, 968.275, 2.877686, 300, 0, 0, 0, 0, 0),
+(3567, 30164, 571, 0, 0, 7596.918, -1562.827, 972.530, 0.171203, 300, 0, 0, 0, 0, 0),
+(3570, 30164, 571, 0, 0, 7599.817, -1569.222, 972.866, 0.425672, 300, 0, 0, 0, 0, 0),
+(3573, 30164, 571, 0, 0, 7585.734, -1531.502, 979.362, 6.179498, 300, 0, 0, 0, 0, 0),
+(3574, 30164, 571, 0, 0, 7586.614, -1523.049, 980.795, 6.179498, 300, 0, 0, 0, 0, 0),
+(3578, 30164, 571, 0, 0, 7579.453, -1490.329, 978.643, 3.242896, 300, 10, 0, 0, 0, 1),
+(3583, 30164, 571, 0, 0, 7576.754, -1484.106, 978.622, 3.550772, 300, 10, 0, 0, 0, 1),
+(46968, 30164, 571, 0, 0, 7570.442, -1455.318, 969.913, 3.240540, 300, 10, 0, 0, 0, 1),
+(46996, 30164, 571, 0, 0, 7777.413, -1558.199, 943.307, 0.171988, 300, 10, 0, 0, 0, 1),
+(47013, 30177, 571, 0, 0, 7590.723, -1490.491, 976.253, 5.747542, 300, 0, 0, 0, 0, 0);
+
+-- Infesting Jormungar SAI
+SET @ENTRY := 30148;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@ENTRY,0,0,0,0,0,100,0,3000,6000,18000,21000,11,56103,0,0,0,0,0,2,0,0,0,0,0,0,0,"Infesting Jormungar - In Combat - Cast 56103"),
+(@ENTRY,0,1,0,0,0,100,0,9000,12000,19000,23000,11,48287,0,0,0,0,0,2,0,0,0,0,0,0,0,"Infesting Jormungar - In Combat - Cast 48287"),
+(@ENTRY,0,2,0,0,0,100,0,2500,20400,20000,30000,11,32738,0,0,0,0,0,2,0,0,0,0,0,0,0,"Infesting Jormungar - In Combat - Cast 32738");
+
+DELETE FROM `game_event_creature` WHERE `guid` IN (79650, 80342, 80351);