<?php

class Template extends ModuleHelper implements ModuleInterface 
{

	/*
	* Columns
	*/
	public $id					= false;
	public $name 				= false;
	public $description = false;
	public $current			= 'N';
	public $author			= 'Clan Command Center';
	public $authorweb		= 'http://www.clancommandcenter.com';
	public $folder			= '';
	public $tplcolumns	= 2;
	
	protected $columns 		= array('id','name','description','current','author','authorweb','folder','tplcolumns');
	protected $table			= 'templates';
	protected $primaryKey = 'id';
	
	/**
	 * De-activates all themes except current one
	 */
	public function deActivateOthers()
	{
		
		global $database;
		
		$database->query("UPDATE `templates` SET current='N' WHERE id!='" . $this->id . "'");
		
	}
	
	public function getColumnBlocks($column=1)
	{
		
		global $database;
		
		$blocks = $database->getrows("SELECT b.name,b.description,b.id 
																	FROM blockpositions a 
																	RIGHT JOIN blocks b  
																		ON a.block = b.id
																	WHERE 
																	a.column=" . (int) $column . " AND 
																	b.active = 'Y'
																	ORDER By a.id ASC");
		
		return $blocks;
		
	}
	
}