<?php

class Sponsor extends ModuleHelper implements ModuleInterface 
{

	/*
	* Columns
	*/
	public $id					= false;
	public $status			= 'published';
	public $file				= false;
	public $name 				= false;
	public $description = false;
	public $url					= 'http://';
	public $displayurl	= false;
	public $type				= 'sponsor';
	
	protected $columns 		= array('id','status','file','name','description','url','displayurl','type');
	protected $table			= 'categoryItems';
	protected $primaryKey = 'id';
	
	/** 
	 * Fill object with values from the database
	 *
	 * @param	$columns array Columns we need to search on in our database 
	 *
	 */	
	public function getBy($columns)
	{
		
		global $database;
		
		$where = $this->buildWhere($columns);
		
		$query = "SELECT * FROM categoryitems WHERE type='sponsor' AND " . $where . " LIMIT 1";
		$result = $database->getrow($query);
		
		$this->setValuesByArray($result);
		
	}
	
	
	
}