From c2ae39685b6604d6eba852accbada4dae5dc7343 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 10 Aug 2013 20:13:24 +0200 Subject: DB/Misc: Fix logic fail in f23069e324facd36325e02b92102a571556c4db2 --- sql/updates/world/2013_08_09_09_world_sai.sql | 8 ++++---- sql/updates/world/2013_08_10_02_world_spell_target_position.sql | 3 +++ 2 files changed, 7 insertions(+), 4 deletions(-) (limited to 'sql') diff --git a/sql/updates/world/2013_08_09_09_world_sai.sql b/sql/updates/world/2013_08_09_09_world_sai.sql index 525e8958f14..1ba2e7a5b15 100644 --- a/sql/updates/world/2013_08_09_09_world_sai.sql +++ b/sql/updates/world/2013_08_09_09_world_sai.sql @@ -17,11 +17,11 @@ DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10 INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (15,10024,0,0,28,12521,0,0,0,'','Show gossip option if player has quest Where in the World is Hemet Nesingwary?'); DELETE FROM `gossip_menu_option` WHERE `menu_id`=10024 AND `id`=1; -/* + -- Add spell target position -DELETE FROM `spell_target_position` WHERE `id`=50859; +DELETE FROM `spell_target_position` WHERE `id`=50987; INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES -(50859,571,5832.892,482.8708,658.2753,0.9121326); -*/ +(50987,571,5071.35,4642.54,72.164,0.878587); + -- Update Archmage Pentarus' Flying Machine UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=28192; diff --git a/sql/updates/world/2013_08_10_02_world_spell_target_position.sql b/sql/updates/world/2013_08_10_02_world_spell_target_position.sql index fbd76738826..e576a424f05 100644 --- a/sql/updates/world/2013_08_10_02_world_spell_target_position.sql +++ b/sql/updates/world/2013_08_10_02_world_spell_target_position.sql @@ -1 +1,4 @@ DELETE FROM `spell_target_position` WHERE `id`=50859; +DELETE FROM `spell_target_position` WHERE `id`=50987; +INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES +(50987,571,5832.892,482.8708,658.2753,0.9121326); -- cgit v1.2.3