Last post on forum home, working version

I had tried a version suggested by someone else instead of my own and well, all it did was send the load average up by about 10 times what it was.

This version inserts the last title into the forum database when it is updating the last post name and time. There is no difference in loading time as everything is called normally by vBulletin.

This works on 2.0.x and 2.2.x

Updated at 11:34 GMT on 28th September 2002

Thanks to floren for the latest update.

[floleb7]

the title of the last post works but now time and date are not showing

[Amasov]

Here I got another problem:

Some lastpost-thread-descriptions won't be shown.

I used the utility "update counters", but it doesn't works.

What can I do?

Here is a sample:

[dxb]

i just cleared my cache and downloaded the file and named it with a different name and still the file is not updated it's still says 2.0.1

[Scott MacVicar]

I looked at your forums Amasov and all looks ok now? did it just sort itself?

dxb i can assure you its the new version i've tried it on multiple computers and Firefly to, pm me your email and i'll email you the file then.

Scott

[Amasov]

Originally posted by PPN
I looked at your forums Amasov and all looks ok now? did it just sort itself?
Scott

Heyho, Scott

I just sorted it myself while I was posting in the latest thread and deleted that post. Anyhow, if there was a new post in that described forums, the thread-description was shown. Therefore I made that database-update "by hand".

By now it works perfectly.

Thanks overall.

Regards,
Chris.

[The Realist]

Installed as per instructions and got the following error:

Parse error: parse error in /home/sites/home/web/forum/admin/functions.php on line 2254

Warning: Cannot add header information - headers already sent by (output started at /home/sites/home/web/forum/admin/functions.php:2254) in /home/sites/home/web/forum/admin/functions.php on line 1524

Fatal error: Call to undefined function: makelogincode() in /home/sites/home/web/forum/global.php on line 332


Any help?

[jamie]

yey thanks!

i made my own version...but i never could get the right code in functions.php to make it work there

one suggestion could you add the last ico too, i already have this included in my version...i just can't code the correct stuff for functions.php to make it work there..ie when updating forums info or after a post is deleted

[The Realist]

Working now but Instructions a little bit confusing.

Were it says:

change to

if ($lastposts['lastpost']) {
if ($lastposts['lastpost']>$lastpost or $lastposts['lastpost']<$currentlastpost) {
$lastposts=$DB_site->query_first("SELECT lastpost,lastposter,title FROM thread WHERE lastpost='$lastposts[lastpost]'");
$lastpost=$lastposts['lastpost'];
$lastposter=$lastposts['lastposter'];
$lasttitle=$lastposts['title'];
}
}

This is not needed at all for 2.2.0 and users of 2.2.0 in fact need:

FOR 2.2.x USE THE FOLLOWING
-----------------------------------
look for
$lastpostquery=",lastpost='$lastpost',lastposter=' ".addslashes($lastposter)."';

change it to

$lastpostquery=",lastpost='$lastpost',lastposter=' ".addslashes($lastposter)."', lasttitle='".addslashes($lasttitle)."'";
save the file and upload then continue hack as normal

Can the very first bit " if ($lastposts['lastpost']) { " be deleted and replaced with FOR 2.0.x USE THE FOLLOWING Info.

[Scott MacVicar]

The

PHP Code:

  if ($lastposts['lastpost']) {
    if ($lastposts['lastpost']>$lastpost or $lastposts['lastpost']<$currentlastpost) {
      $lastposts=$DB_site->query_first("SELECT lastpost,lastposter,title FROM thread WHERE lastpost='$lastposts[lastpost]'");
                        $lastpost=$lastposts['lastpost'];
                        $lastposter=$lastposts['lastposter'];
                        $lasttitle=$lastposts['title'];
                }
  } 


part is needed to give $lasttitle some value.

The last bit depends on which version as of 2.2.x they introduced $lastpostquery cause it wasn't needed some times..

[The Realist]

I could not find the below txt in my version 2.2.0 /admin/functions.php .......

if ($lastposts['lastpost']) {
if ($lastposts['lastpost']>$lastpost or $lastposts['lastpost']<$currentlastpost) {
$lastposts=$DB_site->query_first("SELECT lastpost,lastposter,title FROM thread WHERE lastpost='$lastposts[lastpost]'");
$lastpost=$lastposts['lastpost'];
$lastposter=$lastposts['lastposter'];
$lasttitle=$lastposts['title'];
}
}

So I left it out?