Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
CES Intelligent Attachment Query Details »
CES Intelligent Attachment Query
Mod Version: 1.3.0, 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: (0 vote - 0 average) Installs: 17
Released: 27 Jan 2007 Last Update: 26 Mar 2007 Downloads: 67
Supported Uses Plugins Code Changes  

CES Intelligent Attachment Query
Version: 1.3.0

Version 1.3.0 has no real changes other than now being a product. Now requires CES Pre-Process Hooks.

*** NEWS ***
3/25/2007 - v1.3.0 (product version) released
------------------------------------------------------
1/28/2007 - v3.0.0 released
1/27/2007 - v1.0.0, v2.0.0, v2.0.1 released

I actually came across this while trying to reduce queries in my CES Site News mod which uses a customized showthread.php.

Known Issues:
- NONE

What It Does:
Normally showthread wastes a query on attachments by checking if the thread has an attachment in any post, not bothering to check if that post and attachment are even on the current page, then querying for the page's posts. This hack removes a potentially unnecessary query from showthread.php by joining queries.

I hope someone from Jelsoft sees this thread.

Mod Features:
- removes 1 pointless query

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

*See "What It Does" for details.

*** Changelog ***
As of Version 1.3.0:
- only 1 file edit
- requires CES Pre-Process Hooks
- uses vBulletin's Plugin system
- changed version numbering (confusion!)

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 15 Mar 2008 00:00
Forum Display Enhancements CES Intelligent Announcement Query thincom2000 vBulletin 3.6 Add-ons 17 29 Jan 2007 00:13

  #16  
Old 30 Jan 2007, 01:04
TheFrienzNet's Avatar
TheFrienzNet TheFrienzNet is offline
 
Join Date: Jan 2007
Thanks, it works.
__________________
Make love not war, condoms are cheaper than guns.
Reply With Quote
  #17  
Old 30 Jan 2007, 04:05
Get Shorty's Avatar
Get Shorty Get Shorty is offline
 
Join Date: Jun 2006
Real name: Nick
Originally Posted by thincom2000 View Post
Basically you need to find:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

and change:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

That should fix your "all attachments are moderated" woes.

Not having this resulted in $attachment['visible'] being false, which class_postbit.php interpreted as the attachment requiring moderation to become visible.
Trying it again...
Reply With Quote
  #18  
Old 03 Feb 2007, 23:48
Skyline_GT Skyline_GT is offline
 
Join Date: May 2003
It seems this does not remove a query for my forum.
__________________
Gamerzplanet.Net - The best place to get the latest cracks, hacks, cheats for all popular online games!!
GzP Upload.NET - Fast and Free Image Hosting!!
Online Flash Games - An online flash game with 10,000+ games!!
Reply With Quote
  #19  
Old 04 Feb 2007, 03:44
Get Shorty's Avatar
Get Shorty Get Shorty is offline
 
Join Date: Jun 2006
Real name: Nick
I didn't notice a difference either.
Reply With Quote
  #20  
Old 04 Feb 2007, 04:00
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
vBulletin only adds a query for attachments when the thread has an attachment somewhere.

This hack rearranges the code so that the query doesn't have to be added.

The fact that you didn't notice a query removed means nothing, since this hack only prevents a query from being added, much like caching an uncached template in $globaltemplates, only with attachments.
Reply With Quote
  #21  
Old 08 Mar 2008, 08:16
andrewkhunn andrewkhunn is offline
 
Join Date: Feb 2007
I am attempting to install this plugin on vBulletin 3.7 PL1. I have installed the latest version of CES Pre-Process Hooks (just the showthread portion), but this plugin keeps complaining that the dependancy on that script has not been met.
Reply With Quote
  #22  
Old 08 Mar 2008, 08:28
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
I will look into this when I rewrite this for 3.7.
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 22:28.

Layout Options | Width: Wide Color: