From 7ff14fe1dc04e306c27ee6065b4ae0b6a34a2392 Mon Sep 17 00:00:00 2001
From: VladimirMangos <vladimir@getmangos.com>
Date: Fri, 25 Dec 2009 18:58:54 +0300
Subject: [PATCH] [9064] More internal cooldowns for some intem spells.

---
 sql/mangos.sql                                  | 8 ++++++--
 sql/updates/9064_01_mangos_spell_proc_event.sql | 8 ++++++++
 sql/updates/Makefile.am                         | 2 ++
 src/shared/revision_nr.h                        | 2 +-
 src/shared/revision_sql.h                       | 2 +-
 5 files changed, 18 insertions(+), 4 deletions(-)
 create mode 100644 sql/updates/9064_01_mangos_spell_proc_event.sql

diff --git a/sql/mangos.sql b/sql/mangos.sql
index a06223972..52f14be03 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_9045_02_mangos_spell_chain` bit(1) default NULL
+  `required_9064_01_mangos_spell_proc_event` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -18209,6 +18209,7 @@ INSERT INTO `spell_proc_event` VALUES
 (45243, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000,  0),
 (45244, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000,  0),
 (45354, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(45355, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
 (45481, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
 (45482, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
 (45483, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
@@ -18535,7 +18536,10 @@ INSERT INTO `spell_proc_event` VALUES
 (65661, 0x00000000, 15, 0x00400011, 0x00020004, 0x00000000, 0x00000010, 0x00000001, 0.000000, 100.000000,0),
 (64127, 0x00000000,  6, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
 (67353, 0x00000000,  7, 0x00008000, 0x00100500, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
-(67667, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45);
+(67667, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(67672, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 50),
+(67702, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(67771, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45);
 
 /*!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS */;
 UNLOCK TABLES;
diff --git a/sql/updates/9064_01_mangos_spell_proc_event.sql b/sql/updates/9064_01_mangos_spell_proc_event.sql
new file mode 100644
index 000000000..387a6f1d1
--- /dev/null
+++ b/sql/updates/9064_01_mangos_spell_proc_event.sql
@@ -0,0 +1,8 @@
+ALTER TABLE db_version CHANGE COLUMN required_9045_02_mangos_spell_chain required_9064_01_mangos_spell_proc_event bit;
+
+DELETE FROM spell_proc_event WHERE entry IN (45355,67672,67702,67771);
+INSERT INTO spell_proc_event VALUES
+(45355, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(67672, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 50),
+(67702, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(67771, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45);
diff --git a/sql/updates/Makefile.am b/sql/updates/Makefile.am
index f07dec653..bd6d6606f 100644
--- a/sql/updates/Makefile.am
+++ b/sql/updates/Makefile.am
@@ -219,6 +219,7 @@ pkgdata_DATA = \
 	9034_01_mangos_spell_proc_event.sql \
 	9045_01_mangos_spell_proc_event.sql \
 	9045_02_mangos_spell_chain.sql \
+	9064_01_mangos_spell_proc_event.sql \
 	README
 
 ## Additional files to include when running 'make dist'
@@ -418,4 +419,5 @@ EXTRA_DIST = \
 	9034_01_mangos_spell_proc_event.sql \
 	9045_01_mangos_spell_proc_event.sql \
 	9045_02_mangos_spell_chain.sql \
+	9064_01_mangos_spell_proc_event.sql \
 	README
diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h
index d90d2442e..a1196b4d2 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 "9063"
+ #define REVISION_NR "9064"
 #endif // __REVISION_NR_H__
diff --git a/src/shared/revision_sql.h b/src/shared/revision_sql.h
index c649603f6..15450dd34 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_8874_01_characters_character_skills"
- #define REVISION_DB_MANGOS "required_9045_02_mangos_spell_chain"
+ #define REVISION_DB_MANGOS "required_9064_01_mangos_spell_proc_event"
  #define REVISION_DB_REALMD "required_9010_01_realmd_realmlist"
 #endif // __REVISION_SQL_H__
-- 
2.11.4.GIT