1. REGISTRATION REQUIREMENTS:

    Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Implemented Per Item option: Display cover image above item

Discussion in 'Showcase Closed Suggestions' started by Bob, Feb 18, 2020.

  1. Bob

    Bob Developer Staff Member

    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).

    Selection_380.png


    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.

    Selection_381.png


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

    Selection_382.png


    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; 
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.