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.

[siliconfinance]

Get this error for new posts:

Database error in vBulletin 3.6.8:
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.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed

, 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 subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 17508 AND canview = 1)
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
(74160, 74080, 68654, 74097, 64105, 57850, 74166, 74172, 74171, 74162, 74170, 74169, 49164, 74072, 74141, 74163, 74092, 14029, 74168, 74167);
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
Date : Thursday, January 24th 2008 @ 06:58:04 PM
Script : http://www.mydomain.com/forums/searc...earchid=506222
Referrer : http://www.mydomain.com/forums/showthread.phpp=1282479#post1282479
IP Address :
Username : sfguy
Classname : vb_database

[viper007]

can give ..breif expaltion .. where can i upload php file in to ftp server ....plzzz urgent am waiting to u r reply..

[viper007]

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

wheer can i change the forum ids . thumbnails enabled .. plzzzz tell me dudes.. am waiting ur reply

[theOZer]

Originally Posted by Adam21

Note: If you are using 3.7 Beta2 and have a quick search template edit in a custom template,you must disable the "search_results_query_threads" hook in your plug-ins manager

Without the thread thumbnail showing up in, say, New Posts, I've got to ask, "when will this search feature work in 3.7.0 Beta4?"

Love this mod/hack. Without it an art forum's impact is greatly reduced when viewing just the forum post listing and/or 'New Posts.'
Regards,
theOZer

[SpreadingLight]

How can this be changed so it's enabled for only specified forums,
and so it will auto-sort by the number of thread replies/comments (sorted in reverse; least comments first) ?

Thank You

[siliconfinance]

Does anybody know why my safari and firefox members can't see the thumbs?

[sp0okz]

can we get this for 3.70

[MrGoodbyte]

@ siliconfinance: How did You get the database-error fixxed? I have the same problem!

[superthang]

update for 3.7 please
thanks!

[MrGoodbyte]

Sorry, but I think there are several mistakes in the description of this hack!

1. Nowhere is mentioned that one hast to upload the search.php to the forum-path, too, that's the reason for the database errors mentioned in my last post.
2. The explanation of the forum-array is unclear:
   [CDATA[$tt_thumbsforums = array(76 80 81); causes this error-message: Parse error: syntax error, unexpected T_LNUMBER, expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 9
   [CDATA[$tt_thumbsforums = array(76,80,81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 27
   [CDATA[$tt_thumbsforums = array(76, 80, 81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 36
   [CDATA[$tt_thumbsforums = array(76; 80; 81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 9
   [CDATA[$tt_thumbsforums = array(76;80;81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 9
   [CDATA[$tt_thumbsforums = array(76) (80) (81); causes this error-message: Parse error: syntax error, unexpected '(' in /forumpath/forumdisplay.php(812) : eval()'d code on line 36
   [CDATA[$tt_thumbsforums = array(76)(80)(81); causes this error-message: Parse error: syntax error, unexpected '(' in /forumpath/forumdisplay.php(812) : eval()'d code on line 36
   So, how shall it be possible to create thumbs for more than one forum?

Really nice is, that with all the testing now the thread-overview doesn't work even if I only wanna add thumbs to one forum and that I don't find any possibility to deactivate or deinstall the whole hack! So: What can I do now? My hole board doesn't work correctly!