diff options
| author | Keader <keader.android@gmail.com> | 2019-01-05 01:14:57 -0300 |
|---|---|---|
| committer | Keader <keader.android@gmail.com> | 2019-01-05 01:14:57 -0300 |
| commit | dd81978f432f9c1ecb72ebcadcb5a50042e005ad (patch) | |
| tree | 56bfa930ecf082c139c64cfd9828a116a235831e /sql | |
| parent | 8051ff13dfcf3819b58adfcec1608c08dcbcd080 (diff) | |
Scripts/Icecrown Citadel: Some fixes for Valithria Dreamwalker's encounter
Closes #22754 #21887 #17882
Ty sirikfoll for all help
Bonus fixes: Abomination letting worms when fight end, visual missing, archmages stop respawn if corpse despawn
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_01_05_02_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_01_05_02_world.sql b/sql/updates/world/3.3.5/2019_01_05_02_world.sql new file mode 100644 index 00000000000..32e98f1fed0 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_01_05_02_world.sql @@ -0,0 +1,17 @@ +-- Valithria Dreamwalker fixes +DELETE FROM `creature` WHERE `id`=37868; +DELETE FROM `creature_summon_groups` WHERE `summonerId`=38752; +INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`) VALUES +-- Group All Difficulty +(38752,0,1,37868,4222.86,2504.58,364.96,3.90954,8,0), -- Risen Archmage +(38752,0,1,37868,4223.4 ,2465.11,364.952,2.3911,8,0), -- Risen Archmage +-- Group 10 Man +(38752,0,2,37868,4230.44,2478.56,364.953,2.93215,8,0), -- Risen Archmage +(38752,0,2,37868,4230.53,2490.22,364.957,3.36849,8,0), -- Risen Archmage +-- Group 25 man +(38752,0,3,37868,4185.29,2464.01,364.87,0.798137,8,0), -- Risen Archmage +(38752,0,3,37868,4183.7 ,2503.93,364.879,5.50843,8,0); -- Risen Archmage + +UPDATE `creature` SET `phaseMask`=20 WHERE `id` IN(38421,37950); +UPDATE `creature_template` SET `flags_extra`=2 WHERE `entry`=37950; +UPDATE `conditions` SET `ConditionValue2`=37950 WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN(72031,72032,72033,71946); |