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.

[dwh]

Originally posted by Boofo
Can you supply a screenshot?

Sorry, I only installed it in my test forum...and then deleted it...But it's the same exact screenshot as the other versions of this hack but with the same icon as the user selects showing up on the forumhome and forumdisplay.

[dwh]

Originally posted by Webmasta XT
damn, when editing admin/functions.php in vb 2.2.6

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


That part is not possible, so I can't install the hack.. any help with this?

Yah, the original currently has that section wrong...I don't have the code in front of me but bascially you need to look for the section that say $lastpost=$DB_site...there's only one. The only part you need to worry about is to add "title" to the SELECT statement so instead of "SELECT lastpost,lastposter" it should be "SELECT lastpost,lastposter,title" and then add $lasttitle=$lastposts['title'] and you should be ok..but don't forget that in the template to fix that little error I mentioned $form['lasttitle'] should be $forum[lasttitle]

hope this helps..

[Boofo]

I guess I'm still lost here. What icon did you use and where did you put it? Are you talking about the little arrow icon?

Originally posted by dwh


Sorry, I only installed it in my test forum...and then deleted it...But it's the same exact screenshot as the other versions of this hack but with the same icon as the user selects showing up on the forumhome and forumdisplay.

[dwh]

Here's a screenshot :banana:

[Boofo]

Ok, I understand now. LOL Thanks.

BTW: Who's crappy board is that? They ought to have their vB license revoked.

All seriousness aside now...could you have different icons for each one? And would it pick them from a group or is this all manual labor stuff?

Originally posted by dwh
Here's a screenshot :banana:

[Webmasta XT]

can we get a new updated file? for ppl with vb 2.2.6?

[Webmasta XT]

well, I got it working!

[Boofo]

Any way to get this working in the Search > Thread Results screen?

[Boofo]

Scott, did you ever figure out why when I have a user with an apostrophe in the name that when I run update counters on the forum, that it gives me a db error is the user with the apostrophe is the user with the last post? And every once in a while I get a thread that gives me an errorid error if I click on it but when I go to edit the thread, it fixes it so it is clickable again.

[Scott MacVicar]

let me guess syntax error due to the lack of a slash. Can you post the query it was trying to run if possible.

Ill get an update file done soon, its changed in 2.2.7 so I'll have to post a new one.