Exclude Forums from What's New & FORUMHOME

[ForumsMods]

Exclude Forums from What's New & FORUMHOME

Description:
This Hack allows users to hide forums from What's New (Get New/Get Daily) & FORUMHOME

Installation:

Upload all files in folder upload to ther respective directories on your webserver.
Go to ACP / Plugins & Products / Manage Products and import product-exclude_whatsnew.xmlWhere to set option:
Forums & Moderators-> Forum Permissions

Languages:
- English

History:
31-12-10: v4.0 First Release
23-06-11: v4.1 - Fixed Bug: Forums not being excluded from searches. Added Hide from FORUMHOME

This hack is created for your use free of charge. No payment is requested. However, if you would like to donate money for the work I put in to this hack, a donation would show your appreciation.

[zelnik]

this looks excellent!

[ProFifaLeagues]

Can see a lot of people using this!
Nice work

[Merjawy]

Great mod.. Thanks

[Merjawy]

Just tried it now.. It won't save the settings.. each time I go back the No is checked for any user group.

Using 4.0.7

[ImmortalForums]

Possible query or a way to set the default to no on forum permissions. I only want to allow a couple of forums and have way to many usergroups/forums.

[rowedf]

Just tried it now.. It won't save the settings.. each time I go back the No is checked for any user group.

Using 4.0.7

Same here, I'm using 4.1.1

[ForumsMods]

Same here, I'm using 4.1.1
I will check it.
It is working fine in my five vB 4.1 test sites.

[Asterix_ita]

4.1 don't work well

permits imposed on no - save - I go out - re-entry permits are to be yes

and

does not maintain the exclusions forum made in the user profile

[ForumsMods]

Just tried it now.. It won't save the settings.. each time I go back the No is checked for any user group.

Using 4.0.7
Same here, I'm using 4.1.1
I will check it.
It is working fine in my five vB 4.1 test sites.
4.1 don't work well

permits imposed on no - save - I go out - re-entry permits are to be yes

and

does not maintain the exclusions forum made in the user profile
Please download zip file again.
I changed to the last 32-bit field.
Should not have any problem or conflict with others add-ons or official updates.

Note: you can use "Permission Duplication Tools" and "Quick Forum Permission Setup" to mass enable or disable.

[Asterix_ita]

With this new version I am having trouble in the user cp -> setting:

1. the option of choice don't appears
2. each menu item always leads to setting general

[ForumsMods]

With this new version I am having trouble in the user cp -> setting:

1. the option of choice don't appears
2. each menu item always leads to setting general
Sorry, I forgot one '=' in condition.
Download and overwrite product file again.

Check forum permissions.

[Fraxter]

Options in the cp were not save. vB 4.0.7

[ForumsMods]

Options in the cp were not save. vB 4.0.7
Download again and overwrite product.
An small typo was fixed.

[ProFifaLeagues]

Where are the options to exclude the forum ids???? I can not find them anywhere after giving permission to the admin group to use them.

[ForumsMods]

Where are the options to exclude the forum ids???? I can not find them anywhere after giving permission to the admin group to use them.
In Forums & Moderators-> Forum Permissions

[Merjawy]

I haven't redownlaoded yet.. but I found another issue on my forum.. forum permission for some user groups got messed up.. mainlly registered users .. they got no permission to allowed forums and they got permissions to non allowed forums.. I didn't even mess with all the forums when I was testing this mod..

I had to recheck everything and it was a pain
Then I lost my PC Sat. so I can't do much till I deal with that

[ProFifaLeagues]

Had pretty much the same issues on our forum and have now uninstalled.
Shame as a top mod and one that's needed for Vb...

[hiker]

I just installed on vb 4.0.2 and i'm not seeing the "what's new" option. I can't find any other place to set this. Any advice?

[dutchbb]

I'm looking for the vb 3.8 version of this mod, anyone?

Edit: found it https://vborg.vbsupport.ru/showthread.php?t=215001

[hiker]

Sorry, had to uninstall. It wasn't giving me the menu in the forum manager. I just had to edit the navbar template manually to make this happen.

Great idea though.

[Trek]

Not meant to take anything away from this mod, but I use: https://vborg.vbsupport.ru/showthread.php?t=215001

It's a 3.8 mod, but works fine on my 4.1 board.

[sticky]

