vb.org Archive

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)

theOZer 08-24-2008 05:44 AM

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

Shmaba 08-25-2008 12:01 AM

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?

Shmaba 08-25-2008 12:54 PM

Anyone else have a fix for this?

theOZer 08-25-2008 03:05 PM

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.

covertsem 08-28-2008 01:59 AM

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

NeverBored 08-28-2008 02:31 AM

It's works for 3.7

steveninstl 08-28-2008 10:57 AM

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?

theOZer 08-28-2008 03:14 PM

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.

jacobsen1 08-28-2008 06:20 PM

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

NeverBored 08-28-2008 06:57 PM

Quote:

Originally Posted by jacobsen1 (Post 1609257)
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

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.


All times are GMT. The time now is 07:29 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01290 seconds
  • Memory Usage 1,789KB
  • 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
  • (3)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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