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

all_user_dash_tile_active()

Parameters

ColumnTypeDefaultDescription
$tile

Location

include/dash_functions.php lines 269 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 19th March 2024 06:35 Europe/London time based on the source file dated 15th March 2024 17:00 Europe/London time.