Implemented Per Item option: Display cover image above item

As per title, each individual showcase item now has the option to display the cover image above the item or not (instead of ALL items in the entire system being forced to display or not). This is a much better way of handling this (letting the content author decided if they want the cover image displayed or not).

When creating a new item, there will be a new option input (check box). Being that Showcase is designed to visually "show off" items, this option is checked by default (if you want it unchecked by default its a skill level 1 template edit).




If the author (or staff) wants to CHANGE (set or unset), there are 2 ways to do that.

The quickest way is via the "Set cover image" function in the Item Tools.




You can also set/unset the option via item edit function




Note: all items in the system will be default set, so if you don't want them set, you will have to either edit the items and unset the option OR you can run sql queries that can bulk unset ALL items or on a Per Category basis (in the case where you might need to just unset the option on a specific category.


This SQL Query will update all showcase items and set the option to OFF

Code:

UPDATE xf_xa_sc_item

SET cover_image_above_item = 0; 

This SQL Query will update all showcase items and set the option to ON

Code:

UPDATE xf_xa_sc_item

SET cover_image_above_item = 1; 

You can update all items in a category with a single SQL query.


This SQL Query will update all showcase items in category X and set the option to OFF Note: Replace X with the actual Category Id

Code:

UPDATE xf_xa_sc_item

SET cover_image_above_item = 0

WHERE category_id = X; 

This SQL Query will update all showcase items in category X and set the option to ON Note: Replace X with the actual Category Id

Code:

UPDATE xf_xa_sc_item

SET cover_image_above_item = 1

WHERE category_id = X;