Changeset 239 for trunk/sql

Show
Ignore:
Timestamp:
11/19/08 13:49:43 (17 years ago)
Author:
yumileroy
Message:

[svn] *Update Kalecgos script.
*Correctly select aura triggered spell target.
*Fix some scripts, should be pGOHello = &
*Fix a bug that some channel spells cannot be interrupted.
*Fix a bug that not-selectable creature cannot be hit by target_entry spells.
*If eventAI cannot find heroic flag and normal flag, enable event as default rather than disable it.

Original author: megamage
Date: 2008-11-15 15:09:22-06:00

Location:
trunk/sql/updates
Files:
1 added
2 modified

Legend:

Unmodified
Added
Removed
  • trunk/sql/updates/146_world.sql

    r178 r239  
    1717VALUES 
    1818   (-30410, 44032, 0, 'Manticron Cube Mind Exhaustion'); 
    19  
    20 INSERT INTO spell_linked_spell 
    21    (`spell_trigger`, `spell_effect`, `type`, `comment`) 
    22 VALUES 
    23    (-45934, 7, 0, 'Dark Fiend Suicide'); 
    2419 
    2520INSERT INTO spell_linked_spell 
  • trunk/sql/updates/147_world.sql

    r223 r239  
    1 DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (46648, 46019, 46021, -46021, 46020); 
    2 INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46648, 44866, 1, 'Spectral Blast'); 
    3 INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46019, 46021, 1, 'Teleport: Spectral Realm'); 
    4 INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46021, 44852, 1, 'Spectral Realm Aura'); 
    5 INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-46021, 46020, 0, 'Teleport: Normal Realm'); 
    6 INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46020, 44867, 1, 'Spectral Exhaustion'); 
    7  
    8 DELETE FROM spell_target_position WHERE `id` IN (46019, 46020); 
    9 INSERT INTO spell_target_position () VALUES (46019, 580, 1704.34, 928.17, -74.558, 0); 
    10 INSERT INTO spell_target_position () VALUES (46020, 580, 1704.34, 928.17, 53.079, 0); 
    11  
    121-- Magtheridon Earthquake 
    132DELETE FROM spell_script_target WHERE `entry` IN (30657);