aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorteacher <none@none>2010-04-22 18:50:14 +0200
committerteacher <none@none>2010-04-22 18:50:14 +0200
commit00c2674553950b4fb89d072a28c76bd6419e4fb1 (patch)
tree3fe5413a3d02e07e0f94e50a90a35e5464c214f6 /sql/updates
parentab396beb56b74bc18922055d89230f0b3b19312b (diff)
Make Divine Guardian proc on Divine Sacrifice only (by Liberate).
Removed DB data not handled by Core Team. You can find it on Database forums. Added missing recently committed data to world.sql... Renamed an old file which had wrong name. --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/3.3.3a_old/7893_characters_item_instance.sql (renamed from sql/updates/3.3.3a_old/7893_characters_characters.sql)0
-rw-r--r--sql/updates/7980_world_spell_area.sql4
-rw-r--r--sql/updates/7982_world_spell_proc_event.sql4
3 files changed, 4 insertions, 4 deletions
diff --git a/sql/updates/3.3.3a_old/7893_characters_characters.sql b/sql/updates/3.3.3a_old/7893_characters_item_instance.sql
index 3dea7f98e27..3dea7f98e27 100644
--- a/sql/updates/3.3.3a_old/7893_characters_characters.sql
+++ b/sql/updates/3.3.3a_old/7893_characters_item_instance.sql
diff --git a/sql/updates/7980_world_spell_area.sql b/sql/updates/7980_world_spell_area.sql
deleted file mode 100644
index cabf39f6d62..00000000000
--- a/sql/updates/7980_world_spell_area.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-INSERT IGNORE INTO spell_area (spell, area, quest_start, quest_start_active, quest_end, aura_spell, racemask, gender, autocast) VALUES
-(74411, 3358, 0, 0, 0, 0, 0, 2, 1),(74411, 2597, 0, 0, 0, 0, 0, 2, 1),(74411, 4384, 0, 0, 0, 0, 0, 2, 1),(74411, 3277, 0, 0, 0, 0, 0, 2, 1),
-(74411, 3820, 0, 0, 0, 0, 0, 2, 1),(74411, 4710, 0, 0, 0, 0, 0, 2, 1),(74411, 4197, 0, 0, 0, 0, 0, 2, 1),(74410, 4378, 0, 0, 0, 0, 0, 2, 1),
-(74410, 4406, 0, 0, 0, 0, 0, 2, 1),(74410, 3968, 0, 0, 0, 0, 0, 2, 1),(74410, 3702, 0, 0, 0, 0, 0, 2, 1),(74410, 3698, 0, 0, 0, 0, 0, 2, 1);
diff --git a/sql/updates/7982_world_spell_proc_event.sql b/sql/updates/7982_world_spell_proc_event.sql
new file mode 100644
index 00000000000..0f21c884c75
--- /dev/null
+++ b/sql/updates/7982_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+-- Make Divine Guardian proc on Divine Sacrifice only
+DELETE FROM `spell_proc_event` WHERE `entry`=53530;
+INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES
+(53530,1,10,0x0000,0x0000,0x0004,0x0400,0x0001,0,100,0);