diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2013-08-10 20:13:24 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2013-08-10 20:13:24 +0200 |
| commit | c2ae39685b6604d6eba852accbada4dae5dc7343 (patch) | |
| tree | c466320c252b43d07f49eb1b62c3f6d5111ce7c3 | |
| parent | f23069e324facd36325e02b92102a571556c4db2 (diff) | |
DB/Misc: Fix logic fail in f23069e324facd36325e02b92102a571556c4db2
| -rw-r--r-- | sql/updates/world/2013_08_09_09_world_sai.sql | 8 | ||||
| -rw-r--r-- | sql/updates/world/2013_08_10_02_world_spell_target_position.sql | 3 |
2 files changed, 7 insertions, 4 deletions
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); |