fix #8131 - chinese translations

[Pman.Core] / mysql / core_person_has_perm.sql

diff --git a/mysql/core_person_has_perm.sql b/mysql/core_person_has_perm.sql
index a051137..f9f3017 100644 (file)
--- a/mysql/core_person_has_perm.sql
+++ b/mysql/core_person_has_perm.sql
@@ -1,10 +1,10 @@
 
 
 
-DROP FUNCTION IF EXISTS person_has_perm;
+DROP FUNCTION IF EXISTS core_person_has_perm;
 
 DELIMITER $$
-CREATE FUNCTION person_has_perm(  
+CREATE FUNCTION core_person_has_perm(  
        in_person_id INT(11),
        in_perm_name VARCHAR(64),
        in_perm_level VARCHAR(1)
@@ -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;