From 00c2674553950b4fb89d072a28c76bd6419e4fb1 Mon Sep 17 00:00:00 2001 From: teacher 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 ++++ sql/world.sql | 5 ++++- 5 files changed, 18 insertions(+), 15 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') 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); diff --git a/sql/world.sql b/sql/world.sql index 1129e9596e4..6fdf7173557 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -6478,6 +6478,7 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam ( 31836, 0x00, 10, 0x80000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Light's Grace (Rank 3) ( 31871, 0x00, 10, 0x00000010, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Divine Purpose (Rank 1) ( 31872, 0x00, 10, 0x00000010, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Divine Purpose (Rank 2) +( 53530, 1, 10, 0x00000000, 0x00000000, 0x0004, 0x0400, 0x0001, 0, 100, 0), -- Divine Guardian ( 31876, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Wise (Rank 1) ( 31877, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Wise (Rank 2) ( 31878, 0x00, 10, 0x00800000, 0x00000000, 0x00000000, 0x00000000, 0x00040000, 0, 0, 0), -- Judgements of the Wise (Rank 3) @@ -7135,7 +7136,9 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam ( 58375, 0x00, 4, 0x00000000, 0x00000200, 0x00000000, 0x00000010, 0x00000000, 0, 0, 0), -- Glyph of Blocking ( 58387, 0x00, 4, 0x00004000, 0x00000040, 0x00000000, 0x00000010, 0x00000000, 0, 0, 0), -- Glyph of Sunder Armor ( 54925, 0x02, 10, 0x00000000, 0x00000208, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Glyph of Seal of Command -( 67356, 0x08, 7, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Druid T9 Restoration Relic (Rejuvenation) +( 67356, 0x08, 7, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Druid T9 Restoration Relic (Rejuvenation) +( 67771, 1, 0, 0x00000000, 0x00000000, 0x00000000, 0x0851154, 0x03, 0, 35, 45), -- Item - Coliseum Melee Trinket 10men +( 67702, 1, 0, 0x00000000, 0x00000000, 0x00000000, 0x0851154, 0x03, 0, 35, 45); -- Item - Coliseum Melee Trinket 25men /*!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS */; UNLOCK TABLES; -- cgit v1.2.3