Opt-Out Forums from Get New/Get Daily

Description
This Hack allows the Users to select certain Forums they do not want to appear on Get New/Get Daily.
It includes a new Permission, so you can specify which Usergroups can use this feature, which Forums
can't be excluded, etc.

Details
1 Product XML with 3 Plugins, 4 Phrases and 1 SQL Query
1 Bitfield XML
1 Template Edit

History
1.0.0 Initial Version
1.0.1 Added Option "None" for users who don't know about their CTRL Key
1.0.2 Updated for RC1
Note: This Hack does only work for vBulletin 3.5.0 RC1 and up!
1.0.3 Fixed a small Typo and a possible Problem with Forums that contain HTML in Title

Please only click Install if you actually have installed/are using this Hack, and click Uninstall when you don't use it any longer!

This Hack is unsupported! All support requests except proven bugs will be ignored

[dsotmoon]

Originally Posted by KirbyDE

ACP / Plugin System / Plugin Manager
Locate the Plugin on Hook search_getnew_start for this Hack, click edit.

sometimes i need a picture thanks again Kirby , got it now, worked perfect

[offline]

Originally Posted by KirbyDE

Yes.
register_addmember_process

PHP Code:

$userdata->set('excludeforumsgnp', 'X'); 


Thanks! One more quick question, can the user turn the forum back on themselves?

[Andreas]

Yes they can.

[offline]

you are awesome! Thanks!

[scottct1]

Any chance you can update this hack so that when users turn off the forums they dont want from the new posts search the forums are also no longer displayed in forumhome and the quick jumps?

[Andreas]

No. This is not a feature I find useful therefore it will not make it into this Hack which is only meant for Get New Posts/Get Daily.
Sorry

[Karri]

Is it possible to add a check box next to the forum names instead of just highlighting the ones you do not want to appear? I have a ton of boards on my site and a few users are having trouble selecting the ones they want on and off with just highlight them. If they had a check box they wouldn't have to hold down shift or ctrl and could easily scroll through the list.

Thanks!!!

[Andreas]

The listbox works the same way the listbox for Search does, therefore i'll keep it this way.
Standardized Controls = more usability.

[weaver]

Originally Posted by KirbyDE

Yes.
register_addmember_process

PHP Code:

$userdata->set('excludeforumsgnp', 'X'); 


Is that a template name? I don't see this.

ETA: I've tried choosing "None" but it's still excluding me from my RSS feed forum. There are new threads within that forum that should be showing up for me now.

[dieselpowered]

Originally Posted by KirbyDE

*** Untested ***

To make this work with the welcome module of CMPS:

In welcomeblock.php
FIND

PHP Code:

$getnewposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post WHERE dateline >= " . $vbulletin->userinfo['lastvisit']); 


REPLACE that with

PHP Code:

$getnewposts = $db->query_first("
    SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid=post.threadid)
    WHERE post.dateline >= " . $vbulletin->userinfo['lastvisit'] . "
        AND thread.forumid NOT IN (0," . $vbulletin->userinfo['excludeforumsgnp'] . ")
"); 


(The query might need some optimization though)

Ya that did not work my friend:

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT COUNT(*) AS count FROM vb3_post
LEFT JOIN vb3_thread AS thread ON (thread.threadid=post.threadid)
WHERE post.dateline >= 1128974249
AND thread.forumid NOT IN (0,);

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 ')' at line 4
Error Number : 1064
Date : Monday, October 10th 2005 @ 04:44:28 PM
Script : http://www.weapondepot.com/
Referrer :
IP Address : XXX.XX.XX.XX
Username : XXXXXXXX
Classname : vb_database