you guys already have this hack?

Its like the UBB look, it shows the last post icon and title for each forum instead of just the username , time and date on the forum front page (index.php) in the LAST POST column.

I can post it if nobody has released it

SNA

Ill take that as a 'what the hell are you talking about'

heres what i mean

im sorry, but that seems compleatly useless!
(hey 100 posts)

This is a function my members have been using on my ubb and I would love to have a hack for VB that does it!

Where is it at?

You can do it by editing the templates.
Its easy to do.

You have to hack the templates yes but you need to write code to get the latest title and icon in each forum.

If you can do it without writing a function please let me know.

I can post the hack on how I did it you guys want.

Thank you SNA

I would love to try your hack on my board. waiting ..

EDITED >> 3-18-2001 11:07 AM Central Time
Fixed the Select Statement to take in consideration if the thread was moved or not by looking for open='1'.


Add this code to the bottom of admin/functions.php before ?>

PHP Code:

function active_topic($theforumid)
{
global $DB_site;

$activeresult = $DB_site->query("SELECT thread.title,thread.iconid,icon.iconpath FROM thread LEFT JOIN icon ON thread.iconid=icon.iconid WHERE forumid='$theforumid' AND open='1' ORDER BY lastpost DESC LIMIT 1");
$activeresults = $DB_site->fetch_array($activeresult);

return($activeresults);

} 


Add this code to index.php

PHP Code:

    $lastposthome = active_topic($forum[forumid]);
    $lastposthome[title] = substr($lastposthome[title],0,40) . "...";
    if($lastposthome[iconpath]){
    } else {
    $lastposthome[iconpath] = "images/icons/icon1.gif";
    } 


after

PHP Code:

if ($forum['lastpost']>0) {
          $forum['lastpostdate']=vbdate($dateformat,$forum['lastpost']);
          $forum['lastposttime']=vbdate($timeformat,$forum['lastpost']); 


now add this code to forumdisplay.php

PHP Code:

    $lastposthome = active_topic($forum[forumid]);
    $lastposthome[title] = substr($lastposthome[title],0,40) . "...";
    if($lastposthome[iconpath]){
    } else {
    $lastposthome[iconpath] = "images/icons/icon1.gif";
    } 


after

PHP Code:

        if ($forum['lastpost']>0) {
          $forum['lastpostdate']=vbdate($dateformat,$forum['lastpost']);
          $forum['lastposttime']=vbdate($timeformat,$forum['lastpost']); 


Now to get it to show up on you board.


Edit the 'forumhome' template.


replace it with this

<img  src="$lastposthome[iconpath]" border=0> 
&nbsp;<a href="showthread.php?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]"><smallfont>$lastposthome[title]</smallfont></a>
<smallfont>(by <a href="member.php?s=$session[sessionhash]&action=getinfo&find=lastposter&forumid=$forum[forumid]">$forum[lastposter]</a>)</smallfont>
<br>
<smallfont>$forum[lastpostdate]</smallfont> <smallfont COLOR="#6c6081">$forum[lastposttime]</smallfont>

There you go...

Again, I am new to PHP/MySQL and right now I know how to make things work. Whether its efficient or not, thats another story, im getting there

PM me if you have any problems.

LittleBird. Did it work?