Vision 2.1

i promised to reduse the extra queries to 1. in this 1 query, we can get the last post title, last thread title and last icon... so it have a shorter load time...

i still believe my this hack Release is the simplest mode to display the last post titles in Forumhome & Forumdisplay Page, because it dosen't need any action in database, and just modify 2 places in 2 files... furthermore, now the new vision have reduced the load time very much...

many thanks to PPN for his help...

OK, let's go!

1. change index.php and forumdisplay.php:

find in index.php:find in forumdisplay.php:below these add:
2. i have made the post icons display... so change the template forumhome_lastpostby to:

DONE!




------------------------------------------------------------------------------
The Older Vision
a PHP+MySQL newbie's bad exercise...
if you find interest in this you can compare it with the last Release...


someone has posted this type hack, but this Release has a little difference. and in the other's release there's some bugs(about the subforums' last post title), now it has been fixed:

1. change index.php and forumdisplay.php:

find in index.php:

// prepare template vars
if (!$showforumdescription) {
$forum['description']='';
}


find in forumdisplay.php:

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


below these add:

// start last post title hack by cx
$forum_this = $DB_site->query_first("SELECT parentlist FROM forum WHERE forumid=$forum[forumid]");
$forum_this_parents = explode(',', $forum_this[parentlist]);
$forum_this_parents_count = count($forum_this_parents);

$forum_sons = $DB_site->query('SELECT parentlist,forumid FROM forum');
while ($forum_son = $DB_site->fetch_array($forum_sons)) {
$forum_parentlist = $forum_son[parentlist];
$forum_parents = explode(',', $forum_parentlist);
$forum_parents_count = count($forum_parents);
if ($forum_parents[$forum_parents_count - $forum_this_parents_count] == $forum[forumid]) {
$forum_son_all[] = $forum_son[forumid];
}
}

if ($forum_son_all != '') {
$forum_sons = implode(',', $forum_son_all);

$lastposttitlex = $DB_site->query_first("SELECT post.title FROM thread,post WHERE thread.forumid IN($forum_sons) AND post.threadid=thread.threadid AND post.visible=1 ORDER BY post.dateline DESC");
$lastposttitle = ''.$lastposttitlex[title];

if ($lastposttitle == '') {
$lastposttitlex = $DB_site->query_first("SELECT title FROM thread WHERE forumid IN($forum_sons) AND visible=1 ORDER BY lastpost DESC");
$lastposttitle = 'RE: '.$lastposttitlex[title];
}

if (strlen($lastposttitle) > 30) {
$lastposttitle = substr($lastposttitle, 0, 28);
$lastposttitle .= '..';
}
}
// end last post title hack by cx


2. change the template forumhome_lastpostby to:

<div align=right><smallfontbr><nobr><a href="showthread.php?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]" title="turn to last new post">$lastposttitle</a></nobr><br><nobr>$forum[lastpostdate] <font color="#666686">$forum[lastposttime]</font></nobr><br><nobr>by <a href="member.php?s=$session[sessionhash]&action=getinfo&find=lastposter&forumid=$forum[forumid]">$forum[lastposter]</a></nobr></smallfont></div>


3. done! easy and funny job :)

Is there an example/preview we can see?? Perhaps a URL??

yes an example would be nice before i add it to my hack list :).

Nice work, i've been waiting for someone to fix the subforum bug, but wasn't sure if anyone would figure out the parent/child stuff.

This doesn't include the icon that the old hack now inlcudes, any chance you (or someone) can add it please ?

This increased loading time on the forum by over 7 seconds. This is far too long, so i removed the hack.

Right, installed it on my main board, 40 user online -> server load 11 *lol*

I'll post the version i was using before i tried to install this one, i wrote it so when someone posted it added the title to the forum table. Then it is selected anyway when the forum is loading. I never managed to get it compatible with sub-forums, i will work on that just now.

well obviously it adds loading time he queried the database 4 times in this script.. way to many times. try another way.

64 users on board was 0.48
after this hack it hit 9.46

and that was with 39 forums :rolleyes:

i just have to finish testing my versio and hopefully it should work well.

yes i have chage my code in the first post. or you can see the screenshot here...