Sorry, had to uninstall. It wasn't giving me the menu in the forum manager. I just had to edit the navbar template manually to make this happen.

Great idea though.

Yep, I can't find the menu either going to uninstall this.

[sticky]

Not meant to take anything away from this mod, but I use: https://vborg.vbsupport.ru/showthread.php?t=215001

It's a 3.8 mod, but works fine on my 4.1 board.

Nice tip, thanks, going to try that out.

[sticky]

Bump, could the author fix this mod please?

[ForumsMods]

Will release a new version with new features soon.

[sticky]

Will release a new version with new features soon.
Any update?

[Brandon Sheley]

great mod! :)

[BANDiT600]

Seems it odesn't work in 4.1.2 or some troubles with another hacks. I set up to exclude one forum from "What's new", but threads are still in search. It doesn't exclude.

[footzker]

Same here, 4.1.1, waiting for a fix

[AndrewRich]

Installed on mousepad.mouseplanet.com (4.1.2). Settings appear but do not seem to have any effect.

Unless I'm missing something?

I allowed the 'Can Exclude Forum from "What's New"?' permission to each usergroup, then went to my own Settings page and selected a forum to exclude. I click the "What's New" button and still see posts from that forum. Is there something else I need to do?

Is there a way to prevent certain forums from being excluded?

[AndrewRich]

I found the problem, at least on my system. In the AdminCP, under Plugins & Products -> Plugin Manager -> Product : Exclude Forums from What's New you will see four plugins for this product. One of them, which hooks "search_start", is disabled. I enabled it. Now the forum I selected to exclude does not appear in search results.

I'd still like to know if there is a way to deny excluding certain forums (e.g. FAQ, announcements, etc).

[sticky]

I found the problem, at least on my system. In the AdminCP, under Plugins & Products -> Plugin Manager -> Product : Exclude Forums from What's New you will see four plugins for this product. One of them, which hooks "search_start", is disabled. I enabled it. Now the forum I selected to exclude does not appear in search results.


Can anyone confirm if this works? Going to try it.

[Freewings2]

Can anyone confirm if this works? Going to try it.

Just tried it (4.1.3) and was not able to load the general settings :( Back to disabled. Would LOVE to have this mod back.

[sticky]

Just tried it (4.1.3) and was not able to load the general settings :( Back to disabled. Would LOVE to have this mod back.

Bummer, hope the issues get solved. I really need this as well.

[BadgerDog]

Just tried it (4.1.3) and was not able to load the general settings :( Back to disabled. Would LOVE to have this mod back.

Just installed and tested under 4.04 and yes, same problem ... not holding the settings value once set .. :(

Regards,
Doug

[NPGamers.Net]

Been looking for this for a while... perfect for RSS feeds that wash user posts away.

Edit: doesnt work

[BadgerDog]

Anyone able to get this mod to work? :confused:

Poorly documented ...

Been looking for forum selection box (one with clickable forum name options) for an hour and can't find it ...

Judging from other comments, it may be a useless exercise anyway as it doesn't seem to work, even if I find it .. :D

Regards,
Doug

[BadgerDog]

Update: Still never found the one settings box, but did find the one under forum permissions ...

Set it to "Yes", but it wouldn't retain the value .... :down:

Un-installed mod ...

Regards,
Doug

[sticky]

Hopefully someone makes one that works.

[HolyKiller]

THANKS !!!!! Working like a charm on vB 4.1.4.

Just don't forget to enable one disabled plugin. Just go to ACP -> Plugins & Products -> Plugin manager , and enable "Exclude Forums from What's New" (there are 4 , but one of them is disabled ... ENABLE it !)

Then simply edit permissions for forums ... :)

[ForumsMods]

v4.1
===
- Fixed Bug: Forums not being excluded from searches
- New Feature: Added Hide from FORUMHOME

[BadgerDog]

Ok, re-installed 4.1 for testing on 4.1.3 of vBulletin ....

I now see how individual users can exclude forums from being searched, but where does one do a setting that PREVENTS one (or more) specific forum(s) for ALL users to NOT be searched?

Regards,
Doug

[HolyKiller]

2 BadgerDog:

For specific usergroup:
ACP -> Forums & Moderators -> Forum Permissionst -> Edit permission for that usergroup in that forum where you want block search. And set: Can Search Forums - No

For specific sub-forum for all of the users
ACP -> Forums & Moderators -> Forum Manager -> Edit specific forum and set: Index New Posts in Search Engine - No
(Setting this to 'No' will prevent anyone from being able to search in this forum) and rebuild search indexes:

Maintenance -> Update Counters -> Rebuild Search Index
This will take some time! Depending how big your forum is. And i recommand to CLOSE forum before you start this !!! And, ofcourse, make a DB backup ;)

[BadgerDog]

2 BadgerDog:

For specific usergroup:
ACP -> Forums & Moderators -> Forum Permissionst -> Edit permission for that usergroup in that forum where you want block search. And set: Can Search Forums - No

For specific sub-forum for all of the users
ACP -> Forums & Moderators -> Forum Manager -> Edit specific forum and set: Index New Posts in Search Engine - No
(Setting this to 'No' will prevent anyone from being able to search in this forum) and rebuild search indexes:

Maintenance -> Update Counters -> Rebuild Search Index
This will take some time! Depending how big your forum is. And i recommand to CLOSE forum before you start this !!! And, ofcourse, make a DB backup ;)

Thank you ... :up:

Regards,
Doug

[HolyKiller]

New Feature: Added Hide from FORUMHOME

This is AMAZING! Users on my forum totally LOVE this feature. They finally can hide unneeded forums.

MOTM +1 :]

