aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorQAston <none@none>2009-07-19 14:02:52 +0200
committerQAston <none@none>2009-07-19 14:02:52 +0200
commit94992adb64544ab6a813f3e244a2e14cf80823f5 (patch)
tree2ace74a058e5d7b230246a8d62cec39fa2f213fe /sql
parenta91296aec675dda685e14e02a574a4ec7d4e2110 (diff)
*Fix DK presences and their improved versions - original patch by thenecromancer
*Port player to homebind if instance cannot be created in WorldSession::HandleMoveWorldportAckOpcode. --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/FULL/world_spell_full.sql3
-rw-r--r--sql/updates/4509_world_spell_linked_spell.sql1
2 files changed, 1 insertions, 3 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index c7391c34d35..adc11d4dc82 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -33,9 +33,6 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm
(-49011, 49009, 0, 'Wyvern Sting'),
(-49012, 49010, 0, 'Wyvern Sting'),
( 47585, 60069, 0, 'Dispersion (transform/regen)'),
-( 48265, 49772, 2, 'Unholy Presence'),
-( 49772, 55222, 2, 'Unholy Presence'),
-( 48263, 61261, 2, 'Frost Presence'),
( 61847, 61848, 2, 'Aspect of te dragonhawk'),
( 61846, 61848, 2, 'Aspect of te dragonhawk'),
( 47988, 54501, 2, 'Consume Shadows - Rank 9'),
diff --git a/sql/updates/4509_world_spell_linked_spell.sql b/sql/updates/4509_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..d672b2a564a
--- /dev/null
+++ b/sql/updates/4509_world_spell_linked_spell.sql
@@ -0,0 +1 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (48265, 49772, 48263);