vb.org Archive - Forum Display Enhancements

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Forum Display Enhancements - Thread Thumbnail (https://vborg.vbsupport.ru/showthread.php?t=158396)

"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.

how do i upload a differen thumbnail for each thread?

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 :)

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.

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.

Quote:

Originally Posted by oz_girl (Post 1599832)

reserved :D

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

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!

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

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

are you using the thumbnails in search results? If you go into into your plugin manager and disable the Thread Thumbnail Search - Search plugin, this should fix your error.

steveninstl,
To correct the search problem:
See Page 8 02 APR 2008 Post # 112
~OZ

Quote:

Originally Posted by Spank (Post 1604245)

are you using the thumbnails in search results? If you go into into your plugin manager and disable the Thread Thumbnail Search - Search plugin, this should fix your error.

It fixes the error..but also turns off the thumbnail preview...I want that preview..LOL

AWESOME! It works again! Thanks!

steveninstl,
I'm running vB3.7.2PL2. Thumbnails show in my forums, in Tag searches, and New Posts/regular Searches. To add thumbnails to Tag searches see page 12, post #169.
To get further confused (hopefully not) see page 13, posts #190, #193.
~OZ

Sorry I dont know much about this coding stuff but what does this mean?
How do I do it?
Be sure to change the forum ids in the $thumbsforums array to the forum ids you want to enable thumbnails in.

Shmaba,
Click on a forum you want thumbnailed(, or look it up in AdminCP > Forums.)
In the browser window you should see something like this:
yourforum.com/forums/forumdisplay.php?f=36
IN THIS EXAMPLE, 36 is your forum's forum ID. This goes in the array.
In AdminCP edit your Thread Thumbnail plugin, adding forum 36 to the array:
example, $tt_thumbsforums = array(36);
Separate multiple forums you want thumbnailed with a comma (,):
example, $tt_thumbsforums = array(36, 37);

Well I want the whole forum to do it so I put the number 1. Im not getting anything though.

Ok, its working but I have alot of forums so do I have to enter every number forum? What if there is over 100? Is there a universal fix?

If you want thumbnails to apply to all forums copy over the thread thumbnail plugin with this

Code:

$tt_thumbsforums = array();

$tt_displaythumbs = false;



if (!in_array($forumid, $tt_thumbsforums)) {

    $tt_displaythumbs = true;

    $hook_query_fields .= ", attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid ";

    $hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png' OR attachment.extension = 'jpeg')) ";

    $hook_query_where .= "GROUP BY thread.threadid ";

}

FYI, with this any forum you set in the array line will not use thumbnails

NeverBored, Nice approach.

The forum exclusion logic NeverBored wrote could also be incorporated into this plugin tweak of mine, making it at that point a fairly comprehensive as well as solid mod/hack that covers all the bases.

First & Foremost do this/test this in your testvb forum before actually doing this in your forrealzie vB forum.

This Thread Thumbnail tweak:

Keeps Jason's original 'your selected forum IDs' thread thumbnail logic in place, which shows NO THUMBNAIL AVAILABLE if no thread 1st post thumbnail.
Adds thread thumbnail display to all other forums. If there's no thread 1st post thumbnail then the vB default thread icon is displayed.
All img lines of code have been wrapped in href tags, not just the thumbnailed threads. [If this adds "Server Issues" then delete the href open/close a tag code wrap.]

Installation instructions:

1) Temp Disable, with eventual intent to delete, the Thread Thumbnail plugin.

2) Save the following code as an XML file, naming it whatever you want, e.g., thread-thumbnail-plugins-all-forums.xml. Then load this XML file through your Admin Control Panel > Plugins & Products > Download/Upload Plugins > Import Plugin Definitions XML File window, Import the .xml file you just created. This creates plugin 'Thread Thumbnails - All Forums'.

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugins>

<plugin active="1" executionorder="5" product="vbulletin">

<title>Thread Thumbnail - All Forums</title>

<hookname>forumdisplay_query</hookname>

<phpcode><![CDATA[$tt_thumbsforums = array(2);

$tt_displaythumbs = false;

if (in_array($forumid, $tt_thumbsforums)) {

$tt_displaythumbs = true;

}

$tt_displaythumbs_all = true;

$hook_query_fields .= ", attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid ";

$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png')) ";

$hook_query_where .= "GROUP BY thread.threadid "; 

]]></phpcode>

