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

clear_resource_data()

Parameters

ColumnTypeDefaultDescription
$resource

Location

include/resource_functions.php lines 3852 to 3871

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 19th March 2024 02:05 Europe/London time based on the source file dated 11th March 2024 14:25 Europe/London time.