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

get_all_featured_collections()

Description

Get all featured collections

Parameters

This function accepts no parameters.

Return

array

Location

include/collections_functions.php lines 5437 to 5454

Definition

 
function get_all_featured_collections()
    {
    return 
ps_query("SELECT DISTINCT c.ref,
                      c.`name`,
                      c.`type`,
                      c.parent,
                      c.thumbnail_selection_method,
                      c.bg_img_resource_ref,
                      c.created,
                      count(DISTINCT cr.resource) > 0 AS has_resources,
                      count(DISTINCT cc.ref) > 0 AS has_children
                 FROM collection AS c
            LEFT JOIN collection_resource AS cr ON c.ref = cr.collection
            LEFT JOIN collection AS cc ON c.ref = cc.parent
                WHERE c.`type` = ?
             GROUP BY c.ref"
,
            array(
"i",COLLECTION_TYPE_FEATURED),"featured_collections");
    }

This article was last updated 19th March 2024 07:05 Europe/London time based on the source file dated 15th March 2024 17:00 Europe/London time.