From 9b56360b4c898c19d2762fe6ce04c08aca4df0d4 Mon Sep 17 00:00:00 2001 From: QAston Date: Fri, 31 Jul 2009 14:58:25 +0200 Subject: *Remove world_tmp_full - templates made by core devs are going to be included in update sqls with _TDB suffix and after thatadded to db converters. *Remove some useless mangos sqls. --HG-- branch : trunk --- sql/updates/8253_02_mangos_spell_proc_event.sql.tbd | 21 --------------------- sql/updates/8254_01_mangos_spell_proc_event.sql.tbd | 6 ------ 2 files changed, 27 deletions(-) delete mode 100644 sql/updates/8253_02_mangos_spell_proc_event.sql.tbd delete mode 100644 sql/updates/8254_01_mangos_spell_proc_event.sql.tbd (limited to 'sql/updates') diff --git a/sql/updates/8253_02_mangos_spell_proc_event.sql.tbd b/sql/updates/8253_02_mangos_spell_proc_event.sql.tbd deleted file mode 100644 index 8e3472cbc0d..00000000000 --- a/sql/updates/8253_02_mangos_spell_proc_event.sql.tbd +++ /dev/null @@ -1,21 +0,0 @@ -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 deleted file mode 100644 index 9be2487810e..00000000000 --- a/sql/updates/8254_01_mangos_spell_proc_event.sql.tbd +++ /dev/null @@ -1,6 +0,0 @@ -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); -- cgit v1.2.3