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

[derrene]

Originally Posted by Ignicoccus

Selective Forum Filter works with vbseo ! Just add profile.php to "Exclude pages" option in vbseo cp.

Thank you

[korny]

Is there a 3.7 or 3.8 version for this out yet?

[private_ale]

Originally Posted by korny

Is there a 3.7 or 3.8 version for this out yet?

If you read a few posts up you'll find:

Originally Posted by TriMe

Installed and working great on 3.7.4 patch level 1.
Thanks!

Originally Posted by nascartr

Working fine for 3.8 RC1!

I also just tried this out on 3.7 and I can confirm it does work :up:

[korny]

Great thanks.

[SledgeHead]

When I try to Execute SQL Query I get this:

You are not authorized to execute SQL queries

So my question is, is there a way I can just add one category of the forum to be selected as an option of forums to turn off?

[Fungsten]

Originally Posted by SledgeHead

When I try to Execute SQL Query I get this:

You are not authorized to execute SQL queries

So my question is, is there a way I can just add one category of the forum to be selected as an option of forums to turn off?

Go to your config.php fileon the server, find this:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = 'XXXXX';

Replace the Xs with your user ID number.

[SledgeHead]

Thank you! This works great so far.

[TigerWare]

Super work as usual, and most useful.

Testing this out as it has been requested by my users.

I have this working fine on 3.7.5. However, my forum uses categories which are hidden due to navigation menus (I have a tabbed navigation similar to here at vb.org).

If a category is set to "Forum is Active = no" it is removed from the list in the UserCP, as well as all forums that are a child of the category (regardless of their visibility). I understand the logic behind that, but need to work around this limitation.

I'm pretty sure I need to work around the following code during the build of the excludable list:-

PHP Code:

    if (!forum_accessible($forum, $forumperms))
    {
        continue;
    } 


Logically that's "if the current forum is is not accessible, skip it an try the next one." Commenting this out isn't going to help as forum permissions are a crucial part of this building process (of course).

Any help on what I need to do to modify this to allow hidden categories. (not bothered about hidden forums btw).

TIA

[Deyth]

Forums aren't loading in the options textbox. This is the forum and this is what loads:

[Reset Exclusion]
Online
-- Game-Related
Offline
-- Everything Else

Most of the other forums are set to be excludable but aren't showing.

EDIT: Never mind, it was an inheritance issue. A poster above actually touched on it.

[unicorn2433]

how do I know
what the table prefix is that is defined in the config.php to change the pfx too?

When I look in my config file it says table prefix = ' '

nothing is there???

Oh I have not marked installed yet because I am not finished getting it to work