Options for forums - display or don't display on forum home

This hack adds a yes/no option for forums, to select whether you want to display that forum (or category) on the main page.
I added a "sanity check", so you can't hide forums that have no parent (because then you won't be able to access any of its sub-forums).
I'll get a demo in a few minutes.

Demo::
https://vborg.vbsupport.ru/attachmen...&postid=172718

Installation::
Run this query:

ALTER TABLE forum ADD showonhome SMALLINT(6) DEFAULT '1' not null AFTER allowicons

In forum.php (admin folder) replace

PHP Code:

  makeyesnocode("Count posts made in this forum towards user post counts?","countposts",1); 


with

PHP Code:

  makeyesnocode("Count posts made in this forum towards user post counts?","countposts",1);

  maketableheader("Other Options");

  makeyesnocode("Display this forum on main page","showonhome",1); 


Still in forum.php, replace

PHP Code:

  makeyesnocode("Count posts made in this forum towards user post counts?","countposts",$forum[countposts]); 


with

PHP Code:

  makeyesnocode("Count posts made in this forum towards user post counts?","countposts",$forum[countposts]);

  maketableheader("Other Options");

  makeyesnocode("Display this forum on main page","showonhome",$forum[showonhome]); 


Still in forum.php, replace

PHP Code:

                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons, 


with

PHP Code:

                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,showonhome, 


Still in forum.php, replace

PHP Code:

                       '$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons', 


with

PHP Code:

                       '$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons','$showonhome', 


Still in forum.php, replace

PHP Code:

                     allowimages='$aallowimgcode', allowsmilies='$aallowsmilies', allowicons='$aallowicons', 


with

PHP Code:

                     allowimages='$aallowimgcode', allowsmilies='$aallowsmilies', allowicons='$aallowicons', showonhome='$showonhome', 


Still in forum.php, replace

PHP Code:

  // SANITY CHECK (prevent invalid nesting)
  if ($parentid==$forumid) {
      echo "<b>ERROR:</b> You can't parent a forum to itself!<br><br>".makelinkcode("Go back","javascript:history.back(1)");
    exit;
  }
  $foruminfo = $DB_site->query_first("SELECT forumid,title,parentlist FROM forum WHERE forumid='$parentid'");
  $parents = explode(",", $foruminfo[parentlist]);
  while (list(,$val) = each($parents)) {
    if ($val==$forumid) {
      echo "<b>ERROR:</b> You can't parent a forum to one of its own children!<br><br>".makelinkcode("Go back","javascript:history.back(1)");
      exit;
    }
  }
  // end Sanity check 


with

PHP Code:

  // SANITY CHECK (prevent invalid nesting)
  if ($parentid==$forumid) {
      echo "<b>ERROR:</b> You can't parent a forum to itself!<br><br>".makelinkcode("Go back","javascript:history.back(1)");
    exit;
  }
  $foruminfo = $DB_site->query_first("SELECT forumid,title,parentlist FROM forum WHERE forumid='$parentid'");
  $parents = explode(",", $foruminfo[parentlist]);
  while (list(,$val) = each($parents)) {
    if ($val==$forumid) {
      echo "<b>ERROR:</b> You can't parent a forum to one of its own children!<br><br>".makelinkcode("Go back","javascript:history.back(1)");
      exit;
    }
  }
  if ($parentid==-1 and $showonhome==0) {
      echo "<b>ERROR:</b> You can't hide a forum with no parent!<br><br>".makelinkcode("Go back","javascript:history.back(1)");
    exit;
  }
  // end Sanity check 


We don'e with forum.php, save and upload.

In index.php (main folder) replace

PHP Code:

$forums=$DB_site->query('SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder'); 


with

PHP Code:

$forums=$DB_site->query('SELECT * FROM forum WHERE displayorder<>0 AND showonhome=1 AND active=1 ORDER BY parentid,displayorder'); 


We don'e with index.php, save and upload.

That's it!

[eva2000]

nice i like this one

okay for 2.2.0 and 2.2.1 ?

[Admin]

Should work fine.

[high]* FireFly is embarrassed [/high]

[over]

nice hack thinkin bout installin it

[Jawelin]

Originally posted by Jawelin
Very nice...
Just something about 'sanity check'...

If I had some private forums within a category, can it be hidden by this hack if none of the subforums is visible to the logged user ?

Thank you very much
Bye

Just a remark...

[Stretchr]

Thank you, Chen for another great hack. Just what I have been looking for.

[TurboFC3S]

Does this work in sub-forums also? Or does it just let you turn off forums on the main page?

[Shenlong]

can u add a installer or something? im not good with queries or SQL tables

[Admin]

Nope, only on main forum page.

[Stretchr]

The good news is that you don't have to be proficient with mySQL queries if you use FireFly's hack here: https://vborg.vbsupport.ru/showthrea...threadid=26272

Couldn't be simpler than this! Thanks again, Chen. This is one of my all-time favorites!

[TurboFC3S]

So are there any hacks similar to this that allow you to do sub-forums as well? How about instead of show on forum home, give the option - show on parent page.

Does that make any sense what I'm talking about?