aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMitchesD <majklprofik@seznam.cz>2014-09-12 15:25:07 +0200
committerMitchesD <majklprofik@seznam.cz>2014-09-12 15:25:07 +0200
commitd7b0ee7c0366bf78e09f4eca5f93e65361c5a2b6 (patch)
tree36c4a548ba81305459a6544b3dbcfa50fbb24ce4 /sql
parent4e25304a6688cfc153a2c8238fd571e9bb3ad49f (diff)
parentcc00d2f181e74b6e9e0faa6241a9017435cbca8a (diff)
Merge pull request #12927 from MitchesD/misc_3
Scripts/CoS: implemented Infinite Corruptor, improvements in instance sc...
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_09_12_02_world_misc.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_12_02_world_misc.sql b/sql/updates/world/2014_09_12_02_world_misc.sql
new file mode 100644
index 00000000000..535ecb90367
--- /dev/null
+++ b/sql/updates/world/2014_09_12_02_world_misc.sql
@@ -0,0 +1,9 @@
+DELETE FROM `creature_text` WHERE `entry`=26527;
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextId`) VALUES
+(26527, 0, 0, 'Oh, no! Adventurers, something awful has happened! A colleague of mine has been captured by the Infinite Dragonflight, and they''re doing something horrible to him! Keeping Arthas is still your highest priority, but if you act fast you could help save a Guardian of Time!', 15, 0, 100, 0, 0, 0, 'Chromie', 32670),
+(26527, 1, 0, 'Adventurers, you must hurry! The Guardian of Time cannot last for much longer!', 15, 0, 100, 0, 0, 0, 'Chromie', 32678),
+(26527, 2, 0, 'I can barely sense the Guardian of Time! His timeline is fading quickly!', 15, 0, 100, 0, 0, 0, 'Chromie', 32679);
+
+DELETE FROM `conditions` WHERE `SourceEntry`=60422;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `Comment`) VALUES
+(13, 1, 60422, 0, 0, 31, 1, 3, 32281, 0, 0, 0, 0, 'Corruption of Time (60422) can hit only Guardian of Time');