[BANDiT600]

Now it's working!

[rootsxrocks]

I thought this was working fine, however when I acually used it myself I discovered that when I go to the CMS Home tab it causes mass Chaos
using 4.18 with assorted new post widgets on the home page including most viewed post by friends and latest post.
vB_Legacy_Forum does not have a field 'title' on line 40 in

/home/host1/public_html/example/vb/legacy/dataobject.php
#0 /home/host1/public_html/example/vb/legacy/forum.php(60):

vB_Legacy_Dataobject->get_field('title')
#1 /home/host1/public_html/example/packages/vbforum/search/result/post.php(157):

vB_Legacy_Forum->get_field('title')
#2 /home/host1/public_html/example/packages/vbcms/widget/searchwidget.php(620):

vBForum_Search_Result_Post->render(Object(vB_Legacy_CurrentUser),

Object(vB_Search_Criteria), 'vbcms_searchres...')
#3 /home/host1/public_html/example/packages/vbcms/widget/searchwidget.php(356):

vBCms_Widget_Searchwidget->renderResult(Array, Array)
#4 /home/host1/public_html/example/packages/vbcms/controller/content.php(230):

vBCms_Widget_Searchwidget->getPageView()
#5 [internal function]: vBCms_Controller_Content->actionView()
#6 /home/host1/public_html/example/vb/controller.php(191): call_user_func_array(Array,

Array)
#7 /home/host1/public_html/example/packages/vbcms/route/content.php(97):

vB_Controller->getResponse()
#8 /home/host1/public_html/example/vb/router.php(251):

vBCms_Route_Content->getResponse()
#9 /home/host1/public_html/example/vb/bootstrap.php(58): vB_Router::getResponse()
#10 /home/host1/public_html/example/content.php(30): require_once('/home/host1/pu...')
#11 /home/host1/public_html/example/index.php(56): require('/home/host1/pu...')
#12 {main}


Fatal error: vB_Legacy_Forum does not have a field 'title' on line 40 in

[path]/vb/legacy/dataobject.php in [path]/vb/vb.php on line 287
#0 vb_error_handler(256, vB_Legacy_Forum does not have a field 'title' on line 40 in

/home/host1/public_html/example/vb/legacy/dataobject.php ,

