diff options
| author | Teppic1 <32468801+Teppic1@users.noreply.github.com> | 2017-12-23 15:31:40 +0000 |
|---|---|---|
| committer | jackpoz <giacomopoz@gmail.com> | 2017-12-23 16:31:40 +0100 |
| commit | ecc55c280c69c1f185df8f6365c7945165f0117f (patch) | |
| tree | 126ab14cb805609c087cd9896bb4f6766b9dbe3e /sql/updates | |
| parent | cd88406de9467127e988e4b0f7e2ba0ec787636b (diff) | |
Scripts/Deadmines: New script for Edwin VanCleef (#20736)
* Scripts/Deadmines: New script for Edwin VanCleef
- Blackguards are now summoned properly as part of the encounter
- Blackguards will despawn on evade
- Fixed scripted actions/speech on health
- Removed Blackguards from world DB
- Corrected VanCleef's damage
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/3.3.5/2017_12_23_00_world.sql | 8 |
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; |