CES Intelligent Announcement Query
 

CES Intelligent Announcement Query
Version: 1.0.2

*** NEWS ***
1/28/2007 - v1.0.2 released
1/25/2007 - updated install instructions
1/24/2007 - v1.0.1 released
1/21/2007 - v1.0.0 released

Known Issues:
- none

What It Does:
Makes forumdisplay.php smarter. It will only use a query for Announcements IF there are any announcements for that forum. So more likely than not, this will improve your forumdisplay pages by virtually eliminating 1 query.

I actually wrote this for another mod I'm working on that contains a modified version of forumdisplay.php. Decided to release these plugins separately so people can benefit from it now.

Products to Install: 1
Plugins Included: 2
Files to Upload: 0
Template Edits: 0
Files to Edit: 1
Queries Added:* -1

*This only subtracts 1 query if you don't have any announcements configured for that forum.

*** Changelog ***
As of Version 1.0.2:
- added support for global announcements

As of Version 1.0.1:
- made the announcement check faster
- announcements will work after uninstall if file edits not undone

Theres no download file?

+1?

Sorry guys, I was just making sure all the mod info on here was correct before uploading the file.

*File uploaded.*

Wow people are so impatient, good tip

less queries - more fun!

Thanks! :)

If thats the case, then maybe vbulletin should have this as default then.

I agree. Maybe they will incorporate. :)

Eliminating queries is something I always look to do. Thank you. :)

Thanks for this. Anything to get my forum running faster is always a plus :)

Yeah, also... for anyone who would uninstall this. Why? It's better for performance to leave it installed, plus the file edits you have done would cause Announcements not to work at all after an uninstall (unless you also reversed the file edits).

Or I updated the file edits to allow for that... I need to look at this again, I may have just brainstormed a 0.2 KB more efficient way of doing this.