Selective Forum Filter

[akanevsky]

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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=215001)

[Andreas]

Hmm, not sure but what about

cache_ordered_forums

$excludeforums = explode(',', $vbulletin->userinfo['excludeforumids']);
foreach ($excludeforums AS $forumid)
{
$vbulletin->forumcache["$forumid"]['displayorder'] = 0;
}


to avoid the file edits?

Btw: Where is the Product XML? ;)

[theArchitect]

Hmm, not sure but what about

cache_ordered_forums

$excludeforums = explode(',', $vbulletin->userinfo['excludeforumids']);
foreach ($excludeforums AS $forumid)
{
$vbulletin->forumcache["$forumid"]['displayorder'] = 0;
}


to avoid the file edits?

Btw: Where is the Product XML? ;)

What he said.

But I love the concept.

[heynurse]

Yes, it looks like a great concept!

[JJR512]

Can this be used to, or be modified to be able to, set a universal forum to exclude from the "get new" from the admincp?

The reason is that I have a hidden forum on my board. It's set to inactive, which as described in the admincp prevents it from showing up on the forum view, but is still open if someone knows the URL to it. But it also shows up through the "get new" feature, and I'd like to avoid that. I don't want to make the forum a password-only or limit by permissions or masks; I want it to be accessible to anyone clever enough to find it, but I don't want it to be too too easy, either. :)

[Boofo]

Will this play well with Kirby's Opt-Out product and what is the difference between the two? ;)

[akanevsky]

Hmm, not sure but what about

cache_ordered_forums

$excludeforums = explode(',', $vbulletin->userinfo['excludeforumids']);
foreach ($excludeforums AS $forumid)
{
$vbulletin->forumcache["$forumid"]['displayorder'] = 0;
}


to avoid the file edits?

Btw: Where is the Product XML? ;)

Hmm... That hooks only works within if ($getcounters)... And I am not sure that $getcounters are on everywhere. I'll have to research that before I can say yes.

Can this be used to, or be modified to be able to, set a universal forum to exclude from the "get new" from the admincp?

The reason is that I have a hidden forum on my board. It's set to inactive, which as described in the admincp prevents it from showing up on the forum view, but is still open if someone knows the URL to it. But it also shows up through the "get new" feature, and I'd like to avoid that. I don't want to make the forum a password-only or limit by permissions or masks; I want it to be accessible to anyone clever enough to find it, but I don't want it to be too too easy, either. :)

This sounds like a vBulletin design issue. Post the problem on vBulletin.com, cause hidden forums should not show up through "get new".

Will this play well with Kirby's Opt-Out product and what is the difference between the two? ;)

It will not play nicely. Instead, it is a modified version of his Opt-Out product, which features everything there is in Kirby's product plus removal of forums from forums list, which Kirby refused to add as a feature.

[akanevsky]

Okay, package updated:

1. Missing XML File Added.
2. The hack is now a plugin-type only. Does not require any file edits.

KirbyDE, please move this to an appropriate forum.

[theArchitect]

Okay, package updated:

1. Missing XML File Added.
2. The hack is now a plugin-type only. Does not require any file edits.

KirbyDE, please move this to an appropriate forum.

You Da Man!

[lefthome]

This has to be one of the very best hacks I have used from this site. We have a lot of sections and a large number of our members get upset because of the size. This just fixed their crying....


THANK YOU, THANK YOU, THANK YOU.

[Cyricx]

Unbelievable. Awesome hack!!! This is just what I was hoping for especially for a site like mine that hosts forums for so many different subjects :)

[Cyricx]

I wonder if you could add like X images or something to the forumbit that were links to disable a forum from view.

[Hexemer]

A very nice usefull hack :)

[akanevsky]

Thank you.

[Matt_270581]

Great Hack:)

* Matt_270581 installs

[zappsan]

Nice hack
/me clicks install

[VAN]

This is fantastic. Thanks for the work!

Now how about adding an option in the ACP forum manager to allow/disallow a forum from being hidden by users? For example, I have a News & Announcements forum that I would not want anyone to be able to hide. If you can add this functionality, it would be perfect. :)

[ChrisBaktis]

This is fantastic. Thanks for the work!

