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 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/auth/2013_05_26_00_auth_rbac.sql (limited to 'sql/updates/auth') 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); -- cgit v1.2.3