New Posting Features - Thread Thumbnails

Thread Thumbnails
--------------------------------------
Created By: Null Parameter

This mod is officially tested with 3.8.1, but has been reported to work with many other versions.

Please leave any comments, suggestions or bugs.

Description

This mod allows a user, when creating or editing a thread, to specify a Thumbnail image to be used for display next to the thread in the Thread Listing.

With this mod you can define a set of forums that have thumbnails enabled, then in those forums whenever a user creates or edits their thread they can change their thumbnail, based on the method that you choose to allow.

This image is then shown in the Forum Display, in place of the Thread Icon.
The image also appears in Search & Tag Search, and I can add it to the regular Search if somebody requests it. And possibly have options for displaying in each area.

Forum Display:
Forum.jpg

Search:
Search.jpg

ACP Options:
ACP Options.jpg

Installation

Install the Product XML File. That's it!

All Template Edits Are Now Automatic.

If you are Upgrading from the older version, see directions in the README file on how to undo the template edits.

Demo

Possible Future Features (With Request)

• Additional column instead of replacing Thread Icon
• Displaying Thumbnail within thread
• Edit thumbnail through Thread Edit
• Thumbnail Preview in Edit Window

Fixes

• Version 2.2
  • Fix Attachment + Default Thumbnail Option Combo
• Version 2.1
  • Fix DB Error when using First Attachment option
  • Fix issue with New threads not saving thumbnail
• Version 2
  • Added Features:
    • Automatic Template Edits
    • Thumbnails in Search
    • Thumbnails from First Image/First Attachment
    • Thumbnails on Sticky Threads
  • Fixes:
    • Miscellaneous Fixes

[milsirhc]

Is this workable on V4?

Can we also display the thread title in the show thread page?

[apiasto]

doesn't work

[VBUsers]

uninstalled - thanks but to buggy for me

[vBB-vietnam]

i need it for V4
help me plz

[powerful_rogue]

Hi,
Im really hoping someone may be able to help.

Ive got the mod set to show the thumbnail of an attachment, however when an attachment isnt included within a thread, it just shows a red X.

I added a link to show a "no image" picture, but it still seems to be looking for an attachment when one hasnt been included.

Any help greatly appreciated

[deluxmall]

I need this for VB4 as well.

Anyone help?

[jayfenney]

I've installed this and it works great for the most part, except I get the same problem as gantonr. The template edits have worked fine and there's no issue with the thumbnails showing, except when I have it set to use the first attachment. I get the following database error

Database error in vBulletin 3.8.4:

Invalid SQL:

		SELECT 
			IF(votenum >= 1, votenum, 0) AS votenum,
			IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
		 post.pagetext AS preview,
			thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
			thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
			thread.prefixid, thread.taglist, hiddencount, deletedcount
			, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
			, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
			, threadread.readtime AS threadread
			, threadredirect.expires
			, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , MIN(attachment.attachmentid) AS attachmentid
		FROM thread AS thread
			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 = 2 AND canview = 1)
			 LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 2)
			LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
			
			LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png')) LEFT JOIN attachment AS attachment ON (attachment.postid = thread.firstpostid AND attachment.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
		WHERE thread.threadid IN (0,840,433,889,814,895,900,880,890,808,897,876,835,887,877,733,879,806,874,732,883,483) GROUP BY thread.threadid 
		ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Not unique table/alias: 'attachment'
Error Number  : 1066
Request Date  : Friday, January 15th 2010 @ 04:58:03 AM
Error Date    : Friday, January 15th 2010 @ 04:58:04 AM
Script        : http://www.lightspeed-art.com/community/3d-wips-f13.html
Referrer      : http://www.lightspeed-art.com/community/battleship-thirty-twevle-t840.html
IP Address    : 90.210.63.183
Username      : Scorpius
Classname     : vB_Database
MySQL Version : 5.1.42

[angeljs]

Originally Posted by deluxmall

I need this for VB4 as well.

Anyone help?

Me, too!

[BillieJoe]

ok i really need help, i searched the thread but didnt find out how to fix it.

if i directly put in the thumbnail like this

[img]https://vborg.vbsupport.ru/external/2010/01/15.gif[/img]

and i dont have another img code in that line the preview works.
but if there are 2 img codes per line or hotlinked images like

[URL=http://img240.imagevenue.com/img.php?image=72507_olivia-wilde-1920x1200-36389_122_111lo.jpg][IMG]http://img240.imagevenue.com/loc111/th_72507_olivia-wilde-1920x1200-36389_122_111lo.jpg[/IMG][/URL]

it doenst work
how can i fix it?

[islam mohamed]

hello

i need see that hack in vBadvanced cuz no work in portal

plz help me

Thanks