Now how about adding an option in the ACP forum manager to allow/disallow a forum from being hidden by users? For example, I have a News & Announcements forum that I would not want anyone to be able to hide. If you can add this functionality, it would be perfect. :)

I second this.

[RMS-Chef]

Great hack.

Is there any way to alter the code a bit to still display the selected forums when viewing but exclude it from Get New searches?

EDIT:
Maybe if I disable the plugin hooking to cache_ordered_forums but leave the rest enabled?

[akanevsky]

No. To get what you want, you need to use Andreas's Opt-Out from GetNew/GetDaily (https://vborg.vbsupport.ru/showthread.php?s=&threadid=91025), which is essentially what this hack is based on, as said in first post.

[KeithMcL]

If you've previously installed Andreas's Opt-Out from GetNew/GetDaily hack, is it simply a matter of uninstalling/disabling it in order to use this hack?

[akanevsky]

Yes. This hack is exactly the same as his hack plus the hide forums functionality.

[SpadMan]

Nice! *Installed*

What would I need to do to include the filter in vBadvanced's latesttopics.php? Anyone done this yet?

[KBV]

Might be a stupid question, but can you exclude forums from get new/daily from ACP so that users won't see posts from forum X even if they do not have it selected themselves?

[akanevsky]

Yes, but that'd be a separate hack.

[KBV]

Any chance you could make it? XD Love this mod btw +installed ^^

[AquilaEagle]

downloaded, wont need to install until i have big forums!! :)

[Baldy]

I've been running it for a week on two boards, both pretty big, and from all I can tell it's running great. I really really like this hack.

[digitalhome]

This plugin has stopped working for me! I don't know when - perhaps after the upgrade to 3.5.2. I didn't notice until a member told me.

Anybody else having same problems?

[digitalhome]

Sorry about that. I guess in the upgrade the modifyoptions template was reverted. I have added the code and everything is fine.

[lefthome]

I used this hack, and a great hack I will add, until I upgraded to 3.5.3 and now i have two home pages using Split Forumhome into several Pages Hack.

Here is the minor issue and looking for solution, if one exists. I want to exclude some threads on the first page and some on the second page. In other words, i want to skip some and add others.

I tried to do some and went back and marked others but no luck on the first ones i excluded. Anyway to fix this so I can skip around the forum excluding what I want?

[WAR]

I used this hack, and a great hack I will add, until I upgraded to 3.5.3 and now i have two home pages using Split Forumhome into several Pages Hack.

Here is the minor issue and looking for solution, if one exists. I want to exclude some threads on the first page and some on the second page. In other words, i want to skip some and add others.

I tried to do some and went back and marked others but no luck on the first ones i excluded. Anyway to fix this so I can skip around the forum excluding what I want?

I am also having difficulties getting this to work completely.

It will not let me exclude more than ~50 forums at a time. Is there anyway to bump this up to 2-300 as a maximum?

[mccollin]

I like the hack, but would also like to have the ability to exclude some forums from being excluded. I'm concerned that the members will miss some important information that will lead them to post unnecesary threads. Otherwise it looks pretty good.

Can you tell me if it also excludes these forums from searches?

[akanevsky]

Can you tell me if it also excludes these forums from searches?
Yes.

[Snatch]

Installed on 3.5.3. Works perfect.

GreeTz
Snatch

[Wild-Wing]

nice hack great for those big boards.

[the Sandman]

Installed, but getting many database errors:

Database error in vBulletin 3.5.3:


Invalid SQL:


## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
WHERE open = '1'
AND forumid NOT IN (0,38,154,83,78,30,114,31,33,32,111,84,123,160,161 ,70,121,71,72,73,74,7,79,81,8,10,108,34,9,68,11,40 ,117,118,)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 10;


MySQL Error : 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 ')
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL


Error Number : 1064

[zylstra]

I am also having difficulties getting this to work completely.

It will not let me exclude more than ~50 forums at a time. Is there anyway to bump this up to 2-300 as a maximum?
Or 100,000 for that matter.

Yep, I can't exclude more than ~70 at a time.

[the Sandman]

I cannot enable this hack without getting database errors, mostly for guests. Any ideas?

[007]

This does not seem to work on 3.5.4.

