Collections functions
Encryption functions
General 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 3974 to 3985

Definition

 
function collection_cleanup_inaccessible_resources($collection)
    {
    global 
$userref;

    
$editable_states array_column(get_editable_states($userref), 'id');
    
sql_query("DELETE a 
                FROM   collection_resource AS a 
                INNER JOIN resource AS b 
                ON a.resource = b.ref 
                WHERE  a.collection = '" 
$collection "' 
                AND b.archive NOT IN ( '" 
implode("', '"$editable_states) . "' );");
    }

This article was last updated 14th July 2020 01:35 Europe/London time based on the source file dated 9th July 2020 17:22 Europe/London time.