diff options
author | Killyana <morphone1@gmail.com> | 2016-12-25 09:05:23 +0100 |
---|---|---|
committer | DoctorKraft <DoctorKraft@users.noreply.github.com> | 2018-03-18 00:19:34 +0100 |
commit | 45f91b541524f6cb1ffe5e5f2bf646b8dd4add7b (patch) | |
tree | d04f8ed85e3a89a1586d78f59d417df1c4d4c141 | |
parent | 4c1d63081bc5b2e44ef2931dba2d03d9537c01e9 (diff) |
DB/Quest: Into the Churning Gulch
By Rushor
Closes #18577
(cherry picked from commit 15c97367dd8ee46cce39adf5b1f3a3c83794701e)
-rw-r--r-- | sql/updates/world/master/2018_03_17_09_world_2016_12_25_00_world.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_03_17_09_world_2016_12_25_00_world.sql b/sql/updates/world/master/2018_03_17_09_world_2016_12_25_00_world.sql new file mode 100644 index 00000000000..cbe0c3981f5 --- /dev/null +++ b/sql/updates/world/master/2018_03_17_09_world_2016_12_25_00_world.sql @@ -0,0 +1,26 @@ +-- +-- [Q] Into the Churning Gulch -- http://wotlk.openwow.com/quest=10715 +-- Baron Sablemane SAI +SET @ENTRY := 22103; +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,10715,0,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Baron Sablemane - On Quest 'Into the Churning Gulch' Finished - Run Script"); + +-- Actionlist SAI +SET @ENTRY := 2210300; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; +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,9,0,0,0,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Baron Sablemane - On Script - Remove Npc Flag Questgiver"), +(@ENTRY,9,1,0,0,0,100,0,1000,1000,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Baron Sablemane - On Script - Set Run Off"), +(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,69,0,0,0,0,0,0,8,0,0,0,2915.57,5957.42,3.27419,2.97874,"Baron Sablemane - On Script - Move To Position"), +(@ENTRY,9,3,0,0,0,100,0,4000,4000,0,0,17,69,0,0,0,0,0,1,0,0,0,0,0,0,0,"Baron Sablemane - On Script - Set Emote State 69"), +(@ENTRY,9,4,0,0,0,100,0,7000,7000,0,0,17,26,0,0,0,0,0,1,0,0,0,0,0,0,0,"Baron Sablemane - On Script - Set Emote State 26"), +(@ENTRY,9,5,0,0,0,100,0,2000,2000,0,0,69,0,0,0,0,0,0,8,0,0,0,2919.11,5956.93,3.16149,1.03933,"Baron Sablemane - On Script - Move To Position"), +(@ENTRY,9,6,0,0,0,100,0,2000,2000,0,0,69,0,0,0,0,0,0,8,0,0,0,2919.11,5956.93,3.16149,1.58825,"Baron Sablemane - On Script - Move To Position"), +(@ENTRY,9,7,0,0,0,100,0,1000,1000,0,0,82,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Baron Sablemane - On Script - Add Npc Flag Questgiver"), +(@ENTRY,9,8,0,0,0,100,0,0,0,0,0,1,0,3000,0,0,0,0,1,0,0,0,0,0,0,0,"Baron Sablemane - On Script - Say Line 0"); + +DELETE FROM `creature_text` WHERE `CreatureID`=22103; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `Comment`) VALUES +(22103, 0, 0, 'There, it is completed.', 12, 0, 100, 0, 0, 0, 19808, 'Baron Sablemane'); |