Last post WITH icon on first page (no database modifications needed)

#### Subject Preview by DR2000 ####
I looked at all other hack avaliable for this, and all of them
are trying to do too much by editing your database structure,
and modifying the way data is inserted. Why overcomplicate
things, when all data is already there, and it only needs to be
extracted...

#### DEMO ####
To see this hack in action take a look at
http://forum.4adrive.com

#### FEATURES ####
- Shows the subject of the last active post on the front page
- Shows the icon of the last active post on the front page
- No need to alter database, and risk to screwing something up
- Only one file to change
- If the subject was very long, shows trunkated version of it,
and replaces the rest with '...', preventing your main page
layout from being screwed up.

#### #### ####
Nov 14, 2001
#### #### ####

Note: Tested with 2.0.3, 2.2.0 and 2.2.1.

[xware]

Originally posted by FWC
What was the fix?

in index.php and formdisplay.php
above this hack's code:
$forum['dots'] = '';
add the below code:

PHP Code:

if($forum['thtitle']=='') {
                          
                          $newtitle=$DB_site->fetch_array($DB_site->query("SELECT thread.title AS title FROM  thread WHERE lastposter='$forum[lastposter]' AND thread.lastpost=$forum[lastpost]"));
                          $forum['thtitle']=$newtitle[title];
                        }
                        else {
                          $forum['thtitle']=$forum['thtitle'];
                        } 


and I have released a hack my own.you can try that one.

[DR2000]

I wouldn't recommend doing that. If you have 30 forums, this will query the database 30 times everytime a page is opened, and database query is a very expensive operation (speed, and load wise).

[bigstar]

Awesome hack.. much better then all the others I have tried. The others tend to screw up if you delete/move posts.

Just one question, I don't want to show the post icons, how could I change the query code to remove that?

[xware]

Originally posted by DR2000
I wouldn't recommend doing that. If you have 30 forums, this will query the database 30 times everytime a page is opened, and database query is a very expensive operation (speed, and load wise).

I see,but if not do this, the last title in sub forum will miss in forumhome.
and this fixed code I post is only work when you have sub forum.

[FWC]

Originally posted by bigstar
Just one question, I don't want to show the post icons, how could I change the query code to remove that?

I took the lazy way out and commented the code for the icon out in the template.

[DR2000]

Originally posted by FWC
I took the lazy way out and commented the code for the icon out in the template.

Yep. Just edit the template.

[bigstar]

I was referring to the sql query, surely I can remove the fragment that requests the icon. I just don't know exactly what needs to be removed.

[Bitmap]

works great thanks ... tried to install ppns hack first, but all i got were parse errors. but this one is REALLY easy to install. well done

[Alex]

how can i exclude private forums from show their last title to every one?

[Bitmap]

oeh ... arn't they excluded already? i have a private forum ... it isn't showing on the front page