diff options
| author | Machiavelli <machiavelli.trinity@gmail.com> | 2011-07-27 17:51:57 +0200 |
|---|---|---|
| committer | Machiavelli <machiavelli.trinity@gmail.com> | 2011-07-27 17:51:57 +0200 |
| commit | 0dcc22907114508141cbabbca69aeaa0791feb79 (patch) | |
| tree | 7c06ff9c085d0f10825f12951e41178de852f644 /sql | |
| parent | 2eb69330b4f15e1fad6702a4829420c1a7f33208 (diff) | |
Core/Commands: Allow muting offline players - the mute will become effective on next player login.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 2 | ||||
| -rw-r--r-- | sql/base/world_database.sql | 1 | ||||
| -rw-r--r-- | sql/updates/auth/2011_07_27_00_auth_account.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2011_07_27_01_world_trinity_string.sql | 2 |
4 files changed, 5 insertions, 1 deletions
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 |