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.

[???`S?LV?R???`]

Originally Posted by mhobelsb

hi Harald_T,

really nice addon. i already use it in my forum and for sure want to use it as soon as the gold is released. any chance that you change it to work as plugin? would really love that. not that the file changes are big, but it would make updateing much easier.

thanks again for the good work

martin

ps.: don?t really get there to use the Query of KirbyDE. maybe i am just not really awake.

having it as a plugin would definitly make it easier

[Andreas]

Here is the Plugin (which is just a Copy&Paste of the Code I posted earlier ...)

Note: It must be edited: 1, 2 ,3 has to be replaced with the Forumids where you want to activate this.

But as said above, I still think the best thing would be if the was a setting in Forum Manager to easily turn this on/off without having to edit the code.

[Harald_T]

Sorry, hadn't much time the last days. I think, i've also already made an plugin.

@Kirby: Nice Idea. I'll look after it.

[MrNase]

Originally Posted by KirbyDE

Here is the Plugin (which is just a Copy&Paste of the Code I posted earlier ...)

Note: It must be edited: 1, 2 ,3 has to be replaced with the Forumids where you want to activate this.

But as said above, I still think the best thing would be if the was a setting in Forum Manager to easily turn this on/off without having to edit the code.

Doesn't seem to be working with vB3.5

Some threads appear twice, some are even listed three or four times..

[GrendelKhan{TSU]

anyone else try this for 3.5?

I want to install it but wanna see if its ok.

[Adek]

Yes. It has small bug. Thumbnails are from first post in thread and if first post has more than one attachment, there are more than one thread.

[mhobelsb]

yes, same here. anyone a idea to fix that?

[eXtremeTim]

Then we just need a group by if their isnt one but it sounds like he needs to add a group by into the query.

[Adek]

Yes, that's right. We need to add "GROUP BY" and one "iff" to the SQL query.

my code (in forumdisplay.php)

PHP Code:

// gallery hack

    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)" 
             . iif($displaythumbs == true, "GROUP BY attachment.postid ") ."
        
        ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
    ";
    $threads=$db->query_read($sql_threads);


    
//end of gallery hack 


Check it

[Adek]

sorry, there are still bugs in my code.