From 61109bbd1f1ed8df1aba7e8bcff560031c033584 Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 2 Nov 2016 03:25:24 +0100 Subject: DB/SAI: Bloodscalp Beastmaster, Skullsplinter Beastmaster and Skullsplitter Hunter Closes #18179 Closes #18185 By Staleness89 (cherry picked from commit 101b74b8b4c95886f6eb14b86131beb22e59ac66) DB/Creature: Earthgrab Totem and Tainted Earthgrab Totem Closes #15651 (cherry picked from commit 322f1910fcf2596b14b05b7654da3ab23e1bb018) DB/Gameobject: Add two missing game object Closes #18187 (cherry picked from commit 7e07d9930827e25d79e1c398d4363ca8cad93f07) DB/Spell: Earthgrab Totem http://www.wowhead.com/spell=8378/earthgrab-totem used by http://www.wowhead.com/npc=6066/earthgrab-totem (cherry picked from commit ee52ba690d1b6fcd71b68f49264617a0c12ca9ac) --- .../master/2017_11_26_06_world_2016_11_02_00_world_335.sql | 14 ++++++++++++++ .../master/2017_11_26_07_world_2016_11_02_01_world.sql | 6 ++++++ .../master/2017_11_26_08_world_2016_11_02_02_world.sql | 9 +++++++++ .../master/2017_11_26_09_world_2016_11_02_03_world_335.sql | 6 ++++++ 4 files changed, 35 insertions(+) create mode 100644 sql/updates/world/master/2017_11_26_06_world_2016_11_02_00_world_335.sql create mode 100644 sql/updates/world/master/2017_11_26_07_world_2016_11_02_01_world.sql create mode 100644 sql/updates/world/master/2017_11_26_08_world_2016_11_02_02_world.sql create mode 100644 sql/updates/world/master/2017_11_26_09_world_2016_11_02_03_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/master/2017_11_26_06_world_2016_11_02_00_world_335.sql b/sql/updates/world/master/2017_11_26_06_world_2016_11_02_00_world_335.sql new file mode 100644 index 00000000000..86c433ef209 --- /dev/null +++ b/sql/updates/world/master/2017_11_26_06_world_2016_11_02_00_world_335.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `creature` WHERE `id` IN (698, 756); +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (669,784,699); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (669,784,699) AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(669, 0, 0, 0, 60, 0, 100, 0, 1000, 4000, 10000, 10000, 11, 3621, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Skullsplitter Hunter - On Update - Cast Skullsplitter Pet'), +(669, 0, 1, 0, 0, 0, 100, 0, 4000, 6000, 8000, 10000, 11, 3148, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Skullsplitter Hunter - IC Update - Cast Head Crack'), +(669, 0, 2, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 3417, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Skullsplitter Hunter - On reset - Cast Thrash '), +(784, 0, 0, 0, 60, 0, 100, 0, 1000, 4000, 10000, 10000, 11, 3621, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Skullsplitter Beastmaster - On Update - Cast Skullsplitter Pet'), +(784, 0, 1, 0, 0, 0, 100, 0, 500, 1000, 1661, 2000, 11, 6660, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Skullsplinter Beastmaster - IC - Cast \'Shoot\''), +(699,0, 0,0, 25, 0,100,0, 0, 0, 0, 0, 11, 3612, 0, 0,0,0,0,1,0,0,0,0,0,0,0,'Bloodscalp Beastmaster - On reset - Cast Bloodscalp Pet'), +(699,0, 1,0, 0, 0,100,0, 500, 1000,2000,2000, 11, 6660, 64, 0,0,0,0,2,0,0,0,0,0,0,0,'Bloodscalp Beastmaster - IC - Cast \'Shoot\''), +(699,0, 2,3, 2, 0,100,1, 1, 20, 0, 0, 11, 8599, 0, 0,0,0,0,1,0,0,0,0,0,0,0,'Bloodscalp Beastmaster - On 20% Health - Cast Enrage (No Repeat)'), +(699,0, 3,0, 61, 0,100,0, 0, 0, 0, 0, 1, 0, 0, 0,0,0,0,1,0,0,0,0,0,0,0,'Bloodscalp Beastmaster - On 20% Health - Say Line 0 (No Repeat)'); diff --git a/sql/updates/world/master/2017_11_26_07_world_2016_11_02_01_world.sql b/sql/updates/world/master/2017_11_26_07_world_2016_11_02_01_world.sql new file mode 100644 index 00000000000..d0d4b78c0c3 --- /dev/null +++ b/sql/updates/world/master/2017_11_26_07_world_2016_11_02_01_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (6066,18176) AND `source_type`= 0; +UPDATE `creature_template` SET `AIName`="", `InhabitType`=`InhabitType`|8 WHERE `entry` IN (6066,18176); +DELETE FROM `creature_template_addon` WHERE `entry`=6066; +INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES (6066,'31982'); +UPDATE `creature_template_addon` SET `auras`='31982' WHERE `entry` IN (18176); diff --git a/sql/updates/world/master/2017_11_26_08_world_2016_11_02_02_world.sql b/sql/updates/world/master/2017_11_26_08_world_2016_11_02_02_world.sql new file mode 100644 index 00000000000..7002536a162 --- /dev/null +++ b/sql/updates/world/master/2017_11_26_08_world_2016_11_02_02_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `gameobject_template` WHERE `entry` IN (4,129); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES +(4, 6, 0, "Bonfire Damage", "", "", "", 1, 0, 1, 3, 7902, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0), +(129, 6, 0, "Naxx Teleporter trap", "", "", "", 1, 0, 1, 0, 64446, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0); + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (4); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `mingold`, `maxgold`) VALUES +(4, 14, 0, 0, 0); diff --git a/sql/updates/world/master/2017_11_26_09_world_2016_11_02_03_world_335.sql b/sql/updates/world/master/2017_11_26_09_world_2016_11_02_03_world_335.sql new file mode 100644 index 00000000000..b49502e53c6 --- /dev/null +++ b/sql/updates/world/master/2017_11_26_09_world_2016_11_02_03_world_335.sql @@ -0,0 +1,6 @@ +-- +-- DELETE FROM `spell_dbc` WHERE `id`=8378; +-- INSERT INTO spell_dbc (Id, Dispel, Mechanic, Attributes, AttributesEx, AttributesEx2, AttributesEx3, AttributesEx4, AttributesEx5, AttributesEx6, AttributesEx7, Stances, StancesNot, Targets, CastingTimeIndex, AuraInterruptFlags, ProcFlags, ProcChance, ProcCharges, MaxLevel, BaseLevel, SpellLevel, DurationIndex, RangeIndex, StackAmount, EquippedItemClass, EquippedItemSubClassMask, EquippedItemInventoryTypeMask, Effect1, Effect2, Effect3, EffectDieSides1, EffectDieSides2, EffectDieSides3, EffectRealPointsPerLevel1, EffectRealPointsPerLevel2, EffectRealPointsPerLevel3, EffectBasePoints1, EffectBasePoints2, EffectBasePoints3, EffectMechanic1, EffectMechanic2, EffectMechanic3, EffectImplicitTargetA1, EffectImplicitTargetA2, EffectImplicitTargetA3, EffectImplicitTargetB1, EffectImplicitTargetB2, EffectImplicitTargetB3, EffectRadiusIndex1, EffectRadiusIndex2, EffectRadiusIndex3, EffectApplyAuraName1, EffectApplyAuraName2, EffectApplyAuraName3, EffectAmplitude1, EffectAmplitude2, EffectAmplitude3, EffectMultipleValue1, EffectMultipleValue2, EffectMultipleValue3, EffectItemType1, EffectItemType2, EffectItemType3, EffectMiscValue1, EffectMiscValue2, EffectMiscValue3, EffectMiscValueB1, EffectMiscValueB2, EffectMiscValueB3, EffectTriggerSpell1, EffectTriggerSpell2, EffectTriggerSpell3, EffectSpellClassMaskA1, EffectSpellClassMaskA2, EffectSpellClassMaskA3, EffectSpellClassMaskB1, EffectSpellClassMaskB2, EffectSpellClassMaskB3, EffectSpellClassMaskC1, EffectSpellClassMaskC2, EffectSpellClassMaskC3, MaxTargetLevel, SpellFamilyName, SpellFamilyFlags1, SpellFamilyFlags2, SpellFamilyFlags3, MaxAffectedTargets, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, AreaGroupId, SchoolMask, COMMENT) VALUES +-- (8378, 0, 0, 464, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 29, 29, 21, 1, 0, -1, -1, 0, 6, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 23, 0, 0, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8377, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, "Earthgrab Totem"); + +UPDATE `creature_template_addon` SET `auras`='8378' WHERE `entry` IN (6066); -- cgit v1.2.3