diff options
| author | p0wer <none@none> | 2009-12-21 21:08:29 -0600 |
|---|---|---|
| committer | p0wer <none@none> | 2009-12-21 21:08:29 -0600 |
| commit | 75904791863494b213c5b8ae2a864910a5d4ca35 (patch) | |
| tree | ad36a802e978f42a1730cdb1bb20f9e3271b6aea /sql/updates | |
| parent | cad203e680f1f40585880ef32e210fdc02316ff9 (diff) | |
* Add support for different gmlevel's for different realms.
*
* Using the value -1 will add the same value for all realms.
* Make sure to apply the updates.
* Information regarding this patch will be posted on the database forums soon.
*
* Thanks to Sundark and the Ilixiuemu team(for original patch)
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/6710_realmd_account_access.sql | 14 | ||||
| -rw-r--r-- | sql/updates/6710_world_command.sql | 3 | ||||
| -rw-r--r-- | sql/updates/6710_world_trinity_string.sql | 2 |
3 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/6710_realmd_account_access.sql b/sql/updates/6710_realmd_account_access.sql new file mode 100644 index 00000000000..3349f2f69e8 --- /dev/null +++ b/sql/updates/6710_realmd_account_access.sql @@ -0,0 +1,14 @@ +-- Table structure for `account_access` +DROP TABLE IF EXISTS `account_access`; +CREATE TABLE `account_access` ( + `id` bigint(20) unsigned NOT NULL, + `gmlevel` tinyint(3) unsigned NOT NULL, + `RealmID` int(11) NOT NULL, + PRIMARY KEY (`id`,`RealmID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; +-- export current gm account to the new table +-- RealmID -1 = all realms +INSERT INTO `account_access` (id, gmlevel, RealmID) +SELECT `id`, `gmlevel`, -1 FROM `account` WHERE `gmlevel` > 0; +-- Remove the gmlevel field from account +ALTER TABLE account DROP COLUMN `gmlevel`; diff --git a/sql/updates/6710_world_command.sql b/sql/updates/6710_world_command.sql new file mode 100644 index 00000000000..9aba5be5d56 --- /dev/null +++ b/sql/updates/6710_world_command.sql @@ -0,0 +1,3 @@ +UPDATE command +SET help = 'Syntax: .account set gmlevel [$account] #level [#realmid]\r\n\r\nSet the security level for targeted player (can\'t be used at self) or for account $name to a level of #level on the realm #realmID.\r\n\r\n#level may range from 0 to 3.\r\n\r\n#reamID may be -1 for all realms.' +WHERE name = 'account set gmlevel';
\ No newline at end of file diff --git a/sql/updates/6710_world_trinity_string.sql b/sql/updates/6710_world_trinity_string.sql new file mode 100644 index 00000000000..0a4abb66740 --- /dev/null +++ b/sql/updates/6710_world_trinity_string.sql @@ -0,0 +1,2 @@ +INSERT INTO trinity_string VALUES +(11001, 'You have not chosen -1 or the current realmID that you are on.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
\ No newline at end of file |