diff options
| author | Keader <keader.android@gmail.com> | 2019-01-05 01:14:57 -0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-11-18 22:41:57 +0100 |
| commit | dd067390dcc05b707c40c27758a9f06807cc0803 (patch) | |
| tree | 24f1fcb9a62f83af08e9b3ec7ef4efe9758f2681 /sql | |
| parent | 3b1ed434aeacfa57f392387c2176dfb4438b13f8 (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
(cherry picked from commit dd81978f432f9c1ecb72ebcadcb5a50042e005ad)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2021_11_18_04_world_2019_01_05_02_world.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_18_04_world_2019_01_05_02_world.sql b/sql/updates/world/master/2021_11_18_04_world_2019_01_05_02_world.sql new file mode 100644 index 00000000000..abab877b38d --- /dev/null +++ b/sql/updates/world/master/2021_11_18_04_world_2019_01_05_02_world.sql @@ -0,0 +1,20 @@ +-- 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 `phaseGroup`=650 WHERE `id` IN (36789) AND `map`=631; -- old phasemask 1 | 32, phase ids 169, 174 +UPDATE `creature` SET `phaseId`=173 WHERE `id` IN (37985) AND `map`=631; -- old phasemask 16, phase ids 173 +UPDATE `creature` SET `phaseGroup`=391 WHERE `id` IN (16980,38752) AND `map`=631; -- old phasemask 1 | 16, phase ids 169, 173 +UPDATE `creature` SET `phaseGroup`=413 WHERE `id` IN (38421,37950) AND `map`=631; -- old phasemask 16 | 32, phase ids 173, 174 +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); |