Scripts/Instance: The Stonecore updates

Stonecore Teleporters scripted. Some corrections, better handlings, fixed Travis warnings ...

Closes #13626

(cherry picked from commit 9a941ae125c8b22b802270f7f419c1a8bfd2a343)

Conflicts:
	src/server/scripts/Maelstrom/Stonecore/boss_high_priestess_azil.cpp
	src/server/scripts/Maelstrom/Stonecore/boss_ozruk.cpp
	src/server/scripts/Maelstrom/Stonecore/instance_stonecore.cpp
	src/server/scripts/Maelstrom/Stonecore/stonecore.cpp

1 files changed, 25 insertions, 0 deletions

diff --git a/sql/updates/world/2014_12_28_02_world.sql b/sql/updates/world/2014_12_28_02_world.sql
new file mode 100644
index 00000000000..9bbd10e71b6
--- /dev/null
+++ b/sql/updates/world/2014_12_28_02_world.sql
@@ -0,0 +1,25 @@
+-- The Stonecore updates
+-- Spell conditions
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` IN (93167, 86862, 86863);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13, 1, 93167, 0, 0, 31, 0, 3, 40350, 0, 0, 0, 0, '', 'Twilight Documents targets Generic Trigger LAB'),
+(13, 1, 86862, 0, 0, 31, 0, 3, 42355, 0, 0, 0, 0, '', 'Seismic Shard targets Seismic Shards'),
+(13, 1, 86862, 0, 0, 1, 0, 79009, 0, 0, 0, 0, 0, '', 'Seismic Shard''s target must have SPELL_SEISMIC_SHARD_VISUAL aura'),
+(13, 1, 86863, 0, 0, 31, 0, 3, 42333, 0, 0, 0, 0, '', 'Seismic Shard targets High Priestess Azil');
+
+-- Set CREATURE_FLAG_EXTRA_TRIGGER to Stonecore Teleporters, Lava Fissure, Stalactite Trigger - Boss, Rupture Controller, Rupture, Gravity Well, Seismic Shard
+UPDATE `creature_template` SET `flags_extra` = 128 WHERE `entry` IN (51396, 51397, 43242, 43159, 49597, 49576, 42499, 42355);
+
+-- Stonecore Teleporters
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (51396, 51397);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
+(51396, 95284, 3, 0),
+(51397, 95285, 3, 0);
+
+DELETE FROM `spell_target_position` WHERE `id` IN (95284, 95285);
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(95284, 0, 725, 1313.26, 1236.833, 247.2859, 0),
+(95285, 0, 725, 853.8577, 999.7518, 317.3986, 0);
+
+-- Remove cpp script from Seismic Shard (86862) spell
+DELETE FROM `spell_script_names` WHERE `spell_id` = 86862;