aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2011-09-05 17:18:51 +0100
committerNay <dnpd.dd@gmail.com>2011-09-05 17:18:51 +0100
commit44860ccb15aa84e5c8a7dcece3b860b35972b3ff (patch)
tree2024db08373877b8909f49c65dc655c7d80b41bd
parentfd3bd4c49d511569fcd19826eaa38c69696db1d4 (diff)
DB/Spells: Add some missing spell_target_position
-rw-r--r--sql/updates/world/2011_09_05_00_world_spell_target_position.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2011_09_05_00_world_spell_target_position.sql b/sql/updates/world/2011_09_05_00_world_spell_target_position.sql
new file mode 100644
index 00000000000..ae0a69c6e99
--- /dev/null
+++ b/sql/updates/world/2011_09_05_00_world_spell_target_position.sql
@@ -0,0 +1,6 @@
+DELETE FROM `spell_target_position` WHERE `id` IN (17278,49097,55431);
+INSERT INTO `spell_target_position` (`id` ,`target_map` ,`target_position_x` ,`target_position_y` ,`target_position_z` ,`target_orientation`) VALUES
+(17278, 329, 3534.3, -2966.74, 125.001, 0.279253), -- Cannon Fire cast by a trap GO Cannonball
+(49097, 0, -466.4, 1496.36, 17.43, 2.1), -- Out of Body Experience, quest with the same name (Grizzly Hills -> Silverpine)
+(55431, 571, 5787.781250, -1582.446045, 234.830414, 2.14); -- Summon Gymer
+-- 53821 Teach:Death Gate - couldn't find enough info