<?php

class ForumCategory extends ModuleHelper implements ModuleInterface 
{


	protected $columns 		= array('id','name','description','order');
	protected $table			= 'forum_categories';
	protected $primaryKey = 'id';
	
	private $forums 			= false;
	
	public function getForums()
	{
		
		if(!$this->forums)
		{
			
			global $database;
			
			$query = "SELECT * FROM " . DB_PREFIX . "forum_forums WHERE categoryid=" . (int) $this->id . " order by `order` ASC";
			if($results = $database->getrows($query))
			{
				foreach($results as $result)
				{
					$forum = new ForumItem;
					setvaluesbyarray($forum,$result);
					$forums[] = $forum;
				}
			}
			
			$this->forums = $forums;
			
		}
		
		return $this->forums;
		
	}
		
}