The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 09-19-2001

I updated the hack a little so it looks nice.

http://vbulletin.com/forum/showthrea...272#post173883

Credit To: ethank

Added:

Display order, so it orders the sub-forums the way they are listed in your admin CP.

Added an hr.

Thats it it!

if you watn the HR to look good add this into your
"Custom replacements"

hr is replaced by <hr size="1" color="{ tablebordercolor }"

{ tablebordercolor } - dont forget to remove the spaces "{ }

that is it!

Kengan · #52 11-28-2001, 11:06 PM

That is rocks hack !! thanks !

Princeton · #53 11-29-2001, 01:56 AM

Quote:

Originally posted by danielillo
Is there any way to show "Sub-Forums:" in RED and the Sub-forums in BOLD ?

Thanks and excuse my english (I put the colours to show you how I would like it to appear).

Look for this code ...

PHP Code:


			
$forum['description'] .= "<hr><B>Sub-Forums:</B> ";

and replace it with this:

PHP Code:


			
$forum['description'] .= "<hr><B><font color="#FE1B01">Sub-Forums:</font></B> ";

Princeton · #54 11-29-2001, 01:57 AM

This hack doesn't work with forums that are under moderation (posts have to be validated). Is there a fix to this somewhere?UPDATED: FIXED

george_proost · #55 12-02-2001, 07:33 PM

?0.02

I used the basis of the hack. Modified extremely... and works great. Does not generate many extra queries, and is damn fast.

Features added :
- Bold on new messages
- custom forum type
- variable number of columns to display per parents children

added 2 fields to forum table showas and numcols
this is the index.php version. For the forumdisplay.php
there is some stuff to comment out ( or in) dependeing on your requirements (sorts out spacing before and after subforum lists)

See it in action at www.mainframeforum.com

here is the code, I do not support it, have fun .....

PHP Code:


			
// ********************************************************************

// ADDED BY ERK 

// ********************************************************************

$subforums=$DB_site->query("select title,forumid,lastpost,replycount,threadcount,showas,numcols from forum where parentid = $forum[forumid] and active != 0 ORDER BY parentid,displayorder"); 

