all_user_dash_tile_active()

Parameters

ColumnTypeDefaultDescription
$tile

Location

include/dash_functions.php lines 267 to 296

Definition

 
function all_user_dash_tile_active($tile)
{
    return 
ps_query(
        
"SELECT
            dash_tile.ref AS 'tile',
            dash_tile.title,
            dash_tile.url,
            dash_tile.reload_interval_secs,
            dash_tile.link,
            dash_tile.default_order_by as 'order_by',
            dash_tile.allow_delete 
        FROM dash_tile 
        WHERE 
            dash_tile.all_users=1 
            AND
            dash_tile.ref= ?
            AND 
            (
                dash_tile.allow_delete=1 
                OR 
                (
                    dash_tile.allow_delete=0 
                    AND 
                    dash_tile.ref IN (SELECT DISTINCT user_dash_tile.dash_tile FROM user_dash_tile)
                )
            ) ORDER BY default_order_by
        "
,
        [
'i'$tile]
    );
}

This article was last updated 24th April 2025 07:05 Europe/London time based on the source file dated 17th April 2025 17:40 Europe/London time.