Last Active Thread Display

This is for vB 2.01

This little hack allows the display of the last active thread on the forums pages. This is the 'UBB like' feature. You can see an example at http://dbforums.com.

NOTES
It requires two extra column to be added in the forum table a few code additions and then the thread title and iconid can be referenced using the variables $forum[lastactivethread] and icon$forum[lastactiveiconid].gif. Instructions are in the attachment.

This was originally part of my usenet hack and due to popular request ( all two of them ) I'm releasing it seperately.

[eva2000]

nice but what happesn with very long thread titles ?

[h4p3]

I think they are cut off, if they are too long.

Looks like an awesome hack, and I really want to get it going, but I have no idea how to :

1) Run the following SQL statement:

ALTER TABLE forum ADD lastactivethread VARCHAR (64);

Is their an easy way to do this?

Thanks

[eva2000]

Originally posted by Degen
Looks like an awesome hack, and I really want to get it going, but I have no idea how to :

1) Run the following SQL statement:

ALTER TABLE forum ADD lastactivethread VARCHAR (64);

Is their an easy way to do this?

Thanks

you can run that via phpmyadmin you can get it from www.phpwizard.net

[nuno]

great hack fastforward
any chance to show last post icon also?
tx

[h4p3]

Hm, i noticed that it doesn't work correctly at dbforums.com. If you click on the last post icon, you will get only a blank page.

[fastforward]

Originally posted by h4p3
Hm, i noticed that it doesn't work correctly at dbforums.com. If you click on the last post icon, you will get only a blank page.

That's a template issue. It has nothing to do with the hack. All the hack does is create a new variable that can be accesed via the forum home pages.

[fastforward]

Originally posted by eva2000
nice but what happesn with very long thread titles ?

The default length of the title is 45. This is controlled by the variable $lastactivethread_length.

If you want it longer, add a line to your config_inc.php that reads

$lastactivethread_length=64;

or whatever. If you need it longer than 128, you will also need to increase the table column width.

[eva2000]

Originally posted by fastforward

The default length of the title is 45. This is controlled by the variable $lastactivethread_length.

If you want it longer, add a line to your config_inc.php that reads

$lastactivethread_length=64;

or whatever. If you need it longer than 128, you will also need to increase the table column width.

thanks gonna try this out locally first