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)

4 files changed, 35 insertions, 0 deletions

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);