offset = $offset;
$this->limit = $limit;
$this->fromcache = $cache;
}
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 setOffset($v) {
$this->offset = $v;
}
function setLimit($v) {
$this->limit = $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) {
if($value == false)
unset($this->args[$arg]);
else
$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)
$arr = $bj->cache->get_entries($arg,$value,$this->fromcache);
else {
add_action('query_extra_'.$this->cache_key,array($this,'query_key'));
$arr = $bj->cache->get_entries($this->cache_key,0,$this->fromcache);
}
#Limit and offset/
if(is_array($arr) and $this->limit)
$arr = array_slice($arr,$this->offset,$this->limit);
#Later, d00d!
return $arr;
}
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';
if($arg == 'ptype' and $value == '*')
$query .= $and.' '.$arg.' IS NOT NULL';
else
$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;
#Bon voyage, query!
return $query;
}
function next_page($text,$before='',$after='') {
global $bj;
$older = $this->offset + $this->limit;
$tmplimit = $this->limit;
#We do this to grab all entries for the query processed. Pagination thing- you wouldn't understand.
$this->setLimit(false);
if(count($this->fetch) - $older > 0 and !is_entry()) {
if(!is_admin()) {
$load = (defined('BJ_REWRITE')) ? 'index.php?load=' : '';
if(is_section() and !is_front())
$extra_string = 'section/'.$bj->vars->load[1].'/';
elseif(is_tag())
$extra_string = 'tag/'.$bj->vars->load[1].'/';
elseif(is_search())
$extra_string = 'search/'.$bj->vars->load[1].'/';
echo $before.''.$text.''.$after;
}
else {
if($_GET['req'] == 'filtertag' && $_GET['tag'] != '')
$extra_string = 'req=filtertag&tag='.bj_clean_string($_GET['tag']).'&';
elseif($_GET['req'] == 'filtersection' && $_GET['section'] != '')
$extra_string = 'req=filtersection§ion='.bj_clean_string($_GET['section']).'&';
elseif(is_search())
$extra_string = 'req=search&s='.bj_clean_string($_GET['s']).'&';
echo $before.''.$text.''.$after;
}
}
$this->limit = $tmplimit;
}
function prev_page($text,$before='',$after='') {
global $bj;
$newer = $this->offset - $this->limit;
if($this->offset > 0 && !is_entry()) {
if(!is_admin()) {
if(is_section())
$extra_string = 'section/'.$bj->vars->load[1].'/';
elseif(is_tag())
$extra_string = 'tag/'.$bj->vars->load[1].'/';
$load = (defined('BJ_REWRITE')) ? 'index.php?load=' : '';
echo $before.''.$text.''.$after;
}
else {
if($_GET['req'] == 'filtertag' && $_GET['tag'] != '')
$extra_string = 'req=filtertag&tag='.$_GET['tag'].'&';
elseif($_GET['req'] == 'filtersection' && $_GET['section'] != '')
$extra_string = 'req=filtersection§ion='.bj_clean_string($_GET['section']).'&';
elseif(is_search())
$extra_string = 'req=search&s='.bj_clean_string($_GET['s']).'&';
echo $before.''.$text.''.$after;
}
}
}
}
?>