collections.php

来自「自己写的一个网络日志(BLOG)系统」· PHP 代码 · 共 21 行

<?php
!function_exists('usermsg') && exit('Forbidden');
require_once(R_P.'mod/page_mod.php');
(int)$page<1 && $page = 1;
$item_type=array('blog','goods','photo','music','file','bookmark','tag','team','user');
if(empty($step)){
	$sql="c.uid='$admin_uid'";
	empty($type) && $type='blog';
	!in_array($type,$item_type) && usermsg('undefine_action');
	$sql .=" AND c.type='$type'";
	$rt=$db->get_one("SELECT COUNT(*) AS count FROM pw_collections c WHERE $sql");
	$sum=$rt['count'];
	$pages=page($sum,$page,$db_perpage,"$basename&type=$type&");
	$limit="LIMIT ".($page-1)*$db_perpage.",$db_perpage";
	$collections=array();

	if($type=='user'){
		$query=$db->query("SELECT u.blogtitle,u.username,c.* FROM pw_collections c LEFT JOIN pw_user u ON c.itemid=u.uid WHERE $sql $limit");
		while($rt=$db->fetch_array($query)){
			$rt['adddate']=get_date($rt['adddate']);
			$rt['subject']=$rt['blogtitle'] ? $rt['blogtitle'] : "$rt[username]鐨勭┖闂