[Addon] cinq's vbArticles Hack v2.0 - Show number of articles per category

A small addon to show the number of articles in each category.
This addon is for cinq's vbArticles Hack v2.0

Hack version 1.0

Files to edit: 1
articles.php

Templates to edit: 2
vbArticles_categorybit
vbArticles_childcatbit

Install instructions
===========================================

File Edits

articles.php

Find

PHP Code:

$catlistbit='';
if(!empty($cat_cache))
{
foreach ($cat_cache[0] AS $parentcatrow)
{
         $parentid = $parentcatrow["articles_categoryid"];
         $catname = $parentcatrow["categoryname"];
         $parentcat = $parentcatrow["parentcategory"]; 


Replace with

PHP Code:

$catlistbit='';
if(!empty($cat_cache))
{
foreach ($cat_cache[0] AS $parentcatrow)
{
         $parentid = $parentcatrow["articles_categoryid"];
         $catname = $parentcatrow["categoryname"];
         $parentcat = $parentcatrow["parentcategory"];
                $cattotal = 0;
$catcount = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "articles_article
WHERE categoryid =$parentid 
AND usersubmitted=0
And draft = 0
");
$cattotal = $DB_site->num_rows($catcount); 


Find

PHP Code:

         if(!empty($cat_cache[$parentid]))
{
         foreach ($cat_cache[$parentid] AS $subcatrow)
         {
             $subcatid=$subcatrow["articles_categoryid"];
             $subcatname=$subcatrow["categoryname"]; 


Replace with

PHP Code:

         if(!empty($cat_cache[$parentid]))
{
         foreach ($cat_cache[$parentid] AS $subcatrow)
         {
             $subcatid=$subcatrow["articles_categoryid"];
             $subcatname=$subcatrow["categoryname"];
$cattotal = 0;
$catcount = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "articles_article
WHERE categoryid =$subcatid
AND usersubmitted=0
And draft = 0
");
$cattotal = $DB_site->num_rows($catcount); 


End File Edits

Template Edits

vbArticles_categorybit

Replace existing code with this

PHP Code:

<if condition="$parentcat==0"><br>
<a href="articles.php?action=viewcat&catid=$parentid"><span class="smallfont"><b>$catname</b></a> ($cattotal)</span>
</if> 


vbArticles_childcatbit


Replace existing code with this

PHP Code:

<li><span class="smallfont"><a href="articles.php?action=viewcat&catid=$subcatid">$subcatname</a> ($cattotal)</span></li> 


End Template Edits

You can see a demo of this mod here: http://www.vbaexpress.com/forum/articles.php

[DRJ]

Updated: It was updating the category totals for all articles in the category even if they were not approved yet. So we need an extra condition:

WHERE categoryid =$subcatid
AND usersubmitted=0

First post has the updated code.

[Kohhal]

Nice addon installed.

Though, it seems to be including draft articles which are not publically available yet, bug?

[DRJ]

We can add another condition to take care of that.

And draft = 0

Top post updated.

Thanks

[Kohhal]

Updated, nice one