diff options
| author | Discover- <amort11@hotmail.com> | 2011-10-23 10:16:04 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-10-23 10:16:04 +0100 |
| commit | 238e8e5ea18b744a2915dea419744730d8acdcd0 (patch) | |
| tree | ed25af0f6962ebfdddf983d4fea2b206d5b4253b /sql | |
| parent | a9d86c2c0ba9264456044132cfe783cce0eb317b (diff) | |
DB/SAI: Properly fix quest Blighted Last Rites (EAI->SAI)
Closes #3041
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_10_23_02_world_sai.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_23_02_world_sai.sql b/sql/updates/world/2011_10_23_02_world_sai.sql new file mode 100644 index 00000000000..a6a5da03bbb --- /dev/null +++ b/sql/updates/world/2011_10_23_02_world_sai.sql @@ -0,0 +1,9 @@ +-- Scarlet Onslaught Prisoner SAI +SET @ENTRY := 27349; +SET @SPELL_FLASK_OF_BLIGHT := 48188; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY; +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,1,8,0,100,0,@SPELL_FLASK_OF_BLIGHT,0,0,0,33,27253,0,0,0,0,0,7,0,0,0,0,0,0,0,"Scarlet Onslaught Prisoner - On Spellhit - Quest Credit"), +(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Scarlet Onslaught Prisoner - In Combat - Forced Despawn"); |