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)

[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:

ALTER TABLE PFXusertextfield CHANGE excludeforumids excludeforumids MEDIUMTEXT NOT NULL

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

[projectego]

Thanks.

* projectego clicks install :)

[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]

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]

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]

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]

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]

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]

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. :D

[Kungfu]

i cant seem to get this working even after setting the exclusions

[sunnycher]

This is the one where the members can filter forums, correct? I am using it, love it.

Isn't there one somewhere that the admin can filter the forum also?

[TheEDIGuy]

This works well. After running the query to allow all as excludable, I did have to re-save one of the forums manually to get them to show up on the list, but all else works great. The users have been asking for this one. Thanks!

[nix]

Is there a way to remove the forum from the search function but leave it on the index?

[Kungfu]

This works well. After running the query to allow all as excludable, I did have to re-save one of the forums manually to get them to show up on the list, but all else works great. The users have been asking for this one. Thanks!

uh ok, works now. thats wierd. Thanks.

[akanevsky]

Yeah. Simply disable the plugin at cache_ordered_forums hook.

[nix]

Yeah. Simply disable the plugin at cache_ordered_forums hook.

Thanks. I thought of this last night but I forgot to run the query again. Thanks again!

[nix]

When you this there seems to be a limit with how many forums you can select. No matter how yo do it you can't select all the forums you want.

[akanevsky]

When you this there seems to be a limit with how many forums you can select. No matter how yo do it you can't select all the forums you want.

Yeah, you can select a maximum of 128 forums due to the limitation of the varchar database field. However, the hack is not intended to hide all forums. It is intended to hide a selection of forums only, otherwise there is no point to visit the site at all.

[nix]

Yea I don't want it to hid all of them. But its seems we are limited to 64.

[akanevsky]

Yeah, 128 assuming forumids are all single-digits.
You can run the following query to lift the limitation:
ALTER TABLE usertextfield CHANGE excludeforumids excludeforumids MEDIUMTEXT NOT NULL
Make sure to replace "usertextfield" with YOUR_TABLE_PREFIXusertextfield

[nix]

that did it. thanks.

[kafi]

wow this satsify my needs for "let user customize forum and forumhome" Currently I run 3.5 and use Opt-out forums hack but that one doesnt hid forums on forumhome...

GREAT. ASAP my vb turns 3.6 I will be back .-)

[akanevsky]

wow this satsify my needs for "let user customize forum and forumhome" Currently I run 3.5 and use Opt-out forums hack but that one doesnt hid forums on forumhome...

GREAT. ASAP my vb turns 3.6 I will be back .-)

This works on 3.5.4.

[4yBak]

I'm use version 1.0.0 of this hack and want to update it to 1.0.2: what I need to do for that? I need just install xml file or do template changes also?

Thanks.

[vbreal]

need this thanks

[Ramsesx]

Seems not to work on 3.6.4, did the template change, the querie, product import, but only showing [Reset exclusion] but no forums. Thanks.

[akanevsky]

Seems not to work on 3.6.4, did the template change, the querie, product import, but only showing [Reset exclusion] but no forums. Thanks.

Forums must be set as excludable in order to be excluded.

[Ramsesx]

Got it, thanks.

[Greek Wizard]

Psionic Vision

This is a great hack, one of your best IMO.

It works great for large forums, for those users that do not want everything.

One question though... I have a user that has blocked out a catagory, however vbAdvanced still shows those threads/forum in the recent news block.

if there anything that can be added on to exclude those from there also?

Thanks

[akanevsky]

Psionic Vision

This is a great hack, one of your best IMO.

It works great for large forums, for those users that do not want everything.

One question though... I have a user that has blocked out a catagory, however vbAdvanced still shows those threads/forum in the recent news block.

if there anything that can be added on to exclude those from there also?

Thanks

Please contact the developer of vBAdvanced and ask them to respect the visibility settings of forums in the vBulletin forumcache.

[Greek Wizard]

