From 0ef0db5a3866efad9de4bb2a8eef681f6bf8253e Mon Sep 17 00:00:00 2001 From: VladimirMangos Date: Wed, 25 Nov 2009 16:50:20 +0300 Subject: [PATCH] [8873] Implement proper spell activation for 56815. Learn part suggested by Lightguard Spell proc part sugested by Fullburned. Signed-off-by: VladimirMangos --- sql/mangos.sql | 4 +++- sql/updates/8873_01_mangos_spell_proc_event.sql | 6 ++++++ sql/updates/8873_02_mangos_spell_learn_spell.sql | 4 ++++ sql/updates/Makefile.am | 4 ++++ src/shared/revision_nr.h | 2 +- src/shared/revision_sql.h | 2 +- 6 files changed, 19 insertions(+), 3 deletions(-) create mode 100644 sql/updates/8873_01_mangos_spell_proc_event.sql create mode 100644 sql/updates/8873_02_mangos_spell_learn_spell.sql diff --git a/sql/mangos.sql b/sql/mangos.sql index be816d7ef..0338d06c1 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -24,7 +24,7 @@ CREATE TABLE `db_version` ( `version` varchar(120) default NULL, `creature_ai_version` varchar(120) default NULL, `cache_id` int(10) default '0', - `required_8863_01_mangos_spell_proc_event` bit(1) default NULL + `required_8873_02_mangos_spell_learn_spell` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -17470,6 +17470,7 @@ INSERT INTO `spell_learn_spell` VALUES (34769,33388,1), (53428,53341,1), (53428,53343,1), +(56815,56816,0), (58984,21009,1); /*!40000 ALTER TABLE `spell_learn_spell` ENABLE KEYS */; UNLOCK TABLES; @@ -18305,6 +18306,7 @@ INSERT INTO `spell_proc_event` VALUES (56636, 0x00000000, 4, 0x00000020, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 6), (56637, 0x00000000, 4, 0x00000020, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 6), (56638, 0x00000000, 4, 0x00000020, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 6), +(56816, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000030, 0.000000, 0.000000, 0), (56821, 0x00000000, 8, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), (56822, 0x00000000, 15, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0), (56834, 0x00000000, 15, 0x00440000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0), diff --git a/sql/updates/8873_01_mangos_spell_proc_event.sql b/sql/updates/8873_01_mangos_spell_proc_event.sql new file mode 100644 index 000000000..498e2b99d --- /dev/null +++ b/sql/updates/8873_01_mangos_spell_proc_event.sql @@ -0,0 +1,6 @@ +ALTER TABLE db_version CHANGE COLUMN required_8863_01_mangos_spell_proc_event required_8873_01_mangos_spell_proc_event bit; + +-- (56816) Rune Strike () +DELETE FROM `spell_proc_event` WHERE `entry` IN (56816); +INSERT INTO `spell_proc_event` VALUES +(56816, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000030, 0.000000, 0.000000, 0); diff --git a/sql/updates/8873_02_mangos_spell_learn_spell.sql b/sql/updates/8873_02_mangos_spell_learn_spell.sql new file mode 100644 index 000000000..67f13225d --- /dev/null +++ b/sql/updates/8873_02_mangos_spell_learn_spell.sql @@ -0,0 +1,4 @@ +ALTER TABLE db_version CHANGE COLUMN required_8873_01_mangos_spell_proc_event required_8873_02_mangos_spell_learn_spell bit; + +DELETE FROM spell_learn_spell WHERE SpellID = 56816; +INSERT INTO spell_learn_spell VALUES (56815, 56816, 0); diff --git a/sql/updates/Makefile.am b/sql/updates/Makefile.am index 49ebef8f3..99d8c9f85 100644 --- a/sql/updates/Makefile.am +++ b/sql/updates/Makefile.am @@ -172,6 +172,8 @@ pkgdata_DATA = \ 8851_01_mangos_spell_proc_event.sql \ 8856_01_mangos_spell_proc_event.sql \ 8863_01_mangos_spell_proc_event.sql \ + 8873_01_mangos_spell_proc_event.sql \ + 8873_02_mangos_spell_learn_spell.sql \ README ## Additional files to include when running 'make dist' @@ -324,4 +326,6 @@ EXTRA_DIST = \ 8851_01_mangos_spell_proc_event.sql \ 8856_01_mangos_spell_proc_event.sql \ 8863_01_mangos_spell_proc_event.sql \ + 8873_01_mangos_spell_proc_event.sql \ + 8873_02_mangos_spell_learn_spell.sql \ README diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h index 5c34e2b59..4a0847810 100644 --- a/src/shared/revision_nr.h +++ b/src/shared/revision_nr.h @@ -1,4 +1,4 @@ #ifndef __REVISION_NR_H__ #define __REVISION_NR_H__ - #define REVISION_NR "8872" + #define REVISION_NR "8873" #endif // __REVISION_NR_H__ diff --git a/src/shared/revision_sql.h b/src/shared/revision_sql.h index e59f33119..4836f289f 100644 --- a/src/shared/revision_sql.h +++ b/src/shared/revision_sql.h @@ -1,6 +1,6 @@ #ifndef __REVISION_SQL_H__ #define __REVISION_SQL_H__ #define REVISION_DB_CHARACTERS "required_8843_01_characters" - #define REVISION_DB_MANGOS "required_8863_01_mangos_spell_proc_event" + #define REVISION_DB_MANGOS "required_8873_02_mangos_spell_learn_spell" #define REVISION_DB_REALMD "required_8728_01_realmd_account" #endif // __REVISION_SQL_H__ -- 2.11.4.GIT