aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-04-30 19:37:22 +0200
committerShauren <shauren.trinity@gmail.com>2022-01-01 23:22:09 +0100
commitf32f812e29aa6164f8c85e580c9ae77caded6c0f (patch)
treee0fb87d15d602bf6c45d8697d06c7772ad4a3eb8 /sql
parentb8805f43897bc5b22a7e7491b055b8dad84a34aa (diff)
DB/Quest: Becoming a Spellfire Tailor
Closes #24522 (cherry picked from commit 9638f0ad0b70084f06bf3b6a9d9e49f00830772e)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_01_01_40_world_2020_04_30_01_world_335.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_40_world_2020_04_30_01_world_335.sql b/sql/updates/world/master/2022_01_01_40_world_2020_04_30_01_world_335.sql
new file mode 100644
index 00000000000..6df50e6b68e
--- /dev/null
+++ b/sql/updates/world/master/2022_01_01_40_world_2020_04_30_01_world_335.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `item_script_names` WHERE `ScriptName` = "item_nether_wraith_beacon";
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 22408;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 22408 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(22408,0,0,0,54,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Furious Nether-wraith - On Just Summoned - Start Attacking"),
+(22408,0,1,0,0,0,100,0,0,0,3000,5000,0,11,39337,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Furious Nether-wraith - In Combat - Cast 'Arcane Bolt'"),
+(22408,0,2,0,0,0,100,0,10000,15000,22000,28000,0,11,38205,1,0,0,0,0,2,0,0,0,0,0,0,0,0,"Furious Nether-wraith - In Combat - Cast 'Shadow Blast'");