Can anybody else confirm if it does or does not work for 3.5.4? Thanks.

I'm looking at the code and maybe I'm missing something, but since when did setting a forum's display order to 0 make it not show up at all?

[saree]

thank you man it was great help.

please keep adding more and more great hacks.

take care

[m_k]

This does not seem to work on 3.5.4.

just installed on 3.5.3. with no problems...

great hack Psionic :-)

[the Sandman]

I still cannot get this to work. :( The problem is with guests, who get the database error: <!--
Database error in vBulletin 3.5.3:

Invalid SQL:

## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
WHERE open = '1'
AND forumid NOT IN (0,92,41,38,154,174,83,78,30,114,31,33,32,84,111,6 7,123,160,161,70,121,71,72,73,74,7,79,81,8,10,108, 34,9,68,11,40,117,118,)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 10;

MySQL Error : 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 ')
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL

Error Number : 1064
Date : Thursday, April 13th 2006 @ 10:56:46 AM
Script : http://www.theadminzone.com/index.php
Referrer :
IP Address :
Username : Unregistered
Classname : vb_database
-->Any suggestions? I could really use this.

[akanevsky]

I get no guests problems on my board.. :/

[the Sandman]

I get no guests problems on my board.. :/Probably a conflict with another hack then. Any suggestions on how to track it down and remedy the situation?

[Floris]

INstalleD

[akanevsky]

INstalleD

That is not evident :)

[robert_2004]

Probably a conflict with another hack then. Any suggestions on how to track it down and remedy the situation?

Yes, get the order plugin hack, and keep changing the order in which the plugin is first run.
https://vborg.vbsupport.ru/showthread.php?t=111679

[Parker Clack]

Is there anyway to set this so that the forumjump with still show the excluded forums?

BTW, this is a fantastic hack and my members love ya for it.

Parker

[vbreal]

damn someone asked me about this excluding forums yesterday

[Parker Clack]

As I said before I think this is a great hack. Do you think you could write it in a version that is similar to your 3.0 version that gave you check boxes next to each forum title on the main forum page?

Thanks,
Parker

[akanevsky]

Yes, however, I am not going to do that.

[john1744]

Hmm, I had this hack at one point, but when we moved forums, things got messed up, I had the white space in the edit options area where this is supposed to be however I'm getting this error when trying to reinstall.

Database error in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE usertextfield ADD excludeforumids VARCHAR(255) NOT NULL ;;

MySQL Error : Duplicate column name 'excludeforumids'
Error Number : 1060
Date : Wednesday, May 10th 2006 @ 03:24:12 AM
Script : http://www.sy******ms/admincp/plugin.php
Referrer : http://www.s*******/admincp/plugin.php?do=productadd
IP Address : 24.******
Username : HAL-9000
Classname : vB_Database

[akanevsky]

Remove the appropriate line from the XML file...

[Delor]

This has been asked but I will ask again, is there anyway in the acp to set this so that certain forums can not be excluded like news and announcements and rules or something similar?

Love it Installed

[akanevsky]

No, that is not currently possible.

[Tralala]

This has been asked but I will ask again, is there anyway in the acp to set this so that certain forums can not be excluded like news and announcements and rules or something similar?

I can't answer for this one specifically, but I have a similar hack by Andreas (https://vborg.vbsupport.ru/showthread.php?t=91025) installed. And with that one, you can easily set those restrictions in the Forum Permissions section of the AdminCP. You can set which usergroups can and cannot "exclude Forums from Get New Posts."

It doesn't remove forums from from the forum list though. It only omits posts from those forums from the "Get New/Get Daily" searches.

[akanevsky]

That this is the hack upon which this one was built. The forum setting will be added in future version.

[Delor]

Will they work together? Or must they only be one or the other installed?

[akanevsky]

Although you might be able to install them together, they won't work together, meaning permissions of one won't affect the second...

[Delor]

Thats sad, as I know you asked repeatedly for them to add the requested additions, several times in fact, and many would love that, thanks for the heads up Psionic

[akanevsky]

There was none. I simply verified that this hack is working on 3.5.4 and repackaged it. There were no changes.

[theArchitect]

I just tried to update my version of this, but when I tried to upload the product got this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE usertextfield ADD excludeforumids VARCHAR(255) NOT NULL ;;

