Collections functions
General functions
Render functions
Theme permission functions
Resource functions

collection_cleanup_inaccessible_resources()

Description

Delete any resources from collection moved out of users archive status permissions by other users

Parameters

ColumnTypeDefaultDescription
$collection integer ID of collection

Return

void

Location

include/collections_functions.php lines 5205 to 5223

Definition

 
function collection_cleanup_inaccessible_resources($collection)
    {
    global 
$userref;

    
$editable_states array_column(get_editable_states($userref), 'id');
    
$count_editable_states count($editable_states);

    if(
$count_editable_states === 0)
        {
        return;
        }

    
ps_query("DELETE a 
                FROM   collection_resource AS a 
                INNER JOIN resource AS b 
                ON a.resource = b.ref 
                WHERE  a.collection = ? 
                AND b.archive NOT IN ("
ps_param_insert($count_editable_states) .")"array_merge(['i'$collection], ps_param_fill($editable_states'i')));
    }

This article was last updated 7th February 2023 12:05 Europe/London time based on the source file dated 1st February 2023 15:00 Europe/London time.