Scripts/Archimonde: replaced one yell with proper db content and unhacked drain world tree

(cherry picked from commit 58aca0da81619c7f3932024c573024518369d8a7)

1 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/world/2014_12_15_00_world.sql b/sql/updates/world/2014_12_15_00_world.sql
new file mode 100644
index 00000000000..8ed026454c6
--- /dev/null
+++ b/sql/updates/world/2014_12_15_00_world.sql
@@ -0,0 +1,18 @@
+SET @CGUID := 6747;
+DELETE FROM `creature` WHERE `guid`=@CGUID;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@CGUID, 22418, 534, 1, 1, 5502.288, -3525.471, 1607.909, 2.617994, 7200, 0, 0);
+
+DELETE FROM `creature_text` WHERE `entry`=17968 AND `groupid`=8;
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(17968, 8, 0, 'All of your efforts have been in vain, for the draining of the World Tree has already begun!  Soon the heart of your world will beat no more!', 14, 0, 100, 0, 0, 10986, 20432, 3, 'Archimonde - Intro');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (39140,39141,39142);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,1,39140,0,0,31,0,3,22418,0,0,0, '', 'Drain World Tree Visual'),
+(13,1,39141,0,0,31,0,3,17968,0,0,0, '', 'Drain World Tree Visual 2'),
+(13,1,39142,0,0,31,0,3,22418,0,0,0, '', 'Drain World Tree Dummy');
+
+DELETE FROM `spell_script_names` WHERE `spell_id`=39142;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(39142, 'spell_archimonde_drain_world_tree_dummy');