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!

[sbryan]

im using JamesUS's SQL query tool and when i run the query mentioned above i get this

"Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: ALTER TABLE forum ADD showonhome SMALLINT(6) DEFAULT '1' not null AFTER allowicons
mysql error: Duplicate column name 'showonhome'

mysql error number: 1060"

can anyone help? im really keen to install this hack...

[ImportPassion]

looks like u alredy have the hack, or tried to run that query twice