Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
CES Intelligent Announcement Query Details »»
CES Intelligent Announcement Query
Version: 1.0.2, by thincom2000 thincom2000 is offline
Developer Last Online: Sep 2022 Show Printable Version Email this Page

Category: Forum Display Enhancements - Version: 3.6.x Rating:
Released: 01-20-2007 Last Update: 01-27-2007 Installs: 17
DB Changes Uses Plugins
Code Changes  
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 01-21-2007, 09:29 PM
Sn1p34 Sn1p34 is offline
 
Join Date: Feb 2005
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Theres no download file?
Reply With Quote
  #3  
Old 01-21-2007, 09:32 PM
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Posts: 4,141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Sn1p34 View Post
Theres no download file?
+1?
Reply With Quote
  #4  
Old 01-21-2007, 09:35 PM
thincom2000 thincom2000 is offline
 
Join Date: May 2006
Location: Bronx, NY
Posts: 1,205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 01-21-2007, 09:39 PM
Distance's Avatar
Distance Distance is offline
 
Join Date: Jul 2006
Location: Boston, Uk
Posts: 725
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wow people are so impatient, good tip
Reply With Quote
  #6  
Old 01-22-2007, 03:50 AM
MrNase MrNase is offline
 
Join Date: May 2003
Location: Germany
Posts: 670
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

less queries - more fun!

Thanks!
Reply With Quote
  #7  
Old 01-22-2007, 04:32 AM
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Location: Australia
Posts: 2,469
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If thats the case, then maybe vbulletin should have this as default then.
Reply With Quote
  #8  
Old 01-22-2007, 09:05 AM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I agree. Maybe they will incorporate.

Eliminating queries is something I always look to do. Thank you.
Reply With Quote
  #9  
Old 01-22-2007, 04:32 PM
MaestroX MaestroX is offline
 
Join Date: Aug 2006
Location: UK
Posts: 249
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for this. Anything to get my forum running faster is always a plus
Reply With Quote
  #10  
Old 01-23-2007, 04:34 AM
thincom2000 thincom2000 is offline
 
Join Date: May 2006
Location: Bronx, NY
Posts: 1,205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply


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

Forum Jump


All times are GMT. The time now is 01:13 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06773 seconds
  • Memory Usage 2,288KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete