From: Alan Knowles <alan@roojs.com>
Date: Tue, 11 Oct 2016 03:09:19 +0000 (+0800)
Subject: mysql/core_person_has_perm.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=b367563d8d7b92b7305e8b4881e6dd79c1cbb281

mysql/core_person_has_perm.sql
---

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;