From 0dcc22907114508141cbabbca69aeaa0791feb79 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Wed, 27 Jul 2011 17:51:57 +0200 Subject: Core/Commands: Allow muting offline players - the mute will become effective on next player login. --- sql/base/auth_database.sql | 2 +- sql/base/world_database.sql | 1 + sql/updates/auth/2011_07_27_00_auth_account.sql | 1 + sql/updates/world/2011_07_27_01_world_trinity_string.sql | 2 ++ 4 files changed, 5 insertions(+), 1 deletion(-) create mode 100644 sql/updates/auth/2011_07_27_00_auth_account.sql create mode 100644 sql/updates/world/2011_07_27_01_world_trinity_string.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 1890ea3838b..4aad22245d5 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -61,7 +61,7 @@ CREATE TABLE `account` ( `last_login` timestamp NOT NULL default '0000-00-00 00:00:00', `online` tinyint(4) NOT NULL default '0', `expansion` tinyint(3) unsigned NOT NULL default '2', - `mutetime` bigint(40) unsigned NOT NULL default '0', + `mutetime` bigint(40) NOT NULL default '0', `locale` tinyint(3) unsigned NOT NULL default '0', `recruiter` int(11) NOT NULL default '0', PRIMARY KEY (`id`), diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index d2e7781cf63..812dd8c6b99 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -27147,6 +27147,7 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_ (280, 'Vendor has too many items (max 128)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (281, 'You can''t kick self, logout instead', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (282, 'Player %s kicked.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(283, 'You have disabled %s\'s chat for %u minutes, effective at the player\'s next login. Reason: %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (284, 'Accepting Whisper: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (285, 'Accepting Whisper: ON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (286, 'Accepting Whisper: OFF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), diff --git a/sql/updates/auth/2011_07_27_00_auth_account.sql b/sql/updates/auth/2011_07_27_00_auth_account.sql new file mode 100644 index 00000000000..34393d518fc --- /dev/null +++ b/sql/updates/auth/2011_07_27_00_auth_account.sql @@ -0,0 +1 @@ +ALTER TABLE `account` CHANGE `mutetime` `mutetime` bigint(40) NOT NULL DEFAULT 0; \ No newline at end of file diff --git a/sql/updates/world/2011_07_27_01_world_trinity_string.sql b/sql/updates/world/2011_07_27_01_world_trinity_string.sql new file mode 100644 index 00000000000..9e36d27ed37 --- /dev/null +++ b/sql/updates/world/2011_07_27_01_world_trinity_string.sql @@ -0,0 +1,2 @@ +INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES +(283,'You have disabled %s\'s chat for %u minutes, effective at the player\'s next login. Reason: %s.'); \ No newline at end of file -- cgit v1.2.3