From 5b12c496137618a3bdf87fa8b7f299f3b420f5d1 Mon Sep 17 00:00:00 2001
From: nos4r2zod <nos4r2zod@getmangos.com>
Date: Sat, 25 Jul 2009 08:05:42 +0400
Subject: [PATCH] [8247] Some data for `spell_bonus_data` for DK spells.

Signed-off-by: VladimirMangos <vladimir@getmangos.com>
---
 sql/mangos.sql                                  | 17 ++++++++++++++++-
 sql/updates/8247_01_mangos_spell_bonus_data.sql | 18 ++++++++++++++++++
 sql/updates/Makefile.am                         |  2 ++
 src/shared/revision_nr.h                        |  2 +-
 4 files changed, 37 insertions(+), 2 deletions(-)
 create mode 100644 sql/updates/8247_01_mangos_spell_bonus_data.sql

diff --git a/sql/mangos.sql b/sql/mangos.sql
index b29f4d989..2666460ad 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`;
 CREATE TABLE `db_version` (
   `version` varchar(120) default NULL,
   `creature_ai_version` varchar(120) default NULL,
-  `required_8237_01_mangos_creature_template` bit(1) default NULL
+  `required_8247_01_mangos_spell_bonus_data` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -17699,6 +17699,21 @@ CREATE TABLE `spell_bonus_data` (
 LOCK TABLES `spell_bonus_data` WRITE;
 /*!40000 ALTER TABLE `spell_bonus_data` DISABLE KEYS */;
 INSERT INTO `spell_bonus_data` VALUES
+('49941', '0', '0', '0.04', 'Death Knight - Blood Boil'),
+('55078', '0', '0', '0.055', 'Death Knight - Blood Plague Dummy Proc'),
+('50444', '0', '0', '0.105', 'Death Knight - Corpse Explosion Triggered'),
+('52212', '0', '0', '0.0475', 'Death Knight - Death and Decay Triggered'),
+('47632', '0', '0', '0.15', 'Death Knight - Death Coil Damage'),
+('47633', '0', '0', '0.15', 'Death Knight - Death Coil Heal'),
+('55095', '0', '0', '0.055', 'Death Knight - Frost Fever'),
+('49184', '0', '0', '0.1', 'Death Knight - Howling Blast'),
+('45477', '0', '0', '0.1', 'Death Knight - Icy Touch'),
+('50842', '0', '0', '0.04', 'Death Knight - Pestilence'),
+('47476', '0', '0', '0.06', 'Death Knight - Strangulate'),
+('50536', '0', '0', '0.013', 'Death Knight - Unholy Blight Triggered'),
+('50401', '0', '0', '0', 'Death Knight - Razor Frost'),
+('56903', '0', '0', '0', 'Death Knight - Lichflame'),
+
 ('5185', '1.6104', '0', '0', 'Druid - Healing Touch'),
 ('33763', '0', '0.09518', '0', 'Druid - Lifebloom'),
 ('774', '0', '0.37604', '0', 'Druid - Rejuvenation'),
diff --git a/sql/updates/8247_01_mangos_spell_bonus_data.sql b/sql/updates/8247_01_mangos_spell_bonus_data.sql
new file mode 100644
index 000000000..9af02b45d
--- /dev/null
+++ b/sql/updates/8247_01_mangos_spell_bonus_data.sql
@@ -0,0 +1,18 @@
+ALTER TABLE db_version CHANGE COLUMN required_8237_01_mangos_creature_template required_8247_01_mangos_spell_bonus_data bit;
+
+DELETE FROM `spell_bonus_data` where entry in (49941, 55078, 50444, 52212, 47632, 47633, 55095, 49184, 45477, 45477, 50842, 47476, 50536, 50401, 56903);
+INSERT INTO `spell_bonus_data`(`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES
+(49941, 0, 0, 0.04, "Death Knight - Blood Boil"),
+(55078, 0, 0, 0.055, "Death Knight - Blood Plague Dummy Proc"),
+(50444, 0, 0, 0.105, "Death Knight - Corpse Explosion Triggered"),
+(52212, 0, 0, 0.0475, "Death Knight - Death and Decay Triggered"),
+(47632, 0, 0, 0.15, "Death Knight - Death Coil Damage"),
+(47633, 0, 0, 0.15, "Death Knight - Death Coil Heal"),
+(55095, 0, 0, 0.055, "Death Knight - Frost Fever"),
+(49184, 0, 0, 0.1, "Death Knight - Howling Blast"),
+(45477, 0, 0, 0.1, "Death Knight - Icy Touch"),
+(50842, 0, 0, 0.04, "Death Knight - Pestilence"),
+(47476, 0, 0, 0.06, "Death Knight - Strangulate"),
+(50536, 0, 0, 0.013, "Death Knight - Unholy Blight Triggered"),
+(50401, 0, 0, 0, "Death Knight - Razor Frost"),
+(56903, 0, 0, 0, "Death Knight - Lichflame");
diff --git a/sql/updates/Makefile.am b/sql/updates/Makefile.am
index 69c34b2ad..584629ea5 100644
--- a/sql/updates/Makefile.am
+++ b/sql/updates/Makefile.am
@@ -251,6 +251,7 @@ pkgdata_DATA = \
 	8213_01_mangos_spell_bonus_data.sql \
 	8227_01_mangos_spell_proc_event.sql \
 	8237_01_mangos_creature_template.sql \
+	8247_01_mangos_spell_bonus_data.sql \
 	README
 
 ## Additional files to include when running 'make dist'
@@ -482,4 +483,5 @@ EXTRA_DIST = \
 	8213_01_mangos_spell_bonus_data.sql \
 	8227_01_mangos_spell_proc_event.sql \
 	8237_01_mangos_creature_template.sql \
+	8247_01_mangos_spell_bonus_data.sql \
 	README
diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h
index 4897d3ac8..a62b7ab7d 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 "8246"
+ #define REVISION_NR "8247"
 #endif // __REVISION_NR_H__
-- 
2.11.4.GIT