4 DROP FUNCTION IF EXISTS core_person_has_perm;
7 CREATE FUNCTION core_person_has_perm(
9 in_perm_name VARCHAR(64),
10 in_perm_level VARCHAR(1)
11 ) RETURNS INT(11) DETERMINISTIC
17 core_group_member.id INTO v_id
23 core_group_right.group_id = core_group_member.group_id
25 core_group_right.rightname= in_perm_name AND
26 accessmask LIKE CONCAT('%', in_perm_level, '%') AND user_id = in_person_id LIMIT 1;