From b367563d8d7b92b7305e8b4881e6dd79c1cbb281 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:09:19 +0800 Subject: [PATCH] mysql/core_person_has_perm.sql --- mysql/core_person_has_perm.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/mysql/core_person_has_perm.sql b/mysql/core_person_has_perm.sql index a0511375..08276453 100644 --- a/mysql/core_person_has_perm.sql +++ b/mysql/core_person_has_perm.sql @@ -1,7 +1,7 @@ -DROP FUNCTION IF EXISTS person_has_perm; +DROP FUNCTION IF EXISTS core_person_has_perm; DELIMITER $$ CREATE FUNCTION person_has_perm( @@ -14,15 +14,15 @@ CREATE FUNCTION person_has_perm( DECLARE v_id INT(11); SET v_id = 0; SELECT - group_members.id INTO v_id + core_group_member.id INTO v_id FROM - group_rights + core_group_right LEFT JOIN - group_members + core_group_member ON - group_rights.group_id = group_members.group_id + core_group_right.group_id = core_group_member.group_id WHERE - group_rights.rightname= in_perm_name AND + core_group_right.rightname= in_perm_name AND accessmask LIKE CONCAT('%', in_perm_level, '%') AND user_id = in_person_id LIMIT 1; RETURN v_id; -- 2.39.2