aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKandera <KanderaDev@gmail.com>2012-04-25 15:17:38 -0400
committerKandera <KanderaDev@gmail.com>2012-04-25 15:17:52 -0400
commitede6c38a43f462356868bef6771f2fc09f6362e8 (patch)
treeff2f5cc98873e37f632181783bcf0b22af84ebce
parent1b5fa3a6f3cc1ac0ace75a3d0676e7ea044eb0de (diff)
DB/Spells: fixes the effect stacking of Greater/Blessing of Sanctuary/Kings. Closes #768
-rw-r--r--sql/updates/world/2012_04_25_03_world_spell_group.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_25_03_world_spell_group.sql b/sql/updates/world/2012_04_25_03_world_spell_group.sql
new file mode 100644
index 00000000000..a6fa90ad41d
--- /dev/null
+++ b/sql/updates/world/2012_04_25_03_world_spell_group.sql
@@ -0,0 +1,11 @@
+DELETE FROM `spell_group` WHERE `id` IN (1117,1118);
+INSERT INTO `spell_group` (`id`,`spell_id`) VALUES
+(1117,25898),
+(1117,25899),
+(1118,20911),
+(1118,20217);
+
+DELETE FROM `spell_group_stack_rules` WHERE `group_id` in (1117,1118);
+INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES
+(1117,3),
+(1118,3);