From d604ca11575244b8bafb814fdc3453ac7ecaad40 Mon Sep 17 00:00:00 2001
From: VladimirMangos <vladimir@getmangos.com>
Date: Tue, 8 Jun 2010 17:30:14 +0400
Subject: [PATCH] [10045] Frop unexpected custom rank data for 26016.

This make spell rank use first rank data.
---
 sql/mangos.sql                                   | 3 +--
 sql/updates/10045_01_mangos_spell_proc_event.sql | 3 +++
 sql/updates/Makefile.am                          | 2 ++
 src/shared/revision_nr.h                         | 2 +-
 src/shared/revision_sql.h                        | 2 +-
 5 files changed, 8 insertions(+), 4 deletions(-)
 create mode 100644 sql/updates/10045_01_mangos_spell_proc_event.sql

diff --git a/sql/mangos.sql b/sql/mangos.sql
index d6de4e8d6..84b3c8c96 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_10044_02_mangos_spell_proc_event` bit(1) default NULL
+  `required_10045_01_mangos_spell_proc_event` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -17873,7 +17873,6 @@ INSERT INTO `spell_proc_event` VALUES
 (24932, 0x00,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000,  6),
 (25050, 0x04,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
 (25669, 0x00,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 1.000000, 0.000000,  0),
-(26016, 0x00,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 2.000000, 0.000000,  0),
 (26107, 0x00,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000064, 0.000000, 0.000000,  0),
 (26119, 0x00, 10, 0x90100003, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000,  0),
 (26128, 0x00,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000008, 0.000000, 0.000000,  0),
diff --git a/sql/updates/10045_01_mangos_spell_proc_event.sql b/sql/updates/10045_01_mangos_spell_proc_event.sql
new file mode 100644
index 000000000..c9c88d6a8
--- /dev/null
+++ b/sql/updates/10045_01_mangos_spell_proc_event.sql
@@ -0,0 +1,3 @@
+ALTER TABLE db_version CHANGE COLUMN required_10044_02_mangos_spell_proc_event required_10045_01_mangos_spell_proc_event bit;
+
+DELETE FROM  `spell_proc_event` WHERE `entry` IN (26016);
diff --git a/sql/updates/Makefile.am b/sql/updates/Makefile.am
index 1b15eca02..d4c536e43 100644
--- a/sql/updates/Makefile.am
+++ b/sql/updates/Makefile.am
@@ -86,6 +86,7 @@ pkgdata_DATA = \
 	10036_01_mangos_spell_proc_event.sql \
 	10044_01_mangos_spell_chain.sql \
 	10044_02_mangos_spell_proc_event.sql \
+	10045_01_mangos_spell_proc_event.sql \
 	README
 
 ## Additional files to include when running 'make dist'
@@ -152,4 +153,5 @@ EXTRA_DIST = \
 	10036_01_mangos_spell_proc_event.sql \
 	10044_01_mangos_spell_chain.sql \
 	10044_02_mangos_spell_proc_event.sql \
+	10045_01_mangos_spell_proc_event.sql \
 	README
diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h
index 86d57390a..b63a740ea 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 "10044"
+ #define REVISION_NR "10045"
 #endif // __REVISION_NR_H__
diff --git a/src/shared/revision_sql.h b/src/shared/revision_sql.h
index 4cbac181e..eca15540a 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_10007_01_characters_pet_aura"
- #define REVISION_DB_MANGOS "required_10044_02_mangos_spell_proc_event"
+ #define REVISION_DB_MANGOS "required_10045_01_mangos_spell_proc_event"
  #define REVISION_DB_REALMD "required_10008_01_realmd_realmd_db_version"
 #endif // __REVISION_SQL_H__
-- 
2.11.4.GIT