From 89fe89e41eaec04031a55acf9009cbdc4ae34527 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 6 May 2011 22:20:08 +0200 Subject: SQL: Corrected file naming --- sql/updates/world/2011_05_05_01_spell_proc_event.sql | 1 - sql/updates/world/2011_05_05_01_world_spell_proc_event.sql | 1 + sql/updates/world/2011_05_06_00_spell_proc_event.sql | 3 --- sql/updates/world/2011_05_06_00_world_spell_proc_event.sql | 3 +++ sql/updates/world/2011_05_06_01_spell_proc_event.sql | 3 --- sql/updates/world/2011_05_06_01_world_spell_proc_event.sql | 3 +++ sql/updates/world/2011_05_06_02_spell_proc_event.sql | 5 ----- sql/updates/world/2011_05_06_02_world_spell_proc_event.sql | 5 +++++ sql/updates/world/2011_05_06_03_spell_bonus_data.sql | 5 ----- sql/updates/world/2011_05_06_03_world_spell_bonus_data.sql | 5 +++++ sql/updates/world/2011_05_06_04_spell_bonus_data.sql | 4 ---- sql/updates/world/2011_05_06_04_world_spell_bonus_data.sql | 4 ++++ 12 files changed, 21 insertions(+), 21 deletions(-) delete mode 100644 sql/updates/world/2011_05_05_01_spell_proc_event.sql create mode 100644 sql/updates/world/2011_05_05_01_world_spell_proc_event.sql delete mode 100644 sql/updates/world/2011_05_06_00_spell_proc_event.sql create mode 100644 sql/updates/world/2011_05_06_00_world_spell_proc_event.sql delete mode 100644 sql/updates/world/2011_05_06_01_spell_proc_event.sql create mode 100644 sql/updates/world/2011_05_06_01_world_spell_proc_event.sql delete mode 100644 sql/updates/world/2011_05_06_02_spell_proc_event.sql create mode 100644 sql/updates/world/2011_05_06_02_world_spell_proc_event.sql delete mode 100644 sql/updates/world/2011_05_06_03_spell_bonus_data.sql create mode 100644 sql/updates/world/2011_05_06_03_world_spell_bonus_data.sql delete mode 100644 sql/updates/world/2011_05_06_04_spell_bonus_data.sql create mode 100644 sql/updates/world/2011_05_06_04_world_spell_bonus_data.sql (limited to 'sql') diff --git a/sql/updates/world/2011_05_05_01_spell_proc_event.sql b/sql/updates/world/2011_05_05_01_spell_proc_event.sql deleted file mode 100644 index 6c5db5d3663..00000000000 --- a/sql/updates/world/2011_05_05_01_spell_proc_event.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `spell_proc_event` SET `procFlags`=0x00010000 WHERE `entry` IN (71602, 71645); diff --git a/sql/updates/world/2011_05_05_01_world_spell_proc_event.sql b/sql/updates/world/2011_05_05_01_world_spell_proc_event.sql new file mode 100644 index 00000000000..b7dff58a7bc --- /dev/null +++ b/sql/updates/world/2011_05_05_01_world_spell_proc_event.sql @@ -0,0 +1 @@ +UPDATE `spell_proc_event` SET `procFlags`=0x00010000 WHERE `entry` IN (71602,71645); diff --git a/sql/updates/world/2011_05_06_00_spell_proc_event.sql b/sql/updates/world/2011_05_06_00_spell_proc_event.sql deleted file mode 100644 index d08e3df9c55..00000000000 --- a/sql/updates/world/2011_05_06_00_spell_proc_event.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` = 70844; -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(70844, 0, 4, 256, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2011_05_06_00_world_spell_proc_event.sql b/sql/updates/world/2011_05_06_00_world_spell_proc_event.sql new file mode 100644 index 00000000000..306ee5168b3 --- /dev/null +++ b/sql/updates/world/2011_05_06_00_world_spell_proc_event.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry` = 70844; +INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES +(70844,0,4,256,0,0,0,0,0,0,0); diff --git a/sql/updates/world/2011_05_06_01_spell_proc_event.sql b/sql/updates/world/2011_05_06_01_spell_proc_event.sql deleted file mode 100644 index 511d184c178..00000000000 --- a/sql/updates/world/2011_05_06_01_spell_proc_event.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry`=67115; -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(67115,0x00,15,0x01400000,0x00000000,0x00000000,0x00000000,0x00000000,0,0,45); -- Item - Death Knight T9 Melee 2P Bonus diff --git a/sql/updates/world/2011_05_06_01_world_spell_proc_event.sql b/sql/updates/world/2011_05_06_01_world_spell_proc_event.sql new file mode 100644 index 00000000000..511d184c178 --- /dev/null +++ b/sql/updates/world/2011_05_06_01_world_spell_proc_event.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=67115; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(67115,0x00,15,0x01400000,0x00000000,0x00000000,0x00000000,0x00000000,0,0,45); -- Item - Death Knight T9 Melee 2P Bonus diff --git a/sql/updates/world/2011_05_06_02_spell_proc_event.sql b/sql/updates/world/2011_05_06_02_spell_proc_event.sql deleted file mode 100644 index 7cdf1d264e5..00000000000 --- a/sql/updates/world/2011_05_06_02_spell_proc_event.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Proc event for item spells -DELETE FROM `spell_proc_event` WHERE `entry` IN (67712,67758); -INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES -(67712,0,0,0,0,0,0x00011000,0x0000002,0,0,2), -(67758,0,0,0,0,0,0x00011000,0x0000002,0,0,2); diff --git a/sql/updates/world/2011_05_06_02_world_spell_proc_event.sql b/sql/updates/world/2011_05_06_02_world_spell_proc_event.sql new file mode 100644 index 00000000000..7cdf1d264e5 --- /dev/null +++ b/sql/updates/world/2011_05_06_02_world_spell_proc_event.sql @@ -0,0 +1,5 @@ +-- Proc event for item spells +DELETE FROM `spell_proc_event` WHERE `entry` IN (67712,67758); +INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES +(67712,0,0,0,0,0,0x00011000,0x0000002,0,0,2), +(67758,0,0,0,0,0,0x00011000,0x0000002,0,0,2); diff --git a/sql/updates/world/2011_05_06_03_spell_bonus_data.sql b/sql/updates/world/2011_05_06_03_spell_bonus_data.sql deleted file mode 100644 index 98779bb87f5..00000000000 --- a/sql/updates/world/2011_05_06_03_spell_bonus_data.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Procced spell Pillar of Flame should not scale with spellpower -DELETE FROM `spell_bonus_data` WHERE `entry` IN (67760,67714); -INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES -(67760,0,0,0,0, 'Item - Coliseum 25 Heroic Caster Trinket - Pillar of Flame'), -(67714,0,0,0,0, 'Item - Coliseum 25 Normal Caster Trinket - Pillar of Flame'); \ No newline at end of file diff --git a/sql/updates/world/2011_05_06_03_world_spell_bonus_data.sql b/sql/updates/world/2011_05_06_03_world_spell_bonus_data.sql new file mode 100644 index 00000000000..6edb5d8c305 --- /dev/null +++ b/sql/updates/world/2011_05_06_03_world_spell_bonus_data.sql @@ -0,0 +1,5 @@ +-- Procced spell Pillar of Flame should not scale with spellpower +DELETE FROM `spell_bonus_data` WHERE `entry` IN (67760,67714); +INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES +(67760,0,0,0,0, 'Item - Coliseum 25 Heroic Caster Trinket - Pillar of Flame'), +(67714,0,0,0,0, 'Item - Coliseum 25 Normal Caster Trinket - Pillar of Flame'); diff --git a/sql/updates/world/2011_05_06_04_spell_bonus_data.sql b/sql/updates/world/2011_05_06_04_spell_bonus_data.sql deleted file mode 100644 index 1ab23c0e8bd..00000000000 --- a/sql/updates/world/2011_05_06_04_spell_bonus_data.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Siphon Essence should not scale with spellpower -DELETE FROM `spell_bonus_data` WHERE `entry`=38395; -INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES -(38395,0,0,0,0, 'Warlock - Siphon Essence T6 2P proc'); diff --git a/sql/updates/world/2011_05_06_04_world_spell_bonus_data.sql b/sql/updates/world/2011_05_06_04_world_spell_bonus_data.sql new file mode 100644 index 00000000000..1ab23c0e8bd --- /dev/null +++ b/sql/updates/world/2011_05_06_04_world_spell_bonus_data.sql @@ -0,0 +1,4 @@ +-- Siphon Essence should not scale with spellpower +DELETE FROM `spell_bonus_data` WHERE `entry`=38395; +INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES +(38395,0,0,0,0, 'Warlock - Siphon Essence T6 2P proc'); -- cgit v1.2.3