[Geoserv]

This mod will list counts in your categories.tpl file that shows in ytour sidebar.

I have ONLY tested this in 9.8.2

Find in libs/dbtree.php:

$row = $db->get_row($sql);
if(!$row){
die('There is a problem with the categories table. Error CA:001.');
}

}

after, add:

$catcount = $db->get_results("SELECT COUNT(l.link_category) as catcount, c.category_id FROM pligg_categories c LEFT JOIN pligg_links l ON c.category_id = l.link_category GROUP BY c.category_id"); # query to count the link_category

find,

foreach($result as $row){
if (count($right)>0) {
// check if we should remove a node from the stack
while ($right[count($right)-1]<$row->rgt) {
if (array_pop($right) == NULL) {
break; // We've reached the top of the category chain
}
}
}

after, add

foreach ($catcount as $v) # loop through the result and find the id that matches, if found then this is the associated category count
{
if ($v->category_id == $row->category__auto_id) { # found it, store it and break
$array[$i]['catcount'] = $v->catcount;

break;
}

in templates/yget/sidebar_modules/categories.tpl

find and add the parts in red:

{if $pagename eq "published"}
<strong><a style="padding-bottom:5px;" href="{$URL_maincategory, $cat_array[thecat].safename}" style="padding-bottom:5px;">{$cat_array[thecat].name}</a>{if $cat_array[thecat].parent neq 0} ({$cat_array[thecat].catcount}) {/if}</strong><br />
{else}
<strong><a style="padding-bottom:5px;" href="{$URL_queuedcategory, $cat_array[thecat].safename}" style="padding-bottom:5px;">{$cat_array[thecat].name}</a>{if $cat_array[thecat].parent neq 0} ({$cat_array[thecat].catcount}) {/if}</strong><br />
{/if}

go to libs/smartyvariables and add:

// show count of category
#$catcount = $db->get_results('SELECT COUNT(l.link_category) as catcount, c.category_id FROM pligg_categories c LEFT JOIN pligg_links l ON c.category_id = l.link_category GROUP BY c.category_id'); 
#$catcount = $db->get_var('SELECT a1.Link_Category , b1.Category_Name , count( * ) TotPerCategory ' . ' from pligg_links a1 , pligg_categories        b1 ' . ' where a1.Link_Category = b1.Category_ID ' . ' group by a1.Link_Category , b1.Category_Name ' . ' order by b1.Category_Name; '); 

#$main_smarty->assign('catcount', $catcount);

Thats it.

Any issues post them here.

Geoserv.

Backup all files prior to applying this additions. I guarantee nothing and you are applying at your own risk.

[bbrian017]

Have a demo of this Geoserv, also will it list total article count per category for both upcoming and published?

[Geoserv]

A demo is located at News Dots / Published Dots

It shows the count for published and unpublished. But if you are in published, only published ones will be shown, and if you are in unpublished, only unpublished ones will be shown.

Geoserv.

[DJ2FiNE]

can please someone code it for 9.90 ?? i relly need this!

[akvberlin]

Originally Posted by DJ2FiNE

can please someone code it for 9.90 ?? i relly need this!

Please !!!

[xiesi]

Parse error: syntax error, unexpected $end in E:\wwwroot\qelele\wwwroot\libs\dbtree.php on line 253

[Geoserv]

What version of Pligg?

Geoserv.

[xiesi]

pligg 9.9.0

[bbrian017]

I'm getting the following error when installing this mod!

Parse error: parse error, unexpected $ in /home/content/b/b/r/bbrian017/html/blogengage/libs/dbtree.php on line 253

Maybe I have done something wrong?

Line 253 is the following,

?>

I got the templates part to site right But it's only counting the sub categories it seems!

I'm running 9.8.2 and I trust your work so I must be doing something incorrectly.

[Geoserv]

Sounds like you missed part of the code.

Geoserv.