blog.php

一款基于PHP的网络日记程序。WikyBlog支持：多用户的 BLOG

<?php
//$lang checked

defined('WikyBlog') or die("Not an entry point...");

global $pageOwner,$dbObject,$lang;
$page->displayTitle = $lang['blog'];
$dbObject->links['?'] = $lang['blog'];


includeFile('search/all.php');
	
class queryBlog extends query{
	var $tempObject;
	
	function queryBlog(){
		global $page,$dbInfo,$pageOwner,$lang,$wbTables,$wbTablePrefix,$dbObject;
		$page->css2 =true;
		$this->rowLimit = 5;
		
		$blogType = $pageOwner['blogT'];
		wbData::newObject($blogType,$this->tempObject,true);
		if( !method_exists($this->tempObject,'abbrevOutput') ){
			return;
		}
		
		$tempInfo =& $this->tempObject->dbInfo;
		
		$this->query = 'SELECT SQL_CALC_FOUND_ROWS * ,'.wbData::dbInfo($blogType,'uniqLink').' as uniqLink ';
		$this->query .= ' FROM '.$wbTables['all_files'];
		$this->query .= ' JOIN '.$tempInfo['dbTable']; //$wbTablePrefix.'pages` ';
		$this->query .= ' USING(`file_id`) ';
		$this->query .= ' WHERE `owner_id` = "'.$pageOwner['user_id'].'" ';
		$this->query .= ' AND title != "home" ';
		$this->query .= ' AND !FIND_IN_SET("template", '.$wbTables['all_files'].'.`flags`) ';
		$this->query .= ' AND !FIND_IN_SET("hidden", '.$wbTables['all_files'].'.`flags`) ';
		$this->query .= ' AND !FIND_IN_SET("deleted", '.$wbTables['all_files'].'.`flags`) ';
		$this->query .= ' AND !FIND_IN_SET("redirect", '.$wbTables['all_files'].'.`flags`) ';
		
		if( isset($pageOwner['sBlog']) && ($pageOwner['sBlog'] == 'On') ){
			$this->query .= ' AND FIND_IN_SET("unchecked", '.$wbTables['all_files'].'.`flags`) '; //!!only unused flag.. will need to rename this in a later update
		}
		
		$this->query .= 'ORDER BY `posted` DESC ';
		
		
		$dbObject->links[$lang['blog']] = '/Special/'.$pageOwner['username'].'/Blog';
		$this->searchUrl = '/Special/'.$pageOwner['username'].'/Blog';
		browseSearch3($this,$lang['blog']);
	}
	
	function abbrevOutput(&$row,$i){
		$this->tempObject->abbrevOutput($row,$i);
	}
	
	function mysqlFetch(&$result){
		return mysql_fetch_object($result);
	}
}

new queryBlog();