CES Intelligent Dot-Threads
 

CES Intelligent Dot-Threads
Version: 1.0.1

Requires: CES Pre-Process Hooks v1.2.0+
Recommend: MySQL 5

What It Does:
This modifies vBulletin's behavior if the following setting is enabled on your forum.

Highlight Threads in Which User Has Posted
When this feature is enabled, a logged in user will see an 'arrow' (or whatever graphic you choose) on the folder icons (hot folders, new folders, etc.) next to the threads that they have posted in.

vBulletin normally accomplishes this by adding another query to Forumdisplay. This hack removes that query.

*** NEWS ***
3/30/2007 - v1.0.0, v1.0.1 released

Known Issues:
- none

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

Mod Features:
- removes 1 query from Forumdisplay

*** Changelog ***
As of Version 1.0.1:
- safer file edit

I was wondering about the file too.

If you can explain to me how a screenshot will prove a query is removed, I'll be glad to make one. :p

Great stuff. I'm really glad your looking to enchance vbulletin by cutting down of query usage.

Thumbs up :)

Mod without a screenshot or demo = not using it.

Um, okay... maybe if you would actually read the description of the mod you would understand why posting a screenshot or demo would be meaningless.

Although this removes one query from forumdisplay, it modifies the existing query by adding an expensive outer join to the post table.

Have you compared the execution plan of the modified query with the original? Remember, MySQL versions prior to 5.0 can only use one index per query. You may find the original way with the extra query is more efficient... which is probably why Jelsoft did it that way.

How would a screenshot even apply to this mod?
Haha, I love it when people don't read the thread in which they are replying to. :rolleyes:

kinda worrying that everyone needs a picture of something before they'll accept it.

Make a caveman drawing of something thincom2000 and then they'll all want it :)

Clicked install .. thanks for the hack thincom2000