Collections functions
General functions
Node 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 1573 to 1590

Definition

 
function delete_resource_nodes_multi($resources=array(),$nodes=array())
    {
    if(!
is_array($nodes))
        {
$nodes=array($nodes);}

    
$resource_chunks array_chunk($resourcesSYSTEM_DATABASE_IDS_CHUNK_SIZE);
    
$node_chunks array_chunk($nodesSYSTEM_DATABASE_IDS_CHUNK_SIZE);

    foreach (
$resource_chunks as $resource_chunk)
        {
        foreach (
$node_chunks as $node_chunk)
            {
            
$sql "DELETE FROM resource_node WHERE resource in (" ps_param_insert(count($resource_chunk)) . ") AND node in (" ps_param_insert(count($node_chunk)) . ")";
            
$params array_merge(ps_param_fill($resource_chunk"i"), ps_param_fill($node_chunk"i"));
            
ps_query($sql$params);
            }
        }
    }

This article was last updated 24th April 2024 11:35 Europe/London time based on the source file dated 15th April 2024 11:30 Europe/London time.