<?
//--No direct access
defined('_JEXEC') or die('=;)');

jimport('joomla.application.component.model');

class vxcModelItems extends JModel
{
	function __construct()
	{
		parent::__construct();
		$this->setDBO(VoxelCareDB::getDatabase());	
	}
	
	function getData()
	{
		$sql = "SELECT atv.id ,atv.name, at.name typename
				FROM #__vxc_attributetypevalue atv
				LEFT JOIN #__vxc_attributetype at ON at.id = atv.attributetype				
				ORDER BY at.name, atv.name";
		$this->_db->setQuery($sql);
		return $this->_db->loadObjectList();			
	}
	
	
	
}
?>