[Russ_T]

Hi,

This hack is very useful thank you, can be viewed at


Anyway I made a little mod, I don't know how this will be affected by the update.

Original code

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')." \");");
}

Modified code

if ($action=="main") {
$ebg = $DB_site->query("SELECT a.webcatid, a.catname, a.catdesc, COUNT(b.categoryid) AS catcount FROM gportal_weblinkscat a LEFT OUTER JOIN $gportal_weblinkslink b ON a.webcatid = b.categoryid GROUP BY a.webcatid, a.catname, a.catdesc ORDER BY a.catname ASC;");
if ($DB_site->num_rows($ebg)) {
while ($myrow=$DB_site->fetch_array($ebg)) {
$hasattach=1;
$catid=$myrow["webcatid"];
$catname=$myrow["catname"];
$catdesc=$myrow["catdesc"];
$catcount=$myrow[catcount];
eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
}
}
eval("dooutput(\"".gettemplate('drkslinks_main')." \");");
}

Basically I can now count the number of items in each category so if you see I get a total links in category.

If you haven't already done this thought it would make a nice addition, can you let me know if your db update php will affect my mod please?

Regards

Russ