Location: PHPKode > projects > Uchome and Discuz > source/space_mood.php
<?php
/*
	[UCenter Home] (C) 2007-2008 Comsenz Inc.
	$Id: space_mood.php 10314 2008-11-28 09:09:23Z liguode $
*/

if(!defined('IN_UCHOME')) {
	exit('Access Denied');
}

//·ÖÒ³
$perpage = 20;
$page = empty($_GET['page'])?0:intval($_GET['page']);
if($page<1) $page=1;
$start = ($page-1)*$perpage;

//¼ì²é¿ªÊ¼Êý
ckstart($start, $perpage);

$list = array();
$count = 0;

if($space['mood']) {
	$theurl = "space.php?uid=$space[uid]&do=mood";
	$count = $_SGLOBAL['db']->result($_SGLOBAL['db']->query("SELECT COUNT(*) FROM ".tname('space')." s WHERE s.mood='$space[mood]'"), 0);
	if($count) {
		$query = $_SGLOBAL['db']->query("SELECT s.*,sf.note,sf.sex FROM ".tname('space')." s
			LEFT JOIN ".tname('spacefield')." sf ON sf.uid=s.uid
			WHERE s.mood='$space[mood]'
			ORDER BY s.updatetime DESC LIMIT $start,$perpage");
		while ($value = $_SGLOBAL['db']->fetch_array($query)) {
			$value['isfriend'] = ($value['uid']==$space['uid'] || ($space['friends'] && in_array($value['uid'], $space['friends'])))?1:0;
			realname_set($value['uid'], $value['username'], $value['name'], $value['namestatus']);
			$list[] = $value;
		}
	}
	
	realname_get();
	
	//·ÖÒ³
	$multi = multi($count, $perpage, $page, $theurl);

}

include_once template("space_mood");

?>
Return current item: Uchome and Discuz