[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

[Lee]

the 2 template edits are identical - am I missing something?

[DRJ]

Copy/Paste error. I fixed it now. Thanks

[Lee]

I have installed the hack as shown (without the 2nd template edit possibly) and here it is http://www.cruiselineforums.com/foru...sereviews.php?

It shows some () without numbers. Is this because I don't have the 2nd template edit done?

Thanks!

[Lee]

Okay, now I have () on all categories and subs, but no numbers. Will this just pull in newly submitted articles?

[Lee]

it is working now - thanks!

*clicks install*

would be good to be added to the next release instead of a hack... good work, i like precise counts!

[DRJ]

Glad you got it working speedpro

Thanks nexialys

[kall]

Da.

Gut!

I suggested this waaay back. Good stuff mr (mrs?) DRJ.

[Viks]

very cool