From 44860ccb15aa84e5c8a7dcece3b860b35972b3ff Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 5 Sep 2011 17:18:51 +0100 Subject: DB/Spells: Add some missing spell_target_position --- sql/updates/world/2011_09_05_00_world_spell_target_position.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2011_09_05_00_world_spell_target_position.sql (limited to 'sql') 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 -- cgit v1.2.3