diff options
Diffstat (limited to 'sql/old')
26 files changed, 252 insertions, 253 deletions
diff --git a/sql/old/2.4.3/00542_characters.sql b/sql/old/2.4.3/00542_characters.sql index 4cc3bebea80..f03c03f900f 100644 --- a/sql/old/2.4.3/00542_characters.sql +++ b/sql/old/2.4.3/00542_characters.sql @@ -22,7 +22,7 @@ SET WHERE `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; - + UPDATE `arena_team_member` AS `a`, (SELECT @@ -47,7 +47,7 @@ SET WHERE `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; - + UPDATE `arena_team_member` AS `a`, (SELECT diff --git a/sql/old/2.4.3/00762_world.sql b/sql/old/2.4.3/00762_world.sql index ce64e8c9065..ed7b2ab5241 100644 --- a/sql/old/2.4.3/00762_world.sql +++ b/sql/old/2.4.3/00762_world.sql @@ -1,6 +1,6 @@ DROP TABLE IF EXISTS `transport_events`; CREATE TABLE `transport_events` ( - `entry` int(11) unsigned NOT NULL default '0', - `waypoint_id` int(11) unsigned NOT NULL default '0', - `event_id` int(11) unsigned NOT NULL default '0' +`entry` int(11) unsigned NOT NULL default '0', +`waypoint_id` int(11) unsigned NOT NULL default '0', +`event_id` int(11) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/old/2.4.3/00764_world_scripts.sql b/sql/old/2.4.3/00764_world_scripts.sql index 52592cd8ad3..86e57979e41 100644 --- a/sql/old/2.4.3/00764_world_scripts.sql +++ b/sql/old/2.4.3/00764_world_scripts.sql @@ -118,6 +118,6 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'), (-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'), (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL'); - + UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055; UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056; diff --git a/sql/old/3.0.9/00000_3.0.9_old.sql b/sql/old/3.0.9/00000_3.0.9_old.sql index daa56fa6373..fa57faa3778 100644 --- a/sql/old/3.0.9/00000_3.0.9_old.sql +++ b/sql/old/3.0.9/00000_3.0.9_old.sql @@ -119,7 +119,7 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'), (-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'), (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL'); - + UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055; UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056; diff --git a/sql/old/3.0.9/03637_world_spell.sql b/sql/old/3.0.9/03637_world_spell.sql index c2fe66a5df1..97cfaf55e90 100644 --- a/sql/old/3.0.9/03637_world_spell.sql +++ b/sql/old/3.0.9/03637_world_spell.sql @@ -4,4 +4,4 @@ INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES DELETE FROM `spell_proc_event` WHERE `entry`=56816; INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(56816, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000030, 0, 0, 0); -- Rune Strike +(56816, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000030, 0, 0, 0); -- Rune Strike diff --git a/sql/old/3.0.9/03801_world_spell.sql b/sql/old/3.0.9/03801_world_spell.sql index 8fabcad1c58..4656c66f2aa 100644 --- a/sql/old/3.0.9/03801_world_spell.sql +++ b/sql/old/3.0.9/03801_world_spell.sql @@ -1,6 +1,6 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (44544, 60503, 36032); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(36032, 0x00, 3, 0x00000800, 0x00008000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Arcane Blast +(36032, 0x00, 3, 0x00000800, 0x00008000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Arcane Blast DELETE FROM `spell_affect` WHERE `entry` IN (44544); INSERT INTO `spell_affect` (`entry`, `effectId`, `SpellClassMask0`, `SpellClassMask1`, `SpellClassMask2`) VALUES diff --git a/sql/old/3.0.9/03899_world_spell_proc_event.sql b/sql/old/3.0.9/03899_world_spell_proc_event.sql index bc8b159bd9a..4dfa2e3011a 100644 --- a/sql/old/3.0.9/03899_world_spell_proc_event.sql +++ b/sql/old/3.0.9/03899_world_spell_proc_event.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (18096, 18073); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(18096, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Pyroclasm (Rank 1) -(18073, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Pyroclasm (Rank 2) +(18096, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Pyroclasm (Rank 1) +(18073, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Pyroclasm (Rank 2) diff --git a/sql/old/3.0.9/03903_world_spell_proc_event.sql b/sql/old/3.0.9/03903_world_spell_proc_event.sql index ab534ece0a8..e3e85dce1d9 100644 --- a/sql/old/3.0.9/03903_world_spell_proc_event.sql +++ b/sql/old/3.0.9/03903_world_spell_proc_event.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (56249); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(56249, 0x00, 5, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Felhunter +(56249, 0x00, 5, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Felhunter diff --git a/sql/old/3.0.9/805_world_scripts.sql b/sql/old/3.0.9/805_world_scripts.sql index be57e9c1574..cfeeea149f5 100644 --- a/sql/old/3.0.9/805_world_scripts.sql +++ b/sql/old/3.0.9/805_world_scripts.sql @@ -118,6 +118,6 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`, (-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'), (-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'), (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL'); - + UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055; UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056; diff --git a/sql/old/3.1.3/03920_characters_309-313_converter.sql b/sql/old/3.1.3/03920_characters_309-313_converter.sql index 1a711f3a027..c5aa5ee9b0e 100644 --- a/sql/old/3.1.3/03920_characters_309-313_converter.sql +++ b/sql/old/3.1.3/03920_characters_309-313_converter.sql @@ -30,34 +30,34 @@ CREATE TABLE `character_equipmentsets` ( UPDATE characters SET data = REPLACE(data,' ',' '); UPDATE characters SET data = CONCAT(TRIM(data),' '); UPDATE `characters` SET `data` = CONCAT( - SUBSTRING_INDEX(`data`, ' ', 257 + 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 1), ' ', -261 + 260 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18 + 1), ' ', -261 - 18 + 260 + 18 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*2 + 1), ' ', -261 - 18*2 + 260 + 18*2 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*3 + 1), ' ', -261 - 18*3 + 260 + 18*3 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*4 + 1), ' ', -261 - 18*4 + 260 + 18*4 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*5 + 1), ' ', -261 - 18*5 + 260 + 18*5 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*6 + 1), ' ', -261 - 18*6 + 260 + 18*6 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*7 + 1), ' ', -261 - 18*7 + 260 + 18*7 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*8 + 1), ' ', -261 - 18*8 + 260 + 18*8 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*9 + 1), ' ', -261 - 18*9 + 260 + 18*9 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*10 + 1), ' ', -261 - 18*10 + 260 + 18*10 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*11 + 1), ' ', -261 - 18*11 + 260 + 18*11 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*12 + 1), ' ', -261 - 18*12 + 260 + 18*12 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*13 + 1), ' ', -261 - 18*13 + 260 + 18*13 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*14 + 1), ' ', -261 - 18*14 + 260 + 18*14 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*15 + 1), ' ', -261 - 18*15 + 260 + 18*15 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*16 + 1), ' ', -261 - 18*16 + 260 + 18*16 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*17 + 1), ' ', -261 - 18*17 + 260 + 18*17 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*18 + 1), ' ', -261 - 18*18 + 260 + 18*18 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 837 + 1), ' ', -837 + 600 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 937 + 1), ' ', -937 + 874 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1007 + 1), ' ', -1007 + 1002 - 1), ' ', - '0 0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1688 + 1), ' ', -1688 + 1008 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1696 + 1), ' ', -1696 + 1691 - 1), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1700 + 1), ' ', -1700 + 1699 - 1), ' ' - ) + SUBSTRING_INDEX(`data`, ' ', 257 + 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 1), ' ', -261 + 260 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18 + 1), ' ', -261 - 18 + 260 + 18 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*2 + 1), ' ', -261 - 18*2 + 260 + 18*2 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*3 + 1), ' ', -261 - 18*3 + 260 + 18*3 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*4 + 1), ' ', -261 - 18*4 + 260 + 18*4 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*5 + 1), ' ', -261 - 18*5 + 260 + 18*5 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*6 + 1), ' ', -261 - 18*6 + 260 + 18*6 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*7 + 1), ' ', -261 - 18*7 + 260 + 18*7 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*8 + 1), ' ', -261 - 18*8 + 260 + 18*8 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*9 + 1), ' ', -261 - 18*9 + 260 + 18*9 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*10 + 1), ' ', -261 - 18*10 + 260 + 18*10 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*11 + 1), ' ', -261 - 18*11 + 260 + 18*11 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*12 + 1), ' ', -261 - 18*12 + 260 + 18*12 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*13 + 1), ' ', -261 - 18*13 + 260 + 18*13 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*14 + 1), ' ', -261 - 18*14 + 260 + 18*14 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*15 + 1), ' ', -261 - 18*15 + 260 + 18*15 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*16 + 1), ' ', -261 - 18*16 + 260 + 18*16 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*17 + 1), ' ', -261 - 18*17 + 260 + 18*17 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*18 + 1), ' ', -261 - 18*18 + 260 + 18*18 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 837 + 1), ' ', -837 + 600 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 937 + 1), ' ', -937 + 874 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1007 + 1), ' ', -1007 + 1002 - 1), ' ', + '0 0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1688 + 1), ' ', -1688 + 1008 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1696 + 1), ' ', -1696 + 1691 - 1), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1700 + 1), ' ', -1700 + 1699 - 1), ' ' + ) WHERE length(SUBSTRING_INDEX(data, ' ', 1700)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 1701)) >= length(data); UPDATE characters SET data = REPLACE(data,' ',' '); UPDATE characters SET data = CONCAT(TRIM(data),' '); diff --git a/sql/old/3.1.3/03927_world_spell_proc_event.sql b/sql/old/3.1.3/03927_world_spell_proc_event.sql index 526afb8c48c..cac8696c8de 100644 --- a/sql/old/3.1.3/03927_world_spell_proc_event.sql +++ b/sql/old/3.1.3/03927_world_spell_proc_event.sql @@ -1,5 +1,5 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (59088, 59089, 58388, 56374); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(59088, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection -(59089, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection -(56374, 0x00, 3, 0x00000000, 0x00004000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Glyph of icy veins +(59088, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection +(59089, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection +(56374, 0x00, 3, 0x00000000, 0x00004000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Glyph of icy veins diff --git a/sql/old/3.1.3/03943_world_spell_proc_event.sql b/sql/old/3.1.3/03943_world_spell_proc_event.sql index 7d4c96caefe..7c49aee9e22 100644 --- a/sql/old/3.1.3/03943_world_spell_proc_event.sql +++ b/sql/old/3.1.3/03943_world_spell_proc_event.sql @@ -1,6 +1,6 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (52610); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(52610, 0x00, 7, 0x80000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Savage roar +(52610, 0x00, 7, 0x80000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Savage roar DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (52610, -52610); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES diff --git a/sql/old/3.1.3/03947_world_spell_proc_event.sql b/sql/old/3.1.3/03947_world_spell_proc_event.sql index 6859fc95049..e2aa900ecb6 100644 --- a/sql/old/3.1.3/03947_world_spell_proc_event.sql +++ b/sql/old/3.1.3/03947_world_spell_proc_event.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53397); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(53397, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Invigoration +(53397, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Invigoration diff --git a/sql/old/3.1.3/03951_world_spell_proc_event.sql b/sql/old/3.1.3/03951_world_spell_proc_event.sql index ec0d9d960d7..bc0be3eb9d5 100644 --- a/sql/old/3.1.3/03951_world_spell_proc_event.sql +++ b/sql/old/3.1.3/03951_world_spell_proc_event.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53646); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(53646, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Demonic Pact +(53646, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Demonic Pact diff --git a/sql/old/3.1.3/03969_world_spell_proc_event.sql b/sql/old/3.1.3/03969_world_spell_proc_event.sql index bca25a6ebe0..e79367c5039 100644 --- a/sql/old/3.1.3/03969_world_spell_proc_event.sql +++ b/sql/old/3.1.3/03969_world_spell_proc_event.sql @@ -1,10 +1,10 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (35553, 35552, 35551, 35550, 35541); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(35553, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency -(35552, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency -(35551, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency -(35550, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency -(35541, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0); -- Combat Potency +(35553, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency +(35552, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency +(35551, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency +(35550, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency +(35541, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0); -- Combat Potency DELETE FROM `spell_proc_event` WHERE `entry` IN (20375, 50781, 51414, 54695, 54838, 54841, 55747, 57352, 58442, 58444, 58901, 59345, 60061, 60063, 60066, 60221, 60301, 60306, 60317, 60436, 60473, 60482, 60487, 60490, 60519, 60537, 38347, 34320, 33297, 38299, 59630, 61356); INSERT INTO `spell_proc_event`(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES diff --git a/sql/old/3.1.3/05177_characters.sql b/sql/old/3.1.3/05177_characters.sql index 6b8f85ac527..0e36a2c1841 100644 --- a/sql/old/3.1.3/05177_characters.sql +++ b/sql/old/3.1.3/05177_characters.sql @@ -1,8 +1,8 @@ ALTER TABLE `auctionhousebot` - CHANGE COLUMN `maxstackgrey` `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', - CHANGE COLUMN `maxstackwhite` `maxstackwhite` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', - CHANGE COLUMN `maxstackgreen` `maxstackgreen` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', - CHANGE COLUMN `maxstackblue` `maxstackblue` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', - CHANGE COLUMN `maxstackpurple` `maxstackpurple` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', - CHANGE COLUMN `maxstackorange` `maxstackorange` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', - CHANGE COLUMN `maxstackyellow` `maxstackyellow` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.'; + CHANGE COLUMN `maxstackgrey` `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', + CHANGE COLUMN `maxstackwhite` `maxstackwhite` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', + CHANGE COLUMN `maxstackgreen` `maxstackgreen` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', + CHANGE COLUMN `maxstackblue` `maxstackblue` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', + CHANGE COLUMN `maxstackpurple` `maxstackpurple` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', + CHANGE COLUMN `maxstackorange` `maxstackorange` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.', + CHANGE COLUMN `maxstackyellow` `maxstackyellow` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.'; diff --git a/sql/old/3.1.3/05410_world_spell_dbc.sql b/sql/old/3.1.3/05410_world_spell_dbc.sql index 31f648dcad4..5c5d34d4f1e 100644 --- a/sql/old/3.1.3/05410_world_spell_dbc.sql +++ b/sql/old/3.1.3/05410_world_spell_dbc.sql @@ -1,101 +1,101 @@ DROP TABLE IF EXISTS `spell_dbc`; CREATE TABLE `spell_dbc` ( - `Id` INT UNSIGNED NOT NULL, - `Dispel` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `Mechanic` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `Attributes` INT UNSIGNED NOT NULL DEFAULT 0, - `AttributesEx` INT UNSIGNED NOT NULL DEFAULT 0, - `AttributesEx2` INT UNSIGNED NOT NULL DEFAULT 0, - `AttributesEx3` INT UNSIGNED NOT NULL DEFAULT 0, - `AttributesEx4` INT UNSIGNED NOT NULL DEFAULT 0, - `AttributesEx5` INT UNSIGNED NOT NULL DEFAULT 0, - `Targets` INT UNSIGNED NOT NULL DEFAULT 0, - `CastingTimeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1, - `AuraInterruptFlags` INT UNSIGNED NOT NULL DEFAULT 0, - `ProcFlags` INT UNSIGNED NOT NULL DEFAULT 0, - `ProcChance` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `ProcCharges` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `MaxLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `BaseLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `SpellLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `DurationIndex` SMALLINT UNSIGNED NOT NULL DEFAULT 0, - `RangeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1, - `StackAmount` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EquippedItemClass` INT NOT NULL DEFAULT -1, - `EquippedItemSubClassMask` INT NOT NULL DEFAULT 0 DEFAULT 0, - `EquippedItemInventoryTypeMask` INT NOT NULL DEFAULT 0 DEFAULT 0, - `Effect1` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `Effect2` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `Effect3` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectDieSides1` INT NOT NULL DEFAULT 0, - `EffectDieSides2` INT NOT NULL DEFAULT 0, - `EffectDieSides3` INT NOT NULL DEFAULT 0, - `EffectBaseDice1` INT NOT NULL DEFAULT 0, - `EffectBaseDice2` INT NOT NULL DEFAULT 0, - `EffectBaseDice3` INT NOT NULL DEFAULT 0, - `EffectDicePerLevel1` FLOAT NOT NULL DEFAULT 0, - `EffectDicePerLevel2` FLOAT NOT NULL DEFAULT 0, - `EffectDicePerLevel3` FLOAT NOT NULL DEFAULT 0, - `EffectRealPointsPerLevel1` FLOAT NOT NULL DEFAULT 0, - `EffectRealPointsPerLevel2` FLOAT NOT NULL DEFAULT 0, - `EffectRealPointsPerLevel3` FLOAT NOT NULL DEFAULT 0, - `EffectBasePoints1` INT NOT NULL DEFAULT 0, - `EffectBasePoints2` INT NOT NULL DEFAULT 0, - `EffectBasePoints3` INT NOT NULL DEFAULT 0, - `EffectMechanic1` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectMechanic2` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectMechanic3` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectImplicitTargetA1` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectImplicitTargetA2` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectImplicitTargetA3` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectImplicitTargetB1` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectImplicitTargetB2` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectImplicitTargetB3` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectRadiusIndex1` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectRadiusIndex2` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectRadiusIndex3` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `EffectApplyAuraName1` SMALLINT UNSIGNED NOT NULL DEFAULT 0, - `EffectApplyAuraName2` SMALLINT UNSIGNED NOT NULL DEFAULT 0, - `EffectApplyAuraName3` SMALLINT UNSIGNED NOT NULL DEFAULT 0, - `EffectAmplitude1` INT NOT NULL DEFAULT 0, - `EffectAmplitude2` INT NOT NULL DEFAULT 0, - `EffectAmplitude3` INT NOT NULL DEFAULT 0, - `EffectMultipleValue1` FLOAT NOT NULL DEFAULT 0, - `EffectMultipleValue2` FLOAT NOT NULL DEFAULT 0, - `EffectMultipleValue3` FLOAT NOT NULL DEFAULT 0, - `EffectMiscValue1` INT NOT NULL DEFAULT 0, - `EffectMiscValue2` INT NOT NULL DEFAULT 0, - `EffectMiscValue3` INT NOT NULL DEFAULT 0, - `EffectMiscValueB1` INT NOT NULL DEFAULT 0, - `EffectMiscValueB2` INT NOT NULL DEFAULT 0, - `EffectMiscValueB3` INT NOT NULL DEFAULT 0, - `EffectTriggerSpell1` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectTriggerSpell2` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectTriggerSpell3` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskA1` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskA2` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskA3` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskB1` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskB2` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskB3` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskC1` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskC2` INT UNSIGNED NOT NULL DEFAULT 0, - `EffectSpellClassMaskC3` INT UNSIGNED NOT NULL DEFAULT 0, - `MaxTargetLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `SpellFamilyName` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `SpellFamilyFlags1` INT UNSIGNED NOT NULL DEFAULT 0, - `SpellFamilyFlags2` INT UNSIGNED NOT NULL DEFAULT 0, - `SpellFamilyFlags3` INT UNSIGNED NOT NULL DEFAULT 0, - `MaxAffectedTargets` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `DmgClass` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `PreventionType` TINYINT UNSIGNED NOT NULL DEFAULT 0, - `DmgMultiplier1` FLOAT NOT NULL DEFAULT 0, - `DmgMultiplier2` FLOAT NOT NULL DEFAULT 0, - `DmgMultiplier3` FLOAT NOT NULL DEFAULT 0, - `AreaGroupId` INT NOT NULL DEFAULT 0, - `SchoolMask` INT UNSIGNED NOT NULL DEFAULT 0, - `Comment` TEXT NOT NULL, - PRIMARY KEY (`id`) + `Id` INT UNSIGNED NOT NULL, + `Dispel` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `Mechanic` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `Attributes` INT UNSIGNED NOT NULL DEFAULT 0, + `AttributesEx` INT UNSIGNED NOT NULL DEFAULT 0, + `AttributesEx2` INT UNSIGNED NOT NULL DEFAULT 0, + `AttributesEx3` INT UNSIGNED NOT NULL DEFAULT 0, + `AttributesEx4` INT UNSIGNED NOT NULL DEFAULT 0, + `AttributesEx5` INT UNSIGNED NOT NULL DEFAULT 0, + `Targets` INT UNSIGNED NOT NULL DEFAULT 0, + `CastingTimeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1, + `AuraInterruptFlags` INT UNSIGNED NOT NULL DEFAULT 0, + `ProcFlags` INT UNSIGNED NOT NULL DEFAULT 0, + `ProcChance` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `ProcCharges` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `MaxLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `BaseLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `SpellLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `DurationIndex` SMALLINT UNSIGNED NOT NULL DEFAULT 0, + `RangeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1, + `StackAmount` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EquippedItemClass` INT NOT NULL DEFAULT -1, + `EquippedItemSubClassMask` INT NOT NULL DEFAULT 0 DEFAULT 0, + `EquippedItemInventoryTypeMask` INT NOT NULL DEFAULT 0 DEFAULT 0, + `Effect1` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `Effect2` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `Effect3` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectDieSides1` INT NOT NULL DEFAULT 0, + `EffectDieSides2` INT NOT NULL DEFAULT 0, + `EffectDieSides3` INT NOT NULL DEFAULT 0, + `EffectBaseDice1` INT NOT NULL DEFAULT 0, + `EffectBaseDice2` INT NOT NULL DEFAULT 0, + `EffectBaseDice3` INT NOT NULL DEFAULT 0, + `EffectDicePerLevel1` FLOAT NOT NULL DEFAULT 0, + `EffectDicePerLevel2` FLOAT NOT NULL DEFAULT 0, + `EffectDicePerLevel3` FLOAT NOT NULL DEFAULT 0, + `EffectRealPointsPerLevel1` FLOAT NOT NULL DEFAULT 0, + `EffectRealPointsPerLevel2` FLOAT NOT NULL DEFAULT 0, + `EffectRealPointsPerLevel3` FLOAT NOT NULL DEFAULT 0, + `EffectBasePoints1` INT NOT NULL DEFAULT 0, + `EffectBasePoints2` INT NOT NULL DEFAULT 0, + `EffectBasePoints3` INT NOT NULL DEFAULT 0, + `EffectMechanic1` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectMechanic2` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectMechanic3` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectImplicitTargetA1` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectImplicitTargetA2` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectImplicitTargetA3` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectImplicitTargetB1` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectImplicitTargetB2` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectImplicitTargetB3` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectRadiusIndex1` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectRadiusIndex2` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectRadiusIndex3` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `EffectApplyAuraName1` SMALLINT UNSIGNED NOT NULL DEFAULT 0, + `EffectApplyAuraName2` SMALLINT UNSIGNED NOT NULL DEFAULT 0, + `EffectApplyAuraName3` SMALLINT UNSIGNED NOT NULL DEFAULT 0, + `EffectAmplitude1` INT NOT NULL DEFAULT 0, + `EffectAmplitude2` INT NOT NULL DEFAULT 0, + `EffectAmplitude3` INT NOT NULL DEFAULT 0, + `EffectMultipleValue1` FLOAT NOT NULL DEFAULT 0, + `EffectMultipleValue2` FLOAT NOT NULL DEFAULT 0, + `EffectMultipleValue3` FLOAT NOT NULL DEFAULT 0, + `EffectMiscValue1` INT NOT NULL DEFAULT 0, + `EffectMiscValue2` INT NOT NULL DEFAULT 0, + `EffectMiscValue3` INT NOT NULL DEFAULT 0, + `EffectMiscValueB1` INT NOT NULL DEFAULT 0, + `EffectMiscValueB2` INT NOT NULL DEFAULT 0, + `EffectMiscValueB3` INT NOT NULL DEFAULT 0, + `EffectTriggerSpell1` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectTriggerSpell2` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectTriggerSpell3` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskA1` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskA2` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskA3` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskB1` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskB2` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskB3` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskC1` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskC2` INT UNSIGNED NOT NULL DEFAULT 0, + `EffectSpellClassMaskC3` INT UNSIGNED NOT NULL DEFAULT 0, + `MaxTargetLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `SpellFamilyName` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `SpellFamilyFlags1` INT UNSIGNED NOT NULL DEFAULT 0, + `SpellFamilyFlags2` INT UNSIGNED NOT NULL DEFAULT 0, + `SpellFamilyFlags3` INT UNSIGNED NOT NULL DEFAULT 0, + `MaxAffectedTargets` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `DmgClass` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `PreventionType` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `DmgMultiplier1` FLOAT NOT NULL DEFAULT 0, + `DmgMultiplier2` FLOAT NOT NULL DEFAULT 0, + `DmgMultiplier3` FLOAT NOT NULL DEFAULT 0, + `AreaGroupId` INT NOT NULL DEFAULT 0, + `SchoolMask` INT UNSIGNED NOT NULL DEFAULT 0, + `Comment` TEXT NOT NULL, + PRIMARY KEY (`id`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries'; INSERT INTO `spell_dbc` (`Id`, `DurationIndex`, `Effect1`, `EffectImplicitTargetA1`, `EffectApplyAuraName1`, `Comment`) VALUES (62388, 21, 6, 1, 4, 'Demonic Circle: Teleport(48020) - casterAuraSpell'); diff --git a/sql/old/3.2.2a/06932_characters_character_aura.sql b/sql/old/3.2.2a/06932_characters_character_aura.sql index 9cf36f0143c..0629d89ffa8 100644 --- a/sql/old/3.2.2a/06932_characters_character_aura.sql +++ b/sql/old/3.2.2a/06932_characters_character_aura.sql @@ -1,5 +1,5 @@ ALTER TABLE `character_aura` - ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`, - ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`, - ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`, - ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`; + ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`, + ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`, + ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`, + ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`; diff --git a/sql/old/3.2.2a/06932_characters_pet_aura.sql b/sql/old/3.2.2a/06932_characters_pet_aura.sql index fe386e7a85b..90df4e858c9 100644 --- a/sql/old/3.2.2a/06932_characters_pet_aura.sql +++ b/sql/old/3.2.2a/06932_characters_pet_aura.sql @@ -1,5 +1,5 @@ ALTER TABLE `pet_aura` DROP PRIMARY KEY, - ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`, - ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`, - ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`, - ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`; + ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`, + ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`, + ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`, + ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`; diff --git a/sql/old/3.3.2/07332_characters_characters.sql b/sql/old/3.3.2/07332_characters_characters.sql index 6db1a7d0946..8c21a623b8a 100644 --- a/sql/old/3.3.2/07332_characters_characters.sql +++ b/sql/old/3.3.2/07332_characters_characters.sql @@ -1,60 +1,60 @@ UPDATE characters SET data = REPLACE(data,' ',' '); UPDATE characters SET data = CONCAT(TRIM(data),' '); UPDATE `characters` SET `data` = CONCAT( - SUBSTRING_INDEX(`data`, ' ', 161 + 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 1), ' ', -165 + 162 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4 + 1), ' ', -165 - 4 + 162 + 4 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*2 + 1), ' ', -165 - 4*2 + 162 + 4*2 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*3 + 1), ' ', -165 - 4*3 + 162 + 4*3 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*4 + 1), ' ', -165 - 4*4 + 162 + 4*4 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*5 + 1), ' ', -165 - 4*5 + 162 + 4*5 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*6 + 1), ' ', -165 - 4*6 + 162 + 4*6 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*7 + 1), ' ', -165 - 4*7 + 162 + 4*7 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*8 + 1), ' ', -165 - 4*8 + 162 + 4*8 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*9 + 1), ' ', -165 - 4*9 + 162 + 4*9 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*10 + 1), ' ', -165 - 4*10 + 162 + 4*10 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*11 + 1), ' ', -165 - 4*11 + 162 + 4*11 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*12 + 1), ' ', -165 - 4*12 + 162 + 4*12 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*13 + 1), ' ', -165 - 4*13 + 162 + 4*13 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*14 + 1), ' ', -165 - 4*14 + 162 + 4*14 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*15 + 1), ' ', -165 - 4*15 + 162 + 4*15 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*16 + 1), ' ', -165 - 4*16 + 162 + 4*16 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*17 + 1), ' ', -165 - 4*17 + 162 + 4*17 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*18 + 1), ' ', -165 - 4*18 + 162 + 4*18 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*19 + 1), ' ', -165 - 4*19 + 162 + 4*19 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*20 + 1), ' ', -165 - 4*20 + 162 + 4*20 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*21 + 1), ' ', -165 - 4*21 + 162 + 4*21 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*22 + 1), ' ', -165 - 4*22 + 162 + 4*22 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*23 + 1), ' ', -165 - 4*23 + 162 + 4*23 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 298 + 1), ' ', -298 + 162 + 4*24 - 1), ' ', - '0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1300 + 1), ' ', -1300 + 299 - 1), ' ' - ) + SUBSTRING_INDEX(`data`, ' ', 161 + 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 1), ' ', -165 + 162 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4 + 1), ' ', -165 - 4 + 162 + 4 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*2 + 1), ' ', -165 - 4*2 + 162 + 4*2 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*3 + 1), ' ', -165 - 4*3 + 162 + 4*3 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*4 + 1), ' ', -165 - 4*4 + 162 + 4*4 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*5 + 1), ' ', -165 - 4*5 + 162 + 4*5 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*6 + 1), ' ', -165 - 4*6 + 162 + 4*6 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*7 + 1), ' ', -165 - 4*7 + 162 + 4*7 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*8 + 1), ' ', -165 - 4*8 + 162 + 4*8 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*9 + 1), ' ', -165 - 4*9 + 162 + 4*9 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*10 + 1), ' ', -165 - 4*10 + 162 + 4*10 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*11 + 1), ' ', -165 - 4*11 + 162 + 4*11 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*12 + 1), ' ', -165 - 4*12 + 162 + 4*12 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*13 + 1), ' ', -165 - 4*13 + 162 + 4*13 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*14 + 1), ' ', -165 - 4*14 + 162 + 4*14 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*15 + 1), ' ', -165 - 4*15 + 162 + 4*15 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*16 + 1), ' ', -165 - 4*16 + 162 + 4*16 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*17 + 1), ' ', -165 - 4*17 + 162 + 4*17 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*18 + 1), ' ', -165 - 4*18 + 162 + 4*18 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*19 + 1), ' ', -165 - 4*19 + 162 + 4*19 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*20 + 1), ' ', -165 - 4*20 + 162 + 4*20 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*21 + 1), ' ', -165 - 4*21 + 162 + 4*21 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*22 + 1), ' ', -165 - 4*22 + 162 + 4*22 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*23 + 1), ' ', -165 - 4*23 + 162 + 4*23 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 298 + 1), ' ', -298 + 162 + 4*24 - 1), ' ', + '0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1300 + 1), ' ', -1300 + 299 - 1), ' ' + ) WHERE length(SUBSTRING_INDEX(data, ' ', 1300)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 1300+1)) >= length(data); UPDATE characters SET data = REPLACE(data,' ',' '); UPDATE characters SET data = CONCAT(TRIM(data),' '); diff --git a/sql/old/3.3.3a/07893_characters_item_instance.sql b/sql/old/3.3.3a/07893_characters_item_instance.sql index 3dea7f98e27..9eeef845f40 100644 --- a/sql/old/3.3.3a/07893_characters_item_instance.sql +++ b/sql/old/3.3.3a/07893_characters_item_instance.sql @@ -2,8 +2,8 @@ UPDATE item_instance SET data = REPLACE(data,' ',' '); UPDATE item_instance SET data = CONCAT(TRIM(data),' '); UPDATE `item_instance` SET `data` = CONCAT( - SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ', - SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ') + SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ', + SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ') WHERE length(SUBSTRING_INDEX(data, ' ', 64)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 64+1)) >= length(data); UPDATE item_instance SET data = REPLACE(data,' ',' '); diff --git a/sql/old/3.3.3a/07923_characters_characters.sql b/sql/old/3.3.3a/07923_characters_characters.sql index a9fe4880731..b871727a490 100644 --- a/sql/old/3.3.3a/07923_characters_characters.sql +++ b/sql/old/3.3.3a/07923_characters_characters.sql @@ -1,2 +1 @@ -ALTER TABLE characters - ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER knownTitles; +ALTER TABLE `characters` ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER `knownTitles`; diff --git a/sql/old/3.3.5a/09560_world_spell_proc_event.sql b/sql/old/3.3.5a/09560_world_spell_proc_event.sql index 07779e9e50d..cc9ca570d4f 100644 --- a/sql/old/3.3.5a/09560_world_spell_proc_event.sql +++ b/sql/old/3.3.5a/09560_world_spell_proc_event.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry`=70854; INSERT INTO `spell_proc_event` VALUES -( 70854, 0x00, 4, 0x00000000, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Warrior T10 Melee 2P Bonus
\ No newline at end of file +(70854, 0x00, 4, 0x00000000, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Warrior T10 Melee 2P Bonus diff --git a/sql/old/3.3.5a/09712_world_spell_threat.sql b/sql/old/3.3.5a/09712_world_spell_threat.sql index b66444ee913..06c5892fb40 100644 --- a/sql/old/3.3.5a/09712_world_spell_threat.sql +++ b/sql/old/3.3.5a/09712_world_spell_threat.sql @@ -1,14 +1,14 @@ -- Battle Shout DELETE FROM `spell_threat` WHERE `entry` IN (6673,5242,6192,11549,11550,11551,2048,47436); INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES -(6673,1), -- Rank 1 -(5242,12), -- Rank 2 -(6192,22), -- Rank 3 -(11549,32), -- Rank 4 -(11550,42), -- Rank 5 -(11551,52), -- Rank 6 , Rank 7 already in tdb -(2048,69), -- Rank 8 -(47436,78); -- Rank 9 +(6673,1), -- Rank 1 +(5242,12), -- Rank 2 +(6192,22), -- Rank 3 +(11549,32), -- Rank 4 +(11550,42), -- Rank 5 +(11551,52), -- Rank 6 , Rank 7 already in tdb +(2048,69), -- Rank 8 +(47436,78); -- Rank 9 -- Cleave DELETE FROM `spell_threat` WHERE `entry` IN (47519,47520); @@ -19,9 +19,9 @@ INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES -- Commanding Shout DELETE FROM `spell_threat` WHERE `entry` IN (469,47439,47440); INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES -(469,68), -- Rank 1 -(47439,77), -- Rank 2 -(47440,80); -- Rank 3 +(469,68), -- Rank 1 +(47439,77), -- Rank 2 +(47440,80); -- Rank 3 -- Demoralizing Shout DELETE FROM `spell_threat` WHERE `entry` IN (25202,25203,47437); diff --git a/sql/old/3.3.5a/2011_02_05_00_world_sai.sql b/sql/old/3.3.5a/2011_02_05_00_world_sai.sql index f68f044e2f1..3a5291b6e94 100644 --- a/sql/old/3.3.5a/2011_02_05_00_world_sai.sql +++ b/sql/old/3.3.5a/2011_02_05_00_world_sai.sql @@ -82,7 +82,7 @@ INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@GUID+0,(@GUID+0)*10), (@GUID+1,(@GUID+1)*10); DELETE FROM `waypoint_data` WHERE `id` IN ((@GUID+0)*10,(@GUID+1)*10); -INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES ((@GUID+0)*10,00,5865.73,561.7454,656.3502), ((@GUID+0)*10,01,5864.76,561.5035,656.3502), ((@GUID+0)*10,02,5865.858,545.6048,657.8221), diff --git a/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql b/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql index 4356a82443f..a2d3d5d44a0 100644 --- a/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql +++ b/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql @@ -1,23 +1,23 @@ /* -1 0x0000 0001 MECHANIC_CHARM -2 0x0000 0002 MECHANIC_DISORIENTED -16 0x0000 0010 MECHANIC_FEAR -32 0x0000 0020 MECHANIC_GRIP -64 0x0000 0040 MECHANIC_ROOT -128 0x0000 0080 MECHANIC_PACIFY (0 spells use this mechanic) -256 0x0000 0100 MECHANIC_SILENCE -512 0x0000 0200 MECHANIC_SLEEP -1024 0x0000 0400 MECHANIC_SNARE -2048 0x0000 0800 MECHANIC_STUN -4096 0x0000 1000 MECHANIC_FREEZE -8192 0x0000 2000 MECHANIC_KNOCKOUT -65536 0x0001 0000 MECHANIC_POLYMORPH -131072 0x0002 0000 MECHANIC_BANISH -524288 0x0008 0000 MECHANIC_SHACKLE -4194304 0x0040 0000 MECHANIC_TURN -8388608 0x0080 0000 MECHANIC_HORROR -67108864 0x0400 0000 MECHANIC_DAZE -536870912 0x2000 0000 MECHANIC_SAPPED +1 0x0000 0001 MECHANIC_CHARM +2 0x0000 0002 MECHANIC_DISORIENTED +16 0x0000 0010 MECHANIC_FEAR +32 0x0000 0020 MECHANIC_GRIP +64 0x0000 0040 MECHANIC_ROOT +128 0x0000 0080 MECHANIC_PACIFY (0 spells use this mechanic) +256 0x0000 0100 MECHANIC_SILENCE +512 0x0000 0200 MECHANIC_SLEEP +1024 0x0000 0400 MECHANIC_SNARE +2048 0x0000 0800 MECHANIC_STUN +4096 0x0000 1000 MECHANIC_FREEZE +8192 0x0000 2000 MECHANIC_KNOCKOUT +65536 0x0001 0000 MECHANIC_POLYMORPH +131072 0x0002 0000 MECHANIC_BANISH +524288 0x0008 0000 MECHANIC_SHACKLE +4194304 0x0040 0000 MECHANIC_TURN +8388608 0x0080 0000 MECHANIC_HORROR +67108864 0x0400 0000 MECHANIC_DAZE +536870912 0x2000 0000 MECHANIC_SAPPED */ -- Update Frozen Halls Immunities UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|1|2|16|32|64|128|256|512|1024|2048|4096|8192|65536|131072|524288|4194304|8388608|67108864|536870912 WHERE `entry` IN ( |