DB/Creature: Senetil Selarin

closes #14364

1 files changed, 48 insertions, 0 deletions

diff --git a/sql/updates/world/2015_03_15_04_world.sql b/sql/updates/world/2015_03_15_04_world.sql
new file mode 100644
index 00000000000..b439d0f3a78
--- /dev/null
+++ b/sql/updates/world/2015_03_15_04_world.sql
@@ -0,0 +1,48 @@
+-- 
+-- Senetil Selarin spawn after completition of quest=995 or quest=994
+UPDATE `creature_template` SET `speed_walk`=1 WHERE  `entry`=3694;
+UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=990;
+-- Terenthis SAI
+SET @ENTRY := 3693;
+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,20,0,100,0,995,0,0,0,12,3694,6,180000,0,0,0,8,0,0,0,6339.14,341.764,24.3387,0.498114,"Terenthis - On Quest 'Escape Through Stealth' Finished - Summon Creature 'Sentinel Selarin'"),
+(@ENTRY,0,1,0,20,0,100,0,994,0,0,0,12,3694,6,180000,0,0,0,8,0,0,0,6339.14,341.764,24.3387,0.498114,"Terenthis - On Quest 'Escape Through Force' Finished - Summon Creature 'Sentinel Selarin'");
+
+-- Sentinel Selarin SAI
+SET @ENTRY := 3694;
+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,2,54,0,100,0,0,0,0,0,53,1,3694,0,0,0,0,1,0,0,0,0,0,0,0,"Sentinel Selarin - On Just Summoned - Start Waypoint"),
+(@ENTRY,0,1,0,40,0,100,0,23,3694,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sentinel Selarin - On Waypoint 23 Reached - Despawn Instant"),
+(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sentinel Selarin - On Just Summoned - Set Active On"),
+(@ENTRY,0,3,0,40,0,100,0,1,3694,0,0,54,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sentinel Selarin - On Waypoint 1 Reached - Pause Waypoint"),
+(@ENTRY,0,4,0,40,0,100,0,12,3694,0,0,54,120000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sentinel Selarin - On Waypoint 12 Reached - Pause Waypoint");
+
+DELETE FROM `waypoints` WHERE `entry`=3694;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES 
+(3694, 1, 6339.14,341.764,24.3387, 'Sentinel Selarin'),
+(3694, 2, 6353.39,354.557,22.3779, 'Sentinel Selarin'),
+(3694, 3, 6368.99,357.894,21.5712, 'Sentinel Selarin'),
+(3694, 4, 6387.81,359.455,18.9899, 'Sentinel Selarin'),
+(3694, 5, 6398.12,363.588,17.366, 'Sentinel Selarin'),
+(3694, 6, 6403.68,370.92,15.6815, 'Sentinel Selarin'),
+(3694, 7, 6416.57,392.998,12.0215, 'Sentinel Selarin'),
+(3694, 8, 6424.95,399.193,10.9586, 'Sentinel Selarin'),
+(3694, 9, 6428.93,396.971,11.1736, 'Sentinel Selarin'),
+(3694, 10, 6432,388.708,13.7662, 'Sentinel Selarin'),
+(3694, 11, 6436.71,375.264,13.9403, 'Sentinel Selarin'),
+(3694, 12, 6434.92,367.203,13.9403, 'Sentinel Selarin'), 
+(3694, 13, 6436.9,374.833,13.9403, 'Sentinel Selarin'),
+(3694, 14, 6431.63,389.723,13.5875, 'Sentinel Selarin'),
+(3694, 15, 6428.84,397.45,11.0941, 'Sentinel Selarin'),
+(3694, 16, 6424,400.084,10.9784, 'Sentinel Selarin'),
+(3694, 17, 6413.76,392.804,12.2825, 'Sentinel Selarin'),
+(3694, 18, 6401.4,368.195,16.4249, 'Sentinel Selarin'),
+(3694, 19, 6393.69,360.887,18.1549, 'Sentinel Selarin'),
+(3694, 20, 6377.21,357.731,20.6589, 'Sentinel Selarin'),
+(3694, 21, 6358.35,357.353,22.2106, 'Sentinel Selarin'),
+(3694, 22, 6348.45,352.662,22.6056, 'Sentinel Selarin'),
+(3694, 23, 6322.42,326.649,25.3338, 'Sentinel Selarin');