From 14b82b9fab04e249fbffb0d89dae068a64d79ba4 Mon Sep 17 00:00:00 2001 From: Drahy Date: Fri, 8 May 2009 09:48:44 +0200 Subject: * Updated trinity sql coding style --HG-- branch : trunk --- sql/updates/3121_world_scripts.sql | 2 +- sql/updates/3178_mangos_7777_01_world_spell_proc_event.sql | 6 ++++++ sql/updates/7777_01_mangos_spell_proc_event.sql | 6 ------ 3 files changed, 7 insertions(+), 7 deletions(-) create mode 100644 sql/updates/3178_mangos_7777_01_world_spell_proc_event.sql delete mode 100644 sql/updates/7777_01_mangos_spell_proc_event.sql (limited to 'sql') diff --git a/sql/updates/3121_world_scripts.sql b/sql/updates/3121_world_scripts.sql index 543c4473541..af79cbd0cfd 100644 --- a/sql/updates/3121_world_scripts.sql +++ b/sql/updates/3121_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHERE `entry` = 24079; +UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHERE `entry` = 24079; \ No newline at end of file diff --git a/sql/updates/3178_mangos_7777_01_world_spell_proc_event.sql b/sql/updates/3178_mangos_7777_01_world_spell_proc_event.sql new file mode 100644 index 00000000000..e441a9099f7 --- /dev/null +++ b/sql/updates/3178_mangos_7777_01_world_spell_proc_event.sql @@ -0,0 +1,6 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7776_01_mangos_npc_spellclick_spells required_7777_01_mangos_spell_proc_event bit;*/ + +DELETE FROM spell_proc_event WHERE entry IN (30299,30301,30302); +INSERT INTO spell_proc_event VALUES (30299, 0x0000007E, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); +INSERT INTO spell_proc_event VALUES (30301, 0x0000007E, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); +INSERT INTO spell_proc_event VALUES (30302, 0x0000007E, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); \ No newline at end of file diff --git a/sql/updates/7777_01_mangos_spell_proc_event.sql b/sql/updates/7777_01_mangos_spell_proc_event.sql deleted file mode 100644 index e54db2854f3..00000000000 --- a/sql/updates/7777_01_mangos_spell_proc_event.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7776_01_mangos_npc_spellclick_spells required_7777_01_mangos_spell_proc_event bit; - -DELETE FROM spell_proc_event WHERE entry IN (30299,30301,30302); -INSERT INTO spell_proc_event VALUES (30299, 0x0000007E, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); -INSERT INTO spell_proc_event VALUES (30301, 0x0000007E, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); -INSERT INTO spell_proc_event VALUES (30302, 0x0000007E, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); -- cgit v1.2.3