Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
CES Intelligent Announcement Query Details »
CES Intelligent Announcement Query
Mod Version: 1.0.2, by thincom2000 (Coder) thincom2000 is offline
Developer Last Online: Oct 2019 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.x Rating: (3 votes - 4.67 average) Installs: 15
Released: 21 Jan 2007 Last Update: 28 Jan 2007 Downloads: 67
Supported DB Changes Uses Plugins Code Changes  

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

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Show Thread Enhancements CES Intelligent Postbit Query thincom2000 vBulletin 3.6 Add-ons 87 14 Mar 2008 23:00
Show Thread Enhancements CES Intelligent Attachment Query thincom2000 vBulletin 3.6 Add-ons 21 08 Mar 2008 07:28
Forum Display Enhancements CES Intelligent Dot-Threads thincom2000 vBulletin 3.6 Add-ons 13 31 Mar 2007 19:35

Comments
  #2  
Old 21 Jan 2007, 22:29
Sn1p34 Sn1p34 is offline
 
Join Date: Feb 2005
Theres no download file?
Reply With Quote
  #3  
Old 21 Jan 2007, 22:32
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Real name: Brooks
Originally Posted by Sn1p34 View Post
Theres no download file?
+1?
Reply With Quote
  #4  
Old 21 Jan 2007, 22:35
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
Sorry guys, I was just making sure all the mod info on here was correct before uploading the file.

*File uploaded.*
Reply With Quote
  #5  
Old 21 Jan 2007, 22:39
Distance's Avatar
Distance Distance is offline
 
Join Date: Jul 2006
Real name: Josh
Wow people are so impatient, good tip
__________________
My software never has bugs. It just develops random features.

Distance

Reply With Quote
  #6  
Old 22 Jan 2007, 04:50
MrNase's Avatar
MrNase MrNase is offline
 
Join Date: May 2003
Real name: Dominik
less queries - more fun!

Thanks!
Reply With Quote
  #7  
Old 22 Jan 2007, 05:32
Hornstar's Avatar
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Real name: Matt
If thats the case, then maybe vbulletin should have this as default then.
Reply With Quote
  #8  
Old 22 Jan 2007, 10:05
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
I agree. Maybe they will incorporate.

Eliminating queries is something I always look to do. Thank you.
__________________
AndroidETC.com :: Android, and other stuff.
Reply With Quote
  #9  
Old 22 Jan 2007, 17:32
MaestroX MaestroX is offline
 
Join Date: Aug 2006
Real name: Chris A.
Thanks for this. Anything to get my forum running faster is always a plus
Reply With Quote
  #10  
Old 23 Jan 2007, 05:34
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
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.
Reply With Quote
  #11  
Old 25 Jan 2007, 00:40
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
Cool

Version 1.0.1 was just uploaded. This contains instructions for an updated file edit that will do this check faster, and if someone is foolish enough to uninstall this product, announcements will now work without undoing the file edits.
Reply With Quote
  #12  
Old 25 Jan 2007, 06:58
stomph stomph is offline
 
Join Date: Dec 2006
Thanks for this hack!

There's a ) missing on line 477 in forumdisplay:
if ($announce_exists OR (!is_array($announces)))
Reply With Quote
  #13  
Old 25 Jan 2007, 07:34
adhari_com's Avatar
adhari_com adhari_com is offline
 
Join Date: May 2004
Real name: Hassan AlDoy
Thanx for the great effort,
Although I think eliminating a single query would be replaced with the query calling the hook and also executing itself!

Just an opinion.
Reply With Quote
  #14  
Old 25 Jan 2007, 17:51
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
You are correct that the hooks creates a new query. However this is an additional query in the AdminCP Announcements page, and not one users would experience on your forumdisplay.

I would not have released this if it was that pointless.

Originally Posted by stomph View Post
There's a ) missing on line 477 in forumdisplay:
if ($announce_exists OR (!is_array($announces)))
I have updated the installation instructions with the missing parenthesis. Thanks!

Last edited by thincom2000; 25 Jan 2007 at 17:56.
Reply With Quote
  #15  
Old 28 Jan 2007, 22:07
TheFrienzNet's Avatar
TheFrienzNet TheFrienzNet is offline
 
Join Date: Jan 2007
As much as I love your other hacks, I love this one too;however, there is a bug once again. Global announcements do not show up.
__________________
Make love not war, condoms are cheaper than guns.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:21.

Layout Options | Width: Wide Color: