Collections functions
Encryption functions
General functions
Theme permission functions
Resource functions

all_user_dash_tile_active()

Parameters

ColumnTypeDefaultDescription
$tile

Location

include/dash_functions.php lines 225 to 252

Definition

 
function all_user_dash_tile_active($tile)
    {
    return    
sql_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="
.$tile."
                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
            "
);
    }

This article was last updated 7th July 2020 10:05 Europe/London time based on the source file dated 24th June 2020 14:38 Europe/London time.