diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7156_01_mangos_spell_proc_event.sql | 5 | ||||
| -rw-r--r-- | sql/updates/7168_01_mangos_command.sql | 6 | ||||
| -rw-r--r-- | sql/updates/7175_01_mangos_spell_proc_event.sql | 13 |
3 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/7156_01_mangos_spell_proc_event.sql b/sql/updates/7156_01_mangos_spell_proc_event.sql new file mode 100644 index 00000000000..82e9d264932 --- /dev/null +++ b/sql/updates/7156_01_mangos_spell_proc_event.sql @@ -0,0 +1,5 @@ +ALTER TABLE db_version CHANGE COLUMN required_7150_01_mangos_playercreateinfo_spell required_7156_01_mangos_spell_proc_event bit; + +-- (44401) Missile Barrage () +DELETE FROM `spell_proc_event` WHERE `entry` IN (44401); +INSERT INTO `spell_proc_event` VALUES (44401, 0x00, 3, 0x00200000, 0x00000000, 0x00000000, 0x00000000, 0x00000FFF, 0.000000, 0.000000, 0); diff --git a/sql/updates/7168_01_mangos_command.sql b/sql/updates/7168_01_mangos_command.sql new file mode 100644 index 00000000000..67bbd5e3194 --- /dev/null +++ b/sql/updates/7168_01_mangos_command.sql @@ -0,0 +1,6 @@ +ALTER TABLE db_version CHANGE COLUMN required_7156_01_mangos_spell_proc_event required_7168_01_mangos_command bit; + +DELETE FROM `command` WHERE `name` IN ('learn','unlearn'); +INSERT INTO `command` VALUES +('learn',3,'Syntax: .learn #spell [all]\r\n\r\nSelected character learn a spell of id #spell. If \'all\' provided then all ranks learned.'), +('unlearn',3,'Syntax: .unlearn #spell [all]\r\n\r\nUnlearn for selected player a spell #spell. If \'all\' provided then all ranks unlearned.'); diff --git a/sql/updates/7175_01_mangos_spell_proc_event.sql b/sql/updates/7175_01_mangos_spell_proc_event.sql new file mode 100644 index 00000000000..57e02defea4 --- /dev/null +++ b/sql/updates/7175_01_mangos_spell_proc_event.sql @@ -0,0 +1,13 @@ +ALTER TABLE db_version CHANGE COLUMN required_7168_01_mangos_command required_7175_01_mangos_spell_proc_event bit; + +-- (56333) T.N.T. (Rank 1) +DELETE FROM `spell_proc_event` WHERE `entry` IN (56333); +INSERT INTO `spell_proc_event` VALUES (56333, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); + +-- (56336) T.N.T. (Rank 2) +DELETE FROM `spell_proc_event` WHERE `entry` IN (56336); +INSERT INTO `spell_proc_event` VALUES (56336, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); + +-- (56337) T.N.T. (Rank 3) +DELETE FROM `spell_proc_event` WHERE `entry` IN (56337); +INSERT INTO `spell_proc_event` VALUES (56337, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file |