aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorQAston <none@none>2009-07-31 13:21:32 +0200
committerQAston <none@none>2009-07-31 13:21:32 +0200
commitb212461f95aad264b608abfb88e66e0cf4ce511f (patch)
treef97ca6171659153c6f045e71b33332e3ef1d178f /sql/updates
parent1f53433c6c4de01709410581ba644be7e6aaf6fe (diff)
parent40f7c7243cae08cda7b129ac13d4768414753b4e (diff)
*Merge after backout.
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/8253_02_mangos_spell_proc_event.sql.tbd21
-rw-r--r--sql/updates/8254_01_mangos_spell_proc_event.sql.tbd6
2 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/8253_02_mangos_spell_proc_event.sql.tbd b/sql/updates/8253_02_mangos_spell_proc_event.sql.tbd
new file mode 100644
index 00000000000..8e3472cbc0d
--- /dev/null
+++ b/sql/updates/8253_02_mangos_spell_proc_event.sql.tbd
@@ -0,0 +1,21 @@
+ALTER TABLE db_version CHANGE COLUMN required_8253_01_mangos_spell_chain required_8253_02_mangos_spell_proc_event bit;
+
+/*Bandit's Insignia*/
+DELETE FROM `spell_proc_event` WHERE entry IN (60442);
+INSERT INTO spell_proc_event VALUES
+(60442, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45);
+
+/*Seal of wisdom*/
+DELETE FROM `spell_proc_event` WHERE `entry` IN (20166);
+INSERT INTO `spell_proc_event` VALUES
+(20166, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,15.000000, 0.000000, 0);
+
+/*Shadow embrace*/
+DELETE FROM `spell_proc_event` WHERE `entry` IN (32385);
+INSERT INTO `spell_proc_event` VALUES
+(32385, 0x00000000, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
+
+/*Maelstrom Weapon*/
+DELETE FROM `spell_proc_event` WHERE `entry` IN (51528);
+INSERT INTO `spell_proc_event` VALUES
+(51528, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,12.500000, 0.000000, 0);
diff --git a/sql/updates/8254_01_mangos_spell_proc_event.sql.tbd b/sql/updates/8254_01_mangos_spell_proc_event.sql.tbd
new file mode 100644
index 00000000000..9be2487810e
--- /dev/null
+++ b/sql/updates/8254_01_mangos_spell_proc_event.sql.tbd
@@ -0,0 +1,6 @@
+ALTER TABLE db_version CHANGE COLUMN required_8253_02_mangos_spell_proc_event required_8254_01_mangos_spell_proc_event bit;
+
+DELETE FROM `spell_proc_event` WHERE `entry` IN (55747,60436);
+INSERT INTO `spell_proc_event` VALUES
+(55747, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(60436, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45);