diff options
| author | Keader <keader.android@gmail.com> | 2017-01-01 21:19:25 -0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-01-01 21:19:25 -0200 |
| commit | 64f6f2a0ae7294857d5ebd1ec6034476e94656e6 (patch) | |
| tree | 30a7fb7112b4209b9df43aff7d70f54cfbbc9bd8 /sql | |
| parent | 5af1fa22733c64e97f60967b36ea970a355d0598 (diff) | |
Core/Scripts: Blood Prince Council refactored and fixed reported issues (#18632)
Closes #7150
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2017_01_01_07_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_01_07_world.sql b/sql/updates/world/3.3.5/2017_01_01_07_world.sql new file mode 100644 index 00000000000..3395b580746 --- /dev/null +++ b/sql/updates/world/3.3.5/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 |