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.

[Alien]

Hey..

Yeah, I checked my index.php file and it does contain that code below.. I see it is working well on your forum, so it must just be something minor somehow...

Hmmm.

Originally posted by PPN
i just posted the topic identical to what you used, make sure in index.php that

PHP Code:

          $forum['lasttitle']=unhtmlspecialchars($forum['lasttitle']); 


was added when you were pasting information. Either that or I have missed something else out in the hack, which i hope i haven't.

[dxb]

PPN any updates for this hack

[Scott MacVicar]

updated to work with 2.2.0 there was a small difference with the functions.php, it was just a change in the way the query was run, the update file has been updated to accomodate this.

I also adjust what i presumed was the problem that Alien was experiencing.

[Thomas P]

Hi,

does it let you edit & update the length of the last title through the cp?
Does it support different settings depending on the forum (on/off & length)?
Thanks,
-Tom

[dxb]

hi there PPN

I just downloaded your file and I cant find this

PHP Code:


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


the closes i was able to find is

PHP Code:


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


and also this query seems to be changed a bit

PHP Code:


$DB_site->query("UPDATE forum SET replycount='$numberposts',threadcount='$numberthreads',lastpost='$lastpost',lastposter='".addslashes(htmlspecialchars($lastposter))."' WHERE forumid='$forumid'"); 


to this

PHP Code:


$DB_site->query("UPDATE forum SET replycount='$numberposts',threadcount='$numberthreads' $lastpostquery WHERE forumid='$forumid'"); 


I tried to work on them but with no success

[Scott MacVicar]

Ok instructions updated.

PHP Code:

then look for

      $lastposts=$DB_site->query_first("SELECT lastpost,lastposter FROM thread WHERE 

lastpost='$lastposts[lastpost]'");
                        $lastpost=$lastposts['lastpost'];
                        $lastposter=$lastposts['lastposter'];

change to

      $lastposts=$DB_site->query_first("SELECT lastpost,lastposter,title FROM thread WHERE 

lastpost='$lastposts[lastpost]'");
                        $lastpost=$lastposts['lastpost'];
                        $lastposter=$lastposts['lastposter'];
                        $lasttitle=$lastposts['title'];

-------
FOR VB 2.0.x

on line 1498 look for
  $DB_site->query("UPDATE forum SET 

replycount='$numberposts',threadcount='$numberthreads',lastpost='$lastpost',lastposter='".addslashes(htmlspecialc

hars($lastposter))."' WHERE forumid='$forumid'"); 

change it to

  $DB_site->query("UPDATE forum SET 

replycount='$numberposts',threadcount='$numberthreads',lastpost='$lastpost',lastposter='".addslashes(htmlspecialc

hars($lastposter))."',lasttitle='".addslashes($lasttitle)."' WHERE forumid='$forumid'"); 

FOR VB 2.2.x

look for
        if ($lastpost!=$currentlastpost) {
                $lastpostquery=",lastpost='$lastpost',lastposter='".addslashes($lastposter)."'";
        } else {
                $lastpostquery="";
        }

change to

        if ($lastpost!=$currentlastpost) {
                

$lastpostquery=",lastpost='$lastpost',lastposter='".addslashes($lastposter)."',lasttitle='".addslashes($lasttitle)."'";
        } else {
                $lastpostquery="";
        } 


[Thomas P]

Originally posted by Thomas P
Hi,

does it let you edit & update the length of the last title through the cp?
Does it support different settings depending on the forum (on/off & length)?
Thanks,
-Tom

I guess this means "no"... well is there any possibility to change the length of the last title appearing?
-Tom

[dxb]

Sorry PPN I got lost here ... the instruction file in the first post of this hack is still not updated ....

and million thanks for your

[Scott MacVicar]

It won't let me update the file or add a new one i keep getting this error.

Will bring it up to FireFly

[Scott MacVicar]

yep its been updated, Firefly made sure it was now...

I don't want to post the contents of the file but try making sure its not your cache causing problems.