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

[SoloX]

Originally Posted by SoloX

Hi,
I have a large forum as well. How can I modify the following to process threads from one particular forum only?

I changed

PHP Code:

FROM " . TABLE_PREFIX . "thread 


to

PHP Code:

FROM " . TABLE_PREFIX . "thread where forumid='14' 


where 14 was my target forum. This way I will only do the forums I need. Maybe useful for larger boards.

[SoloX]

Strange.
My test board worked fine but in production version I am getting the error reported by others:

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

[SoloX]

Ohh! I had set it to attachments and possibly I have attachments disabled. .. I set it to first image and all is gud in my land. loving it.

[SoloX]

Q folks:
If I have another image tag, say MEDIA, can I do the following?

PHP Code:

preg_match('/\[(img|MEDIA|IMG)\]\s*(https?:\/\/([^*\r\n]+|[a-z0-9\/\\\._\- !]+))\[\/(img|MEDIA|IMG)\]/', $edit['message'], $matches); 


Is there anything else I have to do to read those images?

[SoloX]

If you have RSS posts going to a forum like I do, you will have to do this:
in includes/cron/rssposter.php find

PHP Code:

$threadactiontime = (($feed['threadactiondelay'] > 0) ? (TIMENOW + $feed['threadactiondelay']  * 3600) : 0); 


right under it, put

PHP Code:

$pat = '/\[IMG\](.*?)\[\/IMG\]/i';
preg_match($pat,$pagetext,$matches);
$thumburl = escape_string($matches[1]);
$itemdata->set('thumbnailurl', $thumburl); 


[vBB-vietnam]

Can you update so it can auto show Thread Thumbnail on VBADVANCED

[gantonr]

ok i installed and get this when set to first attachment

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
			
			, threadredirect.expires
			, MIN(attachment.attachmentid) AS attachmentid
		FROM vbf_thread AS thread
			LEFT JOIN vbf_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			 LEFT JOIN vbf_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
			
			LEFT JOIN vbf_post AS post ON(post.postid = thread.firstpostid)
			
			LEFT JOIN vbf_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			LEFT JOIN vbf_attachment AS attachment ON (attachment.postid = thread.firstpostid AND attachment.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
		WHERE thread.threadid IN (0,17) 
		ORDER BY sticky DESC, lastpost DESC;

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  : Sunday, December 6th 2009 @ 12:39:28 AM
Error Date    : Sunday, December 6th 2009 @ 12:39:28 AM
IP Address    : 95.132.62.79
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.51a-24+lenny2+spu1-log

it seems common problem? ;-) how i get rid of it? if you can please simple and step by step ;-)

cheers, Tong.

[VBUsers]

Originally Posted by VBUsers

when i add this mod i only get 1 thread per page with the image from the first attachment. i did the manual and auto edits to test it out and its doing the same thing.

let me know the steps to fix this and its a great mod for my forum. hopefully we can get it fixed.

anyone on this issue?

[SoloX]

^ check your HTML edits. You are missing either a TD or TR tag.

[mykkal]

This is cool... Question for the creator of the mod. is it possible to be able to define the images for the members?

Just curious...I want to use the mod. I just don't want them to be able to choose any type of image.

Gotta keep control, ya know. This is a really nice mod that could be abused badly.