aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <11556157+offl@users.noreply.github.com>2022-03-27 21:15:04 +0300
committerGitHub <noreply@github.com>2022-03-27 21:15:04 +0300
commitce98938ab8fbbb61fc4b207c11bf14345ce84f3c (patch)
treee41397d9b30399015f6fe9b4ecf6b72ca7832cd0 /sql
parent9ef60d70638888c07d131d42d3746478feac2423 (diff)
Scripts/Quest: Update 'The Art of Persuasion' (11648) (#27887)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2022_03_27_00_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_03_27_00_world.sql b/sql/updates/world/3.3.5/2022_03_27_00_world.sql
new file mode 100644
index 00000000000..de1c26df3aa
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_03_27_00_world.sql
@@ -0,0 +1,8 @@
+--
+UPDATE `creature_template_addon` SET `bytes1` = 5, `bytes2` = 1, `emote` = 0, `auras` = '45631 45842' WHERE `entry` = 25478;
+UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = 25478;
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_borean_tundra_neural_needle','spell_borean_tundra_prototype_neural_needle');
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(45634,'spell_borean_tundra_neural_needle'),
+(48252,'spell_borean_tundra_prototype_neural_needle');