Please contact the developer of vBAdvanced and ask them to respect the visibility settings of forums in the vBulletin forumcache.

OK, Thanks anyways,

I am sure I won't get much help over there so I might bother, it's only a minor issue right now.

I will probably be switching to vBonjour soon anyways, hopefully that one will be better.

[telc]

What exactly does "enable excludability" and "disable excludability" do? Is it needed to run this query?

Also I have around 250+ forums, is the xml file going to be updated to change the varchar to mediumtext to support larger forums.

Thanks.

[Bellinis]

First of all: thank you for this great hack!

Ok, I installed it, but don't see any forums listed in my CP options, only 'reset exclusion'.


I followed the instructions, run the query set alle forums to be excludable. Also I disabled the cache-part. Switched the exclusion option in some forums on- and off, but still no luck. Anything else I could try ? :(

Thanks. :)

[Bellinis]

I just discovered why it's not working. The problem is VBSeo. After disabling VBSeo, all worked fine. Nice, but now what?

What can I do to make it working even with VBSeo activated?

[akanevsky]

I don't know. I am not familiar with vBSEO.

[telc]

Is the xml file going to be updated to change the varchar to mediumtext to support larger forums.

[Bellinis]

I don't know. I am not familiar with vBSEO.
I asked at vbseo, and the suggested using Andreas' mod (https://vborg.vbsupport.ru/showthread.php?t=91025). That mod worked fine for me. :) Anyhow, thank you for your help. Too bad this mod didn't work out for me....

[akanevsky]

I asked at vbseo, and the suggested using Andreas' mod (https://vborg.vbsupport.ru/showthread.php?t=91025). That mod worked fine for me. :) Anyhow, thank you for your help. Too bad this mod didn't work out for me....

This mod is the same as that mod, except that mod only hides stuff from "get new posts", and this one also hide stuff from forums. They are both based on the same code...

[RoughOcean]

I don't know. I am not familiar with vBSEO.