MySQL Error : Duplicate column name 'excludeforumids'
Error Number : 1060
Date : Wednesday, May 24th 2006 @ 05:27:34 PM

[akanevsky]

Update your version of this? This has only had one version.

[theArchitect]

Strange. I was browsing the hack listing and this one had the green "Update" text next to it, so I assumed a newer version had been released.

Plus, it said last update 12 May and I have had it on my board longer than that... I Think.

[akanevsky]

Strange. I was browsing the hack listing and this one had the green "Update" text next to it, so I assumed a newer version had been released.

Plus, it said last update 12 May and I have had it on my board longer than that... I Think.

If it was updated, then the version would be > 1.0.0...
What actually happened:
https://vborg.vbsupport.ru/showpost.php?p=974411&postcount=64

[theArchitect]

No worries. That will teach me not to read the posts properly and just rely on the "Update" note. ;)

[agiacosa]

Anthony,

I know you're busy and it was asked previously, however, I just want to vote for the option. It would be great if you could exclude specific forums from this. For example, I have a series of sponsor forums that I don't want people to be able to hide.

Thanks for this great hack!

[akanevsky]

Ok, I might add that feature in future.

[sunnycher]

Thank you!!!

[4yBak]

This does not seem to work on 3.5.4.

Can anybody else confirm if it does or does not work for 3.5.4? Thanks.

I'm looking at the code and maybe I'm missing something, but since when did setting a forum's display order to 0 make it not show up at all?
I just install it on my board (3.5.4) and this hack not working too (installing was successfully, but in User CP I can't see an options to exclude forums) :tired:

[akanevsky]

Hack updated. To upgrade, just overwrite product xml.

[scottct1]

Anyone using this on the beta yet?

[scottct1]

Ok I installed the update and its not working for me, whenever I go to edit options in my user profile I get the following...

Fatal error: Cannot redeclare forum_accessible() (previously declared in /home/satellit/public_html/profile.php(916) : eval()'d code:1) in /home/satellit/public_html/profile.php(916) : eval()'d code on line 96

[digitalhome]

Added option to set forums as excludable. By default, excludable is 0.

not sure what this means.

Does it mean that I can stop user from excluding a forum (and viewing new posts for that forum) if that forum is set to exludable=1?

[4yBak]

just updated this hack to 1.1.0 and have problem:
1) in introduction say next:
UPDATE PFXforum SET exludable = 1
but in table FORUM field exludable not exist, this field must be exCludable. Example:
UPDATE PFXforum SET excludable = 1
2) why to disable and enable exclude used same value - 1 ? May be to enable value must be 1 and to disable - 0 ?
3) in USERCP can't select forum list to exclude, I run queries, but this can't help me (see an attachment).

[tom w]

Same problems here as 4yBak. Tried both '1' & '0', but neither populates the forum list in User CP.

<later that same day...>
I did discover that if you "save display order" in Forum Manager, Options starts displaying the forum list.

[Parker Clack]

I installed the latest and like others and the forum list will not get pouplated even with all the excluded rows in the forum table set at 0.

[Hell?]

Hello, I also recently installed the latest version and I get this error whenever I try to access the edit options page:

Fatal error: Cannot redeclare forum_accessible() (previously declared in /myforumsdir/profile.php(916) : eval()'d code:1) in /myforumsdir/profile.php(916) : eval()'d code on line 96

[RoughOcean]

Does this hack add an option under "Forum Searching Permissions" when editing a Usergroup. I installed this hack and it seems to be working fine. But I do have a blank option under that heading, like:

Forum Searching Permissions
Can Search Forums Yes No
Yes No
Can Use Natural Language Search(Only applies if Fulltext searching is enabled) Yes No
Can Use Boolean Search(Only applies if Fulltext searching is enabled) Yes No

I am trying to track down out if this hack adds that blank option and if so, what the phrase should say.

[akanevsky]

This hack does not add any usergroup options.

[ericwirtanen]

I installed the latest and like others and the forum list will not get pouplated even with all the excluded rows in the forum table set at 0.

same here - I can't see the list of forums no matter what I do...

[akanevsky]

If you want any forums to be excludable, specify that in forum settings.

[Ntfu2]

Same problem, no forums are showing up in list no matter what

[akanevsky]

Read the post above yours.

[Pathor]

Thanks for the update! :)

