First post on every page of thread.

I had a use for it, so I thought I would share it.

Requires no file edits (Thanks Kirby!).
Adds no quarys when viewing threads

This is something like here on vbulletin.org , it allows you to select forums where the first post of the thread is shown thru out the thread.

It uses stock template looks now , if someone wishes to make a template and share it feel free.

I will offer support as I can.

Ps. If you install this hack please click the install :nervous:

Templates for first post:
https://vborg.vbsupport.ru/showpost....&postcount=124
https://vborg.vbsupport.ru/showpost....&postcount=161

[vBintense]

Originally Posted by Boofo

No, sir, it isn't bad at all. But no file edits are even better.

Yes, I agree but no added quary owns all

[Boofo]

Did you really think I wouldn't be ready for this? LOL

But no added query and no file eidt is the best!

[vBintense]

[high]* vBintense kicks boofo out of my thread until he clicks intall !!!
[/high]

I did look though , I may be blind but I could not find a way not to edit the file

[Boofo]

And there may ne no way around it. But if there is a way, Kirby is the one who will find it.

[high]* Boofo will install when the file edit gets taken care of or Kirby can't find a way to do it. [/high]

[vBintense]

[high]* vBintense looks for the all knowing Kirby to point him into this thread [/high]

[Logikos]

[high]* Logikos clicks install because I will use this later. File edit or not [/high]

[chanhlinh]

Thanks a lot! You're my Hero

[Andreas]

Guess what, I hate File Edits

Hook: showthread_query

PHP Code:

if ($forum['showfirstpost'])
{
    $hook_query_where .= " OR post.postid = $thread[firstpostid]";
} 


This does show the first Post on all Pages. However, if it has attachments they will only be shown on the first Page.
Don't think there is a way to get this working too without a File Edit, but i'll take a further look.

[Logikos]

Originally Posted by KirbyDE

Guess what, I hate File Edits

Hook: showthread_query

PHP Code:

if ($forum['showfirstpost'])
{
    $hook_query_where .= " OR post.postid = $thread[firstpostid]";
} 


KirbyDE to the rescue!!!!!!one

damm, almost

[Andreas]

After looking over the Code for a while, I found a solution that also works for Attachments

Hook: showthread_post_start

PHP Code:

if ($forum['showfirstpost'] AND $threadedmode == 0 AND $thread['attach'])
{
    // Backup
    $thread['hasattach'] = $thread['attach'];
    unset($thread['attach']);
} 


Hook: showthread_query

PHP Code:

if ($forum['showfirstpost'])
{
    $ids .= ",$thread[firstpostid]";
    $postids = "post.postid IN (0" . $ids . ")"; 
    if ($thread['hasattach'])
    {
        $attachments = $db->query_read("
            SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
                postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
                attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
            FROM " . TABLE_PREFIX . "attachment
            LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype USING (extension)
            WHERE postid IN (-1" . $ids . ")
            ORDER BY attachmentid
        ");
        $postattach = array();
        while ($attachment = $db->fetch_array($attachments))
        {
            if (!$attachment['build_thumbnail'])
            {
                $attachment['hasthumbnail'] = false;
            }
            $postattach["$attachment[postid]"]["$attachment[attachmentid]"] = $attachment;
        }      
        // Restore
        $thread['attach'] = $thread['hasattach'];
        unset($thread['hasattach']);
    }
} 


What it does:
By unsetting $thread['attach'] in showthread_post_start, the original $attachments query will not be executed.
Then the Plugin on showthread_query runs this Query - with the Postid for the First Post and then restores the original Value for further processing.