I am having the same problem with a conflict with vBSEO. I really like this mod and would rather not switch to the other one. vBSEO (http://www.vbseo.com) is a mod that makes search engine friendly URLs using mod rewrite.

I hope this is a minor conflict that can be resolved someday since it seems vBSEO is getting more popular.

[akanevsky]

I am having the same problem with a conflict with vBSEO. I really like this mod and would rather not switch to the other one. vBSEO (http://www.vbseo.com) is a mod that makes search engine friendly URLs using mod rewrite.

I hope this is a minor conflict that can be resolved someday since it seems vBSEO is getting more popular.

Consdering that vBSEO is a commercial mod, there is no way I can make any of my modifications compatible with it if they are not already. vBSEO conflicts with a lot of hacks, so please ask the author of vBSEO to consider the existence of other hacks and maybe rework the inner structure of his product. Thanks.

[ccole]

Just an FYI who used the forum filtering hack (don't remember the exact name in 3.0.x):

I just installed this after upgrading to 3.6

I ran into the issue where the field you added to the usertextfield table, 'excludeforumids' happens to be the same field name as the old version, but the difference it that field was showing up in the user table.

So when i installed yours, and set the forums to be allowed to be excluded, i was surprised to find that the exclusions from my old version were still there.. However, I couldn't change them.

I fixed the probem be dropping that column from the user table.. Everything working great now.

[LeeCHeSSS]

Thanks for this hack.

I've noticed that when excluding categories, posts that were made in (sub)forums in those categories, the posts are still visible in get-new and get-daily searches. Is it possible to fix that?

[akanevsky]

I've noticed that when excluding categories, posts that were made in (sub)forums in those categories, the posts are still visible in get-new and get-daily searches. Is it possible to fix that?

In this version, you need to select all subforums that you want to make invisible individually.

[LeeCHeSSS]

Is there another version then?

[akanevsky]

Is there another version then?

No, this is the latest version released...

[LeeCHeSSS]

Oh, you had me confused then by saying "In this version, [...]"

It's not a big problem anyway.

[sere]

i have a similar problem as described above. on 3.6.4 all i see is [Reset exclusion] without any list of forums. i have enabled excludability in all forums (set to 1) but that doesn't seem to help.

[akanevsky]

i have a similar problem as described above. on 3.6.4 all i see is [Reset exclusion] without any list of forums. i have enabled excludability in all forums (set to 1) but that doesn't seem to help.

Save at least one forum via admincp after you run the query.

[prophecydude]

Is there a way I can have it so all a user has to do is just select the parent forum and simply have all the associated sub forums hidden as well? I heard you say that there was a max number of forums that could be excluded, and it's tedious selecting new forums like that.

[akanevsky]

Is there a way I can have it so all a user has to do is just select the parent forum and simply have all the associated sub forums hidden as well? I heard you say that there was a max number of forums that could be excluded, and it's tedious selecting new forums like that.

There's a solution to remove the limitation - please read through this thread to find it.

[morrow]

Damn.... Was looking forward to using this hack. Just yesterday, a few of my users asked if they could exclude 2-3 forums. VBSEO seems to be my issue.

[prophecydude]

There's a solution to remove the limitation - please read through this thread to find it.

Oh yeah I saw that earlier. It's just that I add new subforums every week and it's tedious going through all of them. If the top level forum can be excluded then all of the sub forum should be (or have an option). Do you plan to add this in the future?

[KrisP]

Quote:
Originally Posted by Ramsesx
Seems not to work on 3.6.4, did the template change, the querie, product import, but only showing [Reset exclusion] but no forums. Thanks.

Forums must be set as excludable in order to be excluded.

I am not sure I get it. I have successfully updated the database, updated the template and installed the product. And I also only see "[Reset exclusion]"

[akanevsky]

I am not sure I get it. I have successfully updated the database, updated the template and installed the product. And I also only see "[Reset exclusion]"

After running the query, save at least one forum manually to rebuild the cache.

[prophecydude]

Oh yeah I saw that earlier. It's just that I add new subforums every week and it's tedious going through all of them. If the top level forum can be excluded then all of the sub forum should be (or have an option). Do you plan to add this in the future?

Any updates?

[verrin]

UPDATE PFXforum SET excludable = 1
I ran this query, but I got an error?


In both cases, PFX must be replaced with the actual table prefix that you have defined in config.php.
I'm not sure I understand this.

In my Config.php reads:
// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';
I set the value to 1 in config.php, but it gave me a database error and tried setting it to 0 (same result). Put it to nothing, to retain forum.

[Merriweather]

Installed the product, made the template change, set the forums I wanted excluded, went to adminCP and manually saved a forum to rebuild the cache and all I get is [Reset Exclusion]. Using vB 3.6.5 and I don't have vbSEO.

:(

[akanevsky]

UPDATE PFXforum SET excludable = 1
I ran this query, but I got an error?


I'm not sure I understand this.

In my Config.php reads:
// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';
I set the value to 1 in config.php, but it gave me a database error and tried setting it to 0 (same result). Put it to nothing, to retain forum.

If you have no table prefix (empty value for $config['Database']['tableprefix']) then please just remove PFX from the query.

Installed the product, made the template change, set the forums I wanted excluded, went to adminCP and manually saved a forum to rebuild the cache and all I get is [Reset Exclusion]. Using vB 3.6.5 and I don't have vbSEO.

Please make sure that you allow excludability on all parents forums of the one(s) you want to exclude.

[Fungsten]

Tesing it on VB 3.6.5

[Fungsten]

uploading the XML file, THEN running the SQL Query.

If you have no table prefix (empty value for $config['Database']['tableprefix']) then please just remove PFX from the query.



Please make sure that you allow excludability on all parents forums of the one(s) you want to exclude.

[Tourmeister]

Save at least one forum via admincp after you run the query.

I would suggest adding this to the instructions. I had to sit here and read through all the posts in this thread until I found your suggestion. Then it worked perfect! :D

Very nice mod. Thanks!

[Tourmeister]

It occurs to me that it would be nice if there were a list of currently filtered forums for the user to review. If it has been a while since they filtered forums, they may have forgotten which are ignored. Anyway to include an indicator next to each forum in the list in the window where you pick which to filter?

Also, anyway to reset the exclusions on individual forums without resetting all of them at once? It seems kind of inconvenient that if you want to remove one forum, you have to remove all and then re-exclude all the ones you still want.

[LeeCHeSSS]

I think you haven't followed the installation instructions properly. Because the plugin already allows you to see which forums are excluded (they are selected), and it is already possible to re-enable one specific forum by deselecting it (hold CTRL).

[Tourmeister]

Because the plugin already allows you to see which forums are excluded (they are selected), and it is already possible to re-enable one specific forum by deselecting it (hold CTRL).

Man... you would think that would have been brutally obvious... :o

Unfortunately, I am the master at missing the brutally obvious :p

Thank you for setting me straight :up:

[BulletNow]

I have NO table prefix. So how would I run that Query?

what do u mean by
If you have no table prefix (empty value for $config['Database']['tableprefix']) then please just remove PFX from the query.

[Holidazed]

Can this be modified to be able to turn this on and off globally?
Can it be modified to allow me to select certain usergroups that can and cannot use it?

BTW, instead of using the "reputation.gif" file to represent the ignore thread option, I modified the code to look for "ignore.gif" and then used this image. Feel free to use it yourself.

[subnet_rx]

I think this may be exactly what I've been looking for, thanks!

[akanevsky]

Can this be modified to be able to turn this on and off globally?
Can it be modified to allow me to select certain usergroups that can and cannot use it?

Yes. Anything is possible. Sorry, though, I am not going to provide exact instructions. If you do not want to wait for me to *maybe* implement it, please feel free to ask someone in the modifications forum to help you to modify this hack.

BTW, instead of using the "reputation.gif" file to represent the ignore thread option, I modified the code to look for "ignore.gif" and then used this image. Feel free to use it yourself.

What does "ignore thread" have to do with this hack?

[Holidazed]

What does "ignore thread" have to do with this hack?Oops. The "Ignore" image should have went to the other thread.

[cajunboy2208]

After running the query got this...

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'

NM:
Thought introduction meant to do it 1st. i went ahead and edited the forum, and did the plugin. Then got this...

Affected Rows: 53 (0.0019s)

Thank you. Great hack.

[cajunboy2208]

Ok I got it installed. But I do not see where you can ignore the forums... any help?

Got it. See that you have to go to forum manager and just save one... had no clue... once again, great mod, works wonderfully...

[Fungsten]

;) :D

Ok I got it installed. But I do not see where you can ignore the forums... any help?

Got it. See that you have to go to forum manager and just save one... had no clue... once again, great mod, works wonderfully...

[ABMAC]

I just installed it on 3.6.7 and it works great! Thanks!

[Ignicoccus]

Damn.... Was looking forward to using this hack. Just yesterday, a few of my users asked if they could exclude 2-3 forums. VBSEO seems to be my issue.

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

[ssslippy]

Psionic I believe there is a hook you can use for this template edit. Currently Self Censor Plus makes the template edit exactly where yours is.

[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?

[BWJ]

Thank you for this excellent hack!

[popowich]

I would suggest adding this to the instructions. I had to sit here and read through all the posts in this thread until I found your suggestion. Then it worked perfect! :D

Very nice mod. Thanks!

I'm glad you made a comment somewhere near the end of the thread.

I was banging my head too.

Yes, please add this step to the instructions. Thank you!

-Raymond

[MaxiMal]

I like this addon, but this don't work on vb 367 :-( :cry:

"Forums To Exclude From View" it empty (cann't view forums for ignore).

[popowich]

It works. You need to configure it.

Also, for the list to appear, you need to edit and save any one of your forums with the forum manager.

-Raymond

[MaxiMal]

UPDATE table_prefix_forum SET excludable = 1
this do not help me

/me
ver. 1.0.0 on 3.5.5 work
ver. 1.0.2 on 3.6.7 not

yahooooooooooo! work!

night... :)

[popowich]

Also, for the list to appear, you need to edit and save any one of your forums with the forum manager.
-Raymond

AdminCP -> Forums -> Forum Manager Edit and Save any of your forums.

-Raymond

[SteveC]

just a suggestion -- it would be great if some sort of title like "New Posts Filter" was added, so users know what it is. It just comes up in the "miscellaneous options" box and says "to select multiple forums...etc." A user coming across this wouldn't have any idea what it is.

Has anyone done a mod they'd care to share that adds a title and some more detailed instructions?

ETA: I just noticed my install doesn't match the screenshot. The tile "forums to exclude from view" and the first paragraph below it are missing. Any idea how to fix this?

[FireFish]

:( Not working on my board.
I have a feeling that a current mod "Opt Out of New Posts from select forums" which is placed right beneath it is conflicting with it.

They both show up in my Edit Options; but when this mod is enabled, both mod's selection lists don't show my forum list.

When the other one is disabled & this one enabled, this mod still doesn't show the Forum List (even after running the SQL Script).

BUT, If I disable this one & leave the other enabled, they both show full forum list of selections.

Wierd.
Any possible recommendations?
I uninstalled it for now but will reinstall if I can get a working solution to my issue.

This mod is very useful & would work wonders for my users!

[Razasharp]

Oops I posted this in the 3.5 thread by mistake... :o

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. So if someone goes back to the forum home via the normal http://vbulletin.com/forum/index.php they will all show.

[TheBlackPoet]

okay. before i ran the query, i was going to manually exclude them all.. but opted not to do that since i have over 100 forums...
when i ran the script, i went to check to see if it worked... but it only showed the forums i manually selected...

what i had to do, was reverse the exclusion and uninstall the hack then reinstall the hack and rerun the query... and it works perfect..

installed!!!

[wlad.w.m]

Thank you, Psionic Vision !
Very useful hack.

[Niber]

Has anyone been able to integrate this into vBISpy (https://vborg.vbsupport.ru/showthread.php?t=125947)?

[ericgtr]

Excellent, installed. This is a must have for any political site lol.

[ericgtr]

I wanted to add this to my forumhome next to the forums they have an option to exclude to make it a little more obvious. Here's a simple solution for this for anyone who's interested in this. What it will do is take them right to the Edit Options page and drill to the bottom.

In the modifyoptions template find:
<div style="margin-top:$stylevar[cellpadding]px">
<input type="submit" class="button" value="$vbphrase[save_changes]" accesskey="s" />

Add this just above
<a name="jump" id="jump"></a>

Now we add the anchored link to the Description field under Forum Manager > Edit Forum
http://www.yourforum.com/profile.php?do=editoptions#jump you will need to change the path your forum.

[McMendo]

I have one version of Selective Forum Filter, by Psionic Vision, installed. The oddity is that the version shown on the Manage Products menu is 1.1.0, where this latest version is 1.0.7.

Am I missing something?

[Fungsten]

I wanted to add this to my forumhome next to the forums they have an option to exclude to make it a little more obvious. Here's a simple solution for this for anyone who's interested in this. What it will do is take them right to the Edit Options page and drill to the bottom.

In the modifyoptions template find:
<div style="margin-top:$stylevar[cellpadding]px">
<input type="submit" class="button" value="$vbphrase[save_changes]" accesskey="s" />

Add this just above
<a name="jump" id="jump"></a>

Now we add the anchored link to the Description field under Forum Manager > Edit Forum
http://www.yourforum.com/profile.php?do=editoptions#jump you will need to change the path your forum.

Thanks but it didn't work for me. It just showed the code but nothing to click on. Ver. 3.6.8 PL2

[ericgtr]

Thanks but it didn't work for me. It just showed the code but nothing to click on. Ver. 3.6.8 PL2
You will need to add it as html to Forums & Moderators > Forum Manager > choose forum and add something like this (below) to "Description"


<a href="http://www.yoursite.com/forum/profile.php?do=editoptions#jump">
[Hide this Forum]</a>

[Fungsten]

You will need to add it as html to Forums & Moderators > Forum Manager > choose forum and add something like this (below) to "Description"


<a href="http://www.yoursite.com/forum/profile.php?do=editoptions#jump">
[Hide this Forum]</a>


Worked!! BTW, check your PM.

[SteveC]

this suddenly stopped working on my forum. I reinstalled and it still doesn't show up at all under edit options.

any ideas?

[andrewkhunn]

this suddenly stopped working on my forum. I reinstalled and it still doesn't show up at all under edit options.

any ideas?

Same here. Also looking for some hints at a possible solution.

[Robert Waanders]

Is this mod still supported?

[RaceJunkie]

What's the difference in this mod and this (https://vborg.vbsupport.ru/showthread.php?t=91025) one?

Also will this one be upgraded to 3.7?

[Roxie]

I have tested this on 3.7 and it works perfectly. Thank you!

[SteveC]

Roxie -- you got it to work? I and others have had it suddenly stop working and no one seems to know what happened or how to fix it.

[ManuelW]

i have installed on 3.6
i cant see my forums in the select list. i have enabled all forums for hiding.

[weitalia]

i have installed on 3.6
i cant see my forums in the select list. i have enabled all forums for hiding.
same problem ...

[rwoscott]

i have installed on 3.6
i cant see my forums in the select list. i have enabled all forums for hiding.

same problem ...
Ok guys, try the following.

After running the query, save at least one forum manually to rebuild the cache.

[Panagioths]

excuse me, but i must be blind. I am trying to figure out where is that list that you xan exclude forums from search. I have literally searched everywhere and I can't find where i can exclude forums from search.
I ran the sql command, I opened and saved a forum from the Forum Management (.../admincp/forum.php?do=modify) and i can't see anything. Any guidance would be appreciated.
My vb version is 3.6.8 Patch Level 2. Thanks in advance.

[rwoscott]

excuse me, but i must be blind. I am trying to figure out where is that list that you xan exclude forums from search. I have literally searched everywhere and I can't find where i can exclude forums from search.
I ran the sql command, I opened and saved a forum from the Forum Management (.../admincp/forum.php?do=modify) and i can't see anything. Any guidance would be appreciated.
My vb version is 3.6.8 Patch Level 2. Thanks in advance.Try UserCP> Edit Options. Right down the bottom of the page.

[weitalia]

Ok guys, try the following.
already done, but no effect on it.

[alfaowner]

If you have vbseo installed, add option.php to the vbseocp.php page in the exclude page options.

This will then populate the forums into the exclude box.

[weitalia]

If you have vbseo installed, add option.php to the vbseocp.php page in the exclude page options.

This will then populate the forums into the exclude box.

no i don't install vbseo

[Coop1979]

Is there a way to enable this only for certain usergroups? I want to only enable this for my premium level members.

[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]

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]

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/showpost.php?p=1545695&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

[bessler73]

Is there a way to enable this only for certain usergroups? I want to only enable this for my premium level members.


going to give this one a try on 3.7 only thing I can think of to limit this to certain usegroups is to modify the modifyoptions template with a condtional

<if condition="($bbuserinfo[usergroupid]==xx)"

Something I used to put custom sheilds in front of users names. Unless I missed something and there is already a option for this.

[WoodiE]

It would be awesome if someone could upgrade this to work with 3.7

[Deimos]

It does work for 3.7, at least, it works on my board ok.

[Bellinis]

Can't get this to work either :(
It does show up in my settings, but says [Reset Exclusion]

I did run both queries above, but no luck.
Anyone?

*EDIT - FIXED*

I reloaded the forum settings for one forum and from that moment all forums showed up in the list. :)

[Ov3rrun]

Hi, is there a way to activate this mod on vbadvanced (new messages module). ? Actually vbadvanced is showing all new messages (for all forums even if user have choice to hide some forums.)

[AndrewRich]

Installed! Also using the forumdisplay (https://vborg.vbsupport.ru/showpost.php?p=1390551&postcount=57) enhancement.

[TriMe]

Installed and working great on 3.7.4 patch level 1.

Thanks!

[nascartr]

Working fine for 3.8 RC1!

[Deimos]

Works for the most part, but sometimes blocked forums show up in the new posts screen
Anyone else having this problem?

[Deyth]

How to add this to forum lists including forum home? Kind of like this (https://vborg.vbsupport.ru/showpost.php?p=1390551&postcount=57) except for forums.

[derrene]

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]

Is there a 3.7 or 3.8 version for this out yet?
If you read a few posts up you'll find:
Installed and working great on 3.7.4 patch level 1.
Thanks! 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]

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:-
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 (http://unmoderated.info/forums/index.php) 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:)

[WillUnderwater]

Works great on vbulletin 3.8!!!

[WillUnderwater]

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:)


That means you don't have a table prefix - so just delete PFX and run the command

[Dennis B]

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.Has anyone been able to fix this? Thanks!

[Ov3rrun]

hi, its possible to fix this mod to work on CMPS vbadvanced latest topics module on index?

Actually this mod works ok on all pages except on module latest topics (vbadvanced)

Thanks

[DieselMinded]

Can someone just add an option to the forum manager for each forum

Include Posts From This Forum In New Posts / Latest Posts Search - YES or NO

[edytwinky]

Can you set it to where users cannot select certain forums?

[Mr. W]

_____ So, I tried installing this. Problem is, I wonder if something is broken.

_____ First thing I did, after installing it, is to set the "excludable" field in the "forum" table to my liking for each row (which corresponds to each forum). Thing is, it doesn't seem to make any difference. I tried it with a forum that CAN be excluded, and with a forum that CAN'T, or so I thought. But in both cases, it was still possible to exclude the forum.

_____ Do those settings not apply to Super Administrators? That was the only account where I tested this. Or is this a bug?

_____ Also this is slightly off-topic from what I said earlier, but is there a way to prevent certain user groups from using this feature? Or are template edits and just hiding that option the closest that I can get to achieving this?

[Mr. W]

Can you set it to where users cannot select certain forums?

___ You should be able to, but that function seems to be broken for some reason.

[Wonksta]

Hi there,

Is there anyway to still show the forum on forum home but not to show up in searches, get new posts or unread posts.

I just want to be able to let members click into the forum if they want to view it but not have the threads and posts shown in unread posts / todays posts etc.

Thanks

[briansol]

anyone know of a vb4 version of this/something similiar?

[Dennis B]

A vB4 verson of this hack would indeed be most welcome...

[scottct1]

I am running this on vBulletin 4 and it has been working fine but I have a few issues

1) I added a new forum and its not being displayed in the list to be able to block it. How do I get the new forum to show?

2) People are upset they are seeing results in excluded forums in their searches, how do I get this to work with all searches?

Thank you for your help!

[Alan_SP]

Eh, it doesn't work with vB4, it needs to be rewritten for it. Please, rewrite it for vB4.

[Silmarillion]

Does this actually work with vbseo enabled?

[jilly]

I am using the SocialForums mod, and I also use the selective forum filter mod
my problem is that I can't get the social forums to show up in the list of forums to be excluded. I have run the back end php query that is supposed to make all your forums be excludable, and it still didn't affect the social forums. this was the query:

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.


I have no table prefix for my tables, so i removed the PFX and ran it plain. Does the social forums mod add any special table prefix to the tables it creates?

Any other ideas as to why they won't show up and allow themselves to be excluded? The groups are a combination of public and private groups.

__________________

[jilly]

Actually, I went to this thread again, and then I read the first post where it had the query to run if you have more than 64 forums - I ran that, and now it works! All boards show up and are excludable! Woohoo!

[Bat21]

Did this ever get re-written for vB4? I have done a search but can not see the vB4 version.