mostlinked.php

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

<?php

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

global $pageOwner,$dbObject,$lang;

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

includeFile('search/all.php');
	
class queryWanted extends query{
	var $tempObject;
	
	function queryWanted(){
		global $page,$dbInfo,$pageOwner,$lang,$wbTables;
		$page->css2 =true;
		$this->rowLimit = 50;
		
		
		$this->query = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS ';
		$this->query .= ' `to_link`, COUNT(*) as `count` ';
		$this->query .= ' FROM '.$wbTables['all_links'];
		$this->query .= ' WHERE `to_owner` = "'.wbDB::escape($pageOwner['username']).'" ';
		$this->query .= ' GROUP BY `to_link` ';
		$this->query .= ' ORDER BY `count` DESC ';
		//message($this->query);

		$this->searchUrl = '/Special/'.$pageOwner['username'].'/MostLinked';
		browseSearch3($this,$lang['most_linked']);
	}
	
	function abbrevOutput(&$row,$i){
		echo '<li>';
		echo wbLinks::local($row->to_link,str_replace('_',' ',$row->to_link));
		echo ' &nbsp; (';
		echo wbLinks::special('WhatLinksHere?to='.$row->to_link,$row->count.' links');
		echo ')';
		echo '</li>';
	}
	
	function mysqlFetch(&$result){
		return mysql_fetch_object($result);
	}
	function displayPre(){
		echo '<ol>';
	}
	function displayEmpty(){
		parent::displayEmpty();
		return true;
	}
}

new queryWanted();