diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_11_05_00_world.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_05_00_world.sql b/sql/updates/world/master/2024_11_05_00_world.sql new file mode 100644 index 00000000000..794502aa58b --- /dev/null +++ b/sql/updates/world/master/2024_11_05_00_world.sql @@ -0,0 +1,25 @@ +SET @SPELL_GROUP := 1500; + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_rog_poisoned_knife'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(185565, 'spell_rog_poisoned_knife'); + +-- Non-lethal poisons +DELETE FROM `spell_group` WHERE `id`= @SPELL_GROUP; +INSERT INTO `spell_group` (`id`, `spell_id`) VALUES +(@SPELL_GROUP, 5761), +(@SPELL_GROUP, 381637), +(@SPELL_GROUP, 3408); + +-- Lethal poisons +DELETE FROM `spell_group` WHERE `id`= @SPELL_GROUP+1; +INSERT INTO `spell_group` (`id`, `spell_id`) VALUES +(@SPELL_GROUP+1, 315584), +(@SPELL_GROUP+1, 8679), +(@SPELL_GROUP+1, 2823), +(@SPELL_GROUP+1, 381664); + +DELETE FROM `spell_group_stack_rules` WHERE `group_id` IN (@SPELL_GROUP, @SPELL_GROUP+1); +INSERT INTO `spell_group_stack_rules` (`group_id`, `stack_rule`) VALUES +(@SPELL_GROUP, 1), +(@SPELL_GROUP+1, 1); |
