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

[Cerbero1000]

Solved. All works perfectly!

[matthewhotdude]

Installed, but no thumbnails are showing up.

Ok sorted that out, had to add the width manually.

But is there a way to update all old threads so the thumbnails show up?

[Null Parameter]

Originally Posted by matthewhotdude

Installed, but no thumbnails are showing up.

Ok sorted that out, had to add the width manually.

But is there a way to update all old threads so the thumbnails show up?

I haven't tested this, but others have used it successfully.

Originally Posted by megamoose

This should enable batch processing. I have tested it.
Change the $STEP_AMOUNT at the top to something lower if you still get errors
Remember this is for vB version 3.8
Always backup your data before running scripts like these

TO THOSE WHO HAVEN'T BEEN FOLLOWING THE CONVERSATION:
This script will go through all your existing posts and give them thumbnails, based on the First IMG in post option.

<?php $STEP_AMOUNT = 600; ?>

<input type="button" id="btnNext" value="Process Next Results" onClick="window.location='?start='+(<?php echo $_GET["start"]; ?>+<?php echo $STEP_AMOUNT;?>)" disabled=true><br>
The button above should enable once this batch is complete!<br>
<br>

<?php
error_reporting(E_ALL & ~E_NOTICE & ~8192);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('SKIP_SESSIONCREATE', 1);
define('NOCOOKIES', 1);
define('THIS_SCRIPT', 'xupdate');
define('CSRF_PROTECTION', true);

// #################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

if (!$_GET["start"]) { $_GET["start"] = 0; }


        $threads = $db->query_read_slave("
        SELECT * 
        FROM " . TABLE_PREFIX . "thread
        LIMIT ".$db->escape_string($_GET["start"]).",". $db->escape_string($_GET["start"]+$STEP_AMOUNT));

while ($thread = $db->fetch_array($threads)){
    echo "<b>Thread:</b> ".$thread["title"]."<br>";

    $posts = $db->query_read_slave("SELECT * FROM `" . TABLE_PREFIX . "post` WHERE `postid` = '".$thread["firstpostid"]."'");
    $post = $db->fetch_array($posts);
    echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          <b>First Post:</b> ".$post["title"]."<br>";
preg_match('/\[img\](.*?)\[\/img\]/i',$post["pagetext"],$matches);
$query = "UPDATE `" . TABLE_PREFIX . "thread` set `thumbnailurl` = '".$db->escape_string($matches[1])."' WHERE threadid = " . $thread["threadid"];
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <b>SQL:</b>".$query."<br><br>";
$db->query_write($query);

}
?>

<script> document.getElementById("btnNext").disabled = false; </script>

[Null Parameter]

Originally Posted by Cerbero1000

Solved. All works perfectly!

Good to hear! What did you have to do?

Also, I forgot that I fixed and uploaded a new version where thumbnails should work correctly. Not sure how I forgot that....

[matthewhotdude]

Originally Posted by Null Parameter

I haven't tested this, but others have used it successfully.

Where do I do that?

Sorted!

Thanks great mod works perfect

[Null Parameter]

Originally Posted by matthewhotdude

Where do I do that?

Sorted!

Thanks great mod works perfect

Great!

[siliconfinance]

Originally Posted by Null Parameter

That is currently an option in the vB4 version, but not in this one. If there's demand for it, I could probably port that functionality back here as well.

:up:^Pie^3

If you did it, it would make a lot of people

[Cybershaolin]

Very nice hack but I have a problem with it. I use "First Attachment as the option for displaying the thumbnail but whenever the user does not have any attachments in the thread, nothing shows in the forum column. No thread icon or no "Nothumb.jpg" image even if I have define to use one image if there is none uploaded by the user. The path for nothumb.jpg is correct.

The result is not really nice since it only shows thumbnails for users who have attachments and it shows empty spots everywhere else. So, all the thread icons have disapeared and/or no "Nothumb.jpg" image is showing. I used to have what you see on the first picture but now I have what you see on the second picture.

Why is it doing that and am I the only one for which this is happening?

I chose automatic template edits in the options but, if I decide to choose to do manual edits for the templates, where are they? There is nothing in the readme talking about manual template edits besides those if you upgrade from a previous version.

[Cybershaolin]

I found out what's happening:

1- If you use the option "First Attachment: If the user adds an attachment to the thread, the first image attachment will be used as the thumbnail."
- The thumbnail is diplayed correctly as shown in my previous post in the attached screenshots.
- There is nothing else shown if no attachment is present, No "Nothumb.jpg" picture or no thread icon, just a blank space, again, as shown in my previous post in the attached screenshots.

2- If you use the option "First Image In Post: If the user adds an image into their post, via [IMG] tags, then the first image in the post will be used as the thumbnail."
- The thumbnail is diplayed correctly in the forum.
- If no attachment is present, then the picture "Nothumb.jpg" picture displays correctly if we choose to display it or the thread icon also displays correctly if this option is retained.

Therefore, for me, only the option "First image in Post" works correctly for the thread icon or the "Nothumb.jpg" picture to appear when there is no IMG tag in the post.

The problem is that I don't want to use this option or the URL option either. I want to use the option "First Attachment"! So is there a fix for this? And finally, is it possible to get the template manual edits?

[Cybershaolin]

That would be nice to get some kind of answer on the bug I'm experimenting.