CES Last Post on Forum Home (No Query)

[thincom2000]

CES Last Post on Forum Home
Version: 1.0.3
This mod is no longer supported. Do not install this mod, as it adds postsave queries that can result in full table scans (that is bad).

If you have vBulletin Project Tools installed, you may want the integrated version, which will be released in a few short minutes.

*** NEWS ***
7/31/2007 - v1.0.3 released
6/4/2007 - v1.0.2 released
3/17/2007 - v1.0.1 released
3/11/2007 - v1.0.0 released

Known Issues:
- none

What It Does:
This mod adds the most recent post to Forum Statistics in What's Going On. Unlike other similar hacks that do this, CES Last Post on Forum Home doesn't add a single query to forum home.

IMPORTANT! Install the product last. The product uses the plugin files
to create the appropriate database tables.

Products to Install: 1
Plugins Included: 7
Files to Upload: 0
Files to Edit: 1
New Templates: 1
Template Edits: 1

*** CHANGELOG ***
As of Version 1.0.3:
updated: removed file uploads for faster install
bug fix: cache not updated when threads move, merge, copy
bug fix: icons bloat cache
bug fix: icons don't appear on forum home
bug fix: forum home links don't pass session ids

As of Version 1.0.2:
bug fix: latest post not updated on post delete
bug fix: latest post not updated on thread delete

As of Version 1.0.1:
fixed uncached template

[MrPHD]

Nice Work, go on. Regards and Installed.

Screenshot:

http://evorafm.net/lastpost.jpg

[thincom2000]

Thanks for the screenshot ^_^

I'd been testing this for over a month. Today I finally decided to release it, so I added 2 additional plugins as a safety net to make sure new posts are always recognized.

This is how it works. Whenever a post is made, the hack adds the post info for the most recent post in each forum to the datastore. Then on runtime, these most recent posts are loaded into memory at the same time as vboptions, etc, thus avoiding an extra query, and the hack checks to see which of them is the most recent that the current user actually has permission to view.

I had had problems with the datastore post info not always updating, so now there is the following:

1 plugin for checking after adding a new thread
1 plugin for checking after adding a new reply
1 plugin for checking after editing a post (some hacks allow you to alter post times)
1 plugin for checking after deleting a post

[projectego]

Thanks very much for this hack! :)

[ZomgStuff]

Thx!

[DeanoG]

Nice Hack,

I think you need to update the Readme file in the Zip file.. as it refering to ...

[Log in to your AdminCP, and upload product-ces_search_wiki.xml

You can now search the Wiki with the Forum Search! If you have questions,
ask in the thread.

[thincom2000]

Haha, thanks. I'll do that. Darn copy & paste.

[Atakan KOC]

Thanks....

[thincom2000]

Finally got this to update correctly after the most recent post is deleted. Posting the new version now.

New plugin list:
1 to cache the template
1 to parse the template

1 for posting a new reply / editing a post
1 for posting a new thread
1 for deleting a thread with inlinemod.php
1 for deleting a post with inlinemod.php
1 for deleting a thread inline on Forum Display or Show Thread

[thincom2000]

The first post has been updated again since this mod wasn't working when threads moved, merged, or copied, and since icons still weren't working and were inflating the cache beyond belief.

These bugs have been fixed; however, I will be releasing a version that integrates vBulletin Project Tools on this site shortly. So if you are interested in counting posts in your Project Issues towards the last post on forum home, I would recommend waiting for that.

[tobaro]

any possibility to have this displayed on top of forum under navbar?

[thincom2000]

All you would have to do is make the required template edit higher up in FORUMHOME.