Scripts/Commands: Allow to set a custom duration to the Freeze command applied Aura

- Allow to set a default duration for the Freeze Aura in worldserver.conf
- Handle the .freeze and .unfreeze command custom effects through the Freeze AuraScript
- Make players able to eventually unfreeze by themselves since the aura will expire without someone having to use .unfreeze
- Make .freeze command usable with the following syntax:

      * .freeze (with a targeted player)
      * .freeze duration_in_seconds (with a targeted player)
      * .freeze playername duration (if duration is an invalid value it will be defaulted to the config one)
      * .freeze playername (in this case, duration will be defaulted to the config value)

- Make .listfreeze command able to show the remaining freeze duration on all affected players

Closes #12972

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/2014_09_08_01_world_freeze_cmd.sql b/sql/updates/world/2014_09_08_01_world_freeze_cmd.sql
new file mode 100644
index 00000000000..e2c7d53336b
--- /dev/null
+++ b/sql/updates/world/2014_09_08_01_world_freeze_cmd.sql
@@ -0,0 +1,17 @@
+-- GM Freeze Spell Script
+DELETE FROM `spell_script_names` WHERE `spell_id`=9454;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (9454, 'spell_gen_gm_freeze');
+
+-- Update Command Help
+UPDATE `command` SET `help`='Syntax: .freeze [#player] [#duration]
+Freezes #player for #duration (seconds)
+Freezes the selected player if no arguments are given.
+Default duration: GM.FreezeAuraDuration (worldserver.conf)' WHERE `name`='freeze';
+
+-- Add new string to show the duration on the freeze upon using .listfreeze
+DELETE FROM `trinity_string` WHERE `entry`=5019;
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(5019, '| %s - Status: %d seconds left');
+
+-- Update old string to show if the duration is permanent
+UPDATE `trinity_string` SET `content_default`='| %s - Status: Permanently frozen' WHERE `entry`=5006;