exclude a forum from "Todays active Threads"

[heynurse]

Is there a way to remove a public forum from Todays Active Threads"

For example I have an "Off-topic" or "Chit Chat" forum, that is getting several post per day, but I really don't want to have it take up half of the Todays Active topics results since the topics are irrelevant our sites Niche?

Hope this makes sense. Thanks for any advice.

[Logician]

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=40164" target="_blank">https://vborg.vbsupport.ru/showt...threadid=40164</a>

[heynurse]

Logician,

Thanks for the link, I think it is the answer to my question

[heynurse]

I followed the link in post #2 and I followed the instructions and it did not work, the forum I did not want included in results, remained in the results.

any other suggestions? Thanks

[Logician]

try to apply Post 2 AND Post 7

[heynurse]

Originally posted by Logician
try to apply Post 2 AND Post 7

I did apply both post #2 and #7, but the results are unchanged?

Here are the snippets from my search.php file that I am using:

PHP Code:

// ###################### Start get new #######################
if ($action=="getnew") {
  // generate query
  // do it!
  if ($bbuserinfo[userid]!=0 or $bbuserinfo[lastvisit]!=0) {
    $forumsql=getallforumsql();

        if (isset($forumid)) {
            $forums=$DB_site->query("SELECT forumid FROM forum WHERE INSTR(CONCAT(',',parentlist,','),',".addslashes($forumid).",')>0");
            $forumsql.=" AND forumid IN (0";
            while ($forum=$DB_site->fetch_array($forums)) {
                
                if ($forum[forumid]!=98) {$forumsql.=",$forum[forumid]";}
            }
            $forumsql.=") ";
        } 


and

PHP Code:

// ###################### Start get daily #######################
if ($action=="getdaily") {
  // get allowable forums:
  $forumsql=getallforumsql();

    if (isset($forumid)) {
        $forums=$DB_site->query("SELECT forumid FROM forum WHERE INSTR(CONCAT(',',parentlist,','),',".addslashes($forumid).",')>0");
        $forumsql.=" AND forumid IN (0";
        while ($forum=$DB_site->fetch_array($forums)) {
            if ($forum[forumid]!=98) {$forumsql.=",$forum[forumid]";}
        }
        $forumsql.=") ";
    } 


I hope this helps, thanks again with your help.

[Logician]

ok lets try this:

First revert the changes you made in the code and instead of this find the line: (in search.php)

PHP Code:

 $wheresql.=" AND thread.open<>10"; 


and replace it as:

PHP Code:

 $wheresql.=" AND thread.open<>10 AND thread.forumid!=X"; 


There are 2 instances, one is for members, the other is for guest. If you want to exclude the forum for both of them, change the both lines.

Dont forget to replace X with your excluded forumid.

I guess this will do the trick now..

[heynurse]

Logician,

That worked like a charm! Thanks a million.

Now, one more quick question, I do have one other forum, I would like to exclude, how would I go about excluding two or more fourms?

I tried putting in the two forums(98,112) separated by a comma, but that didn't work, I got an error message.

PHP Code:

$wheresql.=" AND thread.open<>10 AND thread.forumid!=98,112"; 


any ideas? Thanks again!

[Logician]

PHP Code:

$wheresql.=" AND thread.open<>10 AND thread.forumid!=98 AND thread.forumid!=112"; 


Enjoy

[heynurse]

Logician,

Thanks, you rock, worked like a charm.