if ($DB_site->num_rows($subforums)>0) 

  { 

  $subs = "<smallfont><table width="100%" cellpadding="0" cellspacing="0" border="0" align="center" id="ltlink" ><tr valign="top"> "; 



  $num_cols  = $forum[numcols];

  $col_width = floor(100/$num_cols);  

  $num_rows  = ceil($DB_site->num_rows($subforums)/$num_cols);

  $cur_col   = 0;

  $cur_row   = 1;



  while ($forum_child=$DB_site->fetch_array($subforums)) 

    { 

    $permission=$DB_site->query_first("select accessmask from access where userid = $bbuserinfo[userid] AND forumid = $forum_child[forumid]"); 

    if ($permission['accessmask'] != 0 || $permission['accessmask'] == null) 

      { 

      // ------------------------------

      // check new messages in subforum

      // and set 'bolding' attributes

      // ------------------------------

        $bold_on = "";

        $bold_off = ""; 

        if ($bbuserinfo['lastvisitdate']=='Never') {

          $bold_on = "<b>";

          $bold_off = "</b>";

         } else {

           if (isset($bbforumview[$forum_child['forumid']]) and $bbforumview[$forum_child['forumid']]>$bbuserinfo['lastvisit']) {                $userlastvisit=$bbforumview[$forum_child['forumid']];

            } else {

                $userlastvisit=$bbuserinfo['lastvisit'];

            }

        if ($userlastvisit<$forum_child['lastpost']) {

          $bold_on = "<b>";

          $bold_off = "</b>";

        } else {

          $bold_on = "";

          $bold_off = "";

        }

      }



    if ($cur_row == 1)

        {

        $subs.="<td width="$col_width%">";

    

        $cur_col++;

        }

    $subs.="<table cellspacing="0" cellpadding="1" border="0" width="100%"><tr valign="top" ><td nowrap><font class="sf">- </td><td width="100%">";

    $subs.="<a href="$bburl/f$forum_child[forumid]/s">";

    $child_text = "$bold_on$forum_child[title]$bold_off&nbsp;"; 



    // switch on showas

    switch ($forum_child[showas])

    {

    //  FULL AFFILIATES 

    case "AFF":

      $subs.="<font class="sf" color="darkblue">$child_text</font></a><img src="$bburl/images/star.gif">";  

      break;

    case "AFF_AS":

      $subs.="<font class="sf" color="white">$child_text</font></a><img src="$bburl/images/star.gif">";  

      break;

    //  VENDOR MODERATED

    case "VEN":

        $subs.="<font class="sf" color="black">$child_text</font></a><img src="$bburl/images/posticonnew.gif">";

      break;  

    //  CONTRIBUTOR MODERATED

    case "CON":

      $subs.="<font class="sf" color="darkgreen">$child_text</font></a><img src="$bburl/images/paperclip.gif">";   

      break;

    //  USENET FORUM ENTRIES

    case "USE":

      $subs.="<font class="sf" color="brown">$child_text</font></a><img src="$bburl/images/posticon.gif">";

      break;

    //  MEMBER MODERATED

    case "MEM":

      $subs.="<font class="sf" color="darkorange">$child_text</font></a>";  

      break;

    //  HIDDEN 

    case "LOW":

      $subs.="<font class="sf" color="#999999">$child_text</font></a>"; 

      break;

    //  DEFAULT

    default:

      // ------------------------------- 

      // set entry to italic if no posts

      // -------------------------------

      // if ($forum_child[threadcount] == 0 ){

      //   $subs.="<font class="sf" color="black"><i>$child_text</i></font></a>";  

      // } else {

        $subs.="<font class="sf" color="black">$child_text</font></a>"; 

      // }      

      break; 

    } // end switch



    // ---------------------

    // tag on the replycount

    // ---------------------

    // if ($forum_child[threadcount] > 0 ){

    //  $subs.="<font class="sf" color="#999999">&nbsp;&nbsp;<i>Posts($forum_child[replycount])</i></font>";

    // }



    // ---------------------------------------

    // check if i need to go to new column yet

    // ---------------------------------------

    if ($cur_row == $num_rows) { 

      $cur_row=1; $subs.= "</td></tr></table></td>";

      }

    else {

      $cur_row++; 

      $subs.="</td></tr></table>";

      }

    

  } // end-if 

}  // end-while



  // -------------------------------------  

  // close off the remaining empty columns

  // and finish off the table etc..

  // -------------------------------------

  $todo_cols = $num_cols - $cur_col;

  while ($todo_cols != 0)

  {

    $subs.="<td width="$col_width%"></td>" ;

    $todo_cols--;

  }

  $subs.="</tr></table></smallfont>";

  

  if ($forum['description'] != '') {

    $forum['description'].= "<br><br>$subs<br>";                

    }

  else {

    $forum['description'].= "<br>$subs";                  // used in index.php

    // $forum['description'].= "<br>$subs<br>";                 // used in forumdisplay.php

    }



  $subs=null;

} // end-if

else {

  

 if ($forum['description'] != '') {

  //  $forum['description'].= "<br><br>";                     // used in forumdisplay.php 

 } 

  else  {

  // $forum['description'].= "<br>";                     // used in forumdisplay.php 

  }



}



$DB_site->free_result($subforums); 

$forum_child=null;

 

// ********************************************************************

// END ADDED

// ********************************************************************

DarkReaper · #56 12-03-2001, 03:25 AM

I just want to show the forums that have subforums, but no posts themselves, and therefore don't show up as anything but the name of the ategory on the main index page....I want to have the reply count and post count for those shown on the main forum page like other normal forums are. How can I do this the best way, with the fewest queries?

xgamer · #57 12-05-2001, 03:04 PM

cool hack and is very easy to install

philphee · #58 12-06-2001, 05:00 AM

Works like a charm, thx for the great hack!

RobAC · #59 12-08-2001, 07:33 PM

Is there a way to exclude certain subforums from showing up such as private forums?

ixian · #60 12-13-2001, 09:03 PM

Nice hack! I have it working at my site.

Question - Currently, I can't get subforums to show up under CATAGORIES, only other forums. To get around this, I made my Catagories forums, then locked them for new posts so no one would post in them. This works fine, however, that also makes the "Locked" icon appear next to them.

Any way to change the locked icon to active/inactive again even if the main forum is locked but the subforums are not? I've had several users complain that they used to pay attention to the active/inactive icons (never knew that, I don't, but hey).

Sven · #61 01-16-2002, 08:22 PM

Very nice hack

But I think there's a little glitch if a subforum has subforums.
The subforums of subforum are displayed this way

subforum
subforums: x, y
x
y

Is there a way to prevent it?

See attachment:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04871 seconds Memory Usage 2,369KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_imicons pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!