diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/4667_8251_02_mangos_spell_bonus_data.sql | 23 | ||||
| -rw-r--r-- | sql/updates/4667_8251_03_mangos_spell_proc_event.sql | 8 |
2 files changed, 31 insertions, 0 deletions
diff --git a/sql/updates/4667_8251_02_mangos_spell_bonus_data.sql b/sql/updates/4667_8251_02_mangos_spell_bonus_data.sql new file mode 100644 index 00000000000..ca9614fff3e --- /dev/null +++ b/sql/updates/4667_8251_02_mangos_spell_bonus_data.sql @@ -0,0 +1,23 @@ +-- ALTER TABLE db_version CHANGE COLUMN required_8251_01_mangos_spell_chain required_8251_02_mangos_spell_bonus_data bit; + +DELETE FROM `spell_bonus_data` where entry in ( + 49941,48721, + 8037,10458,16352,16353,25501,58797,58798,58799,18937,18938,27265,59092,49941, + 7269,7270,8419,8418,10273,10274,25346,27076,38700,38703,42844,42845, + 42209,42210,42211,42212,42213,42198,42937,42938, + 43043,43044, + 25911,25902,27176,33073,48822,48823, + 25913,25903,27175,33074,48820,48821, + 23458,23459,27803,27804,27805,25329, + 53022, + 8504,8505,11310,11311,25538,25539,61651,61660, + 8028,8029,10445,16343,16344,25488,58786,58787,58788, + 26365,26366,26367,26369,26370,26363,26371,26372,49278,49279, + 10582,10583,10584,25551,58733,58736, + 6350,6351,6352,10435,10436,25530,58700,58701,58702, + 11681,11682,27214,47822, + 42224,42225,42226,42218,47817,47818 +); + +INSERT INTO `spell_bonus_data` VALUES +('48721', '0', '0', '0.04', 'Death Knight - Blood Boil'); diff --git a/sql/updates/4667_8251_03_mangos_spell_proc_event.sql b/sql/updates/4667_8251_03_mangos_spell_proc_event.sql new file mode 100644 index 00000000000..d07659e6096 --- /dev/null +++ b/sql/updates/4667_8251_03_mangos_spell_proc_event.sql @@ -0,0 +1,8 @@ +-- ALTER TABLE db_version CHANGE COLUMN required_8251_02_mangos_spell_bonus_data required_8251_03_mangos_spell_proc_event bit; + +DELETE FROM `spell_proc_event` WHERE entry IN ( + 325,905,945,8134,8494,8495,10191,10192,10193,10431,10432,14318,14319,14320, + 14321,14322,20927,20928,24398,25296,25469,25472,25899,27044,27131,27179,32593, + 32594,33736,33776,34916,34917,43019,43020,63158,48159,48160,48951,48952,49280, + 49281,49283,49284,52129,52131,52134,52136,52138,57960,48112,48113,63733,63737 +); |
