Optimization for "Last Post in Profile"
 

Optimization for "Last Post in Profile"

Description
vBulletin has a feature to display information about the last post made by a user in his profile.
However, this can be very server intensive:

These table scans are necessary because vBulletin does not know if the last post is accessible (eg. not soft-deleted, not in moderation and not in a forum where the viewing user does not have access rights).
But: How often does it happen that the last post is NOT accessible?

If your answer is seldom, then this Hack is for you:
It directly fetches the last post info in this case, without the need for any table scans.

Drawback: If the last post is NOT accessible, then it causes one additional, pretty light query and some PHP processing in member.php.

More background Info: http://www.vbulletin.com/forum/bugs3...iew&bugid=1405

ATTENTION: Due to Multi-Table UPDATEs being used in the installation code of this product, you will need at least mySQL 4.0.4 in order to install this properly.
If you install it with an older Version, it will still work - however it will always cause the additional query then for all users until they have made a new post.

History
1.0.0
Initial Version

1.0.1
Minor Bugfix

1st to install I see. Will post back in time with comments.

The drawback seems less severe than using the built-in system all the time, based on your explanations. Is that correct?

Yes. As pointed out, in most cases the first query (which I added) should catch the necessary data.
Only if it does not it will make a fallback to the default code.

Well, I just found out my webhost only has MySQL 4.0.25. So I'll have to wait...

Erm ... MySQL 4.0.25 is newer than MySQL 4.0.4.
All MySQL Versions > 4.0.4 should work just fine :)

d'Oh!

Yeah, 25 is greater than 4. :D I apparently had mentally ignored the 5 and just saw the 2, and said that's less than 4... :o

OK, just one question: After importing the product, should the "Show Last Post on Profile Page" option in the "User Listing & Profile Viewing" section of the options be on or off? I just wasn't certain if turning it on meant it was using the built-in system or if your hack replaces the built-in system with your own.

On. If it is off, then it is completely off.
This Hack replaces/extends the built-in system.

A handful users complain that if they create a new post while receiving a private message, they'll get a fatal error