Version: 1.1.0, by akanevsky
Developer Last Online: Feb 2016
Version: 3.5.x
Rating:
Released: 10-13-2005
Last Update: 05-30-2009
Installs: 131
DB Changes Uses Plugins Auto-Templates
Translations
No support by the author.
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.
I still cannot get this to work. The problem is with guests, who get the database error:
Code:
<!--
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,67,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
-->
Selective Forum Filter Details »»
About Developer
DB Changes 
No support by the author.
04-13-2006, 02:17 PM
The problem is with guests, who get the database error: 
