diff options
35 files changed, 37 insertions, 50 deletions
diff --git a/sql/updates/4346_8098_characters.sql b/sql/updates/4346_8098_characters.sql index 897b2f7a34d..3329601679c 100644 --- a/sql/updates/4346_8098_characters.sql +++ b/sql/updates/4346_8098_characters.sql @@ -1,4 +1,4 @@ --- ALTER TABLE character_db_version CHANGE COLUMN required_8072_02_characters_characters required_8098_01_characters_character_action bit; +/*ALTER TABLE character_db_version CHANGE COLUMN required_8072_02_characters_characters required_8098_01_characters_character_action bit;*/ ALTER TABLE character_action CHANGE COLUMN action action int(11) unsigned NOT NULL default '0'; @@ -24,4 +24,4 @@ UPDATE character_pet UPDATE pet_spell - SET active = ( active >> 8); + SET active = ( active >> 8);
\ No newline at end of file diff --git a/sql/updates/4346_8098_world.sql b/sql/updates/4346_8098_world.sql index ad81835b433..9f9241c8fc5 100644 --- a/sql/updates/4346_8098_world.sql +++ b/sql/updates/4346_8098_world.sql @@ -7,4 +7,4 @@ UPDATE playercreateinfo_action SET action = action | ( misc << 16 ); ALTER TABLE playercreateinfo_action - DROP COLUMN misc; + DROP COLUMN misc;
\ No newline at end of file diff --git a/sql/updates/4351_8104_01_characters.sql b/sql/updates/4351_8104_01_characters.sql index 070a48a2e2a..63cb8a7161b 100644 --- a/sql/updates/4351_8104_01_characters.sql +++ b/sql/updates/4351_8104_01_characters.sql @@ -4,5 +4,4 @@ ALTER TABLE character_achievement ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE character_achievement_progress ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE character_declinedname ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; ALTER TABLE character_pet_declinedname ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -ALTER TABLE guild_eventlog ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog'; - +ALTER TABLE guild_eventlog ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog';
\ No newline at end of file diff --git a/sql/updates/4356_world_spell_proc_event.sql b/sql/updates/4356_world_spell_proc_event.sql index 4eae8e5041b..5d0dd11ce1f 100644 --- a/sql/updates/4356_world_spell_proc_event.sql +++ b/sql/updates/4356_world_spell_proc_event.sql @@ -22,5 +22,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell (51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0), ( 56372, 0x00, 3, 0x00000000, 0x00000080, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Glyph of Ice Block ( 56374, 0x00, 3, 0x00000000, 0x00004000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Glyph of Icy Veins -( 61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 90); -- Invigorating Earthsiege Diamond Passive -
\ No newline at end of file +( 61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 90); -- Invigorating Earthsiege Diamond Passive
\ No newline at end of file diff --git a/sql/updates/4360_world_spell_proc_event.sql b/sql/updates/4360_world_spell_proc_event.sql index 821a9b78127..bd9169a796e 100644 --- a/sql/updates/4360_world_spell_proc_event.sql +++ b/sql/updates/4360_world_spell_proc_event.sql @@ -1,6 +1,4 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (65013, 46949, 46945, 64415, 60066, 62115, 62114, 62600, 63245, 18096, 18073, 63280 -, 63310, 63320, 63335, 63730, 63733, 63737, 63737, 64127, 64129, 64568, 64571, 64440, 64714, 64738, 64742, 64752, 64786, 64792 -, 64824, 64860, 64867, 64882, 64890, 64908, 64912, 64914, 64928, 64938, 64952, 64964, 65002, 65005, 64999, 65007, 65013, 65020, 65025); +DELETE FROM `spell_proc_event` WHERE `entry` IN (65013, 46949, 46945, 64415, 60066, 62115, 62114, 62600, 63245, 18096, 18073, 63280, 63310, 63320, 63335, 63730, 63733, 63737, 63737, 64127, 64129, 64568, 64571, 64440, 64714, 64738, 64742, 64752, 64786, 64792, 64824, 64860, 64867, 64882, 64890, 64908, 64912, 64914, 64928, 64938, 64952, 64964, 65002, 65005, 64999, 65007, 65013, 65020, 65025); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 64914, 0x00, 8, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Rogue T8 2P Bonus ( 64928, 0x00, 11, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Item - Shaman T8 Elemental 4P Bonus @@ -48,4 +46,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 64882, 0x00, 10, 0x00000000, 0x00100000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Paladin T8 Protection 4P Bonus ( 64890, 0x00, 10, 0x00000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Item - Paladin T8 Holy 2P Bonus ( 64908, 0x00, 6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Priest T8 Shadow 4P Bonus -( 64912, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Priest T8 Healer 4P Bonus +( 64912, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Priest T8 Healer 4P Bonus
\ No newline at end of file diff --git a/sql/updates/4363_world_trinity_string.sql b/sql/updates/4363_world_trinity_string.sql index 949b337f589..78fc7d9da7e 100644 --- a/sql/updates/4363_world_trinity_string.sql +++ b/sql/updates/4363_world_trinity_string.sql @@ -1 +1 @@ -UPDATE `trinity_string` SET `content_default` = 'Player%s %s (guid: %u) Account: %s (id: %u) Email: %s GMLevel: %u Last IP: %s Last login: %s Latency: %ums' WHERE `entry` = 548; +UPDATE `trinity_string` SET `content_default` = 'Player%s %s (guid: %u) Account: %s (id: %u) Email: %s GMLevel: %u Last IP: %s Last login: %s Latency: %ums' WHERE `entry` = 548;
\ No newline at end of file diff --git a/sql/updates/4367_world_spell_proc_event.sql b/sql/updates/4367_world_spell_proc_event.sql index 5eeacab4de3..cb9e517c721 100644 --- a/sql/updates/4367_world_spell_proc_event.sql +++ b/sql/updates/4367_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (51483, 51485, 51486); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES (51483, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0), (51485, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0), -(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0); +(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000001, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/4377_world_spell_proc_event.sql b/sql/updates/4377_world_spell_proc_event.sql index bc006708b82..74e18131370 100644 --- a/sql/updates/4377_world_spell_proc_event.sql +++ b/sql/updates/4377_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53709, 53710, 53711); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES (53709, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0), (53710, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0), -(53711, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0); +(53711, 2, 10, 16384, 0, 0, 0, 0, 0, 0, 0);
\ No newline at end of file diff --git a/sql/updates/4382_8115_world_playercreateinfo_action.sql b/sql/updates/4382_8115_world_playercreateinfo_action.sql index 1af313a0626..5f52a46d240 100644 --- a/sql/updates/4382_8115_world_playercreateinfo_action.sql +++ b/sql/updates/4382_8115_world_playercreateinfo_action.sql @@ -355,4 +355,4 @@ INSERT INTO `playercreateinfo_action` VALUES (11,8,3,59548,0), (11,8,10,159,128), (11,8,11,4540,128), -(11,8,83,4540,128); +(11,8,83,4540,128);
\ No newline at end of file diff --git a/sql/updates/4393_world_spell_proc_event.sql b/sql/updates/4393_world_spell_proc_event.sql index 9d2fb7d776a..16c54e63ef7 100644 --- a/sql/updates/4393_world_spell_proc_event.sql +++ b/sql/updates/4393_world_spell_proc_event.sql @@ -5,4 +5,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 35100, 0x00, 9, 0x00001000, 0x00000000, 0x00000001, 0x00000000, 0x00000000, 0, 0, 0), -- Concussive Barrage ( 35102, 0x00, 9, 0x00001000, 0x00000000, 0x00000001, 0x00000000, 0x00000000, 0, 0, 0), -- Concussive Barrage ( 18119, 0x00, 5, 0x00000000, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Aftermath -( 18120, 0x00, 5, 0x00000000, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Aftermath +( 18120, 0x00, 5, 0x00000000, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Aftermath
\ No newline at end of file diff --git a/sql/updates/4394_world_spell_proc_event.sql b/sql/updates/4394_world_spell_proc_event.sql index babd3782fea..c4346e2df58 100644 --- a/sql/updates/4394_world_spell_proc_event.sql +++ b/sql/updates/4394_world_spell_proc_event.sql @@ -9,4 +9,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 25296, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0), -- Aspect of the Hawk ( 27044, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0), -- Aspect of the Hawk ( 61846, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0), -- Aspect of the Dragonhawk -( 61847, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0); -- Aspect of the Dragonhawk +( 61847, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0, 0, 0); -- Aspect of the Dragonhawk
\ No newline at end of file diff --git a/sql/updates/4397_world_playercreateinfo_spell_TDB.sql b/sql/updates/4397_world_playercreateinfo_spell_TDB.sql index 5bc5689bbf1..27508da6db5 100644 --- a/sql/updates/4397_world_playercreateinfo_spell_TDB.sql +++ b/sql/updates/4397_world_playercreateinfo_spell_TDB.sql @@ -3,4 +3,4 @@ INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (1, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'), (3, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'), (10, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'), -(11, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'); +(11, 2, 60091, 'Judgement Anti-Parry/Dodge Passive');
\ No newline at end of file diff --git a/sql/updates/4401_world_spell_proc_event.sql b/sql/updates/4401_world_spell_proc_event.sql index c2f993e6eb2..214b997359a 100644 --- a/sql/updates/4401_world_spell_proc_event.sql +++ b/sql/updates/4401_world_spell_proc_event.sql @@ -10,4 +10,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 55668, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Desecration ( 55669, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Desecration ( 55670, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Desecration -( 58616, 0x00, 15, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Heart Strike +( 58616, 0x00, 15, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Heart Strike
\ No newline at end of file diff --git a/sql/updates/4408_world_spell_proc_event.sql b/sql/updates/4408_world_spell_proc_event.sql index 108c983e196..1083262b2ac 100644 --- a/sql/updates/4408_world_spell_proc_event.sql +++ b/sql/updates/4408_world_spell_proc_event.sql @@ -8,4 +8,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 49655, 0x00, 15, 0x00000000, 0x00000000, 0x00000002, 0x00000000, 0x00000000, 0, 0, 1), -- Wandering Plague ( 49137, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Endless Winter ( 49657, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Endless Winter -( 58620, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Chains of Ice +( 58620, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Chains of Ice
\ No newline at end of file diff --git a/sql/updates/4409_world_spell_proc_event.sql b/sql/updates/4409_world_spell_proc_event.sql index 76184c6b0c0..cf25a1b4293 100644 --- a/sql/updates/4409_world_spell_proc_event.sql +++ b/sql/updates/4409_world_spell_proc_event.sql @@ -18,4 +18,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 54151, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Pure (Rank 3) ( 54154, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Pure (Rank 4) ( 63310, 0x00, 5, 0x00000000, 0x00010000, 0x00000000, 0x00010000, 0x00000000, 0, 0, 0), -- Glyph of Shadowflame -( 54155, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0); -- Judgements of the Pure (Rank 5) +( 54155, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0); -- Judgements of the Pure (Rank 5)
\ No newline at end of file diff --git a/sql/updates/4422_world_script.sql b/sql/updates/4422_world_script.sql index 99f8591dd04..54f3eb7a831 100644 --- a/sql/updates/4422_world_script.sql +++ b/sql/updates/4422_world_script.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dark_rider_of_acherus' WHERE `entry` =28654; +UPDATE `creature_template` SET `ScriptName`='npc_dark_rider_of_acherus' WHERE `entry` =28654;
\ No newline at end of file diff --git a/sql/updates/4423_world.sql b/sql/updates/4423_world.sql index 638d0d3c9d9..af0309e4f16 100644 --- a/sql/updates/4423_world.sql +++ b/sql/updates/4423_world.sql @@ -15,4 +15,4 @@ INSERT INTO `creature_ai_scripts` VALUES ( 3375100, 33751, 1, 0, 100, 0, 1, 1, 0, 0, 11, 63586, 0, 2, 11, 63582, 0, 2, 0, 0, 0, 0, 'Desecration'), -- Desecration ( 3375001, 33750, 11, 0, 100, 0, 0, 0, 0, 0, 11, 55741, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Desecration'), -( 3375000, 33750, 1, 0, 100, 0, 1, 1, 0, 0, 11, 63587, 0, 2, 11, 63583, 0, 2, 0, 0, 0, 0, 'Desecration'); +( 3375000, 33750, 1, 0, 100, 0, 1, 1, 0, 0, 11, 63587, 0, 2, 11, 63583, 0, 2, 0, 0, 0, 0, 'Desecration');
\ No newline at end of file diff --git a/sql/updates/4426_world.sql b/sql/updates/4426_world.sql index 0db361d93bf..ac53cfb5adf 100644 --- a/sql/updates/4426_world.sql +++ b/sql/updates/4426_world.sql @@ -25,4 +25,4 @@ UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13189; UPDATE `creature` SET `phaseMask`=128 WHERE `id` IN (31082,29173,29199,29204,29200); -- Citizen of New Avalon -UPDATE creature_template SET unit_flags = 537166336, dynamicflags = 0 WHERE entry = 28942; +UPDATE creature_template SET unit_flags = 537166336, dynamicflags = 0 WHERE entry = 28942;
\ No newline at end of file diff --git a/sql/updates/4428_world_spell_proc_event.sql b/sql/updates/4428_world_spell_proc_event.sql index bedb7cabe28..808510b5867 100644 --- a/sql/updates/4428_world_spell_proc_event.sql +++ b/sql/updates/4428_world_spell_proc_event.sql @@ -3,4 +3,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 59725, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000800, 0, 0, 0), -- Improved Spell Reflection ( 56342, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0), -- Lock and Load ( 56343, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0), -- Lock and Load -( 56344, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0); -- Lock and Load +( 56344, 0x00, 9, 0x00000018, 0x08000000, 0x00020000, 0x00000000, 0x00000000, 0, 0, 0); -- Lock and Load
\ No newline at end of file diff --git a/sql/updates/4429_world_spell_proc_event.sql b/sql/updates/4429_world_spell_proc_event.sql index b67c802610f..d9f3cfc8b52 100644 --- a/sql/updates/4429_world_spell_proc_event.sql +++ b/sql/updates/4429_world_spell_proc_event.sql @@ -4,4 +4,4 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 20212, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Illumination (Rank 2) ( 20213, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Illumination (Rank 3) ( 20214, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Illumination (Rank 4) -( 20215, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Illumination (Rank 5) +( 20215, 0x00, 10, 0xC0000000, 0x00010000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Illumination (Rank 5)
\ No newline at end of file diff --git a/sql/updates/4431_world_trinity_string.sql b/sql/updates/4431_world_trinity_string.sql index 564f465dc69..d26aa455932 100644 --- a/sql/updates/4431_world_trinity_string.sql +++ b/sql/updates/4431_world_trinity_string.sql @@ -1,4 +1,4 @@ UPDATE `trinity_string` SET `content_default` = 'Active connections: %u (max: %u) Queued connections: %u (max: %u)' WHERE `entry` = 12; DELETE FROM `trinity_string` WHERE `entry` = 60; -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES (60, 'Online players: %u (max: %u)'); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES (60, 'Online players: %u (max: %u)');
\ No newline at end of file diff --git a/sql/updates/4432_world.sql b/sql/updates/4432_world.sql index 895ffbb503a..3941d9306b1 100644 --- a/sql/updates/4432_world.sql +++ b/sql/updates/4432_world.sql @@ -55,4 +55,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `langua (-1609075,'There... There\'s no more time for me. I\'m done for. Finish me off, $N. Do it or they\'ll kill us both. $N... Remember Mulgore. This world is worth saving.',0,0,0,18,'special_surprise SAY_EXEC_TIME_9'), (-1609076,'Der... Der\'s no more time for me. I be done for. Finish me off $N. Do it or they\'ll kill us both. $N... Remember Sen\'jin Village, mon! Dis world be worth saving!',0,0,0,18,'special_surprise SAY_EXEC_TIME_10'), (-1609077,'Do it, $N! Put me out of my misery!',0,0,0,1,'special_surprise SAY_EXEC_WAITING'), -(-1609078,'dies from his wounds.',0,2,0,0,'special_surprise EMOTE_DIES'); +(-1609078,'dies from his wounds.',0,2,0,0,'special_surprise EMOTE_DIES');
\ No newline at end of file diff --git a/sql/updates/4445_8158_world_playercreateinfo_action.sql b/sql/updates/4445_8158_world_playercreateinfo_action.sql index c4c1eb98d06..572870c3703 100644 --- a/sql/updates/4445_8158_world_playercreateinfo_action.sql +++ b/sql/updates/4445_8158_world_playercreateinfo_action.sql @@ -450,4 +450,4 @@ INSERT INTO `playercreateinfo_action` VALUES (11,8,3,59548,0), (11,8,10,159,128), (11,8,11,4540,128), -(11,8,83,4540,128); +(11,8,83,4540,128);
\ No newline at end of file diff --git a/sql/updates/4451_world_tmp.sql b/sql/updates/4451_world_tmp.sql index 30f12539d75..40f44514575 100644 --- a/sql/updates/4451_world_tmp.sql +++ b/sql/updates/4451_world_tmp.sql @@ -1 +1 @@ -UPDATE creature_template SET `VehicleId`=200, spell1=52264, spell2=52268 WHERE `entry` IN (28605, 28606, 28607); +UPDATE creature_template SET `VehicleId`=200, spell1=52264, spell2=52268 WHERE `entry` IN (28605, 28606, 28607);
\ No newline at end of file diff --git a/sql/updates/4464_world_spell_bonus_data_TDB.sql b/sql/updates/4464_world_spell_bonus_data_TDB.sql index 9d7bacd90be..e53a2916ce9 100644 --- a/sql/updates/4464_world_spell_bonus_data_TDB.sql +++ b/sql/updates/4464_world_spell_bonus_data_TDB.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_bonus_data` WHERE `entry` = '58621'; INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES -(58621, 0, 0, 0.08, 'Death Knight - Glyph of Chains of Ice'); +(58621, 0, 0, 0.08, 'Death Knight - Glyph of Chains of Ice');
\ No newline at end of file diff --git a/sql/updates/4489_world_spell_proc_event.sql b/sql/updates/4489_world_spell_proc_event.sql deleted file mode 100644 index 802ff27eb43..00000000000 --- a/sql/updates/4489_world_spell_proc_event.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` =51915;
\ No newline at end of file diff --git a/sql/updates/4498_characters_channels.sql b/sql/updates/4498_characters_channels.sql index 7f5490ddf79..a56499768d0 100644 --- a/sql/updates/4498_characters_channels.sql +++ b/sql/updates/4498_characters_channels.sql @@ -11,4 +11,4 @@ CREATE TABLE `channels` ( `m_password` text, `BannedList` longtext, PRIMARY KEY (`m_name`(10),`m_team`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Channel System'; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Channel System';
\ No newline at end of file diff --git a/sql/updates/4500_world_spell_bonus_data.sql b/sql/updates/4500_world_spell_bonus_data.sql index 2b8084e8cc7..dc5be2bcf23 100644 --- a/sql/updates/4500_world_spell_bonus_data.sql +++ b/sql/updates/4500_world_spell_bonus_data.sql @@ -242,5 +242,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` (57970, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 9($AP*0.12 / number of ticks)'), (48628, -1, -1, -1, 0.15, 'Druid - Lock Jaw'), (1822, -1, -1, 0.01, 0.06, 'Druid - Rake ($AP*0.18 / number of ticks)'), -(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)'); - +(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)');
\ No newline at end of file diff --git a/sql/updates/4501_world_spell_bonus_data.sql b/sql/updates/4501_world_spell_bonus_data.sql index 337b293e62e..2cef253cd58 100644 --- a/sql/updates/4501_world_spell_bonus_data.sql +++ b/sql/updates/4501_world_spell_bonus_data.sql @@ -28,4 +28,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` (56641, -1, -1, 0.1, -1, 'Hunter - Steady Shot'), (13812, -1, -1, 0.1, -1, 'Hunter - Explosive Trap Effect'), (20253, -1, -1, 0.12, -1, 'Warrior - Intercept'), -(61491, -1, -1, 0.12, -1, 'Warrior - Intercept'); +(61491, -1, -1, 0.12, -1, 'Warrior - Intercept');
\ No newline at end of file diff --git a/sql/updates/4509_world_spell_linked_spell.sql b/sql/updates/4509_world_spell_linked_spell.sql index d672b2a564a..ddca75d5d53 100644 --- a/sql/updates/4509_world_spell_linked_spell.sql +++ b/sql/updates/4509_world_spell_linked_spell.sql @@ -1 +1 @@ -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (48265, 49772, 48263); +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (48265, 49772, 48263);
\ No newline at end of file diff --git a/sql/updates/4520_8190_world_creature_template.sql b/sql/updates/4520_8190_world_creature_template.sql index 7be3a6e49fa..fdc36d4474b 100644 --- a/sql/updates/4520_8190_world_creature_template.sql +++ b/sql/updates/4520_8190_world_creature_template.sql @@ -2,4 +2,4 @@ ALTER TABLE `creature_template` CHANGE COLUMN `unk1` `KillCredit1` int(11) unsigned NOT NULL default '0', - CHANGE COLUMN `unk2` `KillCredit2` int(11) unsigned NOT NULL default '0'; + CHANGE COLUMN `unk2` `KillCredit2` int(11) unsigned NOT NULL default '0';
\ No newline at end of file diff --git a/sql/updates/4524_world_spell_elixir.sql b/sql/updates/4524_world_spell_elixir.sql index dc48a4af91b..49bb9845957 100644 --- a/sql/updates/4524_world_spell_elixir.sql +++ b/sql/updates/4524_world_spell_elixir.sql @@ -1,12 +1,5 @@ DELETE FROM `spell_elixir` WHERE `entry` IN -( - 54452, 60340, 60345, 60341, 60344, - 60346, 54494, 53748, 53749, 53746, - 60343, 53751, 53764, 60347, 53763, - 53747, 53760, 54212, 53758, 53755, - 53752, 62380 -); - +(54452, 60340, 60345, 60341, 60344, 60346, 54494, 53748, 53749, 53746, 60343, 53751, 53764, 60347, 53763, 53747, 53760, 54212, 53758, 53755, 53752, 62380); INSERT INTO `spell_elixir` (`entry`, `mask`) VALUES (54452, 0x1), (60340, 0x1), @@ -29,4 +22,4 @@ INSERT INTO `spell_elixir` (`entry`, `mask`) VALUES (53758, 0x3), (53755, 0x3), (53752, 0x3), -(62380, 0x3); +(62380, 0x3);
\ No newline at end of file diff --git a/sql/updates/4527_world_spell_script_target.sql b/sql/updates/4530_world_spell_script_target.sql index f1bf84d509a..234f5b88b6a 100644 --- a/sql/updates/4527_world_spell_script_target.sql +++ b/sql/updates/4530_world_spell_script_target.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_script_target` WHERE `entry` IN (58836); INSERT INTO `spell_script_target` VALUES (58836, 1, 31216); UPDATE `creature_template` SET `ScriptName`='npc_mirror_image' WHERE `entry`=31216; -UPDATE `creature_template` SET `spell1`=59638, `spell2` = 59637 WHERE `entry`=31216; +UPDATE `creature_template` SET `spell1`=59638, `spell2` = 59637 WHERE `entry`=31216;
\ No newline at end of file diff --git a/sql/updates/4536_world_spell_proc_event.sql b/sql/updates/4536_world_spell_proc_event.sql index 875313c3e85..9b009d65b82 100644 --- a/sql/updates/4536_world_spell_proc_event.sql +++ b/sql/updates/4536_world_spell_proc_event.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (53234, 53237, 53238); INSERT INTO `spell_proc_event` VALUES (53234, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), -- Piercing Shots (Rank 1) (53237, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), -- Piercing Shots (Rank 2) -(53238, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); -- Piercing Shots (Rank 3) +(53238, 0x00, 9, 0x00020000, 0x00000001, 0x00000001, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); -- Piercing Shots (Rank 3)
\ No newline at end of file diff --git a/sql/updates/4539_world_spell_linked_spell.sql b/sql/updates/4539_world_spell_linked_spell.sql index 1be5970f4ab..4b18b179f7c 100644 --- a/sql/updates/4539_world_spell_linked_spell.sql +++ b/sql/updates/4539_world_spell_linked_spell.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (49039); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -( 49039, 50397, 2, 'Lichborne - shapeshift'); +( 49039, 50397, 2, 'Lichborne - shapeshift');
\ No newline at end of file |