From fb52e9ea035f6174e6925e97ed8eaf15f9867d6a Mon Sep 17 00:00:00 2001 From: Ascathor Date: Sun, 26 May 2013 01:52:28 +0200 Subject: Core/Command: Optimized .pinfo more * Moved some checks around * Added RBAC Permission for Email, last login and last ip (group 3 and 4) -- If missing RBAC permission, then it displays "Unauthorized (RBAC)" * Changed totalmail output from uint64 to uint32 * Level either puts Max level, or a list of information necessary * Only queries guild if the current xp query also detects guild membership * Incorporated recent changes into code * Commander requires higher than target to get sensitive data beside RBAC permission. --- sql/updates/auth/2013_05_26_00_auth_rbac.sql | 14 ++++++++++++++ sql/updates/world/2013_05_26_00_world_trinity_string.sql | 9 +++++++++ 2 files changed, 23 insertions(+) create mode 100644 sql/updates/auth/2013_05_26_00_auth_rbac.sql create mode 100644 sql/updates/world/2013_05_26_00_world_trinity_string.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/2013_05_26_00_auth_rbac.sql b/sql/updates/auth/2013_05_26_00_auth_rbac.sql new file mode 100644 index 00000000000..aa05c842932 --- /dev/null +++ b/sql/updates/auth/2013_05_26_00_auth_rbac.sql @@ -0,0 +1,14 @@ +DELETE FROM `rbac_permissions` WHERE `id` = 48; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (48, 'Enable IP, Last Login and EMail output in pinfo'); + +DELETE FROM `rbac_roles` WHERE `id` = 39; +INSERT INTO `rbac_roles` (`id`, `name`) VALUES (39, 'Enable IP, Last Login and EMail output in pinfo'); + +DELETE FROM `rbac_role_permissions` WHERE `roleId` = 39 AND `permissionId` = 48; +INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (39, 48); + +DELETE FROM `rbac_group_roles` WHERE `groupId` = 3 AND `roleId` = 39; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (3, 39); + +DELETE FROM `rbac_group_roles` WHERE `groupId` = 4 AND `roleId` = 39; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (4, 39); diff --git a/sql/updates/world/2013_05_26_00_world_trinity_string.sql b/sql/updates/world/2013_05_26_00_world_trinity_string.sql new file mode 100644 index 00000000000..591021a5f84 --- /dev/null +++ b/sql/updates/world/2013_05_26_00_world_trinity_string.sql @@ -0,0 +1,9 @@ +DELETE FROM `trinity_string` WHERE `entry`=854 LIMIT 1; +INSERT INTO `trinity_string` (`entry`, `content_default`, content_loc1, content_loc2, content_loc3, content_loc4, content_loc5, content_loc6, content_loc7, content_loc8) VALUES +(854, '└ Mails: %d Read/%u Total', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +DELETE FROM `trinity_string` WHERE `entry`=871 LIMIT 1; +INSERT INTO `trinity_string` (`entry`, `content_default`, content_loc1, content_loc2, content_loc3, content_loc4, content_loc5, content_loc6, content_loc7, content_loc8) VALUES +(871, '│ Level: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +UPDATE `trinity_string` SET `content_default`='│ Level: %u (%u/%u XP (%u XP left))' WHERE `entry`=843 LIMIT 1; -- cgit v1.2.3