<?php

class bj_entry {
	var $limit;
	var $offset;
	var $normal = true;
	var $cache_key = '';
	
	#Query information in the WHERE clause.
	var $args = array();
	var $tags = '';
	var $search = '';
	var $sortby = 'posted';
	var $sort = 'DESC';

	function bj_entry($offset,$limit) {
		$this->offset = $offset;
		$this->limit = $limit;
	}
	
	function setID($v) {
		$this->normal = false;
		$this->args['ID'] = $v;
	}
	
	function setSecond($v) {
		$this->normal = false;
		$this->args['SECOND(posted)'] = $v;
	}
	
	function setMinute($v) {
		$this->normal = false;
		$this->args['MINUTE(posted)'] = $v;
	}
	
	function setHour($v) {
		$this->normal = false;
		$this->args['HOUR(posted)'] = $v;
	}
	
	function setDay($v) {
		$this->normal = false;
		$this->args['DAYOFMONTH(posted)'] = $v;
	}
	
	function setMonth($v) {
		$this->normal = false;
		$this->args['MONTH(posted)'] = $v;
	}
	
	function setYear($v) {
		$this->normal = false;
		$this->args['YEAR(posted)'] = $v;
	}
	
	function setTitle($v) {
		$this->normal = false;
		$this->args['title'] = $v;
	}
	
	function setShortname($v) {
		$this->normal = false;
		$this->args['shortname'] = $v;
	}
	
	function setSection($v) {
		$this->args['section'] = $v;
	}
	
	function setAuthor($v) {
		$this->args['author'] = $v;
	}
	
	function setPtype($v) {
		$this->normal = false;
		$this->args['ptype'] = $v;
	}
	
	#Extremely abormal stuff.
	function setTags($v) {
		if(strpos($v,',') !== false or strpos($v,'-') !== false) {
			$this->normal = false;
			$this->args['tags'] = str_replace(',','-',$v);
			$this->tags .= " (";
			$t = explode(",",$v);
			foreach($t as $i=>$tag) {
				if($i > 0)
					$this->tags .= " OR ";
				if(substr($tag,0,1) == "s")
					$this->tags .= "tags NOT REGEXP '\"".substr($tag,1)."\"'";
				else
					$this->tags .= "tags REGEXP '\"".$tag."\"'";
			}
			$this->tags .= ")";
		}
		else {
			$this->args['tags'] = $v;
			$this->tags = " (tags REGEXP '\"".$v."\"')";
		}
	}
	
	function setSearch($v) {
		$this->normal = false;
		$s = str_replace(' ','+',$v);
		$s = explode('+',$s);
		$this->args['search'] = $s;
		$this->search .= " (((title LIKE '%".$search[0]."%') OR (content LIKE '%".$search[0]."%'))";
		for ( $i = 1; $i < count($s); $i++)
			$this->search .= " OR ((title LIKE '%".$s[$i]."%') OR (content LIKE '%".$s[$i]."%'))";
		$this->search .= ')';
	}
	
	function sortBy($v) {
		if($v != 'posted')
			$this->normal = false;
		$this->sortby = $v;
	}
	
	function sortOrder($v) {
		if($v != 'DESC')
			$this->normal = false;
		$this->sort = $v;
	}
	
	function fetch() {
		global $bj;
		#Doing a normal cache fetch can only involve parsing one of these.
		if($this->args['section'] and ($this->args['author'] or $this->args['tags']))
			$this->normal = false;
		elseif($this->args['author'] and ($this->args['section'] or $this->args['tags']))
			$this->normal = false;
		elseif($this->args['tags'] and ($this->args['author'] or $this->args['section']))
			$this->normal = false;
		
		/*
		 * Dude, you have no idea how long it took to code this.
		 * My head split in two, it's that bad. >_<
		 */
		#Make our cache key.
		foreach($this->args as $arg=>$value)
			$this->cache_key .= '-'.$arg.'-'.$value;
		if(!$this->normal)
			$this->cache_key .= '-sort-'.$this->sortby.'-'.$this->sort;
		$this->cache_key = '-'.bj_shortname($this->cache_key);
		
		#Do we normally do this?
		if($this->normal)
			foreach($this->args as $arg=>$value)
				return $bj->cache->get_entries($arg,$value);
		else {
			add_action('query_extra_'.$this->cache_key,array($this,'query_key'));
			return $bj->cache->get_entries($this->cache_key);
		}
	}
	
