From 159353c4e1ff060cae426a9e08ec53223047dc87 Mon Sep 17 00:00:00 2001 From: jon <1337 h4x0r@.(none)> Date: Mon, 24 Oct 2011 12:50:17 +0200 Subject: Fix Misery talent being activated by Mind Flay --- sql/updates/world/2011_10_24_00_world_spell_proc_event.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2011_10_24_00_world_spell_proc_event.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_10_24_00_world_spell_proc_event.sql b/sql/updates/world/2011_10_24_00_world_spell_proc_event.sql new file mode 100644 index 00000000000..32fb23ddbee --- /dev/null +++ b/sql/updates/world/2011_10_24_00_world_spell_proc_event.sql @@ -0,0 +1 @@ +UPDATE `spell_proc_event` SET `SpellFamilyMask2`=64 WHERE `entry`=33193; \ No newline at end of file -- cgit v1.2.3 From f9b0cdd4f80f2ea3f2a4c42380a839e1665ee6f4 Mon Sep 17 00:00:00 2001 From: PKX Date: Wed, 23 Nov 2011 11:24:45 +0100 Subject: DB/Misc: Removed obsolete spell_groups Removes some obsolete and wrong spell_groups. Closes #2462, #1519 and #3968 --- sql/updates/world/2011_11_23_00_world_spell_group.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2011_11_23_00_world_spell_group.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_23_00_world_spell_group.sql b/sql/updates/world/2011_11_23_00_world_spell_group.sql new file mode 100644 index 00000000000..f7258dc882f --- /dev/null +++ b/sql/updates/world/2011_11_23_00_world_spell_group.sql @@ -0,0 +1,7 @@ +-- Blessing of Sanctuary + Grace +DELETE FROM `spell_group` WHERE `id`>=1091 AND `id`<=1093 LIMIT 4; +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1093 LIMIT 1; + +-- Ebon Plague + Curse of Elements + Earth and Moon +DELETE FROM `spell_group` WHERE `id`>=1040 AND `id`<=1043 LIMIT 6; +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1043 LIMIT 1; \ No newline at end of file -- cgit v1.2.3 From 6e943ef1cc23699e044ed0cf29f2a98f26943a7d Mon Sep 17 00:00:00 2001 From: Shocker Date: Sat, 26 Nov 2011 20:41:43 +0200 Subject: SQL: File namings after recent pulls --- sql/updates/world/2011_10_24_00_world_spell_proc_event.sql | 1 - sql/updates/world/2011_11_23_00_world_spell_group.sql | 7 ------- sql/updates/world/2011_11_26_02_world_spell_group.sql | 7 +++++++ sql/updates/world/2011_11_26_03_world_spell_proc_event.sql | 2 ++ 4 files changed, 9 insertions(+), 8 deletions(-) delete mode 100644 sql/updates/world/2011_10_24_00_world_spell_proc_event.sql delete mode 100644 sql/updates/world/2011_11_23_00_world_spell_group.sql create mode 100644 sql/updates/world/2011_11_26_02_world_spell_group.sql create mode 100644 sql/updates/world/2011_11_26_03_world_spell_proc_event.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_10_24_00_world_spell_proc_event.sql b/sql/updates/world/2011_10_24_00_world_spell_proc_event.sql deleted file mode 100644 index 32fb23ddbee..00000000000 --- a/sql/updates/world/2011_10_24_00_world_spell_proc_event.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `spell_proc_event` SET `SpellFamilyMask2`=64 WHERE `entry`=33193; \ No newline at end of file diff --git a/sql/updates/world/2011_11_23_00_world_spell_group.sql b/sql/updates/world/2011_11_23_00_world_spell_group.sql deleted file mode 100644 index f7258dc882f..00000000000 --- a/sql/updates/world/2011_11_23_00_world_spell_group.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Blessing of Sanctuary + Grace -DELETE FROM `spell_group` WHERE `id`>=1091 AND `id`<=1093 LIMIT 4; -DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1093 LIMIT 1; - --- Ebon Plague + Curse of Elements + Earth and Moon -DELETE FROM `spell_group` WHERE `id`>=1040 AND `id`<=1043 LIMIT 6; -DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1043 LIMIT 1; \ No newline at end of file diff --git a/sql/updates/world/2011_11_26_02_world_spell_group.sql b/sql/updates/world/2011_11_26_02_world_spell_group.sql new file mode 100644 index 00000000000..71ad2eaf9fb --- /dev/null +++ b/sql/updates/world/2011_11_26_02_world_spell_group.sql @@ -0,0 +1,7 @@ +-- Blessing of Sanctuary + Grace +DELETE FROM `spell_group` WHERE `id`>=1091 AND `id`<=1093 LIMIT 4; +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1093 LIMIT 1; + +-- Ebon Plague + Curse of Elements + Earth and Moon +DELETE FROM `spell_group` WHERE `id`>=1040 AND `id`<=1043 LIMIT 6; +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1043 LIMIT 1; diff --git a/sql/updates/world/2011_11_26_03_world_spell_proc_event.sql b/sql/updates/world/2011_11_26_03_world_spell_proc_event.sql new file mode 100644 index 00000000000..36837be8ab6 --- /dev/null +++ b/sql/updates/world/2011_11_26_03_world_spell_proc_event.sql @@ -0,0 +1,2 @@ +-- Misery +UPDATE `spell_proc_event` SET `SpellFamilyMask2` = `SpellFamilyMask2` | 64 WHERE `entry` = 33193; -- cgit v1.2.3 From 57db81938985750c255a89fb58e7045b74ee7d65 Mon Sep 17 00:00:00 2001 From: Shocker Date: Sat, 26 Nov 2011 21:15:10 +0200 Subject: SQL: Add SQLs for recent pull --- sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql | 3 +++ sql/updates/world/2011_11_26_04_world_disables.sql | 1 + 2 files changed, 4 insertions(+) create mode 100644 sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql create mode 100644 sql/updates/world/2011_11_26_04_world_disables.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql b/sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..b037bf58349 --- /dev/null +++ b/sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql @@ -0,0 +1,3 @@ +DELETE FROM `achievement_criteria_data` WHERE `type` = 11 AND `criteria_id` = 7363; +INSERT INTO `achievement_criteria_data` VALUES +(7363, 11, 0, 0, 'achievement_snakes_whyd_it_have_to_be_snakes'); diff --git a/sql/updates/world/2011_11_26_04_world_disables.sql b/sql/updates/world/2011_11_26_04_world_disables.sql new file mode 100644 index 00000000000..4722f248656 --- /dev/null +++ b/sql/updates/world/2011_11_26_04_world_disables.sql @@ -0,0 +1 @@ +DELETE FROM `disables` WHERE entry = 7363 AND sourceType = 4; -- cgit v1.2.3 From 1d4a77bbe1b0a56a16406b809096bb6a0920688b Mon Sep 17 00:00:00 2001 From: Giuseppe Montesanto Date: Sat, 26 Nov 2011 20:36:04 +0100 Subject: Set right gameobject spawn in Ulduar. --- sql/updates/world/2011_11_26_05_ulduar_gameobject.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2011_11_26_05_ulduar_gameobject.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql b/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql new file mode 100644 index 00000000000..b48e10b28be --- /dev/null +++ b/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql @@ -0,0 +1,2 @@ +-- Set all gameobjects in Ulduar (escluding chests, including veins and herbs) spawned in 10 and 25 man difficult. +UPDATE `gameobject` SET `spawnMask` = 3 WHERE `id` IN (194555, 194232, 194675, 194560, 194569, 194370, 194371, 194630, 194631, 194375, 194377, 194634, 194635, 194636, 194637, 194904, 194905, 194907, 194398, 194399, 194400, 194401, 194402, 194914, 194403, 194915, 194404, 194405, 194406, 194407, 194663, 194408, 194664, 194665, 194409, 194666, 194410, 194411, 194412, 194413, 194414, 194415, 194416, 194437, 194441, 194442, 194704, 194705, 194706, 194707, 194481, 194484, 194235, 194236, 194750, 194506, 194255, 194773, 194261, 194262, 194264, 194553, 194554, 194556, 194557, 194558, 194559, 194565, 194912, 194913, 194739, 194740, 194741, 194742, 194743, 194744, 194745, 194746, 194747, 194748, 194749, 194774, 194775, 194776) AND `map` = 603; \ No newline at end of file -- cgit v1.2.3 From f5d2eef2dcb5515b428e51498da55d2b48ffe5a1 Mon Sep 17 00:00:00 2001 From: Giuseppe Montesanto Date: Sat, 26 Nov 2011 20:41:44 +0100 Subject: Add missing newline. --- sql/updates/world/2011_11_26_05_ulduar_gameobject.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql b/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql index b48e10b28be..05c68e0d067 100644 --- a/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql +++ b/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql @@ -1,2 +1,2 @@ -- Set all gameobjects in Ulduar (escluding chests, including veins and herbs) spawned in 10 and 25 man difficult. -UPDATE `gameobject` SET `spawnMask` = 3 WHERE `id` IN (194555, 194232, 194675, 194560, 194569, 194370, 194371, 194630, 194631, 194375, 194377, 194634, 194635, 194636, 194637, 194904, 194905, 194907, 194398, 194399, 194400, 194401, 194402, 194914, 194403, 194915, 194404, 194405, 194406, 194407, 194663, 194408, 194664, 194665, 194409, 194666, 194410, 194411, 194412, 194413, 194414, 194415, 194416, 194437, 194441, 194442, 194704, 194705, 194706, 194707, 194481, 194484, 194235, 194236, 194750, 194506, 194255, 194773, 194261, 194262, 194264, 194553, 194554, 194556, 194557, 194558, 194559, 194565, 194912, 194913, 194739, 194740, 194741, 194742, 194743, 194744, 194745, 194746, 194747, 194748, 194749, 194774, 194775, 194776) AND `map` = 603; \ No newline at end of file +UPDATE `gameobject` SET `spawnMask` = 3 WHERE `id` IN (194555, 194232, 194675, 194560, 194569, 194370, 194371, 194630, 194631, 194375, 194377, 194634, 194635, 194636, 194637, 194904, 194905, 194907, 194398, 194399, 194400, 194401, 194402, 194914, 194403, 194915, 194404, 194405, 194406, 194407, 194663, 194408, 194664, 194665, 194409, 194666, 194410, 194411, 194412, 194413, 194414, 194415, 194416, 194437, 194441, 194442, 194704, 194705, 194706, 194707, 194481, 194484, 194235, 194236, 194750, 194506, 194255, 194773, 194261, 194262, 194264, 194553, 194554, 194556, 194557, 194558, 194559, 194565, 194912, 194913, 194739, 194740, 194741, 194742, 194743, 194744, 194745, 194746, 194747, 194748, 194749, 194774, 194775, 194776) AND `map` = 603; -- cgit v1.2.3 From 1c410d20131a562bca5a65631d9b5091605cb9e2 Mon Sep 17 00:00:00 2001 From: Giuseppe Montesanto Date: Sat, 26 Nov 2011 20:49:42 +0100 Subject: Typo fix. --- sql/updates/world/2011_11_26_05_ulduar_gameobject.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql b/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql index 05c68e0d067..60ba0aefbeb 100644 --- a/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql +++ b/sql/updates/world/2011_11_26_05_ulduar_gameobject.sql @@ -1,2 +1,2 @@ --- Set all gameobjects in Ulduar (escluding chests, including veins and herbs) spawned in 10 and 25 man difficult. +-- Set all gameobjects in Ulduar (excluding chests, including veins and herbs) spawned in 10 and 25 man difficult. UPDATE `gameobject` SET `spawnMask` = 3 WHERE `id` IN (194555, 194232, 194675, 194560, 194569, 194370, 194371, 194630, 194631, 194375, 194377, 194634, 194635, 194636, 194637, 194904, 194905, 194907, 194398, 194399, 194400, 194401, 194402, 194914, 194403, 194915, 194404, 194405, 194406, 194407, 194663, 194408, 194664, 194665, 194409, 194666, 194410, 194411, 194412, 194413, 194414, 194415, 194416, 194437, 194441, 194442, 194704, 194705, 194706, 194707, 194481, 194484, 194235, 194236, 194750, 194506, 194255, 194773, 194261, 194262, 194264, 194553, 194554, 194556, 194557, 194558, 194559, 194565, 194912, 194913, 194739, 194740, 194741, 194742, 194743, 194744, 194745, 194746, 194747, 194748, 194749, 194774, 194775, 194776) AND `map` = 603; -- cgit v1.2.3