Last thread with last post icon instead of clear image

(The creator of the original hack is DR2000; I have since then modified it further)

Here's the hack in a handy dandy text file:

Hack:lastthreadlastposticon.txt

It is incredibly simple...you need only edit one file and one template! It can be done in a couple minutes!

###Features###

- Shows the thread name of the last active post on the front page
- Shows the lastpost.gif icon for the theme you're using, instead of either A, using a clear (invisible) image, or using the default lastpost.gif image for the lastpost icon
- If the subject is long enough to start stretching the field on the index page, it'll show a shrinked version (i.e. "I need help with version.....).

Note: This has only been tested on version 2.2.1!

To see it in action, just visit www.ConsoleBoards.com !

[nuno]

PHP Code:

<img src="images/lastpost.gif" border="0" alt="Go to last post"></a></td> 

hmmm

shouldnt this be replaced by

PHP Code:

$forum[icon] 

just a thought

[Island Roots]

Well, I was tweaking the hack for about a day, and I ended up with that and it works...no broken links or broken images, so no.

By the way, sorry about stretching out the board...I don't know how to add .txt or .zip files.

[TheComputerGuy]

its all good...

[Island Roots]

Alright, now I've got the hack in a text file so it doesn't stretch the boards!

[Xsentrik.com]

great hack thanks alot

[Sadie Frost]

When I try to open your text file, it tells me "no attachment specified" - am I doing something wrong already? Thanks!

[Island Roots]

The link is wrong. Let me fix it. You can also get it by clicking here:

[Sadie Frost]

Thank you!

[epic]

when i install this hack i got a error at this line

$forums=$DB_site->query('SELECT forum.*, CASE WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title as thtitle FROM forum left outer join thread on thread.forumid = forum.forumid and thread.lastpost >= (forum.lastpost-30) LEFT OUTER JOIN icon ON icon.iconid=thread.iconid WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder');

no other info.Can u help me?