You have a typo in the querie. ;)

UPDATE PFXforum SET excludable = 1

[Pathor]

Hello, I also recently installed the latest version and I get this error whenever I try to access the edit options page:

Fatal error: Cannot redeclare forum_accessible() (previously declared in /myforumsdir/profile.php(916) : eval()'d code:1) in /myforumsdir/profile.php(916) : eval()'d code on line 96

I have nearly the same error, but with vB 3.6.

EDIT: Got it. ;) You must uninstall the 1.0.0 Version. The new plugin doesn?t overwrite the old version.

[ericwirtanen]

If you want any forums to be excludable, specify that in forum settings.

D'oh! Thanks man; fantastic hack. :cool:

[Pathor]

One problem.

I want to make one subforum not excludable. The subforum ist under category X.
If the user select the category X (to make them invisible), the subforum is also invisible.

[realraptor]

thanks for this hack, installed fine with 3.5.4

[Vindicator]

Ok, I want users to be able to exclude certain forums from the "New Posts" facility. Yuor hack does this but it also hides the forum from the list which I do not want. Can the facility be enabled/disabled and if not can you please point me towards KirbyDE's original hack please? (doesn't appear on this forum)

Edited: Don't worry, found hack under Andreas username

[tandy]

Installed for the second time on a fresh installed vB 3.54, everything seem to work in the database, but no forum excluded, still view all of them.


Ok, i found the reason...

SQL Query:
UPDATE PFXforum SET excludable = 1


To disable excludable in all forums, run this query:
SQL Query:
UPDATE PFXforum SET excludable =0 "Must be Zero instead of one"

[yj_enquirer]

Hiya.. woz wondering if this will work in 3.6.0?

[ChrisBaktis]

Can someone tell me how to get the info I need to replace PFX with?

[ze_roberto]

In the Database. Try to replace it with nothing as a first shot (just delete PFX).

By the way: works on 3.6.1 on my testboard.

The bad news is that the forums still show in the latest thread of an vbadvanced portal and thing like vbispy...

cheers, ze

[McMendo]

Installed (click) on 3.6.2 and working just fine.

Ok, i found the reason...

SQL Query:
UPDATE PFXforum SET excludable = 1


To disable excludable in all forums, run this query:
SQL Query:
UPDATE PFXforum SET excludable =0 "Must be Zero instead of one"The install instructions are still wrong.

[JohnBee]

How do we find our table prefixes?
I tried:

UPDATE PFXforum SET exludable = 1
UPDATE forum SET exludable = 1

both gave me error number: 1054
error desc: Unknown column 'exludable' in 'field list'

[JohnBee]

Okay I figured it out, the modification instructions have a few typos in it.
Also, I'm not sure on the entire effectiveness of this hack. While it does filter out forums if your running any addons such as 'Number of unread posts' it does not really filter them out, it only confused people because the no. of unread posts is still shown but when they hit the link to view them, they get an error page.

I would really like to see this modification expanded on though. It sounds like a great addon.

[akanevsky]

The table prefix is what you specified in config.php.

Also, I'm not sure on the entire effectiveness of this hack. While it does filter out forums if your running any addons such as 'Number of unread posts' it does not really filter them out, it only confused people because the no. of unread posts is still shown but when they hit the link to view them, they get an error page.

The modification is designed as a hack for vBulletin, not for other hacks.

[TosaInu]

Same problems here as 4yBak. Tried both '1' & '0', but neither populates the forum list in User CP.

<later that same day...>
I did discover that if you "save display order" in Forum Manager, Options starts displaying the forum list.

Thank you, fixed it for me.

[Insert Username]

I'm running into a problem here. I updated the template. I imported the product. I ran the query and set all forums as excludable. I even confirmed in the DB that the 'excludable' field for each forum was set to '1'.

When I go to the options in the user cp, I see the excludable section at the bottom, but none of the forums are showing up.

Any ideas?

[akanevsky]

I'm running into a problem here. I updated the template. I imported the product. I ran the query and set all forums as excludable. I even confirmed in the DB that the 'excludable' field for each forum was set to '1'.

