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.

[Bald Bouncer]

edited

[kms]

Originally posted by PPN
send the functions.php to scott.macvicar@vbulletin.org and I'll look it over

hiya PPN, any luck m8 ?

TIA

[mashby]

A rather lengthy hack, but it installed just as described and works like a charm. Thanks for making such a great hack!

[mashby]

I noticed that the thread title for items in "private" forums don't show up on the home page. Is that intentional?

[Boofo]

I just installed this hack and when I tried to update the forum counters, I got this error. Can you tell me what it means and what I need to do, please?

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT * FROM thread WHERE forumid='1' AND lastposter='Boofo's Babe' AND lastpost='1021587428'
mysql error: You have an error in your SQL syntax near 's Babe' AND lastpost='1021587428'' at line 1

mysql error number: 1064

Date: Saturday 18th of May 2002 07:10:17 AM
Script: http://www.bearfacts2.com/forum/forum/admin/misc.php
Referer: http://www.bearfacts2.com/forum/admi...action=chooser

[Boofo]

It seems that SQL doesn't like user names with apostrophies in them. "Boofo's Babe" was reading as "s Babe" and the DB didn't like that. I went ahead and posted in the forums and re-ran the update counters and it went off without a hitch with me as the last poster. Is there any way around this so users can use apostrohies in their names if they like?

BTW: Great hack, PPN! (as usual)

[Jen]

I have one quick question that doesn't seem to have been covered yet..

I want to guarantee that the user ALWAYS goes to the thread shown as the last post, but if you load up the index, wait for a few more posts to be made and then click the thread link it goes to the newest thread, NOT the one listed as last post.

This is confusing my users to no end (if they'd only click a little faster it wouldn't be a problem ).

Is there any way to set the goto link to go to the thread listed as the last post even if there have been new posts made since?

[Franki]

I installed this hack and works fine BUT not with polls. I posted a new thread with poll and it didn't appear as a new post in the forum home page. Why is that?

[Boofo]

It works with polls here fine. I am running version 2.2.5, what are you running?

[Frank-kun]

Hmm..looks like I have a problem...

Had this hack since 2.2.0 and it's worked like a charm ever since - just did the Beyond Compare thing and it worked fine. But I updated to 2.2.6 today and it's having a problem. It works fine on a new reply or new thread, but won't work on moving or deleting threads or posts. It just puts it as before, with just name and date.

I tried installing from scratch, doing the update forums info thing again, still no dice.

Curiously enough it does seem to be leaving a space for the last title on forum home, it's just that it's blanked.

Could someone give some insight or perhaps point me to the file that deals with the move/delete to try and fix this?