DB/Misc: Few Hyjal fixes

By Malcrom 
Cherry pick of https://gitlab.com/trinitycore/TrinityCore_434/commit/380de0105b5ec1ffb2d3467a53e4b578232cde6b

1 files changed, 168 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_04_28_00_world.sql b/sql/updates/world/master/2019_04_28_00_world.sql
new file mode 100644
index 00000000000..95d73d47055
--- /dev/null
+++ b/sql/updates/world/master/2019_04_28_00_world.sql
@@ -0,0 +1,168 @@
+-- Spell Area
+DELETE FROM `spell_area` WHERE `area` IN (493, 5040) AND `spell`= 49416;
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `autocast`, `gender`, `quest_start_status`, `quest_end_status`) VALUES
+(49416, 493, 25316, 25316, 1, 2, 2, 11),
+(49416, 5040, 25316, 25316, 1, 2, 2, 11);
+
+-- Gameobject focus (203087)
+DELETE FROM `gameobject` WHERE `guid`= 200888;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseID`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(200888, 203087, 1, 0, 0, "0", 169, 5758.737, -3297.48, 1604.599, 0, 0, 0, 0, 1, 6000, 100, 1, 0);
+
+-- Remove  duplicate spawns
+DELETE FROM `creature` WHERE `guid` IN (394598, 384268);
+DELETE FROM `creature_addon` WHERE `guid` IN (394598, 384268);
+
+-- Make quest items quest related
+UPDATE `creature_loot_template` SET `QuestRequired`= 1 WHERE `Item` IN (52506, 53139);
+
+-- Conditions
+DELETE FROM `conditions` WHERE `SourceEntry` IN (75206, 75192) AND `SourceTypeOrReferenceId`= 17;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ScriptName`, `Comment`) VALUES
+(17, 0, 75206, 0, 0, 31, 1, 3, 38896, 0, 0, 0, '', 'Flamebreaker - Only allow Blazebound Elemental'),
+(17, 0, 75192, 0, 0, 31, 1, 3, 40147, 0, 0, 0, '', 'Weakening - Only allow Baron Geddon');
+
+-- Conditions
+DELETE FROM `conditions` WHERE `SourceEntry` IN (76205, 73518) AND `SourceTypeOrReferenceId`= 13;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ScriptName`, `Comment`) VALUES
+(13, 1, 76205, 0, 0, 31, 0, 5, 203065, 0, 0, 0, '', 'Emerald Flameweaver Drake Breath - Target Emerald Flames'),
+(13, 1, 73518, 0, 0, 31, 0, 3, 39140, 0, 0, 0, '', 'Hyjal Intro Flight - Target Aronus');
+
+DELETE FROM `conditions` WHERE `SourceEntry` IN (73518) AND `SourceTypeOrReferenceId`= 18;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ScriptName`, `Comment`) VALUES
+(18, 39140, 73518, 0, 0, 28, 0, 25316, 0, 0, 0, 0, '', 'Required quest complete for spellclick');
+
+-- Update Movements
+UPDATE `creature` SET `spawndist`= 0, `MovementType`= 0 WHERE `id`= 39921;
+UPDATE `creature` SET `spawndist`= 7, `MovementType`= 1 WHERE `id`= 40229;
+UPDATE `creature` SET `spawndist`= 5, `MovementType`= 1 WHERE `id`= 49844;
+
+-- Template Updates
+-- Scalding Rock Elemental
+UPDATE `creature_template` SET `DamageModifier`= 2.3 WHERE `entry`= 40229;
+-- Hyjal Warden
+UPDATE `creature_template` SET `DamageModifier`= 2.3 WHERE `entry`= 38915;
+-- Furious Hyjal Warden
+UPDATE `creature_template` SET `DamageModifier`= 2.3 WHERE `entry`= 43427;
+-- Twilight Infiltrator
+UPDATE `creature_template` SET `DamageModifier`= 2.3, `mingold`= 2000, `maxgold`= 2500 WHERE `entry`= 40882;
+-- Aronus
+UPDATE `creature_template` SET `npcflag`= 16777216, `InhabitType`= 4 WHERE `entry`= 39140;
+-- Ragnaros
+UPDATE `creature_template` SET `InhabitType`= 4, `flags_extra`= 2 WHERE `entry`= 38806;
+-- Deathwing
+UPDATE `creature_template` SET `InhabitType`= 4 WHERE `entry`= 39867;
+-- Generic Bunny - PRK (Large AOI)
+UPDATE `creature_template` SET `InhabitType`= 4, `flags_extra`= 128 WHERE `entry`= 44775;
+-- Twilight Vanquisher
+UPDATE `creature_template` SET `DamageModifier`= 1.5, `flags_extra`= 2048, `BaseAttackTime`= 2000, `mingold`= 1000, `maxgold`= 4000 WHERE `entry`= 38913;
+-- Twilight Flamecaller
+UPDATE `creature_template` SET `DamageModifier`= 2.3, `mingold`= 1000, `maxgold`= 4000 WHERE `entry`= 38926;
+-- Twilight Overseer
+UPDATE `creature_template` SET `DamageModifier`= 2.3, `mingold`= 1000, `maxgold`= 4000 WHERE `entry`= 40123;
+-- Blazebound Elemental
+UPDATE `creature_template` SET `DamageModifier`= 2.3 WHERE `entry`= 38896;
+-- Unbound Flame Spirit
+UPDATE `creature_template` SET `unit_flags`= 33587968 WHERE `entry`= 40080;
+-- Unbound Flame Spirit
+UPDATE `creature_template` SET `unit_class`=2 WHERE `entry` IN (40065,40080);
+
+-- Blazebound Elemental Entry: 38896 SAI
+SET @ENTRY := 38896;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,5000,5000,12500,15300,11,80031,0,0,0,0,0,2,0,0,0,0,0,0,0, "Blazebound Elemental - Combat - Cast 'Flaming Slice'"),
+(@ENTRY,0,1,0,8,0,100,0,74723,0,0,0,37,0,0,0,0,0,0,1,0,0,0,0,0,0,0, "Blazebound Elemental - On Spell Hit  - Die");
+
+-- Unbound Flame Spirit Entry: 40080 SAI
+SET @ENTRY := 40080;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,54,0,100,0,0,0,0,0,116,2,0,0,0,0,0,1,0,0,0,0,0,0,0, "Unbound Flame Spirit - Just summoned - Set corpse delay"),
+(@ENTRY,0,1,0,54,0,100,0,0,0,0,0,3,40065,0,0,0,0,0,1,0,0,0,0,0,0,0, "Unbound Flame Spirit - Just summoned - Morph to entry 40065"),
+(@ENTRY,0,2,0,54,0,100,0,0,0,0,0,19,33554688,0,0,0,0,0,1,0,0,0,0,0,0,0, "Unbound Flame Spirit - Just summoned - Remove UNIT_FLAGS - UNIT_FLAG_IMMUNE_TO_PC, UNIT_FLAG_NOT_SELECTABLE"),
+(@ENTRY,0,3,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,23,0,0,0,0,0,0,0, "Unbound Flame Spirit - Just summoned - Attack Summoner"),
+(@ENTRY,0,4,0,6,0,100,0,0,0,0,0,33,40065,0,0,0,0,0,7,0,0,0,0,0,0,0, "Unbound Flame Spirit - On death - Killcredit");
+
+-- Twilight Vanquisher Entry: 38913 SAI
+SET @ENTRY := 38913;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,6000,8000,14000,18000,11,79881,0,0,0,0,0,2,0,0,0,0,0,0,0, "Twilight Vanquisher - Combat - Cast 'Slam'"),
+(@ENTRY,0,1,0,1,0,100,0,1000,1000,5000,5000,49,0,0,0,0,0,0,11,38915,6,0,0,0,0,0, "Twilight Vanquisher - OOC - Attack Hyjal Warden");
+
+-- Twilight Flamecaller Entry: 38926 SAI
+SET @ENTRY := 38926;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4700,11,15536,64,0,0,0,0,2,0,0,0,0,0,0,0, "Twilight Flamecaller - Combat - Cast 'Fireball'"),
+(@ENTRY,0,1,0,0,0,100,0,3000,6000,11000,12000,11,20794,0,0,0,0,0,2,0,0,0,0,0,0,0, "Twilight Flamecaller - Combat - Cast 'Flamestrike'"),
+(@ENTRY,0,2,0,0,0,100,0,9000,9000,21000,22000,11,11990,0,0,0,0,0,2,0,0,0,0,0,0,0, "Twilight Flamecaller - Combat - Cast 'Rain of Fire'"),
+(@ENTRY,0,3,0,1,0,100,0,1000,1000,5000,5000,49,0,0,0,0,0,0,11,38915,10,0,0,0,0,0, "Twilight Flamecaller - Combat - Attack Hyjal Warden"),
+(@ENTRY,0,4,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,0, "Twilight Flamecaller - HP 0% - 15% - Flee for assist (No Repeat)");
+
+-- SAI corrections and additions
+-- Furious Hyjal Warden Entry: 43427 SAI
+SET @ENTRY := 43427;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,5000,6000,22000,30000,11,18328,0,0,0,0,0,1,0,0,0,0,0,0,0, "Furious Hyjal Warden - Combat - Cast 'Incapacitating Shout'"),
+(@ENTRY,0,1,0,0,0,100,0,1000,3000,7000,14000,11,19643,0,0,0,0,0,2,0,0,0,0,0,0,0, "Furious Hyjal Warden - Combat - Cast 'Mortal Strike'"),
+(@ENTRY,0,2,0,0,0,100,0,1000,3000,11000,13000,11,15618,0,0,0,0,0,2,0,0,0,0,0,0,0, "Furious Hyjal Warden - Combat - Cast Snap Kick"),
+(@ENTRY,0,3,0,1,0,100,0,1000,1000,3000,3000,49,0,0,0,0,0,0,11,40229,10,0,0,0,0,0, "Furious Hyjal Warden - OOC - Attack Scalding Rock Elemental");
+
+-- Hyjal Warden Entry: 38915 SAI
+SET @ENTRY := 38915;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,5000,5000,11000,14000,11,19643,0,0,0,0,0,2,0,0,0,0,0,0,0, "Hyjal Warden - Combat - Cast Snap Kick"),
+(@ENTRY,0,1,0,1,0,100,0,1000,1000,3000,3000,49,0,0,0,0,0,0,11,40229,10,0,0,0,0,0, "Hyjal Warden - OOC - Attack Scalding Rock Elemental");
+
+-- Scalding Rock Elemental Entry: 40229 SAI
+SET @ENTRY := 40229;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,0,0,100,0,8000,10000,15000,19000,11,80638,0,0,0,0,0,2,0,0,0,0,0,0,0, "Scalding Rock Elemental - Combat - Cast Searing Touch");
+
+-- Cenarion Emissary Jademoon Entry: 15187 SAI
+SET @ENTRY := 15187;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,62,0,100,512,12129,0,0,0,86,86587,0,7,0,0,0,7,0,0,0,0,0,0,0, "Cenarion Emissary Jademoon - Gossip Option Select - Invoker Cast Teleport to Moonglade");
+
+-- Cenarion Emissary Blackhoof Entry: 15188 SAI
+SET @ENTRY := 15188;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,62,0,100,512,12125,0,0,0,86,86565,0,7,0,0,0,7,0,0,0,0,0,0,0, "Cenarion Emissary Blackhoof - Gossip Option Select - Invoker Cast Teleport to Moonglade");
+
+-- Ragnaros Entry: 38806 SAI
+SET @ENTRY := 38806;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`= @ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,63,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, "Ragnaros - Just Created - Say 0"),
+(@ENTRY,0,1,0,60,0,100,1,3500,3500,0,0,5,53,0,0,0,0,0,1,0,0,0,0,0,0,0, "Ragnaros - Update - Emote 53");
+
+-- As Hyjal Burns Texts
+DELETE FROM `creature_text` WHERE `CreatureID` IN (38806, 39128);
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES
+(38806, 0, 0, 'BY FIRE BE PURGED!!!!', 14, 0, 100, 449, 0, 23335, 39839, 'Ragnaros to Player'),
+(39128, 0, 0, 'No... it can\'t be.  Our forward outpost has been obliterated!', 12, 0, 100, 0, 0, 20950, 39185, 'Aronus to Player'),
+(39128, 1, 0, 'Is it too late?  I feel Deathwing\'s presence nearby!', 12, 0, 100, 0, 0, 20951, 39186, 'Aronus to Player'),
+(39128, 2, 0, 'The Firelord has risen!  We must send word to the others.  Let us hurry!', 12, 0, 100, 0, 0, 20952, 39189, 'Aronus to Player');
+UPDATE `creature_text` SET `TextRange`= 1 WHERE `CreatureID`= 38806;
+
+-- Spellclick
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (39140, 39128);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
+(39140, 73518, 1, 0),(39128, 76649, 1, 0);