From 1df3ca82b7dcc0ff0ebe150ee7bc8c65208e40ea Mon Sep 17 00:00:00 2001 From: Nyeriah Date: Fri, 29 May 2015 13:38:19 -0300 Subject: Rename 2015_08_03_world.sql to 2015_05_29_01_world.sql --- sql/updates/world/2015_05_29_01_world.sql | 7 +++++++ sql/updates/world/2015_08_24_03_world.sql | 7 ------- 2 files changed, 7 insertions(+), 7 deletions(-) create mode 100644 sql/updates/world/2015_05_29_01_world.sql delete mode 100644 sql/updates/world/2015_08_24_03_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2015_05_29_01_world.sql b/sql/updates/world/2015_05_29_01_world.sql new file mode 100644 index 00000000000..ce03049c9a9 --- /dev/null +++ b/sql/updates/world/2015_05_29_01_world.sql @@ -0,0 +1,7 @@ +-- [Quest] No Mere Dream +UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=22834 AND `source_type`=0 AND `id`=1 AND `link`=2; +UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=22834 AND `source_type`=0 AND `id`=2 AND `link`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (22834) AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22,2,22834,0,0,1,0,39601,1,0,1,0,'','Event SAI triggred only if the player don''t have the aura 39601'); +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=22916; diff --git a/sql/updates/world/2015_08_24_03_world.sql b/sql/updates/world/2015_08_24_03_world.sql deleted file mode 100644 index ce03049c9a9..00000000000 --- a/sql/updates/world/2015_08_24_03_world.sql +++ /dev/null @@ -1,7 +0,0 @@ --- [Quest] No Mere Dream -UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=22834 AND `source_type`=0 AND `id`=1 AND `link`=2; -UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=22834 AND `source_type`=0 AND `id`=2 AND `link`=0; -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (22834) AND `SourceId`=0; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES -(22,2,22834,0,0,1,0,39601,1,0,1,0,'','Event SAI triggred only if the player don''t have the aura 39601'); -UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=22916; -- cgit v1.2.3