orphaned.php

来自「一款基于PHP的网络日记程序。WikyBlog支持：多用户的 BLOG」· PHP 代码 · 共 63 行

<?php

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

global $pageOwner,$dbObject,$lang;

$page->displayTitle = $lang['orphaned_files'];
$dbObject->links['?'] = $lang['orphaned_files'];

includeFile('search/all.php');
	
class deadEndFiles extends query{
	var $tempObject;
	
	function deadEndFiles(){
		global $page,$dbInfo,$pageOwner,$lang,$wbTables;
		$page->css2 =true;
		$this->rowLimit = 50;
		$this->searchUrl = '/Special/'.$pageOwner['username'].'/OrphanedFiles';
		
		//
		//	New
		//
		$this->allSelect = array();
		$this->joinAllTo = 'T1';
		
		$this->selectFrom = $wbTables['all_files'].' AS T1 LEFT JOIN '.$wbTables['all_links'];
		$this->selectFrom .= ' ON T1.`file_id` = '.$wbTables['all_links'].'.`to_id` ';
		//$this->selectFrom .= ' LEFT JOIN '.$wbTables['all_files'].' AS T2 ';
		//$this->selectFrom .= ' ON T2.`file_id` = '.$wbTables['all_links'].'.`to_id` ';
		
		$this->queryAllFiles();
		$this->query .= ' AND T1.`owner_id` = "'.wbDB::escape($pageOwner['user_id']).'" ';
		$this->query .= ' AND ('.$wbTables['all_links'].'.`to_id` IS NULL ';
		//$this->query .= ' OR FIND_IN_SET("hidden", T2.`flags`) ';
		//$this->query .= ' OR FIND_IN_SET("deleted", T2.`flags`) ';
		$this->query .= ' )';
		
		//message($this->query);
		browseSearch3($this,$lang['orphaned_files']);
	}
	
	function abbrevOutput(&$row,$i){
		$this->queryAllResult($row);
		
		echo '<li>';
		echo wbLinks::local($row['uniqLink'],toDisplay($row['dTitle']));
		echo '</li>';
	}
	
	function displayPre(){
		echo '<ol>';
	}
	function displayEmpty(){
		parent::displayEmpty();
		return true;
	}
	
}

new deadEndFiles();