From 222b30f2e8d03ad45a01b6c475e576a5995978b2 Mon Sep 17 00:00:00 2001 From: Pitcrawler Date: Sat, 16 Mar 2013 14:35:48 +0100 Subject: DB/Conditions: Fix some spell implicit targets Fix an SAI issue (visual only) --- sql/updates/world/2013_03_16_00_world_conditions.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2013_03_16_00_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2013_03_16_00_world_conditions.sql b/sql/updates/world/2013_03_16_00_world_conditions.sql new file mode 100644 index 00000000000..0a8f347ac35 --- /dev/null +++ b/sql/updates/world/2013_03_16_00_world_conditions.sql @@ -0,0 +1,10 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (48619,48620,52812); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=48738; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,48619,0,0,31,0,3,27377,0,0,'','Spell Flame Breath effect0 targets Thane Torvald Eriksson'), +(13,2,48619,0,0,31,0,3,27377,0,0,'','Spell Flame Breath effect1 targets Thane Torvald Eriksson'), +(13,1,48620,0,0,31,0,3,27377,0,0,'','Spell Wing Buffet targets Thane Torvald Eriksson'), +(13,1,52812,0,0,31,0,3,27377,0,0,'','Spell Molten Fury effect0 targets Thane Torvald Eriksson'), +(13,2,52812,0,0,31,0,3,27377,0,0,'','Spell Molten Fury effect1 targets Thane Torvald Eriksson'); + +UPDATE `smart_scripts` SET `event_type`=1, `event_flags`=1 WHERE `entryorguid`=21633 AND `source_type`=0 AND `id`=0; -- cgit v1.2.3