clear_resource_data()

Parameters

ColumnTypeDefaultDescription
$resource

Location

include/resource_functions.php lines 3481 to 3498

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 23rd April 2025 09:35 Europe/London time based on the source file dated 17th April 2025 12:45 Europe/London time.