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

[akanevsky]

First Post Reserved

Q: I have a lot of forums that I need to be able to hide, but I cannot hide them all. Help!
A: Yes, there is a limitation due to the properties of the mysql field. It is intended to hold up to 64 forums. If you need more than that, please run the following query:

[SQL]ALTER TABLE PFXusertextfield CHANGE excludeforumids excludeforumids MEDIUMTEXT NOT NULL[/SQL]

Make sure to replace PFX with your TABLE_PREFIX (it is found in config.php).

[projectego]

Thanks.

[high]* projectego clicks install [/high]

[JD45]

Ok, I know I must be doing something wrong, so if someone can point me in the right direction, I'd appreciate it. I went in to phpmyadmin and tried running the sql command, but I get this in return:

#1146 - Table 'justpres_forumtest.vb1_forum' doesn't exist

'vb1' is what is listed in my config.php

[akanevsky]

Originally Posted by JD45

Ok, I know I must be doing something wrong, so if someone can point me in the right direction, I'd appreciate it. I went in to phpmyadmin and tried running the sql command, but I get this in return:

#1146 - Table 'justpres_forumtest.vb1_forum' doesn't exist

'vb1' is what is listed in my config.php

If vb1 is listed in config.php then in query, you would use vb1forum, not vb1_forum.

[JD45]

Originally Posted by Psionic Vision

If vb1 is listed in config.php then in query, you would use vb1forum, not vb1_forum.

That worked perfectly, thank you.

I went back in to my options and only reset exclusion shows. I followed the instructions to clear it, but nothing else shows up. Any ideas? I re-ran the installer with overwrite on just to be sure, and still no luck.

[akanevsky]

Originally Posted by JD45

That worked perfectly, thank you.

I went back in to my options and only reset exclusion shows. I followed the instructions to clear it, but nothing else shows up. Any ideas? I re-ran the installer with overwrite on just to be sure, and still no luck.

What exactly are you trying to do?

[JD45]

Originally Posted by Psionic Vision

What exactly are you trying to do?

Trying to get the list of forums to show so I can select which ones not to show up when I hit new posts.

[akanevsky]

Originally Posted by JD45

Trying to get the list of forums to show so I can select which ones not to show up when I hit new posts.

You need to set those forums (and all of their parents) as excludable.

[JD45]

Originally Posted by Psionic Vision

You need to set those forums (and all of their parents) as excludable.

All I had to do was save one forums setting to enable excludability and then they showed up in the user options.

Thanks for your help.