	function query_key() {
		$query = '';
		#Args.
		if(count($this->args) > 0) {
			$query .= ' WHERE';
			$and = '';
			$i = 0;
			foreach($this->args as $arg=>$value) {
				if($arg != 'section' and $arg != 'tags') {
					if($i > 0)
						$and = ' AND';
					$query .= $and.' '.$arg.' = \''.$value.'\'';
					$i++;
				}
			}
			if(!empty($this->tags))
				$query .= $and.$this->tags;
			if(!empty($this->search))
				$query .= $and.$this->search;
		}
		#Order by...
		$query .= ' ORDER BY '.$this->sortby.' '.$this->sort;
		#And the final piece, offset and limit.
		if($this->limit)
			$query .= ' LIMIT '.$this->offset.','.$this->limit;
		#Bon voyage, query!
		return $query;
	}
	
	function gete($q) {
		global $bj,$i;
		parse_str($q,$args);
		$i = 0;	
		$query = "SELECT * FROM ".$bj->db->entries." WHERE";
		if(isset($args['id']))
			$query .= " `ID` = '".intval($args['id'])."'";
		else
			$query .= " `ID` != '0'"; #Just a filler so each value can start with "AND".
		if(isset($args['second']))
			$query .= " AND SECOND(`posted`) = '".$args['second']."'";
		if(isset($args['minute']))
			$query .= " AND MINUTE(`posted`) = '".$args['minute']."'";
		if(isset($args['hour']))
			$query .= " AND HOUR(`posted`) = '".$args['hour']."'";
		if(isset($args['day']))
			$query .= " AND DAYOFMONTH(`posted`) = '".$args['day']."'";
		if(isset($args['month']))
			$query .= " AND MONTH(`posted`) = '".$args['month']."'";
		if(isset($args['year']))
			$query .= " AND YEAR(`posted`) = '".$args['year']."'";
		if(isset($args['title']))
			$query .= " AND `title` = '".$args['title']."'";
		if(isset($args['shortname']))
			$query .= " AND `shortname` = '".$args['shortname']."'";
		if(isset($args['tag'])) {
			$query .= " AND (";
			$tags = explode(",",$args['tag']);
			foreach($tags as $num=>$tag) {
				if($num != 0)
					$query .= " OR ";
				if(substr($tag,0,1) == "-")
					$query .= "`tags` NOT REGEXP '\"".substr($tag,1)."\"'";
				else
					$query .= "`tags` REGEXP '\"".$tag."\"'";
			}
			$query .= ")";
		}
		if(isset($args['section']))
			$query .= " AND `section` = '".$args['section']."'";
		if(isset($args['type']))
			$query .= " AND `ptype` = '".$args['type']."'";
		if(isset($args['author']))
			$query .= " AND `author` = '".$args['author']."'";
		if(isset($args['search'])) {
			$search = str_replace('+',' ',$args['search']);
			$search = explode(' ',$search);
			$query .= " AND (((`title` LIKE '%".$search[0]."%') OR (`content` LIKE '%".$search[0]."%'))";
			for ( $i = 1; $i < count($search); $i++)
				$query .= " OR ((`title` LIKE '%".$search[$i]."%') OR (`content` LIKE '%".$search[$i]."%'))";
			$query .= ')';
		}
		if(isset($args['sortby']))
			$query .= " ORDER BY `".$args['sortby']."`";
		else
			$query .= " ORDER BY `posted`";
		if(isset($args['order']))
			$query .= " ".$args['order'];
		else
			$query .= " DESC";
		if($args['inclimit'] != "false") {
			$loffset = (isset($args['offset'])) ? $args['offset'] : $this->offset;
			$limit = (isset($args['limit'])) ? $args['limit'] : $this->perpage;
			$query .= " LIMIT ".$loffset.",".$limit;
		}
		#Limit and offset.
		if($args['count'] == "true")
			return mysql_num_rows($bj->db->query($query));
		else
			return $bj->db->get_rows($query);
	}
}

?>