Thumbnail of Attachments on forum display

This hack has been requested a number of times, for multiple versions of vBulletin. For whatever reason, it was never done (at least publicly) until now. Heres to wishing each and everyone of you a Merry Christmas, and a prosperous, healthy, and safe, New Year!

What it does: This hack will display a thumbnail of the threads attachment on the forum display. Quite useful if you have forums designated for graphics/photos .. etc. Could also be tweaked to display the posters avatar instead of an attachment. Variable possibilities. (Screenshot attached for further review) and or see it in action at this forum in realtime. If the thread has multiple attachments, it will display the first. If no attachment, a 'no attachment' thumb will appear. Can be assigned for use in any forum you wish it to be active in.

Install time is minimal - Less than 5 minutes for the average joe. (Simplicity at it's Finest)
1 file to modify, and 1 template to modify, along with the upload of an image.

Known Issues: If the attachment is not an image, a thumbnail will not be shown. (IE: .zip or .rar)

If you install it, please click the 'Install' icon - Updates will be sent to those who do.

[memobug]

Hi Delphy,

What you're suggesting sounds interesting. I would be interested in seeing it. What I did, to enable USERS to chose the thumbnail option or not is to create a copy of the style with thumbnails turned on. That way the user can make the selection.

People on broadband really like it. The ones on dialup sometimes prefer not to load extra images. So I think it's a feature that might best be in the hands of the user rather than the admin. However, one thing I could really use would be the capability to show fewer threads per page if its a thumbnail view, and more threads per page in nothumbs. That would help to normalize the scrolling and load time.

Regards,

Matt

[Delphy]

memobug,

What I did was set a limit of 10 threads if viewing thumbnails, or the normal 25 if viewing forums without thumbnails.

I agree with you on the user selectable thumbnails though - especially in the New Posts search screen. I hadn't considered a style becuase it would still do the mySQL queries to get the attachment ids even if it's not showing the thumbnails, unless you hardcoded the styleid into the php and checked against that.

To change the number of threads on a forum that has thumbnails:

Edit forumdisplay.php
Find the section where you define forumids

        $forumids = array(41, 43, 44, 45, 46, 47, 48, 49, 69, 70, 40, 50, 51, 52, 97, 98);
        if (in_array($forumid, $forumids)) {
                $displaythumbs = true;

BELOW this add:

                $perpage = 10;

Thats it. You could add this as a vBulletin option too.

[sicloan]

Originally Posted by Delphy

To change the number of threads on a forum that has thumbnails:

Edit forumdisplay.php
Find the section where you define forumids

        $forumids = array(41, 43, 44, 45, 46, 47, 48, 49, 69, 70, 40, 50, 51, 52, 97, 98);
        if (in_array($forumid, $forumids)) {
                $displaythumbs = true;

BELOW this add:

                $perpage = 10;

Thats it. You could add this as a vBulletin option too.

this worked if you changed the page. But not if you view a forum by itself.

[Bent Concepts]

this is really a great hack -- but i'd love to know how to do it in the search results also. my php knowledge is fairly minimal -- any ideas?

[Delphy]

sicloan, works fine here. Might be becuase of some small other changes I made.

Bent, you need to alter search.php

Find:

        // #############################################################################
        // show results as threads
        else
        {
                $show['threadicons'] = true;
                $show['forumlink'] = true;

                foreach ($itemids AS $thread)
                {
                        // add highlight words
                        $thread['highlight'] = &$highlightwords;

                        // get info from thread
                        $thread = process_thread_array($thread, $lastread["$thread[forumid]"]);

(Should be around line 2518)

AFTER this add:

                        // Delphy's Search Thumbnail Hack
                        $thread[attachmentid] = "";
        $forumids = array(1, 2, 3);
        if (in_array($thread[forumid], $forumids)) {
                                        $displaythumbs = true;
                                        $sql_images = "SELECT DISTINCT postid,attachmentid FROM " . TABLE_PREFIX ."attachment WHERE postid IN (0$thread[firstpostid]) AND thumbnail_dateline > 0";
                                        $images = $DB_site->query($sql_images);
                                        while ($image = $DB_site->fetch_array($images)) {
                                                $thread[attachmentid] = $image[attachmentid];
                                        }
                                        $DB_site->free_result($images);
                                        unset($image);
                                }

Replace 1,2,3 with the forum ids similar to the way you did in forumdisplay.php

[Bent Concepts]

thanks a million -- that's really great stuff there. it seems to work, but unfortunately it's only displaying the nothumb.gif image -- as if there was no image in the thread (even though there is)

other thing is that that codeblock was around 1200 something, not 2518 -- must be installed mods on your search.php or something

my codeblock in search.php looks like this:

PHP Code:

// #############################################################################
    // show results as threads
    else
    {
        $show['threadicons'] = true;
        $show['forumlink'] = true;
 
        foreach ($itemids AS $thread)
        {
            // add highlight words
            $thread['highlight'] = &$highlightwords;
 
            // get info from thread
            $thread = process_thread_array($thread, $lastread["$thread[forumid]"]);
 
// Delphy's Search Thumbnail Hack
$thread[attachmentid] = "";
$forumids = array(1,2,3,4,5,6,7,);
if (in_array($thread[forumid], $forumids)) {
$displaythumbs = true;
$sql_images = "SELECT DISTINCT postid,attachmentid FROM " . TABLE_PREFIX ."attachment WHERE postid IN (0$thread[firstpostid]) AND thumbnail_dateline > 0";
$images = $DB_site->query($sql_images);
while ($image = $DB_site->fetch_array($images)) {
$thread[attachmentid] = $image[attachmentid];
}
$DB_site->free_result($images);
unset($image);
}
 
            $itemcount++;
            exec_switch_bg();
            eval('$searchbits .= "' . fetch_template('threadbit') . '";');
        }
    }
    // ############################################################################# 


[skokarl]

I have installed, but i can't see anything.

Must I change something in the admin cp ?

[Delphy]

skokari,

did you change the forum ids to the same ones you want thumbnails to appear in?

bent concepts,

hrm I haven't modified search.php that much at all... so it's weird that yours is on a different line. What version you running? 3.0.7 here

[Bent Concepts]

I'm running 3.07 also.

i hadn't changed it at all from the base unmodified version. what it's doing is displaying the "no thumb" image for all the items in the search.

is that code change the only thing that needs to be done in search.php? is there a specific version of this hack that needs to be used in order to get the search to work? i just changed the hack code i was using to the December 20th, 2004 version.

thanks

[Delphy]

Hrm

It might be your $forumids = array(1,2,3,4,5,6,7,); line. Try taking out the last , in that.

What I found handy when developing the hack was doing this:

if ($bbuserinfo[userid] == 1) {
  echo "<pre>".print_r($thread, true)."</pre>";
}

Replace 1 with your userid. What this will do is *just* for you, print out ALL the information it's got in your browser window. You can then see what the values are for the $thread[attachmentid] etc

Obviously turn it off before you go live