diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_10_08_00_world_conditions.sql | 9 | ||||
| -rw-r--r-- | sql/updates/world/2013_10_09_00_world_update.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2013_10_10_00_world_misc.sql | 8 |
3 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/2013_10_08_00_world_conditions.sql b/sql/updates/world/2013_10_08_00_world_conditions.sql new file mode 100644 index 00000000000..c167921b58c --- /dev/null +++ b/sql/updates/world/2013_10_08_00_world_conditions.sql @@ -0,0 +1,9 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (69708,70194,69784,70224,70225,69768,69767); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 3, 69708, 0, 0, 31, 0, 3, 36954, 0, 0, 0, 0, '', 'Spell Ice Prison only hits Lich King'), +(13, 3, 70194, 0, 0, 31, 0, 3, 36954, 0, 0, 0, 0, '', 'Spell Dark Binding only hits Lich King'), +(13, 1, 69784, 0, 0, 31, 0, 3, 37014, 0, 0, 0, 0, '', 'Spell Destroy Wall only hits Ice Wall Target'), +(13, 1, 70224, 0, 0, 31, 0, 3, 37014, 0, 0, 0, 0, '', 'Spell Destroy Wall only hits Ice Wall Target'), +(13, 1, 70225, 0, 0, 31, 0, 3, 37014, 0, 0, 0, 0, '', 'Spell Destroy Wall only hits Ice Wall Target'), +(13, 1, 69768, 0, 0, 31, 0, 3, 37014, 0, 0, 0, 0, '', 'Spell Summon Ice Wall only hits Ice Wall Target'), +(13, 5, 69767, 0, 0, 31, 0, 3, 37014, 0, 0, 0, 0, '', 'Spell Summon Ice Wall only hits Ice Wall Target'); diff --git a/sql/updates/world/2013_10_09_00_world_update.sql b/sql/updates/world/2013_10_09_00_world_update.sql new file mode 100644 index 00000000000..c92c84df7fb --- /dev/null +++ b/sql/updates/world/2013_10_09_00_world_update.sql @@ -0,0 +1 @@ +UPDATE `smart_scripts` SET `action_type`=85, `action_param2`=2 WHERE `entryorguid`=32588 AND `source_type`=0 AND `id`=5; diff --git a/sql/updates/world/2013_10_10_00_world_misc.sql b/sql/updates/world/2013_10_10_00_world_misc.sql new file mode 100644 index 00000000000..e46668548b1 --- /dev/null +++ b/sql/updates/world/2013_10_10_00_world_misc.sql @@ -0,0 +1,8 @@ +UPDATE `creature` SET `spawndist`=0 WHERE `guid`=142524; + +UPDATE `smart_scripts` SET `event_param2`=100 WHERE `entryorguid`=16769 AND `source_type`=0 AND `id`=9; +UPDATE `smart_scripts` SET `action_param1`=55661 WHERE `entryorguid`=29872 AND `source_type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `action_param1`=55661 WHERE `entryorguid`=29895 AND `source_type`=0 AND `id`=3; + +UPDATE `conditions` SET `SourceGroup`=10059 WHERE `SourceTypeOrReferenceId`=10 AND `SourceGroup`=10058 AND `SourceEntry`=51969; +UPDATE `conditions` SET `SourceGroup`=10058 WHERE `SourceTypeOrReferenceId`=10 AND `SourceGroup`=10059 AND `SourceEntry`=51961;
\ No newline at end of file |