/home/host1/public_html/example/vb/vb.php, 287, Array ([exception] => Exception Object ([] =>

vB_Legacy_Forum does not have a field 'title',[] => ,[] => 0,[] =>

/home/host1/public_html/example/vb/legacy/dataobject.php,[] => 40,[] => Array ([0] => Array

([file] => /home/host1/public_html/example/vb/legacy/forum.php,[line] => 60,[function] =>

get_field,[class] => vB_Legacy_Dataobject,[type] => ->,[args] => Array ([0] => title)),[1] => Array

([file] => /home/host1/public_html/example/packages/vbforum/search/result/post.php,[line] =>

157,[function] => get_field,[class] => vB_Legacy_Forum,[type] => ->,[args] => Array ([0] => title)),[2]

=> Array ([file] =>

/home/host1/public_html/example/packages/vbcms/widget/searchwidget.php,[line] =>

620,[function] => render,[class] => vBForum_Search_Result_Post,[type] => ->,[args] => Array ([0]

=> vB_Legacy_CurrentUser Object ([] => ,[] => ,[] => ,[] => vB_Registry Object ([datastore] =>

vB_Datastore Object ([defaultitems] => Array ([0] => options,[1] => bitfields,[2] =>

attachmentcache,[3] => forumcache,[4] => usergroupcache,[5] => stylecache,[6] =>

languagecache,[7] => products,[8] => pluginlist,[9] => cron,[10] => profilefield,[11] => loadcache,[12]

=> noticecache),[registry] => vB_Registry Object ( *RECURSION*,[dbobject] => vB_Database

Object ([functions] => Array ([connect] => mysql_connect,[pconnect] =>

mysql_pconnect,[select_db] => mysql_select_db,[query] => mysql_query,[query_unbuffered] =>

mysql_unbuffered_query,[fetch_row] => mysql_fetch_row,[fetch_array] =>

mysql_fetch_array,[fetch_field] => mysql_fetch_field,[free_result] => mysql_free_result,[data_seek]

=> mysql_data_seek,[error] => mysql_error,[errno] => mysql_errno,[affected_rows] =>

mysql_affected_rows,[num_rows] => mysql_num_rows,[num_fields] =>

mysql_num_fields,[field_name] => mysql_field_name,[insert_id] =>

mysql_insert_id,[escape_string] => mysql_escape_string,[real_escape_string] =>

mysql_real_escape_string,[close] => mysql_close,[client_encoding] =>

mysql_client_encoding,[ping] => mysql_ping),[registry] => vB_Registry Object (

*RECURSION*,[fetchtypes] => Array ([2] => 2,[1] => 1,[0] => 3),[appname] =>

vBulletin,[appshortname] => vBulletin,[database] => host1_firstforum,[connection_master] =>

Resource id #9,[connection_slave] => Resource id #9,[connection_recent] => Resource id

#9,[multiserver] => ,[shutdownqueries] => Array ([lastvisit] => UPDATE user SET lastactivity =

1322146912 WHERE userid = 1 ),[sql] => ,[reporterror] => 1,[error] => ,[errno] => 0,[maxpacket] =>

0,[locked] => ,[querycount] => 222),[prefix] => ,[checked_options] => 1),[input] => vB_Input_Cleaner

Object ([shortvars] => Array ([f] => forumid,[t] => threadid,[p] => postid,[u] => userid,[a] =>

announcementid,[c] => calendarid,[e] => eventid,[q] => query,[pp] => perpage,[page] =>

pagenumber,[sort] => sortfield,[order] => sortorder),[superglobal_lookup] => Array ([g] => _GET,[p]

=> _POST,[r] => _REQUEST,[c] => _COOKIE,[s] => _SERVER,[e] => _ENV,[f] => _FILES),[scriptpath]

=> ,[reloadurl] => ,[wolpath] => ,[url] => ,[ipaddress] => ,[alt_ip] => ,[registry] => vB_Registry Object (

*RECURSION*,[cleaned_vars] => Array ([vbulletin_collapse] => 7,[CC_referrerid] => 3,[CC_userid]

=> 3,[CC_password] => 7,[CC_lastvisit] => 3,[CC_lastactivity] => 3,[CC_threadedmode] =>

9,[CC_sessionhash] => 9,[CC_userstyleid] => 3,[CC_languageid] => 3,[CC_skipmobilestyle] =>

1,[s] => 9,[styleid] => 2,[langid] => 2,[api] => 0,[referrerid] => 3,[a] => 7,[nojs] => 1,[ajax] =>

1,[dofbredirect] => 1,[CC_cms_rate] => 7,[page] => 2,[pagenumber] => 3,[CC_thread_lastview] =>

7),[friendly_uri] => ),[db] => vB_Database Object ([functions] => Array ([connect] =>

mysql_connect,[pconnect] => mysql_pconnect,[select_db] => mysql_select_db,[query] =>

mysql_query,[query_unbuffered] => mysql_unbuffered_query,[fetch_row] =>

mysql_fetch_row,[fetch_array] => mysql_fetch_array,[fetch_field] =>

mysql_fetch_field,[free_result] => mysql_free_result,[data_seek] => mysql_data_seek,[error] =>

mysql_error,[errno] => mysql_errno,[affected_rows] => mysql_affected_rows,[num_rows] =>

mysql_num_rows,[num_fields] => mysql_num_fields,[field_name] => mysql_field_name,[insert_id]

=> mysql_insert_id,[escape_string] => mysql_escape_string,[real_escape_string] =>

mysql_real_escape_string,[close] => mysql_close,[client_encoding] =>

mysql_client_encoding,[ping] => mysql_ping),[registry] => vB_Registry Object (

*RECURSION*,[fetchtypes] => Array ([2] => 2,[1] => 1,[0] => 3),[appname] =>

vBulletin,[appshortname] => vBulletin,[database] => host1_firstforum,[connection_master] =>

Resource id #9,[connection_slave] => Resource id #9,[connection_recent] => Resource id

#9,[multiserver] => ,[shutdownqueries] => Array ([lastvisit] => UPDATE user SET lastactivity =

1322146912 WHERE userid = 1 ),[sql] => ,[reporterror] => 1,[error] => ,[errno] => 0,[maxpacket] =>

0,[locked] => ,[querycount] => 222),[userinfo] => Array ([userid] => 1,[temp] => ,[field1] => I have

done it all Humanitarian Architect Naturalist Sculptor, Oddities Collector Mathematician, Engineer

Botanist, Inventor Geologist, Dork Idealist Chef Kind Artist Noeticist Docimologist Bacon lover

Animal behaviorist, Lapidarist Libertarian Satyr,[field2] => Palm Coast, Florida, United

States,[field3] => Community cooperation,[field4] => Artist,[field6] => Jamie Abbott,[field7] =>

4167538,[subfolders] => ,[pmfolders] => ,[buddylist] => 3 4 5 7 8 9 10 11 12 14 15 16 17 20 22 23 24

25 28 29 31 32 34 35 36 40 44 45 46 49 53 54 57 60 63 71 74 75 80 84 92 94 95 96 97 106 110 111 113

117 118 119 129 130 140 141 147 150 151 155 158 161 163 186 206 218 221 251 279 289 302 343 398

414 517,[ignorelist] => ,[signature] => Get your facts first, then you can distort them as

you please.,[searchprefs] => a:1:{s:20:"cmsadmin_showperpage";i:200;},[rank] =>

,[excludeforums] => 4,[excludeforumhome] => 1,[usergroupid] => 6,[membergroupids] =>

14,[displaygroupid] => 6,[username] => ROOT,[password] =>

542hfgf92c0dd4d27f283a7a5761db271,[passworddate] => 1250222424,[email] =>

[hjmaier]

Thank you for that great AddOn!

I would like to have a larger box in the user control panel (I have over 200 forums). How can I make that box bigger?

[nit233]

This is AMAZING! Users on my forum totally LOVE this feature. They finally can hide unneeded forums.

MOTM +1 :]

How can you hide the unneeded forums from ForumsHome

[Alan_SP]

To hide, you need to go to usergroups and there you need to enable to selected usergroup(s) that they can exclude forums. After that, they can exclude them from searching in What's new and also, there's option that they could use and exclude it from forumhome too if they want it.

[Vcize]

Is there anything that does something similar for VB3?

[Deimos]

Thank you for that great AddOn!

I would like to have a larger box in the user control panel (I have over 200 forums). How can I make that box bigger?

Edit the exclude_whatsnew template

Change - <select class="primary" id="sel_excludewn" name="excludewn[]" multiple="multiple" tabindex="1" size="19">

The bit in bold :P

[Deimos]

Is there anything that does something similar for VB3?

Yes

https://vborg.vbsupport.ru/showthread.php?t=215001

[str8bourbon]

I installed this mod on one of my systems running VB 4.1.11, and it works flawlessy. However, no such luck with 4.2.0. There is no entry in the usergroup search permissions page, and clicking on "general settings" in the (any user) UserCP returns a server error.

Help! This mod is exactly what I need for my forum. I looked over the source, but I'm not familiar enough with the internal workings of VB 4.2 to even know where to start looking for the problem.

[str8bourbon]

I installed this mod on one of my systems running VB 4.1.11, and it works flawlessy. However, no such luck with 4.2.0. There is no entry in the usergroup search permissions page, and clicking on "general settings" in the (any user) UserCP returns a server error.

Help! This mod is exactly what I need for my forum. I looked over the source, but I'm not familiar enough with the internal workings of VB 4.2 to even know where to start looking for the problem.

Nevermind. I uninstalled the product, then re-installed and all seems to be well now. Works great, and it's just what I was after, thanks!

[sublo]

Maybe I'm just an idiot. But now that I've got this mod installed, how do I hide a particular forum from New/What's-New?

[viaccess]

A problem - I have this working on 4.2, at least so far as hiding forums from forum home is concerned. However, highlighting a forum in general settings to hide from the 'What's New' section doesn't want to work. The drop down box is there, and it's possible to highlight and save - but the latest posts from the selected forum remain.

[Elric]

Working not on my vb4.2 pl3, no forum exluded

[Elric]

I have the mod new installed ans now it works but not for the newest themes in the vbcmps portal, have anywhere a idea?

[craigvm]

how do i set it to exclude a forum from whats new for all users

[tehbasmentdwell]

Installed and working thanks :)

[HolyKiller]

I can confirm that the mod works fine on 4.2.2 PL1


Also following hack could be useful for someone who want to exclude some forums for new users by default :]

- If new registrations needs to be confirmed via email follow "A"
- If NO email confirmation is required to registration then follow "B"

A: Go to AdminCP -> Plugins & Products -> Plugin Manager and "[Add New Plugin]"
Product: vBulletin
Hook Location: register_addmember_complete
Title: <whatever you want>
Execution Order: 5
Plugin PHP Code:

1] For having the "Hide Forums from Forumhome" checked for all new registered users by default
if (!empty($_POST)){
if($vbulletin->options['verifyemail']){
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "usertextfield SET excludeforumhome = '1' WHERE userid = '".$userid."' LIMIT 1 ");
}
}

2] For excluding some forums from what's new by default
$forumhide = <list_of_the_forum_IDs>; //example: $forumhide = '487,496,503,504,647';
if (!empty($_POST)){
if($vbulletin->options['verifyemail']){
$vbulletin->input->clean_gpc('p', 'forumhide',TYPE_STR);
if ($forumhide == !NULL){
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "usertextfield SET excludeforums = '".$forumhide."' WHERE userid = '".$userid."' LIMIT 1 ");
}
}
}

3] For combination of BOTH of the things above (Exclude specific forums AND hide from forumhome by default)
$forumhide = <list_of_the_forum_IDs>; //example: $forumhide = '487,496,503,504,647';
if (!empty($_POST)){
if($vbulletin->options['verifyemail']){
$vbulletin->input->clean_gpc('p', 'forumhide',TYPE_STR);
if ($forumhide == !NULL){
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "usertextfield SET excludeforums = '".$forumhide."', excludeforumhome = '1' WHERE userid = '".$userid."' LIMIT 1 ");
}
}
}


B: Go to AdminCP -> Plugins & Products -> Plugin Manager and "[Add New Plugin]"
Product: vBulletin
Hook Location: register_addmember_process
Title: <whatever you want>
Execution Order: 5
Plugin PHP Code:

1] For having the "Hide Forums from Forumhome" checked for all new registered users by default
if (!empty($_POST)){
if(!$vbulletin->options['verifyemail']){
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "usertextfield SET excludeforumhome = '1' WHERE userid = '".$userid."' LIMIT 1 ");
}
}

2] For excluding some forums from what's new by default
$forumhide = <list_of_the_forum_IDs>; //example: $forumhide = '487,496,503,504,647';
if (!empty($_POST)){
if(!$vbulletin->options['verifyemail']){
$vbulletin->input->clean_gpc('p', 'forumhide',TYPE_STR);
if ($forumhide == !NULL){
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "usertextfield SET excludeforums = '".$forumhide."' WHERE userid = '".$userid."' LIMIT 1 ");
}
}
}

3] For combination of BOTH of the things above (Exclude specific forums AND hide from forumhome by default)
$forumhide = <list_of_the_forum_IDs>; //example: $forumhide = '487,496,503,504,647';
if (!empty($_POST)){
if(!$vbulletin->options['verifyemail']){
$vbulletin->input->clean_gpc('p', 'forumhide',TYPE_STR);
if ($forumhide == !NULL){
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "usertextfield SET excludeforums = '".$forumhide."', excludeforumhome = '1' WHERE userid = '".$userid."' LIMIT 1 ");
}
}
}