Thumbnails of Attachments on Forum-Display

Foreword:

This is the old hack of Dechevious, i only changed it to work under 3.5.0 Beta 3.

I've used this hack, to build a gallery for my forum.

You'll need the icon for no Thumbs from Dechevious hack, so be sure
to check his hack out, too.

[rharbison]

Any progress on fixing the bugs? Looks like a really good plugin

[Adek]

Yes. Here you have correct code:

PHP Code:


// gallery hack (fixed by adek)

    if (in_array($forumid, $forumids)) {
                $displaythumbs = true;
        }

    $sql_threads = "
        SELECT $votequery $previewfield
            thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
            $lastpost_info, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach "
            . iif($displaythumbs == true, ", attachment.attachmentid AS attachmentid ")
            . iif($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid'], ", NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed") 
            . iif($deljoin, ", deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason")
            . iif($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid'], ', threadread.readtime AS threadread') . "
        FROM " . TABLE_PREFIX . "thread AS thread 
            $deljoin
            " . iif($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = " . $vbulletin->userinfo['userid'] . ")") . "
            " . iif($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ")") . "
            $previewjoin 
            " . iif($displaythumbs == true, "LEFT JOIN ".TABLE_PREFIX."attachment as attachment ON(attachment.postid = thread.firstpostid) "). "
            $tachyjoin
        WHERE thread.threadid IN (0$ids) GROUP BY thread.firstpostid
        ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
    ";
    $threads=$db->query_read($sql_threads);

    
//end of gallery hack 


Now. Even after update to 3.5.1 everything looks great

[rharbison]

Works great, and I really like it.

One question / suggestion... How do I make this work in the search results? I see they use the threadbit template, but it doesn't show the icons. I'd like to show the thumbnails, even if they show up for all forums.

Any suggestions on how to do that?

[rharbison]

My members love this! It's getting great reviews.

One question... How does it decide which image to show? It usually, but not always, shows the first image. Sometimes it's the second or third. Any idea how/why that happens?

Also, <beg>PLEASE</beg> somebody tell me how to do this with the "new post" and "today's post" searches. I think it would be very useful!

[fabianv]

Harald_T, how would I make this work together with your other Gallery hack release but on seperate areas?

Theyre both so good, wish they worked together.. when Install both and I try use this one it just looks like your other gallery release which I dont want for that specific area.. just want thumbnails :P

reply would be great

[Harald_T]

I'll look after this tomorrow.

Edit: The problem is based on the way the gallery-hack was build up. Wait for the next version (i hope this night), then the problems should be removed.

[fabianv]

You are a star!!

I will be waiting in suspense!

Thank you Thank you Thank you!!!!!

my forum , http://forum.cgcentral.net

Its launched yesterday so its under beta... what will basically happen is under the gallery section the first 3 forums will just be thumbnail.. and the last one (awards) will be that great gallery with the new works on the main page.

Cant wait for your release.. told my friends and they also cant wait!

[fabianv]

when its done please notify in this thread or email me.. i'll put it to good use..

[Harald_T]

The new version of my gallery is up now. Try it out.

[fabianv]

Originally Posted by Harald_T

The new version of my gallery is up now. Try it out.

Harald I have 2 questions:

1) I installed the new version but now am wondering why when I view my gallery it shows the blocks and everything but no thumbnail at all.. not even on the front page, nowhere.. I added the image as an attachment; why isnt this working?

2) So now I will be able to install both gallery codes?