</plugin>

</plugins>

Add the forum IDs you want thumbnailed, the ones where you definitely expect art post attachments, to the $tt_thumbsforums array.

Click on a forum you want thumbnailed(, or look it up in AdminCP > Forums & Moderators > Forum Manager).
In the browser window you should see something like this:
yourforum.com/forums/forumdisplay.php?f=36
IN THIS EXAMPLE, 36 is your forum's forum ID. This goes in the array.
In AdminCP edit your Thread Thumbnail plugin, adding forum 36 to the array:
example, $tt_thumbsforums = array(36);
Separate multiple forums you want thumbnailed with a comma (,):
example, $tt_thumbsforums = array(36, 37);

3) In all your threadbit templates add this code tweaking it to your liking.

[Note: This code includes IF statements that handle thumbnailing 1) Tag Searches (see vB.org, Thread Thumbnails, page 13, Post # 193), 2) New Posts & regular Searches (see vB.org, Thread Thumbnails, page 12, Post # 169), 3) forums (original mod logic). Delete the IF statement section(s) that do NOT apply to you.]

Find in threadbit template:

Code:

<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:

Code:

<!-- OMAC Thread Thumbnails -->

<!-- in this code:  -->

<!-- All img lines of code have been wrapped in href tags, not just threads with thumbnails -->

<if condition="$show['threadicons']">

   <td class="alt2" align="center" valign="middle">

<!-- Tag Search -->

   <if condition="($tt_displaythumbs_tags)">

     <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 />

<!-- and, don't forget to close all the If stmts with vB's original If stmt code that we've just bastardized. -->

       <if condition="$show['threadicon']">

        <a href="showthread.php?$session[sessionurl]t=$thread[threadid]">

         <img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />

        </a>

       <else />

         &nbsp;

       </if>

     </if>

<!-- end_of Tag Search -->

   <else />

<!-- New Posts & regular Search -->

     <if condition="($tt_displaythumbs_search)">

       <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 />

<!-- and, don't forget to close all the If stmts with vB's original If stmt code that we've just bastardized. -->

         <if condition="$show['threadicon']">

           <a href="showthread.php?$session[sessionurl]t=$thread[threadid]">

           <img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />

           </a>

         <else />

           &nbsp;

         </if>

       </if>

<!-- end_of New Posts & regular Search -->

     <else />

<!-- Thread Thumbnails in All Forums -->

<!-- Your forum IDs you added to the $tt_thumbsforums array will show thread 1st post thumbnail or the "NO THUMBNAIL AVAILABLE" icon -->

       <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 />

           <a href="showthread.php?$session[sessionurl]t=$thread[threadid]">

           <img src="$stylevar[imgdir_misc]/nothumb.jpg" alt="" border="0" />

           </a>

         </if>

       <else />

<!-- All Your NON-selected forums will show thread 1st post thumbnail or the vB default thread post icon -->

         <if condition="($tt_displaythumbs_all)">

           <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 />

<!-- and, don't forget to close all the If stmts with vB's original If stmt code that we've just bastardized. -->

             <if condition="$show['threadicon']">

               <a href="showthread.php?$session[sessionurl]t=$thread[threadid]">

                 <img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />

               </a>

             <else />

               &nbsp;

             </if>

           </if>

<!-- end_of Thread Thumbnails in All Forums -->

         <else />

<!-- and, don't forget to close all the If stmts with vB's original If stmt code that we've just bastardized. -->

           <if condition="$show['threadicon']">

             <a href="showthread.php?$session[sessionurl]t=$thread[threadid]">

               <img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />

             </a>

           <else />

             &nbsp;

           </if>

         </if>

       </if>

     </if>

   </if>

   </td>

</if>

<!-- end of OMAC Thread Thumbnails -->

Once you get this to work then go ahead and delete the original Thread Thumbnail plugin -OR- just keeping it disabled works too.

~OZ

OK for some reason the thumbnails dont show up when your viewing as a guest? How do we change it so its viewable for everyone?

Anyone else have a fix for this?

Quote:

Originally Posted by Shmaba (Post 1606167)

OK for some reason the thumbnails dont show up when your viewing as a guest? How do we change it so its viewable for everyone?

Guests (Unregistered/Not Logged in)
Under: Forum Viewing Permission
Parameter: Can Download Attachments must be set to YES.

Would love to see this for 3.7 and would donate $5 to make it happen. PM me to claim your $

OK...I'm back...

I upgraded (I'm starting to hate upgrades) to VB 3.7.3 and I get this new SQL..

Database error in vBulletin 3.7.3:

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
GROUP BY thread.threadid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY thread.threadid' at line 24
Error Number : 1064
Request Date : Thursday, August 28th 2008 @ 07:41:56 AM
Error Date : Thursday, August 28th 2008 @ 07:41:56 AM
Script : http://www.pimpmyberry.com/search.php?searchid=2966
Referrer :
IP Address : 1234567890
Username : StevenInSTL
Classname : vB_Database
MySQL Version : 5.0.51a-community

I did all the fixes to the search.php, and I still get the error...

Any idea?

If you have the 'Thread Thumbnail - Search' plugin turned ON - Did you change, add the TT code to, the vB3.7.3 search.php file? (see Post # 112 on Page 8)
If you have the 'Thread Thumbnail - Tag Search' plugin turned ON - Did you change, add the TT code to, the vB3.7.3 tags.php file? (see Post # 169 on page 12)
In my testvb instance I successfully upgraded to vB3.7.3, after adding the TT code to both search.php and tags.php, and both plugins work for me.

does this work with hotlinked images? ie [img]?

I've seen something working here:
http://www.inspiring-photography.com...isplay.php?f=7

and they seem to be linked images, not attachements... Any idea what mod that is if it's not this one?

Thanks

Quote:

Originally Posted by jacobsen1 (Post 1609257)

This mod doesn't work with hotlinked images. You should contact them and ask them to post in this thread how they're doing that.

I dont think this mod has anything to do with the error I am getting...thanks!

I have A Problem.

I have install this Hack. And replace the ID.

Now i can see the image "no Thumbnail avaliable" but how can i replatze this image with a picture in a thread?

what musst i do?

Diniska,
This plugin will ONLY display a thumbnail for the FIRST post of a thread, and, ONLY an image posted as an attachment, using Manage Attachments, will show as a thumbnail picture. Posts with Image INSERTs and LINKs won't show as thumbnails in the post nor as thumbnails in this plugin. I hope this helps answer your question.
~OZ

Ok after deleting every mod one by one because I was getting a search error link can be found below
https://vborg.vbsupport.ru/showthread.php?t=189322

I deleted this Mod last and guess what everything worked! Now I reinstalled every mod but this one and my search is still working. What is causing this?

Shmaba,
If you have the 'Thread Thumbnail - Search' plugin turned on then you HAVE to modify search.php, adding the TT code, or New Posts and/or regular searches will bomb with database errors. End of chat here.

See Post # 228 this page which references other posts that no one seems to read that could possibly have the answer to your question hidden away somewhere in them.

~OZ

How do you turn if off?

Quote:

Originally Posted by NeverBored (Post 1605403)

If you want thumbnails to apply to all forums copy over the thread thumbnail plugin with this

Code:

$tt_thumbsforums = array();

$tt_displaythumbs = false;



if (!in_array($forumid, $tt_thumbsforums)) {

    $tt_displaythumbs = true;

    $hook_query_fields .= ", attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid ";

    $hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png' OR attachment.extension = 'jpeg')) ";

    $hook_query_where .= "GROUP BY thread.threadid ";

}

FYI, with this any forum you set in the array line will not use thumbnails

Ok so say I have alot of forums that I want to use but then about 6 I dont want to have appear what coding can you create for that? Thanks!

anyone anyone? Bueller? Anyone.

Quote:

Originally Posted by Shmaba (Post 1615475)

How do you turn if off?

Go to the Plugin Manager screen (AdminCP > Plugins & Products > Plugin Manager):
For the ‘Thread Thumbnail – Search’ plugin:
Disable (uncheck the Active box)
OR
Delete the ‘Thread Thumbnail – Search’ plugin (REQUIRES REINSTALL IF YOU EVENTUALLY DECIDE TO USE THIS PLUGIN!!)
Then, do a Save Active Status.

Quote:

Originally Posted by Shmaba (Post 1615835)

Ok so say I have alot of forums that I want to use but then about 6 I dont want to have appear what coding can you create for that? Thanks!

Put the forum ids of the forums you don't want in the array.

So for example if you want to exclude forum 3 and 5, it'd look like this

$tt_thumbsforums = array(3,5);

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01640 seconds Memory Usage 1,881KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: