diff options
| author | Keader <keader.android@gmail.com> | 2017-01-01 21:19:25 -0200 |
|---|---|---|
| committer | DoctorKraft <DoctorKraft@users.noreply.github.com> | 2018-03-18 00:19:50 +0100 |
| commit | f7970166d7c5891e42835d5a6c5235c4e895bc0a (patch) | |
| tree | 0966defc6d90ce341315bb8b5975e1d98de387cb /sql | |
| parent | 36910585c9cb27e22ecceca647909b4b20a2c087 (diff) | |
Core/Scripts: Blood Prince Council refactored and fixed reported issues (#18632)
Closes #7150
(cherry picked from commit 64f6f2a0ae7294857d5ebd1ec6034476e94656e6)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2018_03_17_49_world_2017_01_01_07_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_03_17_49_world_2017_01_01_07_world.sql b/sql/updates/world/master/2018_03_17_49_world_2017_01_01_07_world.sql new file mode 100644 index 00000000000..3395b580746 --- /dev/null +++ b/sql/updates/world/master/2018_03_17_49_world_2017_01_01_07_world.sql @@ -0,0 +1,13 @@ +DELETE FROM `linked_respawn` WHERE `guid`IN(201369,201493,201577,201286); +DELETE FROM `creature` WHERE `id` IN(37973,37972,37970); +DELETE FROM `creature_summon_groups` WHERE `summonerId`=38008; -- Blood orb controller +INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`) VALUES +(38008,0,1,37973,4682.89,2755.11,364.17,3.14159 ,6,3600000), -- Taldaram +(38008,0,1,37972,4682.73,2783.42,364.17,3.14159,6,3600000), -- Keleseth +(38008,0,1,37970,4680.29,2769.24,364.17,3.14159,6,3600000); -- Valanar + +DELETE FROM spell_proc WHERE SpellId=72059; +INSERT INTO spell_proc (SpellId, SchoolMask, SpellFamilyName, SpellFamilyMask0, SpellFamilyMask1, SpellFamilyMask2, ProcFlags, SpellTypeMask, SpellPhaseMask, HitMask, AttributesMask, ProcsPerMinute, Chance, Cooldown, Charges) VALUES +(72059, 0, 0, 0x0, 0x0, 0x0, 0, 0x1, 0x2, 0x403, 0x2, 0, 0, 0, 0); -- Unstable + +UPDATE `creature_template` SET `speed_walk`=0.4, `speed_run`=0.142857 WHERE `entry` IN (38454,38775); -- normal kinetic |