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.

[bd] Attachment Store integration

Discussion in 'Showcase Support' started by Bob, May 4, 2013.

  1. Bob

    Bob Developer Staff Member

    For those of you using showcase and want to use the [bd] Attachment Store , you will need to make a simple single file edit until the next release of showcase (in which it will be included).

    File: /library/NFLJ/Showcase/Model/Item.php
    Line: 711

    FIND:
    PHP:
    data.filenamedata.file_sizedata.file_hashdata.widthdata.heightdata.thumbnail_widthdata.thumbnail_height
    Replace with:
    PHP:
    ' . XenForo_Model_Attachment::$dataColumns . '

    The entire method (line 699-720) will look like this after the edit:

    PHP:
        /**
        * Gets the first attachment (and limited data info) by the given content ID.
        *
        * @param string $contentType
        * @param array $contentIds
        *
        * @return array Format: [attachment id] => info
        */
        
    public function getAttachmentByContentId($contentType$contentId)
        {
            return 
    $this->fetchAllKeyed('
                SELECT attachment.*,
                    ' 
    XenForo_Model_Attachment::$dataColumns '
                FROM xf_attachment AS attachment
                    INNER JOIN xf_attachment_data AS data ON
                        (data.data_id = attachment.data_id)
                WHERE attachment.content_type = ?
                    AND attachment.content_id = ?
                ORDER BY attachment.attachment_id, attachment.attach_date, attachment.view_count
                LIMIT 1
            '
    'attachment_id', array($contentType,$contentId));
        }
     
  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.