diff options
Diffstat (limited to 'sql/updates')
108 files changed, 1417 insertions, 0 deletions
diff --git a/sql/updates/auth/2013_09_10_00_auth_misc_434.sql b/sql/updates/auth/2013_09_10_00_auth_misc_434.sql new file mode 100644 index 00000000000..73abc02f88a --- /dev/null +++ b/sql/updates/auth/2013_09_10_00_auth_misc_434.sql @@ -0,0 +1,15 @@ +/* cs_modify.cpp & cs_debug.cpp only 4.3.4 */ + +SET @id = 775; + +-- Add new permissions +DELETE FROM `rbac_permissions` WHERE `id` BETWEEN @id AND @id+13; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(@id+0, 'modify currency'), +(@id+1, 'debug phase'); + +-- Add permissions to "corresponding Commands Role" +DELETE FROM `rbac_role_permissions` WHERE `permissionId` BETWEEN @id AND @id+13; +INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES +(3, @id+0), +(4, @id+1); diff --git a/sql/updates/world/2013_07_17_04_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_17_04_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..757f33ba232 --- /dev/null +++ b/sql/updates/world/2013_07_17_04_world_spell_script_misc_434.sql @@ -0,0 +1,14 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (63310,-18094,56218,6358,-30293); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(63310,'spell_warl_glyph_of_shadowflame'), +(-18094,'spell_warl_shadow_trance_proc'), +(56218,'spell_warl_shadow_trance_proc'), +(6358,'spell_warl_seduction'), +(-30293,'spell_warl_soul_leech'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (18094,30293); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(18094, 18094, 1), +(18094, 18095, 2), +(30293, 30293, 1), +(30293, 30295, 2); diff --git a/sql/updates/world/2013_07_18_00_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_18_00_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..9eed10846cb --- /dev/null +++ b/sql/updates/world/2013_07_18_00_world_spell_script_misc_434.sql @@ -0,0 +1,15 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-31641,50421,-30881); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-31641,'spell_mage_blazing_speed'), +(50421,'spell_dk_scent_of_blood'), +(-30881,'spell_sha_nature_guardian'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (31641,30881); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(31641, 31641, 1), +(31641, 31642, 2), +(30881, 30881, 1), +(30881, 30883, 2), +(30881, 30884, 3); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (30881,30883,30884); diff --git a/sql/updates/world/2013_07_18_01_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_18_01_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..b5eecfcc8e7 --- /dev/null +++ b/sql/updates/world/2013_07_18_01_world_spell_script_misc_434.sql @@ -0,0 +1,16 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-46951,23780,33896,37594,37705,23551,23552,23572); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-46951,'spell_warr_sword_and_board'), +(23780,'spell_item_aegis_of_preservation'), +(33896,'spell_item_desperate_defense'), +(37594,'spell_pri_item_greater_heal_refund'), +(37705,'spell_pal_item_healing_discount'), +(23551,'spell_sha_item_lightning_shield'), +(23552,'spell_sha_item_lightning_shield_trigger'), +(23572,'spell_sha_item_mana_surge'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (46951); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(46951, 46951, 1), +(46951, 46952, 2), +(46951, 46953, 3); diff --git a/sql/updates/world/2013_07_18_02_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_18_02_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..5bc7bffadb1 --- /dev/null +++ b/sql/updates/world/2013_07_18_02_world_spell_script_misc_434.sql @@ -0,0 +1,12 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-31571,-51664); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-31571,'spell_mage_arcane_potency'), +(-51664,'spell_rog_cut_to_the_chase'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (31571,51664); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(31571, 31571, 1), +(31571, 31572, 2), +(51664, 51664, 1), +(51664, 51665, 2), +(51664, 51667, 3); diff --git a/sql/updates/world/2013_07_19_00_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_19_00_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..19d9a738296 --- /dev/null +++ b/sql/updates/world/2013_07_19_00_world_spell_script_misc_434.sql @@ -0,0 +1,10 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-51556,55440); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-51556,'spell_sha_ancestral_awakening'), +(55440,'spell_sha_glyph_of_healing_wave'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=51556; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(51556, 51556, 1), +(51556, 51557, 2), +(51556, 51558, 3); diff --git a/sql/updates/world/2013_07_19_01_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_19_01_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..c265c9cd8ce --- /dev/null +++ b/sql/updates/world/2013_07_19_01_world_spell_script_misc_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-53228); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-53228,'spell_hun_rapid_recuperation'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=53228; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(53228, 53228, 1), +(53228, 53232, 2); diff --git a/sql/updates/world/2013_07_20_00_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_00_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..cde03c0ad69 --- /dev/null +++ b/sql/updates/world/2013_07_20_00_world_spell_script_misc_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-48979); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-48979,'spell_dk_butchery'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=48979; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(48979, 48979, 1), +(48979, 49483, 2); diff --git a/sql/updates/world/2013_07_20_01_world_spell_bonus_data_434.sql b/sql/updates/world/2013_07_20_01_world_spell_bonus_data_434.sql new file mode 100644 index 00000000000..58a5fc47bf2 --- /dev/null +++ b/sql/updates/world/2013_07_20_01_world_spell_bonus_data_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_bonus_data` WHERE `entry`=52174; +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +(52174, 0, 0, 0.5, 0, 'Warrior - Heroic Leap'); diff --git a/sql/updates/world/2013_07_20_02_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_02_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..b8a515f4d21 --- /dev/null +++ b/sql/updates/world/2013_07_20_02_world_spell_script_misc_434.sql @@ -0,0 +1,17 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (56342, 56343, 56333, 56336); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +-- Lock and Load +(56342, 0, 9, 0x18, 0, 0, 0x200000, 0, 0, 0, 0), +(56343, 0, 9, 0x18, 0, 0, 0x200000, 0, 0, 0, 0), +-- T.N.T. +(56333, 0, 9, 0x84, 0x8000000, 0x24000, 0x240000, 0, 0, 100, 0), +(56336, 0, 9, 0x84, 0x8000000, 0x24000, 0x240000, 0, 0, 100, 0); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-56333); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-56333,'spell_hun_tnt'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=56333; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(56333, 56333, 1), +(56333, 56336, 2); diff --git a/sql/updates/world/2013_07_20_03_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_03_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..9da7a7536cc --- /dev/null +++ b/sql/updates/world/2013_07_20_03_world_spell_script_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=56372; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(56372,'spell_mage_glyph_of_ice_block'); + +DELETE FROM `spell_proc_event` WHERE `entry`=56372; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(56372, 0, 3, 0, 0x80, 0x8, 0x4000, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_20_04_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_04_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..36c2c4c13a4 --- /dev/null +++ b/sql/updates/world/2013_07_20_04_world_spell_script_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=32216; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(32216,'spell_warr_victorious'); + +DELETE FROM `spell_proc_event` WHERE `entry`=32216; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(32216, 0, 4, 0, 256, 0, 16, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_20_05_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_05_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..e625bf0a544 --- /dev/null +++ b/sql/updates/world/2013_07_20_05_world_spell_script_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=56375; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(56375,'spell_mage_glyph_of_polymorph'); + +DELETE FROM `spell_proc_event` WHERE `entry`=56375; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(56375, 0, 3, 16777216, 0, 0, 65536, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_20_06_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_06_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..0dd62f80fa1 --- /dev/null +++ b/sql/updates/world/2013_07_20_06_world_spell_script_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=56374; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(56374,'spell_mage_glyph_of_icy_veins'); + +DELETE FROM `spell_proc_event` WHERE `entry`=56374; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(56374, 0, 3, 0, 16384, 0, 16384, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_20_07_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_07_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..1705485c672 --- /dev/null +++ b/sql/updates/world/2013_07_20_07_world_spell_script_misc_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-11175); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-11175,'spell_mage_permafrost'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=11175; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(11175, 11175, 1), +(11175, 12569, 2), +(11175, 12571, 3); + +DELETE FROM `spell_bonus_data` WHERE `entry`=91394; +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +(91394, 0, 0, 0, 0, 'Mage - Permafrost'); diff --git a/sql/updates/world/2013_07_20_08_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_08_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..a1ea020baa1 --- /dev/null +++ b/sql/updates/world/2013_07_20_08_world_spell_script_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=17619; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(17619, 0, 13, 0, 0, 0, 0x4800, 0, 0, 100, 0); + +DELETE FROM `spell_script_names` WHERE `spell_id`=17619; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(17619,'spell_gen_alchemist_stone'); diff --git a/sql/updates/world/2013_07_21_00_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_21_00_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..1e0dfb24d50 --- /dev/null +++ b/sql/updates/world/2013_07_21_00_world_spell_script_misc_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-19572; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-19572,'spell_hun_improved_mend_pet'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=19572; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(19572, 19572, 1), +(19572, 19573, 2); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (19572,19573); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(19572, 0, 9, 8388608, 0, 0, 0x4000, 0, 0, 100, 0), +(19573, 0, 9, 8388608, 0, 0, 0x4000, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_21_01_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_21_01_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..6833b3cb548 --- /dev/null +++ b/sql/updates/world/2013_07_21_01_world_spell_script_misc_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-85113; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-85113,'spell_warl_aftermath'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=85113; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(85113, 85113, 1), +(85113, 85114, 2); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (85113,85114); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(85113, 0, 5, 0x20, 0x800000, 0, 0, 0, 0, 0, 0), +(85114, 0, 5, 0x20, 0x800000, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_07_21_02_world_spell_script_names_434.sql b/sql/updates/world/2013_07_21_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..aa971c0bfad --- /dev/null +++ b/sql/updates/world/2013_07_21_02_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=15286; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(15286,'spell_pri_vampiric_embrace'), +(15290,'spell_pri_vampiric_embrace_target'); diff --git a/sql/updates/world/2013_07_21_03_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_21_03_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..2b4933fd433 --- /dev/null +++ b/sql/updates/world/2013_07_21_03_world_spell_script_misc_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-47569; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-47569,'spell_pri_phantasm'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=47569; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(47569, 47569, 1), +(47569, 47570, 2); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (47569,47570); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(47569, 0, 6, 16384, 0, 0, 16384, 0, 0, 100, 0), +(47570, 0, 6, 16384, 0, 0, 16384, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_21_04_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_21_04_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..375d0bcaa1b --- /dev/null +++ b/sql/updates/world/2013_07_21_04_world_spell_script_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=54832; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(54832,'spell_dru_glyph_of_innervate'); + +DELETE FROM `spell_proc_event` WHERE `entry`=54832; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(54832, 0, 7, 0, 4096, 0, 16384, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_21_05_world_spell_script_names_434.sql b/sql/updates/world/2013_07_21_05_world_spell_script_names_434.sql new file mode 100644 index 00000000000..d910444ae31 --- /dev/null +++ b/sql/updates/world/2013_07_21_05_world_spell_script_names_434.sql @@ -0,0 +1 @@ +UPDATE `spell_script_names` SET `spell_id`=34914 WHERE `ScriptName`='spell_pri_vampiric_touch'; diff --git a/sql/updates/world/2013_07_21_06_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_21_06_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..0ea599ca048 --- /dev/null +++ b/sql/updates/world/2013_07_21_06_world_spell_script_misc_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-64127; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-64127,'spell_pri_body_and_soul'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=64127; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(64127, 64127, 1), +(64127, 64129, 2); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (64127,64129); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(64127, 0, 6, 0x1, 0x1, 0x80000, 0x4000, 0, 0, 100, 0), +(64129, 0, 6, 0x1, 0x1, 0x80000, 0x4000, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_22_00_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..46059c6ddcc --- /dev/null +++ b/sql/updates/world/2013_07_22_00_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=20230; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(20230,'spell_warr_retaliation'); diff --git a/sql/updates/world/2013_07_22_01_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_22_01_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..0d768c8163c --- /dev/null +++ b/sql/updates/world/2013_07_22_01_world_spell_script_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=58387; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(58387,'spell_warr_glyph_of_sunder_armor'); + +DELETE FROM `spell_proc_event` WHERE `entry`=58387; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(58387, 0, 4, 16384, 64, 0, 16, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_22_02_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..3723575d273 --- /dev/null +++ b/sql/updates/world/2013_07_22_02_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=56641; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(56641,'spell_hun_steady_shot'); diff --git a/sql/updates/world/2013_07_22_03_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_03_world_spell_script_names_434.sql new file mode 100644 index 00000000000..53b89090c39 --- /dev/null +++ b/sql/updates/world/2013_07_22_03_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=6262; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(6262,'spell_warl_healthstone_heal'); diff --git a/sql/updates/world/2013_07_22_04_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_04_world_spell_script_names_434.sql new file mode 100644 index 00000000000..e0406417397 --- /dev/null +++ b/sql/updates/world/2013_07_22_04_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=73159; diff --git a/sql/updates/world/2013_07_22_05_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_05_world_spell_script_names_434.sql new file mode 100644 index 00000000000..13d7af101bf --- /dev/null +++ b/sql/updates/world/2013_07_22_05_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_burnout'; diff --git a/sql/updates/world/2013_07_22_06_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_06_world_spell_script_names_434.sql new file mode 100644 index 00000000000..94c5e9cf39e --- /dev/null +++ b/sql/updates/world/2013_07_22_06_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-24604; diff --git a/sql/updates/world/2013_07_22_07_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_07_world_spell_script_names_434.sql new file mode 100644 index 00000000000..edba00cd544 --- /dev/null +++ b/sql/updates/world/2013_07_22_07_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=31687; diff --git a/sql/updates/world/2013_07_22_08_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_08_world_spell_script_names_434.sql new file mode 100644 index 00000000000..20583473b26 --- /dev/null +++ b/sql/updates/world/2013_07_22_08_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=63108; diff --git a/sql/updates/world/2013_07_22_09_world_spell_misc_434.sql b/sql/updates/world/2013_07_22_09_world_spell_misc_434.sql new file mode 100644 index 00000000000..490b0bca6ae --- /dev/null +++ b/sql/updates/world/2013_07_22_09_world_spell_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=54845; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(54845,'spell_dru_glyph_of_starfire_proc'); + +DELETE FROM `spell_proc_event` WHERE `entry`=54845; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(54845, 0, 7, 4, 0, 0, 65536, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_22_10_world_spell_script_names_434.sql b/sql/updates/world/2013_07_22_10_world_spell_script_names_434.sql new file mode 100644 index 00000000000..cce8a869033 --- /dev/null +++ b/sql/updates/world/2013_07_22_10_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_item_refocus'; diff --git a/sql/updates/world/2013_07_23_00_world_spell_misc_434.sql b/sql/updates/world/2013_07_23_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..51c18dc11ca --- /dev/null +++ b/sql/updates/world/2013_07_23_00_world_spell_misc_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-18119; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-18119,'spell_warl_improved_soul_fire'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=18119; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(18119, 18119, 1), +(18119, 18120, 2); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (18119,18120); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(18119, 0, 5, 0, 0x80, 0, 0x10000, 0, 0, 100, 0), +(18120, 0, 5, 0, 0x80, 0, 0x10000, 0, 0, 100, 0); diff --git a/sql/updates/world/2013_07_23_01_world_spell_misc_434.sql b/sql/updates/world/2013_07_23_01_world_spell_misc_434.sql new file mode 100644 index 00000000000..d1776eb3edf --- /dev/null +++ b/sql/updates/world/2013_07_23_01_world_spell_misc_434.sql @@ -0,0 +1,11 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (34485,34486,34487,82926); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(34485, 0, 9, 0, 0x1, 0, 0, 0, 0, 0, 0), +(34486, 0, 9, 0, 0x1, 0, 0, 0, 0, 0, 0), +(34487, 0, 9, 0, 0x1, 0, 0, 0, 0, 0, 0), +(82926, 0, 9, 0x20000, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `spell_script_names` WHERE `spell_id`IN (82925,82926); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(82925,'spell_hun_ready_set_aim'), +(82926,'spell_hun_fire'); diff --git a/sql/updates/world/2013_07_23_02_world_spell_miscs_434.sql b/sql/updates/world/2013_07_23_02_world_spell_miscs_434.sql new file mode 100644 index 00000000000..0bd26f016c1 --- /dev/null +++ b/sql/updates/world/2013_07_23_02_world_spell_miscs_434.sql @@ -0,0 +1,11 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_dk_death_strike_enabler'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(89832, 'spell_dk_death_strike_enabler'); + +-- Improved Death Strike (talent) ranks +DELETE FROM `spell_ranks` WHERE `first_spell_id` = 62905; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(62905, 62905, 1), +(62905, 62908, 2), +(62905, 81138, 3); + diff --git a/sql/updates/world/2013_07_23_03_world_spell_pet_auras_434.sql b/sql/updates/world/2013_07_23_03_world_spell_pet_auras_434.sql new file mode 100644 index 00000000000..4997dc50c61 --- /dev/null +++ b/sql/updates/world/2013_07_23_03_world_spell_pet_auras_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_pet_auras` WHERE `spell` IN (56314,56315); diff --git a/sql/updates/world/2013_07_23_04_world_spell_spell_misc_434.sql b/sql/updates/world/2013_07_23_04_world_spell_spell_misc_434.sql new file mode 100644 index 00000000000..80775b931e1 --- /dev/null +++ b/sql/updates/world/2013_07_23_04_world_spell_spell_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_pal_blessing_of_sanctuary'; + +DELETE FROM `spell_proc_event` WHERE `entry` IN (20911,84628,84629); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(20911, 0, 0, 0, 0, 0, 0, 0x50, 0, 0, 0), +(84628, 0, 0, 0, 0, 0, 0, 0x50, 0, 0, 0), +(84629, 0, 0, 0, 0, 0, 0, 0x50, 0, 0, 0); diff --git a/sql/updates/world/2013_07_23_05_world_spell_bonus_data_434.sql b/sql/updates/world/2013_07_23_05_world_spell_bonus_data_434.sql new file mode 100644 index 00000000000..21cb5899bc1 --- /dev/null +++ b/sql/updates/world/2013_07_23_05_world_spell_bonus_data_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_bonus_data` WHERE `entry`=78; +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +(78, 0, 0, 0.6, 0, 'Warrior - Heroic Strike'); diff --git a/sql/updates/world/2013_07_23_06_world_spell_script_names_434.sql b/sql/updates/world/2013_07_23_06_world_spell_script_names_434.sql new file mode 100644 index 00000000000..355037c8dc0 --- /dev/null +++ b/sql/updates/world/2013_07_23_06_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`IN (687,28176); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(687,'spell_warl_nether_ward_overrride'), +(28176,'spell_warl_nether_ward_overrride'); diff --git a/sql/updates/world/2013_07_23_07_world_spell_target_position_434.sql b/sql/updates/world/2013_07_23_07_world_spell_target_position_434.sql new file mode 100644 index 00000000000..2977d7454b1 --- /dev/null +++ b/sql/updates/world/2013_07_23_07_world_spell_target_position_434.sql @@ -0,0 +1 @@ +UPDATE `spell_target_position` SET `effIndex`=1 WHERE `id`IN (84073,109984,100268,100335,100508,100509,100523,67838,67835,67836,67837,67834,68081); diff --git a/sql/updates/world/2013_07_23_08_world_spell_script_names_434.sql b/sql/updates/world/2013_07_23_08_world_spell_script_names_434.sql new file mode 100644 index 00000000000..df11f6d54bf --- /dev/null +++ b/sql/updates/world/2013_07_23_08_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-52752; diff --git a/sql/updates/world/2013_07_24_00_world_spell_misc_434.sql b/sql/updates/world/2013_07_24_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..dafd88fc7f1 --- /dev/null +++ b/sql/updates/world/2013_07_24_00_world_spell_misc_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-14748; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-14748,'spell_pri_improved_power_word_shield'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=14748; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(14748, 14748, 1), +(14748, 14768, 2); diff --git a/sql/updates/world/2013_07_24_00_world_spell_script_names_335.sql b/sql/updates/world/2013_07_24_00_world_spell_script_names_335.sql new file mode 100644 index 00000000000..8c156fb2e57 --- /dev/null +++ b/sql/updates/world/2013_07_24_00_world_spell_script_names_335.sql @@ -0,0 +1,11 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (63310,50421,23780,33896,37594,37705,23551,23552,23572); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(63310,'spell_warl_glyph_of_shadowflame'), +(50421,'spell_dk_scent_of_blood'), +(23780,'spell_item_aegis_of_preservation'), +(33896,'spell_item_desperate_defense'), +(37594,'spell_pri_item_greater_heal_refund'), +(37705,'spell_pal_item_healing_discount'), +(23551,'spell_sha_item_lightning_shield'), +(23552,'spell_sha_item_lightning_shield_trigger'), +(23572,'spell_sha_item_mana_surge'); diff --git a/sql/updates/world/2013_07_24_01_world_spell_misc_434.sql b/sql/updates/world/2013_07_24_01_world_spell_misc_434.sql new file mode 100644 index 00000000000..933426e6164 --- /dev/null +++ b/sql/updates/world/2013_07_24_01_world_spell_misc_434.sql @@ -0,0 +1,10 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_dk_will_of_the_necropolis'; +DELETE FROM `spell_script_names` WHERE `spell_id`=-52284; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-52284,'spell_dk_will_of_the_necropolis'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=52284; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(52284, 52284, 1), +(52284, 81163, 2), +(52284, 81164, 3); diff --git a/sql/updates/world/2013_07_24_02_world_spell_script_names_434.sql b/sql/updates/world/2013_07_24_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..d03b8292491 --- /dev/null +++ b/sql/updates/world/2013_07_24_02_world_spell_script_names_434.sql @@ -0,0 +1 @@ +UPDATE `spell_script_names` SET `spell_id`=633 WHERE `ScriptName`='spell_pal_lay_on_hands'; diff --git a/sql/updates/world/2013_07_24_03_world_creature_template_434.sql b/sql/updates/world/2013_07_24_03_world_creature_template_434.sql new file mode 100644 index 00000000000..c31e5f4a30e --- /dev/null +++ b/sql/updates/world/2013_07_24_03_world_creature_template_434.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `mechanic_immune_mask` = 32,`flags_extra` = 0x40000,`ScriptName` = 'npc_training_dummy' WHERE `name` LIKE '%Training Dummy%' AND `ScriptName` != 'npc_training_dummy'; diff --git a/sql/updates/world/2013_07_24_04_world_spell_script_names_434.sql b/sql/updates/world/2013_07_24_04_world_spell_script_names_434.sql new file mode 100644 index 00000000000..49707df2515 --- /dev/null +++ b/sql/updates/world/2013_07_24_04_world_spell_script_names_434.sql @@ -0,0 +1,6 @@ +DELETE FROM spell_script_names WHERE ScriptName LIKE "spell_warl_soul_swap%"; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(86121, "spell_warl_soul_swap"), +(86211, "spell_warl_soul_swap_override"), +(92795, "spell_warl_soul_swap_dot_marker"), +(86213, "spell_warl_soul_swap_exhale"); diff --git a/sql/updates/world/2013_07_24_05_world_spell_script_names_434.sql b/sql/updates/world/2013_07_24_05_world_spell_script_names_434.sql new file mode 100644 index 00000000000..cfed3bc8f00 --- /dev/null +++ b/sql/updates/world/2013_07_24_05_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=52437; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(52437,'spell_warr_sudden_death'); diff --git a/sql/updates/world/2013_07_24_06_world_spell_ranks_434.sql b/sql/updates/world/2013_07_24_06_world_spell_ranks_434.sql new file mode 100644 index 00000000000..d74b77d5ed2 --- /dev/null +++ b/sql/updates/world/2013_07_24_06_world_spell_ranks_434.sql @@ -0,0 +1,21 @@ +DELETE FROM `spell_ranks` WHERE `first_spell_id`=746; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(746, 746, 1), +(746, 1159, 2), +(746, 3267, 3), +(746, 3268, 4), +(746, 7926, 5), +(746, 7927, 6), +(746, 10838, 7), +(746, 10839, 8), +(746, 18608, 9), +(746, 18610, 10), +(746, 27030, 11), +(746, 27031, 12), +(746, 45543, 13), +(746, 51827, 14), +(746, 45544, 15), +(746, 51803, 16), +(746, 74553, 17), +(746, 74554, 18), +(746, 74555, 19); diff --git a/sql/updates/world/2013_07_25_00_world_spell_ranks_434.sql b/sql/updates/world/2013_07_25_00_world_spell_ranks_434.sql new file mode 100644 index 00000000000..ab7c731c625 --- /dev/null +++ b/sql/updates/world/2013_07_25_00_world_spell_ranks_434.sql @@ -0,0 +1,21 @@ +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN ( +11175, +14748, +18094, +18119, +19572, +30293, +30881, +31571, +31641, +46951, +47569, +48979, +51556, +51664, +52284, +53228, +56333, +62905, +64127, +85113); diff --git a/sql/updates/world/2013_07_25_01_world_spell_proc_events_434.sql b/sql/updates/world/2013_07_25_01_world_spell_proc_events_434.sql new file mode 100644 index 00000000000..e0a8b179117 --- /dev/null +++ b/sql/updates/world/2013_07_25_01_world_spell_proc_events_434.sql @@ -0,0 +1,468 @@ +ALTER TABLE `spell_proc_event` + CHANGE `entry` `entry` MEDIUMINT(8) DEFAULT 0 NOT NULL; + +DELETE FROM `spell_proc_event` WHERE `entry` IN ( +11120, +12487, +12574, +12575, +12598, +12668, +12724, +12725, +12799, +12846, +12849, +12867, +12872, +12873, +12958, +12971, +12972, +13867, +14160, +14161, +14190, +15362, +16196, +16235, +16281, +16282, +16489, +16492, +16544, +17796, +17801, +18095, +18120, +19387, +19573, +20056, +20057, +20179, +25988, +29179, +29180, +29075, +29594, +29838, +30295, +31126, +31570, +31572, +32387, +32392, +33145, +33882, +34486, +34487, +34498, +34499, +34938, +34939, +34954, +35102, +35550, +35551, +44448, +45243, +46914, +46915, +46949, +47196, +47197, +47202, +47203, +47246, +47247, +47259, +47260, +47511, +47515, +47517, +47570, +47581, +48484, +48499, +48500, +48544, +49508, +49509, +49529, +49530, +49627, +49628, +50115, +51462, +51524, +51557, +51558, +51563, +51564, +51626, +51665, +51667, +51679, +51696, +52797, +53179, +53222, +53224, +53232, +53237, +53238, +53259, +53260, +53376, +53488, +53576, +53673, +53696, +53710, +54151, +55667, +56336, +56343, +56611, +56637, +56638, +56822, +57472, +57880, +59057, +61345, +61346, +62765, +63158, +63374, +63733, +64129, +66191, +66192, +77795, +77796, +82988, +84628, +84629, +85114, +86184, +86185 +); + +DELETE FROM `spell_proc_event` WHERE `entry` IN ( +5952, +9799, +11095, +11119, +11185, +11213, +11255, +12289, +12298, +12311, +12319, +12797, +12834, +13754, +14156, +14186, +14892, +16086, +16176, +16180, +16256, +16487, +16880, +17793, +18094, +18119, +19184, +19572, +20049, +20177, +20911, +29074, +29593, +29834, +30160, +30293, +31124, +31569, +31571, +32385, +33142, +33881, +34485, +34497, +34935, +34950, +35100, +35541, +44446, +45234, +46867, +46913, +46945, +47195, +47201, +47245, +47258, +47509, +47516, +47569, +47580, +48483, +48496, +48539, +49004, +49018, +49149, +49188, +49219, +51459, +51523, +51556, +51562, +51625, +51664, +51692, +52795, +53178, +53221, +53228, +53234, +53256, +53375, +53486, +53569, +53671, +53695, +53709, +55666, +56333, +56342, +56636, +57470, +57878, +62764, +63156, +63373, +63730, +64127, +65661, +77794, +82984, +85113, +86183, +-5952, +-9799, +-11095, +-11119, +-11185, +-11213, +-11255, +-12289, +-12298, +-12311, +-12319, +-12797, +-12834, +-13754, +-14156, +-14186, +-14892, +-16086, +-16176, +-16180, +-16256, +-16487, +-16880, +-17793, +-18094, +-18119, +-19184, +-19572, +-20049, +-20177, +-20911, +-29074, +-29593, +-29834, +-30160, +-30293, +-31124, +-31569, +-31571, +-32385, +-33142, +-33881, +-34485, +-34497, +-34935, +-34950, +-35100, +-35541, +-44446, +-45234, +-46867, +-46913, +-46945, +-47195, +-47201, +-47245, +-47258, +-47509, +-47516, +-47569, +-47580, +-48483, +-48496, +-48539, +-49004, +-49018, +-49149, +-49188, +-49219, +-51459, +-51523, +-51556, +-51562, +-51625, +-51664, +-51692, +-52795, +-53178, +-53221, +-53228, +-53234, +-53256, +-53375, +-53486, +-53569, +-53671, +-53695, +-53709, +-55666, +-56333, +-56342, +-56636, +-57470, +-57878, +-62764, +-63156, +-63373, +-63730, +-64127, +-65661, +-77794, +-82984, +-85113, +-86183 +); + +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-5952,0,8,0,1,0,0,0,0,0,0), +(-9799,0,0,0,0,0,65536,0,0,0,0), +(-11095,0,3,16,0,0,0,0,0,0,0), +(-11119,4,3,0,0,0,0,2,0,0,0), +(-11185,0,3,128,0,0,327680,0,0,0,0), +(-11213,0,3,0,0,0,0,0,0,0,0), +(-11255,0,3,16384,0,0,0,0,0,0,0), +(-12289,0,4,2,0,0,0,0,0,0,0), +(-12298,0,0,0,0,0,0,112,0,0,0), +(-12311,0,4,2048,1,0,0,0,0,0,0), +(-12319,0,0,0,0,0,0,2,0,0,0), +(-12797,0,4,1024,0,0,0,0,0,0,0), +(-12834,0,0,0,0,0,0,2,0,0,0), +(-13754,0,8,16,0,0,0,0,0,0,0), +(-14156,0,8,4063232,8,0,0,0,0,0,0), +(-14186,0,8,1082131720,6,0,0,2,0,0,1), +(-14892,0,6,268443136,65540,0,0,2,0,0,0), +(-16086,4,11,0,262144,0,196608,0,0,0,0), +(-16176,0,11,448,0,16,0,2,0,0,0), +(-16180,0,11,448,0,16,0,2,0,100,0), +(-16256,0,0,0,0,0,0,2,0,0,0), +(-16487,0,0,0,0,0,0,2,0,0,0), +(-16880,72,7,103,58720258,0,0,2,0,0,0), +(-17793,0,5,1,64,0,0,0,0,0,0), +(-18094,0,5,10,0,0,0,0,0,0,0), +(-18119,0,5,0,128,0,65536,0,0,100,0), +(-19184,0,9,16,8192,0,0,0,0,0,0), +(-19572,0,9,8388608,0,0,16384,0,0,100,0), +(-20049,0,0,0,0,0,0,2,0,0,0), +(-20177,0,0,0,0,0,0,67,0,0,0), +(-20911,0,0,0,0,0,0,80,0,0,0), +(-29074,20,3,0,0,0,0,2,0,0,0), +(-29593,0,0,0,0,0,0,112,0,0,0), +(-29834,0,0,0,0,0,0,65536,0,0,0), +(-30160,0,0,0,0,0,0,2,0,0,0), +(-30293,0,5,897,8519872,0,0,0,0,0,0), +(-31124,0,8,16777222,0,0,0,0,0,0,0), +(-31569,0,3,65536,0,0,0,0,0,0,0), +(-31571,0,3,0,34,0,16384,0,0,0,0), +(-32385,0,5,1,262144,0,0,0,0,0,0), +(-33142,0,0,0,0,0,0,2,0,0,0), +(-33881,0,0,0,0,0,0,2,0,0,0), +(-34485,0,9,0,1,0,0,0,0,0,0), +(-34497,0,9,2176,2281701376,0,0,0,0,0,0), +(-34935,0,0,0,0,0,0,0,0,0,8), +(-34950,0,0,0,0,0,0,2,0,0,0), +(-35100,0,9,4096,0,1,0,0,0,0,0), +(-35541,0,0,0,0,0,8388608,0,0,0,0), +(-44446,0,3,19,69632,0,0,0,0,0,0), +(-45234,0,0,0,0,0,0,2,0,0,0), +(-46867,0,0,0,0,0,0,2,0,0,0), +(-46913,0,4,64,1028,0,0,262144,0,0,0), +(-46945,0,4,0,65536,0,0,0,0,0,0), +(-47195,0,5,2,0,0,0,0,0,0,0), +(-47201,0,5,16393,262144,0,0,0,0,0,0), +(-47245,0,5,4,0,0,0,1,0,0,0), +(-47258,0,5,0,8388608,0,0,65536,0,0,0), +(-47509,0,0,0,0,0,0,2,0,0,0), +(-47516,0,6,6144,65536,0,0,0,0,0,0), +(-47569,0,6,16384,0,0,16384,0,0,100,0), +(-47580,0,6,0,0,64,0,65536,0,0,0), +(-48483,0,7,34816,1088,0,0,0,0,0,0), +(-48496,0,7,96,33554434,0,0,2,0,0,0), +(-48539,0,7,16,67108864,0,262144,0,0,0,0), +(-49004,0,0,0,0,0,0,51,0,0,0), +(-49018,0,15,20971520,0,0,0,0,0,0,0), +(-49149,0,15,6,131074,0,0,0,0,0,0), +(-49188,0,15,0,131072,0,0,0,0,0,0), +(-49219,0,0,0,0,0,4,0,0,0,0), +(-51459,0,0,0,0,0,4,0,0,0,0), +(-51523,0,11,0,1,0,65536,0,0,50,0), +(-51556,0,11,192,0,16,0,2,0,0,0), +(-51562,0,11,256,0,16,0,0,0,0,0), +(-51625,0,8,268476416,0,0,0,0,0,0,0), +(-51664,0,8,131072,8,0,0,0,0,0,0), +(-51692,0,8,516,0,0,0,0,0,0,0), +(-52795,0,6,1,0,0,0,0,0,0,0), +(-53178,0,9,0,268435456,0,65536,0,0,100,0), +(-53221,0,9,0,1,0,0,0,0,0,0), +(-53228,0,9,32,16777216,0,0,0,0,0,0), +(-53234,0,9,131072,1,1,0,2,0,0,0), +(-53256,0,9,2048,8388609,0,0,2,0,0,0), +(-53375,0,10,0,8192,0,1024,0,0,0,6), +(-53486,0,10,8388608,163840,0,0,262146,0,0,0), +(-53569,0,10,1075838976,65536,0,0,0,0,0,0), +(-53671,0,10,8388608,0,0,0,0,0,0,0), +(-53695,0,10,8388608,0,8,16,0,0,0,0), +(-53709,2,10,16384,0,0,0,0,0,0,0), +(-55666,0,15,1,134217728,0,0,0,0,0,0), +(-56333,0,9,132,134217728,147456,2359296,0,0,100,0), +(-56342,0,9,24,0,0,2097152,0,0,0,0), +(-56636,0,4,32,0,0,0,262144,0,0,6), +(-57470,0,6,1,0,0,0,0,0,0,0), +(-57878,0,0,0,0,0,0,16,0,0,0), +(-62764,0,9,0,268435456,0,65536,0,0,100,0), +(-63156,0,5,1,192,0,0,0,0,0,0), +(-63373,0,11,2147483648,0,0,65536,0,0,0,0), +(-63730,0,6,2048,4,0,0,0,0,0,0), +(-64127,0,6,1,1,524288,16384,0,0,100,0), +(-65661,0,15,4194321,537001988,0,16,0,0,100,0), +(-77794,0,11,2416967680,0,0,0,0,0,0,0), +(-82984,0,11,1,0,0,0,0,0,0,0), +(-85113,0,5,32,8388608,0,0,0,0,0,0), +(-86183,0,11,3,0,0,0,0,0,0,0); + diff --git a/sql/updates/world/2013_07_25_02_world_spell_misc_434.sql b/sql/updates/world/2013_07_25_02_world_spell_misc_434.sql new file mode 100644 index 00000000000..040d3d58dff --- /dev/null +++ b/sql/updates/world/2013_07_25_02_world_spell_misc_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceEntry` IN (81913,81914); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(24, 0, 81913, 0, 0, 38, 1, 20, 4, 0, 0, 0, 0, '', 'Die by the Sword (Rank 1) - 20% health or less'), +(24, 0, 81914, 0, 0, 38, 1, 20, 4, 0, 0, 0, 0, '', 'Die by the Sword (Rank 2) - 20% health or less'); + +DELETE FROM `spell_proc_event` WHERE `entry`=-81913; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-81913, 0, 0, 0, 0, 0, 0, 0, 0, 0, 120); diff --git a/sql/updates/world/2013_07_25_03_world_spell_script_names_434.sql b/sql/updates/world/2013_07_25_03_world_spell_script_names_434.sql new file mode 100644 index 00000000000..9bf0fa9ecee --- /dev/null +++ b/sql/updates/world/2013_07_25_03_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`IN (-17,17); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(17,'spell_pri_power_word_shield'); diff --git a/sql/updates/world/2013_07_25_04_world_spell_script_names_434.sql b/sql/updates/world/2013_07_25_04_world_spell_script_names_434.sql new file mode 100644 index 00000000000..ca2ef27a1c7 --- /dev/null +++ b/sql/updates/world/2013_07_25_04_world_spell_script_names_434.sql @@ -0,0 +1,90 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_dk_icebound_fortitude', +'spell_dk_rune_tap_party', +'spell_dk_vampiric_blood', +'spell_dru_dash', +'spell_dru_idol_lifebloom', +'spell_dru_innervate', +'spell_dru_owlkin_frenzy', +'spell_dru_rip', +'spell_dru_typhoon', +'spell_gen_create_lance', +'spell_gen_gift_of_naaru', +'spell_gen_netherbloom', +'spell_mage_fire_frost_ward', +'spell_mage_ring_of_frost', +'spell_mage_ring_of_frost_freeze', +'spell_pal_hand_of_salvation', +'spell_pri_lightwell_renew', +'spell_pri_reflective_shield_trigger', +'spell_rog_rupture', +'spell_sha_mana_tide_totem', +'spell_sha_thunderstorm', +'spell_sha_tidal_waves', +'spell_warl_ritual_of_doom_effect', +'spell_warl_shadow_ward', +'spell_warr_improved_spell_reflection', +'spell_warr_intimidating_shout', +'spell_warr_overpower', +'spell_warr_rend', +'spell_warr_shattering_throw', +'spell_warr_vigilance', +'spell_warr_vigilance_trigger', +'spell_item_arcane_shroud', +'spell_item_goblin_jumper_cables', +'spell_item_goblin_jumper_cables_xl', +'spell_item_gnomish_army_knife', +'spell_item_piccolo_of_the_flaming_fire', +'spell_item_scroll_of_recall', +'spell_item_the_eye_of_diminution', +'spell_winter_veil_px_238_winter_wondervolt'); + +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(61391, 'spell_dru_typhoon'), +(51490, 'spell_sha_thunderstorm'), +(-7235, 'spell_warl_shadow_ward'), +(7001, 'spell_pri_lightwell_renew'), +(1943, 'spell_rog_rupture'), +(1850, 'spell_dru_dash'), +(1079, 'spell_dru_rip'), +(772, 'spell_warr_rend'), +(543, 'spell_mage_fire_frost_ward'), +(1038, 'spell_pal_hand_of_salvation'), +(5246, 'spell_warr_intimidating_shout'), +(7384, 'spell_warr_overpower'), +(8342, 'spell_item_goblin_jumper_cables'), +(17512, 'spell_item_piccolo_of_the_flaming_fire'), +(18541, 'spell_warl_ritual_of_doom_effect'), +(22999, 'spell_item_goblin_jumper_cables_xl'), +(26275, 'spell_winter_veil_px_238_winter_wondervolt'), +(26400, 'spell_item_arcane_shroud'), +(28702, 'spell_gen_netherbloom'), +(28862, 'spell_item_the_eye_of_diminution'), +(28880, 'spell_gen_gift_of_naaru'), +(29166, 'spell_dru_innervate'), +(34246, 'spell_dru_idol_lifebloom'), +(16191, 'spell_sha_mana_tide_totem'), +(48129, 'spell_item_scroll_of_recall'), +(48391, 'spell_dru_owlkin_frenzy'), +(48792, 'spell_dk_icebound_fortitude'), +(50720, 'spell_warr_vigilance'), +(50725, 'spell_warr_vigilance_trigger'), +(54732, 'spell_item_gnomish_army_knife'), +(55233, 'spell_dk_vampiric_blood'), +(59542, 'spell_gen_gift_of_naaru'), +(59543, 'spell_gen_gift_of_naaru'), +(59544, 'spell_gen_gift_of_naaru'), +(59545, 'spell_gen_gift_of_naaru'), +(59547, 'spell_gen_gift_of_naaru'), +(59548, 'spell_gen_gift_of_naaru'), +(59725, 'spell_warr_improved_spell_reflection'), +(59754, 'spell_dk_rune_tap_party'), +(60320, 'spell_item_scroll_of_recall'), +(60321, 'spell_item_scroll_of_recall'), +(60779, 'spell_dru_idol_lifebloom'), +(63845, 'spell_gen_create_lance'), +(64380, 'spell_warr_shattering_throw'), +(65941, 'spell_warr_shattering_throw'), +(82676, 'spell_mage_ring_of_frost'), +(82691, 'spell_mage_ring_of_frost_freeze'), +(51562,'spell_sha_tidal_waves'); diff --git a/sql/updates/world/2013_07_25_05_world_spell_script_names_434.sql b/sql/updates/world/2013_07_25_05_world_spell_script_names_434.sql new file mode 100644 index 00000000000..bc4175a3e5e --- /dev/null +++ b/sql/updates/world/2013_07_25_05_world_spell_script_names_434.sql @@ -0,0 +1,28 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_pal_eye_for_an_eye', +'spell_warr_second_wind_proc', +'spell_hun_thrill_of_the_hunt', +'spell_dk_improved_blood_presence', +'spell_dk_improved_unholy_presence', +'spell_sha_tidal_waves', +'spell_sha_focused_insight', +'spell_sha_telluric_currents', +'spell_mage_nether_vortex', +'spell_sha_feedback', +'spell_mage_nether_vortex', +'spell_sha_rolling_thunder', +'spell_sha_lava_surge' +); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(-9799, 'spell_pal_eye_for_an_eye'), +(-29834, 'spell_warr_second_wind_proc'), +(-34497, 'spell_hun_thrill_of_the_hunt'), +(-50365, 'spell_dk_improved_blood_presence'), +(-50391, 'spell_dk_improved_unholy_presence'), +(-51562, 'spell_sha_tidal_waves'), +(-77794, 'spell_sha_focused_insight'), +(-82984, 'spell_sha_telluric_currents'), +(-86181, 'spell_mage_nether_vortex'), +(-86183, 'spell_sha_feedback'), +(-88756, 'spell_sha_rolling_thunder'), +(-77755, 'spell_sha_lava_surge'); diff --git a/sql/updates/world/2013_07_25_06_world_spell_script_names_434.sql b/sql/updates/world/2013_07_25_06_world_spell_script_names_434.sql new file mode 100644 index 00000000000..59293d491bd --- /dev/null +++ b/sql/updates/world/2013_07_25_06_world_spell_script_names_434.sql @@ -0,0 +1,16 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN ( +-62900, +-58872, +-50294, +-49158, +-49145, +-33851, +-6143, +13161, +18541, +20425, +20625, +21084, +34074, +63521, +69366); diff --git a/sql/updates/world/2013_07_25_07_world_spell_misc_434.sql b/sql/updates/world/2013_07_25_07_world_spell_misc_434.sql new file mode 100644 index 00000000000..6a2d96b5f45 --- /dev/null +++ b/sql/updates/world/2013_07_25_07_world_spell_misc_434.sql @@ -0,0 +1,66 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_gen_lifeblood', +'spell_dk_scourge_strike', +'spell_dru_starfall_dummy', +'spell_dk_death_strike', +'spell_pri_mind_sear', +'spell_dk_blood_boil', +'spell_pri_guardian_spirit', +'spell_dk_death_coil', +'spell_pri_penance', +'spell_mage_living_bomb', +'spell_dru_lifebloom', +'spell_pri_shadow_word_death', +'spell_pal_ardent_defender', +'spell_pal_holy_shock', +'spell_warr_deep_wounds', +'spell_pri_mana_burn', +'spell_dru_insect_swarm', +'spell_dru_enrage', +'spell_dru_tiger_s_fury', +'spell_rog_deadly_poison', +'spell_sha_earth_shield', +'spell_mage_frost_warding_trigger' +); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(-81708, 'spell_gen_lifeblood'), +(55090, 'spell_dk_scourge_strike'), +(50286, 'spell_dru_starfall_dummy'), +(49998, 'spell_dk_death_strike'), +(49821, 'spell_pri_mind_sear'), +(48721, 'spell_dk_blood_boil'), +(47788, 'spell_pri_guardian_spirit'), +(47541, 'spell_dk_death_coil'), +(47540, 'spell_pri_penance'), +(44457, 'spell_mage_living_bomb'), +(33763, 'spell_dru_lifebloom'), +(32379, 'spell_pri_shadow_word_death'), +(31850, 'spell_pal_ardent_defender'), +(20473, 'spell_pal_holy_shock'), +(12162, 'spell_warr_deep_wounds'), +(8129, 'spell_pri_mana_burn'), +(5570, 'spell_dru_insect_swarm'), +(5229, 'spell_dru_enrage'), +(5217, 'spell_dru_tiger_s_fury'), +(2818, 'spell_rog_deadly_poison'), +(974, 'spell_sha_earth_shield'), +(543, 'spell_mage_frost_warding_trigger'), +(52375, 'spell_dk_death_coil'), +(59134, 'spell_dk_death_coil'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (51685,31130,7235); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(51685, 51685, 1), +(51685, 51686, 2), +(51685, 51687, 3), +(51685, 51688, 4), +(51685, 51689, 5), + +(31130, 31130, 1), +(31130, 31131, 2), + +(7235, 7235, 1), +(7235, 7241, 2), +(7235, 7242, 3), +(7235, 7243, 4), +(7235, 7244, 5); diff --git a/sql/updates/world/2013_07_25_08_world_spell_script_names_434.sql b/sql/updates/world/2013_07_25_08_world_spell_script_names_434.sql new file mode 100644 index 00000000000..4250491d855 --- /dev/null +++ b/sql/updates/world/2013_07_25_08_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_dru_owlkin_frenzy'; diff --git a/sql/updates/world/2013_07_25_09_world_spell_script_names_434.sql b/sql/updates/world/2013_07_25_09_world_spell_script_names_434.sql new file mode 100644 index 00000000000..850ff1cd728 --- /dev/null +++ b/sql/updates/world/2013_07_25_09_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_lifeblood'; diff --git a/sql/updates/world/2013_07_26_00_world_spell_script_names_434.sql b/sql/updates/world/2013_07_26_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..0167401a42d --- /dev/null +++ b/sql/updates/world/2013_07_26_00_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_warr_vigilance'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(50720, 'spell_warr_vigilance'); diff --git a/sql/updates/world/2013_07_26_01_world_spell_misc_434.sql b/sql/updates/world/2013_07_26_01_world_spell_misc_434.sql new file mode 100644 index 00000000000..697e7ec6739 --- /dev/null +++ b/sql/updates/world/2013_07_26_01_world_spell_misc_434.sql @@ -0,0 +1,12 @@ +DELETE FROM `spell_dbc` WHERE `Id`=123456; +INSERT INTO `spell_dbc` (`Id`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `CastingTimeIndex`, `DurationIndex`, `RangeIndex`, `SchoolMask`, `SpellAuraOptionsId`, `SpellCastingRequirementsId`, `SpellCategoriesId`, `SpellClassOptionsId`, `SpellEquippedItemsId`, `SpellLevelsId`, `SpellTargetRestrictionsId`, `SpellInterruptsId`, `Comment`) VALUES +(123456, 0, 0, 0, 262144, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Halion - Summon Twilight Portals'); + +DELETE FROM `spelleffect_dbc` WHERE `Id` IN (153096,153097); +INSERT INTO `spelleffect_dbc` (`Id`, `Effect`, `EffectValueMultiplier`, `EffectApplyAuraName`, `EffectAplitude`, `EffectBasePoints`, `EffectBonusMultiplier`, `EffectDamageMultiplier`, `EffectChainTarget`, `EffectDieSides`, `EffectMechanic`, `EffectMiscValue`, `EffectMiscValueB`, `EffectRadiusIndex`, `EffectRadiusIndexMax`, `EffectRealPointsPerLevel`, `EffectSpellClassMaskA`, `EffectSpellClassMaskB`, `EffectSpellClassMaskC`, `EffectTriggerSpell`, `EffectImplicitTargetA`, `EffectImplicitTargetB`, `EffectSpellId`, `EffectIndex`) VALUES +(153096, 76, 0, 0, 0, 0, 0, 0, 0, 0, 0, 202796, 0, 0, 0, 0, 0, 0, 0, 0, 18, 0, 123456, 0), +(153097, 76, 0, 0, 0, 0, 0, 0, 0, 0, 0, 202796, 0, 0, 0, 0, 0, 0, 0, 0, 18, 0, 123456, 1); + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_halion_summon_exit_portals'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(123456, 'spell_halion_summon_exit_portals'); diff --git a/sql/updates/world/2013_07_26_02_world_spell_misc_434.sql b/sql/updates/world/2013_07_26_02_world_spell_misc_434.sql new file mode 100644 index 00000000000..77f271154f0 --- /dev/null +++ b/sql/updates/world/2013_07_26_02_world_spell_misc_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_warr_rend'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(94009, 'spell_warr_rend'); diff --git a/sql/updates/world/2013_07_26_03_world_spell_script_names_434.sql b/sql/updates/world/2013_07_26_03_world_spell_script_names_434.sql new file mode 100644 index 00000000000..f62fd1f66ea --- /dev/null +++ b/sql/updates/world/2013_07_26_03_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pal_hand_of_salvation'; diff --git a/sql/updates/world/2013_07_26_04_world_misc_434.sql b/sql/updates/world/2013_07_26_04_world_misc_434.sql new file mode 100644 index 00000000000..a13c55a7b3e --- /dev/null +++ b/sql/updates/world/2013_07_26_04_world_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (10568,10570); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(10568,11,0,0,'achievement_he_feeds_on_your_tears'), -- He Feeds On Your Tears (10 player) +(10570,11,0,0,'achievement_he_feeds_on_your_tears'); -- He Feeds On Your Tears (25 player) + +UPDATE `gameobject_template` SET `ScriptName`='go_blackhoof_cage' WHERE `entry`=186287; +UPDATE `creature_template` SET `ScriptName`='boss_daakara' WHERE `entry`=23863; diff --git a/sql/updates/world/2013_07_26_04_world_spell_script_names_434.sql b/sql/updates/world/2013_07_26_04_world_spell_script_names_434.sql new file mode 100644 index 00000000000..fdebced7df0 --- /dev/null +++ b/sql/updates/world/2013_07_26_04_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_magic_rooster'; diff --git a/sql/updates/world/2013_07_26_05_world_playercreateinfo_spell_434.sql b/sql/updates/world/2013_07_26_05_world_playercreateinfo_spell_434.sql new file mode 100644 index 00000000000..831d0e7d298 --- /dev/null +++ b/sql/updates/world/2013_07_26_05_world_playercreateinfo_spell_434.sql @@ -0,0 +1 @@ +UPDATE `playercreateinfo_spell` SET `classmask`=0 WHERE `Spell`=89964; diff --git a/sql/updates/world/2013_07_26_06_world_spell_misc_434.sql b/sql/updates/world/2013_07_26_06_world_spell_misc_434.sql new file mode 100644 index 00000000000..06e8895145f --- /dev/null +++ b/sql/updates/world/2013_07_26_06_world_spell_misc_434.sql @@ -0,0 +1,17 @@ +DELETE FROM `spell_proc_event` WHERE `entry`IN (-78892,-81021); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-78892, 0, 7, 0, 0, 0x30, 0x1000, 0, 0, 100, 0), +(-81021, 0, 0, 0, 0, 0, 0x10, 0, 0, 100, 0); + +DELETE FROM `spell_script_names` WHERE `spell_id`=-78892; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-78892,'spell_dru_stampede'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (81016,81021); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +-- Bear +(81016, 81016, 1), +(81016, 81017, 2), +-- Cat +(81021, 81021, 1), +(81021, 81022, 2); diff --git a/sql/updates/world/2013_07_27_00_world_spell_misc_434.sql b/sql/updates/world/2013_07_27_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..a8688b6e919 --- /dev/null +++ b/sql/updates/world/2013_07_27_00_world_spell_misc_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=-84583; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-84583, 0, 4, 0x2000000, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `spell_script_names` WHERE `spell_id`=-84583; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-84583,'spell_warr_lambs_to_the_slaughter'); diff --git a/sql/updates/world/2013_07_27_01_world_spell_proc_event_434.sql b/sql/updates/world/2013_07_27_01_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..41c30287187 --- /dev/null +++ b/sql/updates/world/2013_07_27_01_world_spell_proc_event_434.sql @@ -0,0 +1,3 @@ +DELETE FROM spell_proc_event WHERE entry=-53569; +INSERT INTO spell_proc_event (entry, SchoolMask, SpellFamilyName, SpellFamilyMask0, SpellFamilyMask1, SpellFamilyMask2, procFlags, procEx, ppmRate, CustomChance, Cooldown) VALUES +(-53569, 0, 10, 0x200000, 0x10000, 0, 0, 0x2, 0, 0, 0); diff --git a/sql/updates/world/2013_07_27_02_world_spell_misc_434.sql b/sql/updates/world/2013_07_27_02_world_spell_misc_434.sql new file mode 100644 index 00000000000..043bcc76889 --- /dev/null +++ b/sql/updates/world/2013_07_27_02_world_spell_misc_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=118; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(118,'spell_mage_polymorph'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=83046; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(83046, 83046, 1), +(83046, 83047, 2); diff --git a/sql/updates/world/2013_07_27_03_world_spell_proc_event_434.sql b/sql/updates/world/2013_07_27_03_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..84a701d2bc1 --- /dev/null +++ b/sql/updates/world/2013_07_27_03_world_spell_proc_event_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=-55666; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-55666, 0, 15, 0x01, 0x8000000, 0x2000, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_07_27_04_world_spell_misc_434.sql b/sql/updates/world/2013_07_27_04_world_spell_misc_434.sql new file mode 100644 index 00000000000..36dd8a870eb --- /dev/null +++ b/sql/updates/world/2013_07_27_04_world_spell_misc_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=82368; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(82368,'spell_warr_victorious'); + +DELETE FROM `spell_proc_event` WHERE `entry`IN (82368,-80128); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(82368, 0, 4, 0, 0x100, 0, 16, 0, 0, 100, 0), +(-80128, 0, 4, 0, 0x40, 0, 0, 0, 0, 0, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceEntry` IN (80128,80129); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(24, 0, 80128, 0, 0, 38, 1, 20, 4, 0, 0, 0, 0, '', 'Impending Victory (Rank 1) - 20% health or less'), +(24, 0, 80129, 0, 0, 38, 1, 20, 4, 0, 0, 0, 0, '', 'Impending Victory (Rank 2) - 20% health or less'); diff --git a/sql/updates/world/2013_07_27_05_world_spell_proc_event_434.sql b/sql/updates/world/2013_07_27_05_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..56716d3c5e6 --- /dev/null +++ b/sql/updates/world/2013_07_27_05_world_spell_proc_event_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=-29598; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-29598, 0, 4, 0x1000, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_07_27_06_world_spell_script_names_434.sql b/sql/updates/world/2013_07_27_06_world_spell_script_names_434.sql new file mode 100644 index 00000000000..9cf1d3e99b1 --- /dev/null +++ b/sql/updates/world/2013_07_27_06_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-51625; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-51625,'spell_rog_crippling_poison'); diff --git a/sql/updates/world/2013_07_27_07_world_spell_script_names_434.sql b/sql/updates/world/2013_07_27_07_world_spell_script_names_434.sql new file mode 100644 index 00000000000..781691f15b3 --- /dev/null +++ b/sql/updates/world/2013_07_27_07_world_spell_script_names_434.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN ( +32748,44835 +); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(32748,'spell_gen_interrupt'), +(44835,'spell_gen_interrupt'); diff --git a/sql/updates/world/2013_07_27_08_world_spell_proc_event_434.sql b/sql/updates/world/2013_07_27_08_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..5bdef4ed4a1 --- /dev/null +++ b/sql/updates/world/2013_07_27_08_world_spell_proc_event_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=-88820; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-88820, 0, 10, 0xC0000000, 0, 0x400, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_07_28_00_world_conditions_434.sql b/sql/updates/world/2013_07_28_00_world_conditions_434.sql new file mode 100644 index 00000000000..75adedb4fba --- /dev/null +++ b/sql/updates/world/2013_07_28_00_world_conditions_434.sql @@ -0,0 +1,5 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceEntry` IN (20138,20139,20140); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(24, 0, 20138, 0, 0, 33, 1, 0, 0, 0, 1, 0, 0, '', 'Protector of the Innocent (Rank 1) - cannot proc on hit self'), +(24, 0, 20139, 0, 0, 33, 1, 0, 0, 0, 1, 0, 0, '', 'Protector of the Innocent (Rank 2) - cannot proc on hit self'), +(24, 0, 20140, 0, 0, 33, 1, 0, 0, 0, 1, 0, 0, '', 'Protector of the Innocent (Rank 3) - cannot proc on hit self'); diff --git a/sql/updates/world/2013_07_28_01_world_spell_script_names_434.sql b/sql/updates/world/2013_07_28_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..890ea5317ce --- /dev/null +++ b/sql/updates/world/2013_07_28_01_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=73975; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(73975,'spell_dk_necrotic_strike'); diff --git a/sql/updates/world/2013_07_28_02_world_spell_script_names_434.sql b/sql/updates/world/2013_07_28_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..0e7b4ef719a --- /dev/null +++ b/sql/updates/world/2013_07_28_02_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=53651; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(53651,'spell_pal_beacon_of_light'); diff --git a/sql/updates/world/2013_07_28_03_world_spell_proc_event_434.sql b/sql/updates/world/2013_07_28_03_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..c3616ce5622 --- /dev/null +++ b/sql/updates/world/2013_07_28_03_world_spell_proc_event_434.sql @@ -0,0 +1,9 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=-50685; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-50685, 0, 0, 0, 0, 0, 0, 0x2, 0, 0, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceEntry` IN (50685,50686,50687); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(24, 0, 50685, 0, 0, 1, 0, 86627, 0, 0, 1, 0, 0, '', 'Incite (Rank 1) - cannot proc with already Incite aura'), +(24, 0, 50686, 0, 0, 1, 0, 86627, 0, 0, 1, 0, 0, '', 'Incite (Rank 2) - cannot proc with already Incite aura'), +(24, 0, 50687, 0, 0, 1, 0, 86627, 0, 0, 1, 0, 0, '', 'Incite (Rank 3) - cannot proc with already Incite aura'); diff --git a/sql/updates/world/2013_07_28_04_world_spell_misc_434.sql b/sql/updates/world/2013_07_28_04_world_spell_misc_434.sql new file mode 100644 index 00000000000..1af5378cf4f --- /dev/null +++ b/sql/updates/world/2013_07_28_04_world_spell_misc_434.sql @@ -0,0 +1,9 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_warr_deep_wounds'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(-12162, 'spell_warr_deep_wounds'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=12162; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(12162, 12162, 1), +(12162, 12850, 2), +(12162, 12868, 3); diff --git a/sql/updates/world/2013_07_28_05_world_spell_script_names_434.sql b/sql/updates/world/2013_07_28_05_world_spell_script_names_434.sql new file mode 100644 index 00000000000..760e453f398 --- /dev/null +++ b/sql/updates/world/2013_07_28_05_world_spell_script_names_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (31821,64364,63510,63514,63531); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(31821, 'spell_pal_aura_mastery'), +(64364, 'spell_pal_aura_mastery_immune'), +(63510, 'spell_pal_improved_concentraction_aura_effect'), +(63514, 'spell_pal_improved_devotion_aura_effect'), +(63531, 'spell_pal_sanctified_retribution_effect'); diff --git a/sql/updates/world/2013_07_29_00_world_spell_script_names_434.sql b/sql/updates/world/2013_07_29_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..ae2b65ae30c --- /dev/null +++ b/sql/updates/world/2013_07_29_00_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-19464; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-19464,'spell_hun_improved_serpent_sting'); diff --git a/sql/updates/world/2013_07_30_00_world_spell_script_names_434.sql b/sql/updates/world/2013_07_30_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..aeae886d4ec --- /dev/null +++ b/sql/updates/world/2013_07_30_00_world_spell_script_names_434.sql @@ -0,0 +1,9 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-20254,-20138,31869,-53379); + + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_warl_banish' +); + +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(710, 'spell_warl_banish'); diff --git a/sql/updates/world/2013_07_30_01_world_spell_script_names_434.sql b/sql/updates/world/2013_07_30_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..07f72b82ea7 --- /dev/null +++ b/sql/updates/world/2013_07_30_01_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=77767; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(77767,'spell_hun_cobra_shot'); diff --git a/sql/updates/world/2013_08_01_00_world_spell_script_names_434.sql b/sql/updates/world/2013_08_01_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..358b85e657b --- /dev/null +++ b/sql/updates/world/2013_08_01_00_world_spell_script_names_434.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (1784,58428); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(1784,'spell_rog_stealth'), +(58428,'spell_rog_overkill'), +(31666,'spell_rog_master_of_subtlety'); diff --git a/sql/updates/world/2013_08_01_01_world_spell_proc_event_434.sql b/sql/updates/world/2013_08_01_01_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..7bb6d5a58db --- /dev/null +++ b/sql/updates/world/2013_08_01_01_world_spell_proc_event_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=105764; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(105764, 0, 11, 0x20000000, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_08_01_02_world_spell_proc_event_434.sql b/sql/updates/world/2013_08_01_02_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..907777522d9 --- /dev/null +++ b/sql/updates/world/2013_08_01_02_world_spell_proc_event_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=-16880; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-16880, 0, 7, 0x200042, 0, 0, 0, 0, 0, 0, 60); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (48517,48518); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(48517,'spell_dru_eclipse_solar'), +(48518,'spell_dru_eclipse_lunar'); diff --git a/sql/updates/world/2013_08_03_00_world_npc_vendor_434.sql b/sql/updates/world/2013_08_03_00_world_npc_vendor_434.sql new file mode 100644 index 00000000000..7769a43f202 --- /dev/null +++ b/sql/updates/world/2013_08_03_00_world_npc_vendor_434.sql @@ -0,0 +1 @@ +UPDATE `npc_vendor` SET `maxcount`=25000 WHERE `item`=392 AND `ExtendedCost`=3408 AND `type`=2; diff --git a/sql/updates/world/2013_08_03_01_world_npc_vendor_434.sql b/sql/updates/world/2013_08_03_01_world_npc_vendor_434.sql new file mode 100644 index 00000000000..7359f10c31d --- /dev/null +++ b/sql/updates/world/2013_08_03_01_world_npc_vendor_434.sql @@ -0,0 +1,2 @@ +UPDATE `npc_vendor` SET `maxcount`=25000 WHERE `item`=390 AND `ExtendedCost`=3411 AND `type`=2; +UPDATE `npc_vendor` SET `maxcount`=25000 WHERE `item`=395 AND `ExtendedCost`=3410 AND `type`=2; diff --git a/sql/updates/world/2013_08_06_01_world_defiant_troll_434.sql b/sql/updates/world/2013_08_06_01_world_defiant_troll_434.sql new file mode 100644 index 00000000000..5188e5b3e13 --- /dev/null +++ b/sql/updates/world/2013_08_06_01_world_defiant_troll_434.sql @@ -0,0 +1,13 @@ +-- http://www.wowhead.com/quest=14069 +UPDATE `creature_template` SET `ScriptName` = 'npc_defiant_troll' WHERE `entry` = 34830; + +DELETE FROM `creature_text` WHERE `entry` = 34830; +INSERT INTO `creature_text`(`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(34830, 0, 0, 'Oops, break''s over.', 14, 0, 100, 0, 0, 0, 'defiant troll says'), +(34830, 0, 1, 'Don''t tase me, mon!', 14, 0, 100, 0, 0, 0, 'defiant troll says'), +(34830, 0, 2, 'I report you to HR!', 14, 0, 100, 0, 0, 0, 'defiant troll says'), +(34830, 0, 3, 'Work was bettah in da Undermine!', 14, 0, 100, 0, 0, 0, 'defiant troll says'), +(34830, 0, 4, 'I''m going. I''m going!', 14, 0, 100, 0, 0, 0, 'defiant troll says'), +(34830, 0, 5, 'Sorry, mon. It won''t happen again.', 14, 0, 100, 0, 0, 0, 'defiant troll says'), +(34830, 0, 6, 'What I doin'' wrong? Don''t I get a lunch and two breaks a day, mon?', 14, 0, 100, 0, 0, 0, 'defiant troll says'), +(34830, 0, 7, 'Ouch! Dat hurt!', 14, 0, 100, 0, 0, 0, 'defiant troll says'); diff --git a/sql/updates/world/2013_08_10_00_world_argaloth_434.sql b/sql/updates/world/2013_08_10_00_world_argaloth_434.sql new file mode 100644 index 00000000000..e9b8188e174 --- /dev/null +++ b/sql/updates/world/2013_08_10_00_world_argaloth_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (88954,95173,88942,95172); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(88954,'spell_argaloth_consuming_darkness'), +(95173,'spell_argaloth_consuming_darkness'), +(88942,'spell_argaloth_meteor_slash'), +(95172,'spell_argaloth_meteor_slash'); + +UPDATE `creature_template` SET `ScriptName`='boss_pit_lord_argaloth' WHERE `entry`=47120; +UPDATE `creature_template` SET `faction_A`=85,`faction_H`=85,`faction_A`=16,`faction_H`=16,`flags_extra`=128 WHERE `entry`=47829; + +DELETE FROM `creature_template_addon` WHERE `entry`=47829; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(47829, 0, 0x0, 0x1, '88999'); diff --git a/sql/updates/world/2013_08_14_00_world_occuthar_434.sql b/sql/updates/world/2013_08_14_00_world_occuthar_434.sql new file mode 100644 index 00000000000..f523a688600 --- /dev/null +++ b/sql/updates/world/2013_08_14_00_world_occuthar_434.sql @@ -0,0 +1,39 @@ +UPDATE `creature_template` SET `ScriptName`='boss_occuthar' WHERE `entry`=52363; +UPDATE `creature_template` SET `minlevel`=87,`maxlevel`=87,`exp`=3,`faction_A`=14,`faction_H`=14,`ScriptName`='npc_eyestalk',`flags_extra`=128 WHERE `entry`=52369; +UPDATE `creature_template` SET `minlevel`=87,`maxlevel`=87,`exp`=3,`faction_A`=14,`faction_H`=14,`ScriptName`='' WHERE `entry`=52389; +UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry`=52368; + +UPDATE `creature_template` SET `unit_flags`=33554432 WHERE `entry`=52369; +UPDATE `creature_template` SET `unit_flags`=2048 WHERE `entry`=52389; + +DELETE FROM `creature_template_addon` WHERE `entry`=52389; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(52389, 0, 0x0, 0x1, '96995'); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (96872,96931,96932,96942,101009); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(96872 ,'spell_occuthar_focused_fire'), +(96931 ,'spell_occuthar_eyes_of_occuthar'), +(96932 ,'spell_occuthar_eyes_of_occuthar_vehicle'), +(96942 ,'spell_occuthar_occuthars_destruction'), +(101009 ,'spell_occuthar_occuthars_destruction'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=96931; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition` ,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,96931,0,0,31,0,3,52368,0,0,0,'',''); + +DELETE FROM `creature` WHERE `id`=52368; + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=52363; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(52363, 46598, 1, 0); + +DELETE FROM `vehicle_template_accessory` WHERE `entry`=52363; +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(52363, 52368, 0, 1, 'Occu''thar - Eyestalk (Seat 1)', 8, 0), +(52363, 52368, 1, 1, 'Occu''thar - Eyestalk (Seat 2)', 8, 0), +(52363, 52368, 2, 1, 'Occu''thar - Eyestalk (Seat 3)', 8, 0), +(52363, 52368, 3, 1, 'Occu''thar - Eyestalk (Seat 4)', 8, 0), +(52363, 52368, 4, 1, 'Occu''thar - Eyestalk (Seat 5)', 8, 0), +(52363, 52368, 5, 1, 'Occu''thar - Eyestalk (Seat 6)', 8, 0), +(52363, 52368, 6, 1, 'Occu''thar - Eyestalk (Seat 7)', 8, 0); diff --git a/sql/updates/world/2013_08_14_01_world_gameobject_434.sql b/sql/updates/world/2013_08_14_01_world_gameobject_434.sql new file mode 100644 index 00000000000..430c7ee2394 --- /dev/null +++ b/sql/updates/world/2013_08_14_01_world_gameobject_434.sql @@ -0,0 +1,5 @@ +SET @OGUID := xxxx; + +DELETE FROM `gameobject` WHERE `id`=@OGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID, 209849, 757, 1, 1, 386.859, 1337.48, 170.1612, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 0);
\ No newline at end of file diff --git a/sql/updates/world/2013_08_15_00_world_spell_misc_434.sql b/sql/updates/world/2013_08_15_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..8ad29e7ec3d --- /dev/null +++ b/sql/updates/world/2013_08_15_00_world_spell_misc_434.sql @@ -0,0 +1,9 @@ +-- Grand Crusader +DELETE FROM `spell_script_names` WHERE `spell_id`=-75806; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-75806,'spell_pal_grand_crusader'); + +-- Grand Crusader can only be activated by Crusader Strike or Hammer of the Righteous +DELETE FROM `spell_proc_event` WHERE `entry`=-75806; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-75806, 0, 10, 0, 0x48000, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_08_15_00_world_spell_proc_event_434.sql b/sql/updates/world/2013_08_15_00_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..83d957d4725 --- /dev/null +++ b/sql/updates/world/2013_08_15_00_world_spell_proc_event_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry`=53390; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(53390, 11, 0, 192, 0, 65536, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_09_10_00_world_command_434.sql b/sql/updates/world/2013_09_10_00_world_command_434.sql new file mode 100644 index 00000000000..aa89539b1b0 --- /dev/null +++ b/sql/updates/world/2013_09_10_00_world_command_434.sql @@ -0,0 +1,7 @@ +/* cs_modify.cpp & cs_debug.cpp only 4.3.4 */ + +SET @id = 775; + +-- Update command table with new RBAC permissions +UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'modify currency'; +UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'debug phase'; diff --git a/sql/updates/world/2013_11_03_00_world_spell_script_names_434.sql b/sql/updates/world/2013_11_03_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..5a3a4b29db5 --- /dev/null +++ b/sql/updates/world/2013_11_03_00_world_spell_script_names_434.sql @@ -0,0 +1,2 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=77799; -- Fel Flame +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES (77799, "spell_warl_fel_flame");
\ No newline at end of file diff --git a/sql/updates/world/2014_01_14_00_world_creature_classlevelstats_434.sql b/sql/updates/world/2014_01_14_00_world_creature_classlevelstats_434.sql new file mode 100644 index 00000000000..b6273e69588 --- /dev/null +++ b/sql/updates/world/2014_01_14_00_world_creature_classlevelstats_434.sql @@ -0,0 +1,5 @@ +ALTER TABLE `creature_classlevelstats` + CHANGE `basehp0` `basehp0` MEDIUMINT(8) UNSIGNED DEFAULT 1 NOT NULL, + CHANGE `basehp1` `basehp1` MEDIUMINT(8) UNSIGNED DEFAULT 1 NOT NULL, + CHANGE `basehp2` `basehp2` MEDIUMINT(8) UNSIGNED DEFAULT 1 NOT NULL, + ADD COLUMN `damage_exp3` FLOAT DEFAULT 0 NOT NULL AFTER `damage_exp2`; diff --git a/sql/updates/world/2014_01_24_00_world_spell_script_names_434.sql b/sql/updates/world/2014_01_24_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..51030a39a85 --- /dev/null +++ b/sql/updates/world/2014_01_24_00_world_spell_script_names_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_gen_slow_roasted_turkey', +'spell_gen_cranberry_chutney', +'spell_gen_spice_bread_stuffing', +'spell_gen_pumpkin_pie', +'spell_gen_candied_sweet_potato' +); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(65422, 'spell_gen_slow_roasted_turkey'), -- Slow-Roasted Turkey +(65420, 'spell_gen_cranberry_chutney'), -- Cranberry Chutney +(65419, 'spell_gen_spice_bread_stuffing'), -- Spice Bread Stuffing +(65421, 'spell_gen_pumpkin_pie'), -- Pumpkin Pie +(65418, 'spell_gen_candied_sweet_potato'); -- Candied Sweet Potato diff --git a/sql/updates/world/2014_01_27_14_world_spell_script_names_434.sql b/sql/updates/world/2014_01_27_14_world_spell_script_names_434.sql new file mode 100644 index 00000000000..c5dbaf65ece --- /dev/null +++ b/sql/updates/world/2014_01_27_14_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=20271; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(20271,'spell_pal_judgement'); diff --git a/sql/updates/world/2014_01_29_01_world_spell_script_names_434.sql b/sql/updates/world/2014_01_29_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..7fe4b70bc38 --- /dev/null +++ b/sql/updates/world/2014_01_29_01_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (90355,80353); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(90355,'spell_hun_ancient_hysteria'), +(80353,'spell_mage_time_warp'); diff --git a/sql/updates/world/2014_03_03_00_world_quest_14069.sql b/sql/updates/world/2014_03_03_00_world_quest_14069.sql new file mode 100644 index 00000000000..6186c0d1b7f --- /dev/null +++ b/sql/updates/world/2014_03_03_00_world_quest_14069.sql @@ -0,0 +1,37 @@ +-- Good Help is Hard to Find (14069) quest script +DELETE FROM `conditions` WHERE `SourceGroup` = 34830; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(18, 34830, 66306, 0, 7, 9, 0, 14069, 0, 0, 0, 0, 0, '', 'Requires Good Help is Hard to Find quest active for spellclick'); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 34830; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(34830, 66306, 1, 0); + +DELETE FROM `creature_text` WHERE `entry` = 34830; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(34830, 0, 0, 'Don''t tase me, mon!', 12, 0, 100, 0, 0, 0, 'Defiant Troll'), +(34830, 0, 1, 'I report you to HR!', 12, 0, 100, 0, 0, 0, 'Defiant Troll'), +(34830, 0, 2, 'I''m going. I''m going!', 12, 0, 100, 0, 0, 0, 'Defiant Troll'), +(34830, 0, 3, 'Oops, break''s over.', 12, 0, 100, 0, 0, 0, 'Defiant Troll'), +(34830, 0, 4, 'Sorry, mon. It won''t happen again.', 12, 0, 100, 0, 0, 0, 'Defiant Troll'), +(34830, 0, 5, 'What I doin'' wrong? Don''t I get a lunch and two breaks a day, mon?', 12, 0, 100, 0, 0, 0, 'Defiant Troll'), +(34830, 0, 6, 'Work was bettah in da Undermine!', 12, 0, 100, 0, 0, 0, 'Defiant Troll'); + +UPDATE `creature_template` SET `AIName` = "SmartAI", `ScriptName` = '' WHERE `entry` = 34830; + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (34830, 3483000, 3483001, 3483002, 3483003, 3483004); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(34830, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 11, 45111, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - on spawn - cast Enrage on self (45111)'), +(34830, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 87, 3483001, 3483002, 3483003, 3483004, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - linked - random actionlist/emote state'), +(3483001, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - emote state'), +(3483002, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 12, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - emote state'), +(3483003, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 26, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - emote state'), +(3483004, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 378, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - emote state'), +(34830, 0, 5, 0, 8, 0, 100, 1, 66306, 0, 0, 0, 80, 3483000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - on spellhit (66306) - run actionlist (3483000)'), +(3483000, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 83, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - remove npc_spellclick_spells flag'), +(3483000, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 45111, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - remove Enrage (45111)'), +(3483000, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 26, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - set emote state (26)'), +(3483000, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 34830, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - give quest credit (34830)'), +(3483000, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - say text 0'), +(3483000, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 89, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - set random movement'), +(3483000, 9, 6, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - actionlist - despawn'); diff --git a/sql/updates/world/2014_04_21_02_world_guild_xp_for_level_434.sql b/sql/updates/world/2014_04_21_02_world_guild_xp_for_level_434.sql new file mode 100644 index 00000000000..5e8d12c5855 --- /dev/null +++ b/sql/updates/world/2014_04_21_02_world_guild_xp_for_level_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE `guild_xp_for_level` + CHANGE `lvl` `lvl` TINYINT(3) UNSIGNED NOT NULL, + CHANGE `xp_for_next_level` `xp_for_next_level` INT(10) UNSIGNED NOT NULL; diff --git a/sql/updates/world/2014_04_26_01_world_game_event.sql b/sql/updates/world/2014_04_26_01_world_game_event.sql new file mode 100644 index 00000000000..c87525f1074 --- /dev/null +++ b/sql/updates/world/2014_04_26_01_world_game_event.sql @@ -0,0 +1,17 @@ +DELETE FROM `game_event` WHERE `eventEntry` IN (65,66,67,68,69,70,71); +INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `world_event`, `announce`) VALUES +(65, '2008-11-23 00:01:00', '2008-11-23 23:59:00', 525600, 1440, 0, 'WoW''s 4th Anniversary', 0, 2), +(66, '2009-11-22 00:01:00', '2009-12-06 23:59:00', 525600, 10080, 0, 'WoW''s 5th Anniversary', 0, 2), +(67, '2010-11-30 00:01:00', '2010-12-14 23:59:00', 525600, 10080, 0, 'WoW''s 6th Anniversary', 0, 2), +(68, '2011-11-20 00:01:00', '2011-12-03 23:59:00', 525600, 10080, 467, 'WoW''s 7th Anniversary', 0, 2), +(69, '2012-11-18 00:01:00', '2012-12-01 23:59:00', 525600, 10080, 484, 'WoW''s 8th Anniversary', 0, 2), +(70, '2013-11-18 00:01:00', '2013-12-01 23:59:00', 525600, 10080, 0/*509*/, 'WoW''s 9th Anniversary', 0, 2), +(71, '2014-11-17 00:01:00', '2014-12-01 23:59:00', 525600, 10080, 0/*514*/, 'WoW''s 10th Anniversary', 0, 2); + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (9058, 12562,16082,17804,18500); +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(9058, 24, 65, 0, ''), -- WoW''s 4th Anniversary' +(12562, 24, 66, 0, ''), -- WoW''s 5th Anniversary +(16082, 24, 67, 0, ''), -- WoW''s 6th Anniversary +(17804, 16, 467, 0, ''), -- WoW''s 7th Anniversary +(18500, 16, 484, 0, ''); -- WoW''s 8th Anniversary diff --git a/sql/updates/world/2014_06_01_00_world_phases_434.sql b/sql/updates/world/2014_06_01_00_world_phases_434.sql new file mode 100644 index 00000000000..a073498d745 --- /dev/null +++ b/sql/updates/world/2014_06_01_00_world_phases_434.sql @@ -0,0 +1,6 @@ +ALTER TABLE `creature` + ADD `PhaseId` INT(10) DEFAULT '0' AFTER `phaseMask`, + ADD `PhaseGroup` INT(10) DEFAULT '0' AFTER `PhaseId`; +ALTER TABLE `gameobject` + ADD `PhaseId` INT(10) DEFAULT '0' AFTER `phaseMask`, + ADD `PhaseGroup` INT(10) DEFAULT '0' AFTER `PhaseId`; |