From 00c2674553950b4fb89d072a28c76bd6419e4fb1 Mon Sep 17 00:00:00 2001
From: teacher <none@none>
Date: Thu, 22 Apr 2010 18:50:14 +0200
Subject: 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
---
 sql/updates/3.3.3a_old/7893_characters_characters.sql    | 10 ----------
 sql/updates/3.3.3a_old/7893_characters_item_instance.sql | 10 ++++++++++
 sql/updates/7980_world_spell_area.sql                    |  4 ----
 sql/updates/7982_world_spell_proc_event.sql              |  4 ++++
 4 files changed, 14 insertions(+), 14 deletions(-)
 delete mode 100644 sql/updates/3.3.3a_old/7893_characters_characters.sql
 create mode 100644 sql/updates/3.3.3a_old/7893_characters_item_instance.sql
 delete mode 100644 sql/updates/7980_world_spell_area.sql
 create mode 100644 sql/updates/7982_world_spell_proc_event.sql

(limited to 'sql/updates')

diff --git a/sql/updates/3.3.3a_old/7893_characters_characters.sql b/sql/updates/3.3.3a_old/7893_characters_characters.sql
deleted file mode 100644
index 3dea7f98e27..00000000000
--- a/sql/updates/3.3.3a_old/7893_characters_characters.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-UPDATE item_instance SET data = REPLACE(data,'  ',' ');
-UPDATE item_instance SET data = CONCAT(TRIM(data),' ');
-
-UPDATE `item_instance` SET `data` = CONCAT(
-	SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ',
-	SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ')
-WHERE length(SUBSTRING_INDEX(data, ' ', 64)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 64+1)) >= length(data);
-
-UPDATE item_instance SET data = REPLACE(data,'  ',' ');
-UPDATE item_instance SET data = CONCAT(TRIM(data),' ');
diff --git a/sql/updates/3.3.3a_old/7893_characters_item_instance.sql b/sql/updates/3.3.3a_old/7893_characters_item_instance.sql
new file mode 100644
index 00000000000..3dea7f98e27
--- /dev/null
+++ b/sql/updates/3.3.3a_old/7893_characters_item_instance.sql
@@ -0,0 +1,10 @@
+UPDATE item_instance SET data = REPLACE(data,'  ',' ');
+UPDATE item_instance SET data = CONCAT(TRIM(data),' ');
+
+UPDATE `item_instance` SET `data` = CONCAT(
+	SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ',
+	SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ')
+WHERE length(SUBSTRING_INDEX(data, ' ', 64)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 64+1)) >= length(data);
+
+UPDATE item_instance SET data = REPLACE(data,'  ',' ');
+UPDATE item_instance SET data = CONCAT(TRIM(data),' ');
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);
-- 
cgit v1.2.3