From 8743fd9c6ff694153d49d648e5714065da55ef0e Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 18 Apr 2015 15:40:21 +0200 Subject: DB/Quest: Fix multiples spawn for A Taste of Flame By Killyana, closes #2752 (cherry picked from commit 10edd860ee6a66a06ca9b47014fe4f393f556d20) --- sql/updates/world/2015_05_19_02_world_2015_04_18_00.sql | 1 + sql/updates/world/2015_05_19_02_world_2015_04_18_00_world.sql | 1 - sql/updates/world/2015_05_19_03_world_2015_04_18_01.sql | 6 ++++++ 3 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2015_05_19_02_world_2015_04_18_00.sql delete mode 100644 sql/updates/world/2015_05_19_02_world_2015_04_18_00_world.sql create mode 100644 sql/updates/world/2015_05_19_03_world_2015_04_18_01.sql (limited to 'sql') diff --git a/sql/updates/world/2015_05_19_02_world_2015_04_18_00.sql b/sql/updates/world/2015_05_19_02_world_2015_04_18_00.sql new file mode 100644 index 00000000000..29d67fe0429 --- /dev/null +++ b/sql/updates/world/2015_05_19_02_world_2015_04_18_00.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `InhabitType`=3 WHERE `entry` IN (5931, 3989, 3988, 3991, 3999, 4004, 4003); diff --git a/sql/updates/world/2015_05_19_02_world_2015_04_18_00_world.sql b/sql/updates/world/2015_05_19_02_world_2015_04_18_00_world.sql deleted file mode 100644 index 29d67fe0429..00000000000 --- a/sql/updates/world/2015_05_19_02_world_2015_04_18_00_world.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `InhabitType`=3 WHERE `entry` IN (5931, 3989, 3988, 3991, 3999, 4004, 4003); diff --git a/sql/updates/world/2015_05_19_03_world_2015_04_18_01.sql b/sql/updates/world/2015_05_19_03_world_2015_04_18_01.sql new file mode 100644 index 00000000000..707335c490e --- /dev/null +++ b/sql/updates/world/2015_05_19_03_world_2015_04_18_01.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=40060 AND `ConditionTypeOrReference`=29; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,40060,0,0,0,29,0,9461,100,0,1,0,0,'','Gor Grimgut cannot be a target for Exhaustion.'), +(15,40060,0,0,1,29,0,9461,100,0,1,0,0,'','Gor Grimgut cannot be a target for Exhaustion.'), +(15,40060,0,0,2,29,0,9461,100,0,1,0,0,'','Gor Grimgut cannot be a target for Exhaustion.'); -- cgit v1.2.3