The Arcive of Official vBulletin Modifications Site.

Thread Thumbnails · **Released**: 05-27-2009

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

Ghostt · #**122** 10-25-2009, 12:27 PM

Quote:

Originally Posted by aztecboi2003

I don't have the same bug as you Ghostt. But I did notice it gave me 2 Thumbnail URL boxes now.

the thumbnail thing is working but completly useless for me i am speaking about the autiomatic first image option.... it still dont show the thumbnail only after updateing(editing) the post...

Sayid · #**123** 10-26-2009, 11:03 AM

Oh yes and finally I can see the mod updated

nominate and will try it on weakend

Thanks Null

Ghostt · #**124** 10-26-2009, 07:53 PM

Quote:

Originally Posted by Ghostt

ok ive tested the mod today. following bug: The first image is only showing if i make a Topic and after that i have to edit that the image is shown.. do you have the same bug? ive tested it with manuel template change and with automatic
best regards

Do anyone have the same bug?

marianoblesa · #**125** 10-26-2009, 08:13 PM

Ami same thing happens to me until I edit the theme is not agego the image of the first pos

Chadi · #**126** 10-26-2009, 08:34 PM

Thumbnails not working on sticky threads and I do have the option enabled and have img file paths/url applied to each thread.

Did manual template edits as well.

Null Parameter · #**127** 10-27-2009, 04:47 PM

Odd, I wasn't getting emails from replies, so now I have a lot to respond to. Sorry for the delay!

Quote:

Originally Posted by aztecboi2003

I upgraded and everything went smooth. But after I switched from URL to first attachment I got a database error. I switched back to URL and my site was fine again. I didn't look to see what the eror was though. I can try and recreate it if you want me too.

The Attachment Option has some known bugs, but I've never seen a database error. If you want to recreate and PM me the error, along with your vBulletin version, that would be great.

Quote:

Originally Posted by Ghostt

ok ive tested the mod today. following bug: The first image is only showing if i make a Topic and after that i have to edit that the image is shown.. do you have the same bug? ive tested it with manuel template change and with automatic
best regards

I'll take a look into this, but it had been working for me.

Quote:

Originally Posted by aztecboi2003

I don't have the same bug as you Ghostt. But I did notice it gave me 2 Thumbnail URL boxes now.

The only reason I can think of for this is if you had done the manual edits for v1 and then added in v2. Or possibly, if you have edited your templates, you might have two instances of the string that is being searched for to do the auto-template edits.

Quote:

Originally Posted by Chadi

Thumbnails not working on sticky threads and I do have the option enabled and have img file paths/url applied to each thread.

Did manual template edits as well.

I'll look at this as well, but again, it had been working for me.

Quote:

Originally Posted by marianoblesa

Ami same thing happens to me until I edit the theme is not agego the image of the first pos

Not sure I understand the issue.

Null Parameter · #**128** 10-27-2009, 04:57 PM

Quote:

Originally Posted by BlessedLAF

Hmmmmm, it won't let me change the image once I put the original URL in. I have no clue what I am doing wrong.

EDIT: OK, I tried it again and it won't let me change it.

It shows the original image and then when I edit it again it also shows the original URL. I would so love to get this to work...just not sure what I did wrong. Any help would be much appreciated.

This could be an issue with the Auto-template edits. If you want to PM me your editpost template, I can take a look to see if it should be working.

Quote:

Originally Posted by marianoblesa

Hello, install this hack and it works very well.

Just wanted to make a query you could suggest how I might do to the subjects who are already echos and I state x forum as it should do to make me appear.
Since I only put them in the new issues

the option that I would like to use is that of the first image of the item.

Greetings.

Actually, I think I just figured out the issue people are seeing with the First Image Setting.

The issue is that, to save on processing, I only update the thumbnail when a thread is edited or created, therefore if you have a forum full of threads, none of them will have the thumbnail saved. So, if you go back and edit the first post of a thread, the thumbnail should update and work.

Obviously, this is a bad workaround, because if you have 5k threads, you'll have to edit 5k posts to get all of the thumbnails to work, but it should still work while I think of a good way to automatically update threads when a forum is added/removed from the list.

Quote:

Originally Posted by Sayid

Oh yes and finally I can see the mod updated

nominate and will try it on weakend

Thanks Null

You are welcome.

Quote:

Originally Posted by Canadians360

Hey Null the new update is great, I thought I might pitch in a few ideas myself

*Option to set thumbnails as a required field when thumbnails are enabled
*Prioritize the three forms of thumbnail fetching (ex: if I am a thumbnail forum and a thumbnail url was not given use the first image)
*Dont show thumbnails on closed threads

Those are the only three I have right now, Ill let you know if any more decent ideas cross my mind.

Thanks for the suggestions. I had the Priority planned before, I think it's listed in rough form on like the first page of this thread, but it adds a lot of complexity and with people wanting updates, I skipped it for the time being. And I'm not exactly sure how I'd make it a required field..... I'll have to look into that one.

elenh · #**129** 10-27-2009, 05:39 PM

Works not for me.
The sticky threads is on but nothing showing and the rest thumbs is showing the "no image avaible" thumb.

The fuction of Thumbnail Source is: First image in post. but no images getting.

Null Parameter · #**130** 10-27-2009, 05:44 PM

Quote:

Originally Posted by elenh

Works not for me.
The sticky threads is on but nothing showing and the rest thumbs is showing the "no image avaible" thumb.

The fuction of Thumbnail Source is: First image in post. but no images getting.

Like I said above, I already figured out the issue here.....

Quote:

Originally Posted by Null Parameter

Actually, I think I just figured out the issue people are seeing with the First Image Setting.

The issue is that, to save on processing, I only update the thumbnail when a thread is edited or created, therefore if you have a forum full of threads, none of them will have the thumbnail saved. So, if you go back and edit the first post of a thread, the thumbnail should update and work.

Obviously, this is a bad workaround, because if you have 5k threads, you'll have to edit 5k posts to get all of the thumbnails to work, but it should still work while I think of a good way to automatically update threads when a forum is added/removed from the list.

Lietha · #**131** 10-28-2009, 10:28 AM

Have just installed the mod and much easier to use. However, if I set Thumbnail Source to "First Image In Post" I get the follwoing SQL error

Code:

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
			, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , MIN(attachment.attachmentid) AS attachmentid
		FROM dudbthread AS thread
			LEFT JOIN dudbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			 LEFT JOIN dudbsubscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
			
			LEFT JOIN dudbpost AS post ON(post.postid = thread.firstpostid)
			
			LEFT JOIN dudbthreadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			LEFT JOIN dudbattachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png')) LEFT JOIN dudbattachment AS attachment ON (attachment.postid = thread.firstpostid AND attachment.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
		WHERE thread.threadid IN (0,19,18,10,8) GROUP BY thread.threadid 
		ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Not unique table/alias: 'attachment'
Error Number  : 1066
Request Date  : Wednesday, October 28th 2009 @ 11:28:21 AM
Error Date    : Wednesday, October 28th 2009 @ 11:28:21 AM
Script        : http://www.3d-underground.com/forums/forumdisplay.php?f=4
Referrer      : http://www.3d-underground.com/forums/
IP Address    : 160.79.38.70
Username      : SnowCrash
Classname     : vB_Database
MySQL Version : 5.0.82-community

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09603 seconds Memory Usage 2,371KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (13)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (2)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (2)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

2 благодарности(ей) от:
chikkoo, vijayninel

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!