End-User Options - Selective Forum Filter

I no longer support my hacks. Please feel free to update them and release new versions elsewhere as long as I get the credit for the original modification.

/*================================================= =====================*\
|| Selective Forum Filter
||
|| Author : Anton Kanevsky
|| Co-Author(s) : Andreas
|| Works on : vBulletin 3.5.x - 3.8.x
|| Released : May 31, 2009
||
|| Time required to install: 30 seconds
|| Difficulty: easy
\*================================================ ======================*/

DESCRIPTION

Ever came across large boards with a huge number of sub forums? Couldn't find your info? Wanted to run away from that huge load of stupid threads? This hack is intended to save your users from having such a horrible experience. It provides them with an opportunity to exclude any number of forums from the forums list (as well as from "get new"/"get daily" searches), which still letting them to access those forums directly and search within them, too.

STATISTICS

Products to Install: 1


INTRODUCTION

To enable "can be excluded" in all forums, run this query:
UPDATE PFXforum SET excludable = 1
To disable "can be excluded" in all forums, run this query:
UPDATE PFXforum SET excludable = 0
In both cases, PFX must be replaced with the actual table prefix that you have defined in config.php.
If you have not defined a prefix, remove PFX from the queries.
After you run either one of these queries, you must then open and save any one forum for the forum cache to be updated.

VERSION HISTORY

1.1.0
[+] The hack is now compatible with vBulletin 3.5.x - 3.8.x.
[+] Eliminated all template edits.

1.0.2
[+] The hack is now compatible with vBulletin 3.6.
[+] Corrected a couple of mistakes in the installation manual.

1.0.1
[+] Added option to set forums as excludable. By default, excludability of all forums is disabled.

1.0.0
First Public Release

The installation manual is contained within the attached file.

IF YOU LIKE MY HACK, PLEASE CLICK INSTALL

[iRO Wiki]

Wow, I was just looking around for that, it'd be really nice to have an option of which usergroups were allowed to use it!

[Deimos]

Anyone managed to get this working for VB 3.7?

[BreezeDK]

I'd like to know if this is working on 3.7 before i try to install it and mess up my forum ^^

[Deimos]

Doesn't work on 3.7, comes up with a missing security token or something (I forget the error)

[Jorrit787]

Originally Posted by Deimos

Doesn't work on 3.7, comes up with a missing security token or something (I forget the error)

That should be easy to fix... Check the topic where Kier explains about the security token.

[Deimos]

Hmm, you sure it was Kier? I did a search on his posts for "Token" but couldn't find anything.

[Jorrit787]

Originally Posted by Deimos

Hmm, you sure it was Kier? I did a search on his posts for "Token" but couldn't find anything.

Sorry, it's on vB.com:

http://www.vbulletin.com/forum/showp...95&postcount=2

[surfjunkey]

cannot get this to work on 3.68 patch 2 - tried to install it twice, no editing options appear in usercp>edit options

tried all the suggestions in this thread - still no luck!

[glennybee]

I'm getting an error when trying to run the query.

This is the query that I'm running as I don't have a prefix set...

UPDATE SET excludable = 1

...and this is the error I'm getting...

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET excludable = 1' at line 1

I'd appreciate anyones input.

The box is visible in 'Edit Options' but no forums are visible to select. I have manually saved a forum in Forum Manager so I suspect it's down to the query failing.

Running 3.7.0.

Thanks

[Deimos]

Ya need to run

UPDATE forum SET excludable = 1