diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_07_18_00_world_conditions.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2013_07_18_01_world_koralon.sql | 15 |
2 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/2013_07_18_00_world_conditions.sql b/sql/updates/world/2013_07_18_00_world_conditions.sql new file mode 100644 index 00000000000..90a16d32fb3 --- /dev/null +++ b/sql/updates/world/2013_07_18_00_world_conditions.sql @@ -0,0 +1,2 @@ +-- Fix There's Something About the Squire +UPDATE `conditions` SET `ConditionTarget`=1 WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=63126 AND `ConditionTypeOrReference`=9; diff --git a/sql/updates/world/2013_07_18_01_world_koralon.sql b/sql/updates/world/2013_07_18_01_world_koralon.sql new file mode 100644 index 00000000000..a67df5222ca --- /dev/null +++ b/sql/updates/world/2013_07_18_01_world_koralon.sql @@ -0,0 +1,15 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (66725,68161,66808,68160,66765,67333,66809,67331); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(66725, 'spell_koralon_meteor_fists'), +(68161, 'spell_koralon_meteor_fists'), +(66808, 'spell_flame_warder_meteor_fists'), +(68160, 'spell_flame_warder_meteor_fists'), +(66765, 'spell_koralon_meteor_fists_damage'), +(67333, 'spell_koralon_meteor_fists_damage'), +(66809, 'spell_koralon_meteor_fists_damage'), +(67331, 'spell_koralon_meteor_fists_damage'); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (66808,68160); +INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES +(66808,0,0,0,0,0,0x4,0,0,0,0), +(68160,0,0,0,0,0,0x4,0,0,0,0); |