Forum Display Enhancements - Thread Thumbnail

This plugin is the newest version of the Thread Thumbnail plugin

This plugin will display the first attachment as a thumbnail on forumdisplay.php

New Features:

• If there are attachments that are not images, it will skip them and go to the first image attachment.
• Optional - you can now display thumbnails on search results.

Installation:

In your AdminCP, go to Plugin System, Download/Upload Plugins and import the xml document.

Be sure to change the forum ids in the $thumbsforums array to the forum ids you want to enable thumbnails in.

The plugin comes with the Search Thumbnails enabled. If you do not want to have thumbnails show up in the search results, make sure you deactivate it.

If you would like thumbnails to display in the search results, you will need to replace your search.php page with the one in the zip file. Unfortunately vBulletin forgot to include a hook variable where it is necessary for this to work. I have added 1 line to search.php with the hook variable. There is no way around this until vbulletin adds it themselves.

Next you will need to modify your threadbit template:

Find:

<if condition="$show['threadicons']">
	<td class="alt2">
		<if condition="$show['threadicon']">
			<img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />
		<else />
			&nbsp;
		</if>
	</td>
</if>

Replace With:

<if condition="$show['threadicons']">
	<td class="alt2" align="center" valign="middle">
			<if condition="$tt_displaythumbs">
				<if condition="($thread['attachmentid']) AND ($thread['thumbsize'])">
			     	<a href="showthread.php?$session[sessionurl]t=$thread[threadid]">
			          	<img src="attachment.php?attachmentid=$thread[attachmentid]&stc=1&thumb=1" alt="" border="0" />
			        </a>
			     <else />
			        <img src="$stylevar[imgdir_misc]/nothumb.jpg" alt="" border="0" />
			     </if>
			<else />
				<if condition="$show['threadicon']">
			     <img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />
				 </if>
			</if>
	</td>
</if>

You will also need to upload an image to display if there are no image attachments here: $stylevar[imgdir_misc]/nothumb.jpg(ex: http://www.mysite.com/forums/images/misc/nothumb.jpg). I've made a simple one you can use or you can make your own. By default thumbnails are confined in a 100x100 px area, I found that it looks good to make the "no image" image about 100x83 px.

__________________________________________________ ___

Add-ons (Optional)

UserCP option to turn the thumbnails on/off on a per user basis

Go into your admincp and click User Profile Fields->Add New User Profile Field.

Select "single selection radio buttons", click continue.

For title put "Thread Thumbnails", for description put "This will allow you to turn the thumbnails of threads on and off."

For options, enter "On" and "Off".

Skip down to Display Page and choose "Options: Thread Viewing".

In your threadbit template(assuming you already applied the template changes above):

Find:

<if condition="$tt_displaythumbs">

Replace with:

<if condition="($tt_displaythumbs) AND ($bbuserinfo['field5'] <> 'Off' OR $show['guest'])">

You need to replace field5 with the field name of the profile field you created earlier.

[theOZer]

"In threadbit template add an additonal IF statement like you added for the Tag Search changing the IF stmt to check for $tt_displaythumbs_search (versus the Tag Search checking for $tt_displaythumbs_tag)."
I can't explain it any better than I have already tried. Sorry.

[mrxclusive]

how do i upload a differen thumbnail for each thread?

[klower]

Hi theOZer

Great mod ! works with my 3.7.2 as well.

I've just wondering how to change code a little bit so that modification you've created could search in second post in thread (if first post does not have any attached images) ..
any suggestions ?

cheerz

[theOZer]

Hello klower,
I will see if I can come up with code that will do that. I guess I've kinda taken over supporting this mod, but, to be honest, I don't fully understand how it works, how it is determining if or if not there's a thumbnail/pic included in the first post of a thread. I'll work on it this weekend and if I have any success trying to add your code tweak I'll PM you.
Thanks for the kudos. I really mean that; that's all I want is to help other vBers so that they can use this mod in their forum. This mod is priceless if you support an art forum.
~OZ
Post thought: First and foremost a salute to Jason Merchant for writing this mod.
And, I wish not to sound pompous. Any and all of us here at vB.org support our fellow members. That's a gimme.

[oz_girl]

reserved

[klower]

hello theOzer, did you make some progres in this mod?
I'm not sure your connection with Jason or why he's not supporting this fantastic mod.. anyway I'm still waiting for any kind of info about my question.

[theOZer]

Originally Posted by oz_girl

reserved

oz girl,
(32 posts with (at least) 12 but a "reserved." Okay, TT's been reserved.)
I wish I could help your true need. I'm weak here, but, maybe get a portal with multiple forum licenses, cross accessed.

klower,
This intrinsic Thread Thumbnail mod/hack Jason Merchant wrote, that to this minute I don't understand why vB just doesn't just have this as part of 'the package,' only works on the first post of a thread.
2 (obvious) work arounds:
1) Merge 1st post with 2nd post.
2) Change the 2nd post's date to before the 1st post's date.
I love this thread thumbnail mod/hack. I am going to learn how to code a mod that shows all photo attachments in a thread. I hope I can; I want to be a part of supporting open source code; php is The Boss open source code; vB uses it. End of chat.
~OZ

[steveninstl]

I am getting this error (After I upgraded to VB 3.7.2 PL 2) I was using this plugin on PL 1 and did not have an issue..unti tonite.

Database error in vBulletin 3.7.2:
Invalid SQL:

SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,

replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.lastpost, thread.lastposter, thread.lastpostid
,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid


, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
FROM thread AS thread
LEFT JOIN user AS user ON(user.userid = thread.postuserid)

LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')


LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(94);

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Thursday, August 21st 2008 @ 08:52:45 PM
Error Date : Thursday, August 21st 2008 @ 08:52:45 PM
Script : http://www.pimpmyberry.com/search.php?searchid=2243
Referrer : http://www.pimpmyberry.com/
IP Address : **************
Username : StevenInSTL
Classname : vB_Database
MySQL Version : 5.0.51a-community


I disabled your plugin and I do not get an error (of course I don't get the thumbs either!)

Can you fix this most awesome plugin?

Thanks!

[Spank]

I've just installed on 3.7.2 PL2 and it's working great.

[steveninstl]

Really... It worked for me too, until I went to NEW POSTS or TODAY's Posts...thats when I received the SQL errors.