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.

[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?

[Scott MacVicar]

look for

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'];
}
}

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'];
}
}

your looking for the above one if you still can't find it your looking for

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

this in specific

[The Realist]

I cannot find the above, the nearest I can find is the below:

$lastposts=$DB_site->query_first("SELECT MAX(lastpost) AS lastpost FROM thread WHERE forumid=$forumid AND visible=1 AND open<>10");
if ($lastposts['lastpost']>$lastpost) {
$lastposts=$DB_site->query_first("SELECT lastpost,lastposter FROM thread WHERE lastpost='$lastposts[lastpost]'");
$lastpost=$lastposts['lastpost'];
$lastposter=$lastposts['lastposter'];
}

[Scott MacVicar]

ok change the following

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']; 
} 


to

PHP Code:

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


I'll update the documentation with this then

[The Realist]

Its still has not updated the posts that have already been made. Its working if a member posts a current message but it does not update at all with any old posts.

I have change what you stated above and still no joy?

[LuBi]

This hack didn't work for me on 2.2 I get the following error.

Parse error: parse error in /www/htdocs/forums/newthread.php on line 375

It's the ?> at the end of the document. I use EditPlus 2 to edit my files, why is it doing this?

[dxb]

also this may couse a problem

PHP Code:

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


the new function file has the query changed to this

PHP Code:

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


you can see the $lastpostquery is added to the query

[Scott MacVicar]

dxb >
i took that into account and its mentioned within the readme for how to do it to 2.2.x and 2.0.x because of the difference.

Lubi >
does EditPlus have syntax highlighting for PHP? if so then it should show where it went wrong, if not PHPed from http://soysal.com does and is useful for spotting errors.
I honestly don't know what would cause an error like that, you were only updating 3 lines within newreply.php

[LuBi]

Well I dunno either I do have the sytax colors but the code isn't wrong I think the software must be doing something when I save the file. I've never had this problem with Textpad but I like Editplus 2 way better... I dunno but I can't install any hacks until I get this squared away

[LuBi]

How can I make the title of the post/thread a link to the post..? Basically like below... Icon and all...



Ubb style.. Can someone maybe write the template because i don't have the slightest... thanks

I had it like this on 2.0.3 but I dunno what to do...

[mojotim]

Hi, great hack.

This typo gave me some problems:
within it you may add $form['lasttitle'] to show

Duh, I should have checked that!