Child Cat Count - ExpressionEngine Plugin

child-cat-count-ee

<?php

if ( ! defined('BASEPATH')) exit('No direct script access allowed');

$plugin_info = array(
  'pi_name' => 'Child Category Count',
  'pi_version' =>'1.0',
  'pi_author' =>'Zac Gordon',
  'pi_author_url' => 'http://www.wideskyweb.com/expressionengine',
  'pi_description' => 'Returns number of child categories.',
  'pi_usage' => Childcatcount::usage()
  );


class Childcatcount {

	var $return_data = '';

	function Childcatcount()
	{
		$this->EE =& get_instance(); 

		//Get parameters
    	$cat_url_title = $this->EE->TMPL->fetch_param('cat_url_title');		
    	$group_id = $this->EE->TMPL->fetch_param('group_id');
		$count = 0;
		
		//Database query
		$this->EE->db->select('cat_id');
		$this->EE->db->where('cat_url_title', $cat_url_title);
		$this->EE->db->where('group_id', $group_id);		
		$query = $this->EE->db->get('exp_categories');				
		foreach ($query->result() as $row)
		{
		   $cat_id = $row->cat_id;
		}		
		$query->free_result();
				
		$this->EE->db->select('cat_name');
		$this->EE->db->where('parent_id', $cat_id);
		$query = $this->EE->db->get('exp_categories');
		$count = $this->return_data = $query->num_rows();
		
		$this->return_data = $count;		
	}

	  function usage()
	  {
	  ob_start(); 
	  ?>
		Description:

		Returns the number of child categories for a category.

		------------------------------------------------------
		
		Example:


		{exp:childcatcount group_id="1" cat_url_title="{segment_2}"}

		Returns
		3

		------------------------------------------------------
		
		Parameters:

		cat_url_title="{segment_2}"
		The url title for the category you want to check for child categories.  REQUIRED

		group_id = "1"
		The category group for the category you want to check.  REQUIRED
		

	  <?php
	  $buffer = ob_get_contents();

	  ob_end_clean(); 

	  return $buffer;
	  }
	  // END

	}


/* End of file pi.childcatcount.php */ 
/* Location: ./system/expressionengine/third_party/plugin_name/pi.childcatcount.php */