When I go to the options in the user cp, I see the excludable section at the bottom, but none of the forums are showing up.

Any ideas?

Try saving at least one forum via admincp forum manager. It rebuilds the forum cache.

[Insert Username]

Try saving at least one forum via admincp forum manager. It rebuilds the forum cache.
Perfect! Thanks.

[otstrel]

I would strongly recommend changing the type of field in database from varchar(255) to mediumtext.
Some users are clicking through every forum they don't want to see instead of selecting only categories and they end up with huge list of forumids which simply do not fit in varchar(255).

[sickboy6ths]

Nevermind this post...

[kofoid]

anyone know what's up with 3.5.4? I can't see it in my user options either. Just installed for the 1st time today

[akanevsky]

anyone know what's up with 3.5.4? I can't see it in my user options either. Just installed for the 1st time today

Please read the first post. Thanks.

[kofoid]

Hi again. OK I am slow, blond and apparently blind. I don't see what you are referring to in the 1st post other than it was created for 3.5.4. Sooo any idea why I can't see it in my memberoptions?

[akanevsky]

Hi again. OK I am slow, blond and apparently blind. I don't see what you are referring to in the 1st post other than it was created for 3.5.4. Sooo any idea why I can't see it in my memberoptions?

Please read the introduction section of the first post.

[Deimos]

Can't seem to get this working properly on VB 3.6.4

SOME of the categories/forums show up, but not all of them
I ran that sql query in the first post, but that hasn't helped

Any suggestions?

[Deimos]

Yay, got it working
It didn't work on some forums because the category was a link.

[FinalAngel]

The Script doesn't work with VB 3.6.5

it worked perfectly with VB 3.6.4

[Merriweather]

OOPS -- Wrong thread.

[furst]

Is it possible to create custom links which will automatically select which forums to filter for users when they click on them?

I'd like to put some links at the top which would break my forum into sections. For instance, when someone clicks the Sports link, all forums are excluded for them except for those related to sports.

And another question - is this hack hard on server resources? Is it safe for big boards to install it?

[chompychan]

Is there any way I can make a forum excluded BY DEFAULT and allow users to, after registration (if they choose) to make the forum viewable?

This would be GREAT!

[Sushubh]

does not work for me on 3.6.6

[pcg]

I am not seeing sub forums in my selection, is this a possibility?

[TosaInu]

Hello,

In order to be listed on the can be excluded list in the UserCP a forum only:
-needs to be excludable
-visible for that usergroup

That's right?

[TosaInu]

Hello,

The reason I ask is that one of the forums, set up like that, is not listed in the exclusion options at all. Am I missing something?

[akanevsky]

Hello,

In order to be listed on the can be excluded list in the UserCP a forum only:
-needs to be excludable
-visible for that usergroup

That's right?

Yes, that is correct.

[TosaInu]

Hello Psionic Vision,

One of the forums refuses to list.

It does list when search is allowed too, but that should be disabled since it's a huge off topic forum.

[SteveC]

Thanks. Very nice.

Has anyone posting simple instructions on how this works for end users?

[Razasharp]

Great work Psionic Vision :)

Is it possible you could create a very slight variation of this hack so I could use a url to exclude certain forums form the forum index? Eg:

http://vbulletin.com/forum/index.php?&exclude=10,28,12

Which would then exclude forums 10, 28, and 12 from showing on the forum home/index page.

That would be a HUGE help, please please please consider it :)

Edit: Meant to say so it's not permanent, just that those forum IDs will not show when that particular url/link is followed.

[rlharp5375]

Ok, help a newbie please. When running the query, I got this error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'excludable' in 'field list'

Any idea how to fix it?

[TosaInu]

Hello rlharp5375,

You need to create that field first. Have you installed the hack already?

[TosaInu]

Hello Psionic Vision,

One of the forums refuses to list.

It does list when search is allowed too, but that should be disabled since it's a huge off topic forum.

It appears a forum also needs to be searchable for a usergroup or it won't be added to the exclusion list. Does it use part of the advanced search code?

[jilly]

Is there a 3.7 working version of this hack yet? or coming?

[hjmaier]

It works already with 3.7

