[Overgrow]

>>overgrow, post your forumdisplay.php as an attachment

Sorry, can't post whole vB files as it violates the license. Freddie made this super easy though.. I see no reason why this wasn't suggested as the first way to code the hack. Here is the important part of forumdisplay.. add the first part and modify the query by including $previewselect and $previewjoin.

PHP Code:

// HACK POST PREVIEW
    $previewselect="post2.pagetext as pagetext,";
    $previewjoin="LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)";
// END PREVIEW

$threads=$DB_site->query("
SELECT $dotuserid $votequery $previewselect "
.iif($foruminfo[allowicons],'icon.title as icontitle,icon.iconpath,','')."
    thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
    lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach
    FROM thread
    ".iif($foruminfo[allowicons],'LEFT JOIN icon ON (icon.iconid = thread.iconid)','')."
    $dotjoin $previewjoin
    WHERE $threadids
    ORDER BY sticky DESC, $sortfield $sqlsortorder
    "); 


One of my users asked why this didn't work for search results, so that is pretty easy to move over. Search.php

find:

PHP Code:

$dotuserid = '';
      $dotjoin = '';
    } 


below that add

PHP Code:

// HACK POST PREVIEW
    $previewselect="post2.pagetext as pagetext,";
    $previewjoin="LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)";
    // END PREVIEW 


find

user.userid AS postuserid,

replace with

user.userid AS postuserid, $previewselect


find

LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
$dotjoin

replace with

LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
$dotjoin $previewjoin


find

PHP Code:

$searchresult['pagetext'] = $ignoreduser;
        $searchresult['posttitle'] = $ignoreduser;
      } else { 


below that add

PHP Code:

// POST PREVIEW HACK
        $searchresult[pagetext]=preg_replace("/\[[^\]]*\]/","",$searchresult[pagetext]);
        $searchresult[pagetext]=str_replace("\"","",$searchresult[pagetext]);
        if (strlen($searchresult[pagetext]) > 300) {
         $fppreview = substr($searchresult[pagetext], 0, 300) . "...";
        } else {
         $fppreview = $searchresult[pagetext];
        }
        // END PREVIEW 


Then put $fppreview in the searchresultbit_threadonly template.

I noticed this was your first project so I hope you write this all up into a new hack so it's not confusing for the other users. thanks~