From 95cad03fa4fa316b49eb2dfe1a2742a71847dfe9 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Tue, 8 Oct 2013 04:22:26 +0200 Subject: Scripts/HoR: fixed infinite spawn, added some missing spell target conditions and fixed codestyle Closes #10754 --- sql/updates/world/2013_10_08_00_world_conditions.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/2013_10_08_00_world_conditions.sql (limited to 'sql') 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'); -- cgit v1.2.3 From 8a94744c4b0ed750c6d251b0352acecb341a92aa Mon Sep 17 00:00:00 2001 From: Filip Date: Wed, 9 Oct 2013 09:13:38 +0200 Subject: DB/Update: Quest credit fix-up --- sql/updates/world/2013_10_09_00_world_update.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_10_09_00_world_update.sql (limited to 'sql') 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; -- cgit v1.2.3 From 4588294dd8580f93efdede3921909c7f1b7924c7 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Wed, 9 Oct 2013 23:13:26 +0200 Subject: Fix some db errors ... (Yippie-Ya-Yeah) --- sql/updates/world/2013_10_10_00_world_misc.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2013_10_10_00_world_misc.sql (limited to 'sql') 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 -- cgit v1.2.3