Collections functions
General functions
Render functions
Theme permission functions
Resource functions

clear_resource_data()

Parameters

ColumnTypeDefaultDescription
$resource

Location

include/resource_functions.php lines 3447 to 3466

Definition

 
function clear_resource_data($resource)
    {
    
# Clears stored data for a resource.
    
ps_query("DELETE FROM resource_dimensions WHERE resource = ?", ["i",$resource]);
    
ps_query("DELETE FROM resource_related WHERE resource = ? OR related = ?", ["i",$resource,"i",$resource]);
    
delete_all_resource_nodes($resource);

    
// Clear all 'joined' fields
    
$joins=get_resource_table_joins();
    if(
count($joins) > 0)
        {
        
$joins_sql "";
        foreach (
$joins as $join)
            {
            
$joins_sql .= (($joins_sql!="")?",":"") . "field" . (int)$join "=NULL";
            }
        
ps_query("UPDATE resource SET $joins_sql WHERE ref = ?", ["i",$resource]);
        }
    return 
true;
    }

This article was last updated 2nd October 2022 16:05 Europe/London time based on the source file dated 30th September 2022 14:20 Europe/London time.