Best regards
hj

[Aquestor]

Originally Posted by WAR
I am also having difficulties getting this to work completely.

It will not let me exclude more than ~50 forums at a time. Is there anyway to bump this up to 2-300 as a maximum?
Or 100,000 for that matter.

Yep, I can't exclude more than ~70 at a time.


Have the same Problem need this hack absolutly! Is there anyone who can resolve this problem?

[Andy Rickard]

Just installed this. After the initial install, the list of forums wouldn't populate, but saving the display order as suggested fixed the issue.

Works great.... thanks for the hack!!

[SteveC]

Just installed this. After the initial install, the list of forums wouldn't populate, but saving the display order as suggested fixed the issue.

Works great.... thanks for the hack!!

still doesn't work for me and it used to work fine. Does it need to be reinstalled if you add a new forum?

[Aquestor]

Have the same Problem need this hack absolutly! Is there anyone who can resolve this problem?

Get this work need no help any more

[jilly]

I get this error message when trying to actually select the forums for exclusion

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE usertextfield SET
excludeforumids = '18'
WHERE userid = 1;

MySQL Error : Unknown column 'excludeforumids' in 'field list'
Error Number : 1054
Request Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Error Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Script : http://www.mysite.org/profile.php?do=updateoptions
Referrer : http://www.mysite.org/profile.php?do=editoptions
Classname : vb_database
MySQL Version : 5.0.45-community

[jilly]

I get this error message when trying to actually select the forums for exclusion

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE usertextfield SET
excludeforumids = '18'
WHERE userid = 1;

MySQL Error : Unknown column 'excludeforumids' in 'field list'
Error Number : 1054
Request Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Error Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Script : http://www.mysite.org/profile.php?do=updateoptions
Referrer : http://www.mysite.org/profile.php?do=editoptions
Classname : vb_database
MySQL Version : 5.0.45-community



I am guessing this means I need to manually add a field or column somewhere but I am clueless on how to do it - does anyone know?

[Andreas]

ALTER TABLE usertextfield ADD excludeforumids MEDIUMTEXT
But the column should have been created automatically upon product install ...

[dtv100]

edit:
post in wrong thread sorry .

[jilly]

ALTER TABLE usertextfield ADD excludeforumids MEDIUMTEXT
But the column should have been created automatically upon product install ...

thank you, that fixed it! I don't know why it didnt take at first - I followed all the instructions - but that query fixed it - thanks!

[shridevimoogi]

Hi,

Can I make this hack controllable only by admin
and in conjunction I want to control forum list based on different domains,but the database remains one

Thanks

[EagleNick]

Not working on 3.8.2. I have ran the query multiple times and it confirms that the rows have been affected.

However, in the UserCP in the menu there is only one choice: "[Reset Exclusion]" and selecting it does nothing.
Hopefully somebody can offer a remedy.

[akanevsky]

The new version work better, so you might want to download it now. It works on 3.8.x, too.

[scottct1]

Not working on 3.8.2. I have ran the query multiple times and it confirms that the rows have been affected.

However, in the UserCP in the menu there is only one choice: "[Reset Exclusion]" and selecting it does nothing.
Hopefully somebody can offer a remedy.


Same issue here, any solution?

[WF Rabbit]

trying to run the query on this hack.

Get the following error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@xxxxxxx.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


any idea's?

[hmspain]

Sorry if this has been asked and answered; I did search :-).

Is this mod compatible with vBulletin V4 systems?

I have a ton of forums (unavoidable) and vBulletin appears to expect you to have a focused system since "New Posts" will show you ALL the new postings across ALL the forums!

My users are hoping to narrow things down a bit, and this might be the perfect answer.

[tehbasmentdwell]

Sorry if this has been asked and answered; I did search :-).

Is this mod compatible with vBulletin V4 systems?

I have a ton of forums (unavoidable) and vBulletin appears to expect you to have a focused system since "New Posts" will show you ALL the new postings across ALL the forums!

My users are hoping to narrow things down a bit, and this might be the perfect answer.

Doesn't seem to, i've just tried it on my own board running 4.2.2 and it just throws up a bunch of error messages when you go into general settings.

If anyone could help to fix this mod for 4x i'd be eternally grateful :)