vb.org Archive
Page 12 of 37 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

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 04-02-2008 03:55 PM
NeverBored,
I did a file compare using TOAD: vB369 search.php versus Thread Thumbnails search.php.
There's very little difference between these two search.phps.
There's quite a difference between vB370RC2 search.php versus Thread Thumbnails search.php, though.
I put together a cluge-bag screen capture of the search.php differences, put into a Word document, that I can PM to you.
~OZ

theOZer 04-02-2008 05:11 PM
If you add JasonMerchant's code, a comment line and code line, to the vB370RC2 search.php it APPEARS to work; now shows the thumbnails when doing a New Posts search.
Code:
        // do data query
        if (!empty($itemids))
        {
                $ids = implode(', ', array_keys($itemids));
                $dataQuery .= '(' . $ids . ')';
                //edited by jason
                $dataQuery .= " " . $hook_query_where;                $items = $db->query_read_slave($dataQuery);
                $itemidname = iif($search['showposts'], 'postid', 'threadid');

                $dotthreads = fetch_dot_threads_array($ids);
        }
[Note: I bolded Jason's code for clarity.]

Give this a try. This truly is a wonderful hack and it's a priceless addition to any art forum that has people posting their art work.
~OZ

NeverBored 04-02-2008 07:00 PM
Great, that got the thumbnails working for search, thanks.

Though, a small problem, it displays thumbnails (the no thumbnail available image) for threads not in the specified forums. It did this using the search.php included in the download too, so I don't know if this is how it works or just a bug using it as is on 3.7.

theOZer 04-02-2008 07:19 PM
True enough. It appears any 'new posts,' be it from whichever forum, either shows the 'No Image' icon or, if there's an attachment, it shows the thumbnail.
If the forum itself is not included in the TT plugin's list of forums to display,
example, $tt_thumbsforums = array(4, 5, 17, 46, 50, 53);
then that specific forum's threads list do not then show thumbnails when viewed.
This 'feature'/not-necessarily-a-bug appears to have been 'in place' since day one the hack has been around. (I also see this glitch occurs in vB3.6.x.)

lauxanh 04-04-2008 04:29 AM
I got mysql error after upgrade to 3.6.9 when search for thread started by member.
Quote:
Database error in vBulletin 3.6.9:
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.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed

, 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 subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
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
(31818, 31485, 26032, 30791, 30777, 12626, 31813, 17504, 30916, 14352, 30784, 30778, 30802, 30768, 31388, 28247, 30765, 31152, 15399, 30806, 27583, 15294, 20513, 30131, 30793);
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
Date : Friday, April 4th 2008 @ 12:26:57 AM
Script : http://www.xxxxxxxxxx/search.php?searchid=222763
Referrer : http://www.xxxxxxxxxx/member.php?u=67920
Classname : vb_database
Any idea how to fix it?

theOZer 04-04-2008 01:45 PM
You need to turn off the Thread Thumbnail - Search plugin.
-OR-
Add Jason's code to the vB369 search.php, as mentioned in my Post #112, above.
~OZ

winkm 04-06-2008 09:17 AM
Hi, I installed this mod which is great, but it only shows "No Thumbnail Available" also if there is an image attachment. I'm running 3.6.8 patch level 2.

See:
http://www.inoudeansichten.nl/zoekpl...splay.php?f=40

I used: Thread_Thumbnail_v1-1.zip
- imported the XML
- activated plugin
- updated threadbit

Any suggestions how to solve this ?
thanks!

theOZer 04-06-2008 01:46 PM
I'm looking at your web site...

Are you dead certain that you've updated threadbits correctly? Most likely, yes.

Did you update the Thread Thumbnail plugin, adding your test forums ID number (bolded below)?

http://www.inoudeansichten.nl/zoekpl...display.php?f=40

(I'd also try adding forum ID 42 (the main forum), to test it out.)

In the Thread Thumbnail plugin, is forum 40 been added?:
example, $tt_thumbsforums = array(40, 42);

Did you set up a member option User Profile field for Thumbnails On/Off? If not then do NOT include the code to check for the user profile field in your threadbits. (I have this option added.)

Have you replaced your vB368PL2 search.php with Jason's search.php? (It works for vB368 but vB369 a/o vB370x requires modding the search.php adding Jason's code. See my post # 112 , above, concerning this.)

Jason's TT works and has always worked for me. Good luck getting this to work. It's a great hack.

[Note: only an image posted as an attachment will/should show as a thumbnail pic; the test image INSERTS, e.g., your test3 post, won't show as thumbnails.]

Later, ~OZ

winkm 04-13-2008 08:31 AM
OZ, thanks for your reply !

I upgraded my vBulletin to 3.6.9
- installed xml file
- updated threadsbit
- changed forum to #40
- update search.php (incl. your 112 post)
- plugins are both activated

but ... attachments still not displayed ....

any other suggestions I can try ???

thanks!:confused:

theOZer 04-13-2008 05:42 PM
winkm,
Joined your forum. Couldn't post in TEST forum to see if my hunch is right, but...
the test threads' pictures are full sized. It appears that the images were inserted into the post code, not added as attachments through Manage Attachment at the bottom of an Advanced screen post.
Images inserted directly into the code/the post don't have thumbnails; they're shown full sized, with no need to click on them to see them larger.
That's my guess.
~OZ


All times are GMT. The time now is 08:19 PM.
Page 12 of 37 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

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.02444 seconds
  • Memory Usage 1,751KB
  • 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
  • (1)bbcode_code_printable
  • (1)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