mysql/core_person_has_perm.sql

diff --git a/mysql/core_person_has_perm.sql b/mysql/core_person_has_perm.sql
index a051137..0827645 100644 (file)
--- 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;