Collections functions
General functions
Render functions
Theme permission functions
User functions
Resource functions

delete_resource_nodes_multi()

Description

Delete all node relationships matching the passed resource IDs and node IDs.

Parameters

ColumnTypeDefaultDescription
$resources array array An array of resource IDs
$nodes mixed array An integer or array of single/multiple nodes

Return

void

Location

include/node_functions.php lines 1581 to 1593

Definition

 
function delete_resource_nodes_multi($resources=array(),$nodes=array())
    {
    if(!
is_array($nodes))
        {
$nodes=array($nodes);}
    
    
$chunks array_chunk($resources,SYSTEM_DATABASE_IDS_CHUNK_SIZE);
    foreach(
$chunks as $chunk)
        {
        
$sql "DELETE FROM resource_node WHERE resource in (" ps_param_insert(count($chunk)) . ") AND node in (" ps_param_insert(count($nodes)) . ")";
        
$params array_merge(ps_param_fill($chunk"i"), ps_param_fill($nodes"i"));
        
ps_query($sql$params);
        }
    }

This article was last updated 4th December 2023 20:05 Europe/London time based on the source file dated 8th November 2023 16:10 Europe/London time.