[kastle]

For those who are interested in catagory counts, this might help some...

1. Edit your vB Links Directory Templates > drkslinks_catbit file as such (for example) -- I've added a [$linkcounted] to mine, more on what it is ....

PHP Code:

<tr valign="top">
<td bgcolor="#F1F1F1"><normalfont><b><a href="links.php?action=viewlinks&catid=$catid">$catname</a></b> [$linkcounted] </smallfont></normalfont></td>
<td bgcolor="#DFDFDF"><normalfont>$catdesc</normalfont></td>
</tr> 


2. In the links.php, change

PHP Code:

// #################### Links Home ####################
if ($action=="main") {
$ebg = $DB_site->query("SELECT * FROM gportal_weblinkscat ORDER BY catname");
if ($DB_site->num_rows($ebg)) {
  while ($myrow=$DB_site->fetch_array($ebg)) {
            $hasattach=1;
            $catid=$myrow["webcatid"];
            $catname=$myrow["catname"];
            $catdesc=$myrow["catdesc"];
                        eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
  }
}
eval("dooutput(\"".gettemplate('drkslinks_main')."\");");
} 


TO

PHP Code:

// #################### Links Home ####################
if ($action=="main") {
$ebg = $DB_site->query("SELECT * FROM gportal_weblinkscat ORDER BY catname");
if ($DB_site->num_rows($ebg)) {
  while ($myrow=$DB_site->fetch_array($ebg)) {
            $hasattach=1;
            $catid=$myrow["webcatid"];
            $catname=$myrow["catname"];
            $catdesc=$myrow["catdesc"];
            $linkcount=$DB_site->query_first("select count(*) 
                        as linkcounted from `gportal_weblinkslink` 
                        where catagoryid=$catid[webcatid]");
            $linkcounted=$linkcount[linkcounted];                        
                        eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
  }
}
eval("dooutput(\"".gettemplate('drkslinks_main')."\");");
}