aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2017_12_23_00_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_12_23_00_world.sql b/sql/updates/world/3.3.5/2017_12_23_00_world.sql
new file mode 100644
index 00000000000..294e320cbca
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_12_23_00_world.sql
@@ -0,0 +1,8 @@
+-- Edwin VanCleef changes
+
+-- Remove two spawned Blackguards
+DELETE FROM `creature` WHERE `guid` IN (79369, 79370);
+-- Adjust VanCleef's template
+UPDATE `creature_template` SET `AIName`='', `DamageModifier`='7.5', `ScriptName`='boss_vancleef' WHERE `entry`=639;
+-- Delete old SAI script
+DELETE FROM `smart_scripts` WHERE `entryorguid`=639 AND `source_type`=0;