Collections functions
Encryption functions
General functions
Theme permission functions
Resource functions

get_resource_custom_access_users_usergroups()

Parameters

ColumnTypeDefaultDescription
$resource

Location

include/resource_functions.php lines 3346 to 3360

Definition

 
function get_resource_custom_access_users_usergroups($resource)
    {
    
# Returns only matching custom_access rows, with users and groups expanded
    
return sql_query("
                 SELECT g.name usergroup,
                        u.username user,
                        c.access,
                        c.user_expires AS expires
                   FROM resource_custom_access AS c
        LEFT OUTER JOIN usergroup AS g ON g.ref = c.usergroup
        LEFT OUTER JOIN user AS u ON u.ref = c.user
                  WHERE c.resource = '
{$resource}'
               ORDER BY g.name, u.username
    "
);
    }

This article was last updated 13th July 2020 16:35 Europe/London time based on the source file dated 13th July 2020 14:40 Europe/London time.