aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKandera <KanderaDev@gmail.com>2012-05-18 13:44:30 -0400
committerKandera <KanderaDev@gmail.com>2012-05-18 13:44:30 -0400
commit7b8bece5788339a9da91f845d1ebf2399c360460 (patch)
tree4f1ec4fe299d75179e02996dc9e8e9067a0fe3d4
parent1037f96e4f9a788cc450fd429ce5f2b0fcc29790 (diff)
DB/SpellTargeting: use correct spell target position data from sniffs for all teleport to dalaran spells.
-rw-r--r--sql/updates/world/2012_05_18_01_world_spell_target_position.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_18_01_world_spell_target_position.sql b/sql/updates/world/2012_05_18_01_world_spell_target_position.sql
new file mode 100644
index 00000000000..72ebc409d9d
--- /dev/null
+++ b/sql/updates/world/2012_05_18_01_world_spell_target_position.sql
@@ -0,0 +1,9 @@
+DELETE FROM `spell_target_position` WHERE `id` IN (30719,53140,53141,53360,54406,68328,71512);
+INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES
+(30719,571,5807.75,588.347,661.505,1.663),
+(53140,571,5807.75,588.347,661.505,1.663),
+(53141,571,5807.75,588.347,661.505,1.663),
+(53360,571,5807.75,588.347,661.505,1.663),
+(54406,571,5807.75,588.347,661.505,1.663),
+(68328,571,5807.75,588.347,661.505,1.663),
+(71512,571,5807.75,588.347,661.505,1.663);