how do I show the number of item in each entry in main menu ?

kixvn · 07.04.2004, 15:05

I asked around and come out with this solution to automatically expand all the submenu in mainmenu,

"In modules/mod_mainmenu.class.php Comment out line 195 and line 197 so that it looks like this:
195: // if (in_array( $row->id, $open )) { 197: // }"

now I wonder how can I do to show the number of items in each sub-menu (if they point to a category)

thanks

stingrey · 07.04.2004, 21:06

You'd need to edit the same file.

I've included this functionality in my soon to be released Display Sections & Display Categories modules (look out for an announcement in the Development Announcements forum in the next week).

If you want I can post the code I used.
Though I'm not sure if it will work exactly off the bat for you (but it may give you a start point)

kixvn · 08.04.2004, 09:32

hi there, can you post your code, it may not work but still I want to try
thanks

kixvn · 12.04.2004, 14:24

hi.
can you post your code ? I can't wait until it's announced

thanks

stingrey · 12.04.2004, 20:29

Opps sorry, forgot about this...I read way too many posts

Warning this is part of more extensive code, i'm not sure if it will make sense on its own:

Will probably require some massaging.

Generates info:

Code:

 /**---------------------------------------------------------------------**/
  	// Count # of Categories for the Section 
  	if (($show_categories == "y") || ($show_categories_count == "y")) {
  		$query = "SELECT a.title, a.name, a.id, a.section"
  		. "\n  FROM #__categories AS a"
  		. "\n  LEFT JOIN #__sections AS b ON a.section = b.id"
  		. "\n  WHERE a.section = $row->id"
  		. "\n $access";
  		$database->setQuery($query);
  		$cats = $database->loadObjectList();
  		$cats_count = count($cats);
  	}	//---------------------------------------------------------------

THen place this where you want the number to appear:

Code:

echo "<span class='ds-categories_count'>(".$cats_count.")</span>";

kixvn · 12.04.2004, 20:55

uh oh ..

Quote:

// Count # of Categories for the Section

does that mean that piece would show the number of categories in a section ?

in my case, I want to show the number of items in each categories in one section

so may be I should $cats to something else in this line, rite ?

$cats_count = count($cats);

waiting for ur answer, also, trying .. ^-^

stingrey · 12.04.2004, 21:21

Having looked at my code again, I'm thinking it may be difficult for you to use in your particular case.

Anyway heres the code:

Code:

 /**---------------------------------------------------------------------**/
 // Count # of Items for a Category
 if ($show_items_count == "y") {
 	$query = "SELECT a.catid"
 	. "\n  FROM #__content AS a"
 	. "\n  LEFT JOIN #__categories AS b ON a.catid = b.id"
 	. "\n  WHERE a.catid = $row->id";
 	$database->setQuery($query);
 	$items = $database->loadObjectList();
 	$items_count = count($items);
 }	//---------------------------------------------------------------------

The thing is the $row->id needs to be the id of the category you wish to have the items counted for. Problem is I have no idea how your capturing this in your case and to be honest I'm doing too many things already that I don't have the time to try help out further with your code

Anyway good luck with it