pcstat.php

KBS的BBS源码

<?php
/*
** @id:windinsin nov 29,2003
*/
require_once("pcfuncs.php");

function getNewBlogs($link,$pno=1,$etemnum=0)
{
	global $pcconfig;
	if($pno < 1)
		$pno = 1;
	
	$etemnum = intval( $etemnum );
	if($etemnum <= 0 )
		$etemnum = $pcconfig["NEWS"];
	
	$newBlogs = array();
	$newBlogs["channel"] = array(
			"siteaddr" => "http://".$pcconfig["SITE"],
			"title" => $pcconfig["BBSNAME"]."即时Blog日志" ,
			"pcaddr" => "http://".$pcconfig["SITE"],
			"desc" => $pcconfig["BBSNAME"]."最新".$etemnum."个日志",
			"email" => $pcconfig["BBSNAME"],
			"publisher" => $pcconfig["BBSNAME"],
			"creator" => $pcconfig["BBSNAME"],
			"rights" => $pcconfig["BBSNAME"],
			"date" => date("Y-m-d"),
			"updatePeriod" => "10分钟更新一次",
			"updateFrequency" => "最新的".$etemnum."个Blog日志",
			"updateBase" => date("Y-m-d H:i:s"),
			
			);
	
	$query = "SELECT users.visitcount,description,corpusname,username,created,subject,body,htmltag,nodes.uid,nid,tid,users.theme,nodescount ".
	         "FROM nodes force index(PRIMARY) ,users ".
	         "WHERE `access` = 0 ".
	         "   AND nodes.uid = users.uid ".
	         "   AND pctype < 6 ".
	         "   AND nodetype = 0 ".
	         "ORDER BY `nid` DESC ".
	         "LIMIT ".(($pno - 1) * $etemnum)." , ".$etemnum." ;";
	$result = mysql_query($query,$link);
	$j = 0;
	while($rows=mysql_fetch_array($result))
	{
		$body = "<br>\n".
			"来自: ".html_format($rows["corpusname"])."<br>\n".
			"作者: ".html_format($rows["username"])."<br>\n".
			"发信站: ".$pcconfig["BBSNAME"]."<br>\n".
			"时间: ".time_format($rows["created"])."<br>\n".
			"<hr size=1>\n".
			html_format($rows["body"],TRUE,$rows["htmltag"]).
			"<hr size=1>\n".
			"(<a href=\"http://".$pcconfig["SITE"]."/pc/pccon.php?id=".$rows["uid"]."&nid=".$rows["nid"]."&tid=".$rows["tid"]."&s=all\">浏览全文</a>\n".
			"<a href=\"http://".$pcconfig["SITE"]."/pc/pccom.php?act=pst&nid=".$rows["nid"]."\">发表评论</a>)<br>\n".
			"<a href=\"http://".$pcconfig["SITE"]."/pc/rss.php?userid=".html_format($rows["username"])."\"><img src=\"http://".$pcconfig["SITE"]."/pc/images/xml.gif\" border=\"0\" align=\"absmiddle\" alt=\"XML\">Blog地址：http://".$pcconfig["SITE"]."/pc/rss.php?userid=".html_format($rows["username"])."</a>";
		$newBlogs["useretems"][$j] = array(
					"addr" => "http://".$pcconfig["SITE"]."/pc/pccon.php?id=".$rows["uid"]."&amp;nid=".$rows["nid"]."&amp;tid=".$rows["tid"],
					"subject" => htmlspecialchars($rows["subject"]),
					"desc" => $body,
					"tid" => $rows["tid"],
					"nid" => $rows["nid"],
					"publisher" => $pcconfig["BBSNAME"],
					"creator" => html_format($rows["username"]),
					"pc" => $rows["uid"],
					"created" => time_format($rows["created"]),
					"rights" => html_format($rows["username"]).".bbs@".$pcconfig["SITE"],
					"theme" => pc_get_theme($rows["theme"]),
					"pcdesc" => $rows["description"],
					"pcname" => $rows["corpusname"],
					"pcvisit" => $rows[0],
					"pcnodes" => $rows["nodescount"]
					);
		$j ++;
	}
	mysql_free_result($result);
	
	return $newBlogs;
}

function getNewComments($link,$pno=1,$etemnum=0)
{
	global $pcconfig;
	if($pno < 1)	$pno = 1;
	$etemnum = intval( $etemnum );
	if($etemnum <= 0 )
		$etemnum = $pcconfig["NEWS"];
	
	$newComments = array();
	$query = "SELECT cid , comments.uid , comments.subject , comments.created , comments.username , nodes.subject , nodes.created , nodes.visitcount , commentcount , nodes.nid ".
	         "FROM comments, nodes , users ".
	         "WHERE comments.nid = nodes.nid ".
	         "  AND nodes.uid = users.uid ".
	         "  AND pctype < 6 ".
	         "  AND access = 0 ".
	         "  AND comment = 1 ".
	         "  AND nodetype = 0 ".
	         "ORDER BY cid DESC ".
	         "LIMIT ".(($pno - 1) * $etemnum)." , ".$etemnum." ;";
	$result = mysql_query($query,$link);
	for($i = 0; $i < mysql_num_rows($result) ; $i ++ )
	{
		$rows = mysql_fetch_array($result);
		$newComments[$i] = array(
					"CID" => $rows["cid"],
					"UID" => $rows["uid"],
					"CCREATED" => time_format($rows[3]),
					"NCREATED" => time_format($rows["created"]),
					"VISITCOUNT" => $rows["visitcount"],
					"COMMENTCOUNT" => $rows["commentcount"],
					"CSUBJECT" => html_format($rows[2]),
					"NSUBJECT" => html_format($rows["subject"]),
					"POSTER" => $rows["username"],
					"NID" => $rows["nid"]
					);	
	}
	mysql_free_result($result);
	return $newComments;
}

//nodes without body and user information
function getRecommendNodes($link,$num)
{
	$num = intval($num);
	$query = "SELECT nid , subject , uid FROM recommend ORDER BY state DESC, rid DESC LIMIT 0 , ".$num.";";
	$result = mysql_query($query,$link);	
	$nodes = array();
	while($rows = mysql_fetch_array($result))
		$nodes[] = $rows;
	mysql_free_result($result);
	return $nodes;
}


//nodes with body and user information
function getRecommendBlogs($link,$pno=1,$etemnum=0)
{
	global $pcconfig;
	if($pno < 1)
		$pno = 1;
	
	$etemnum = intval( $etemnum );
	if($etemnum <= 0 )
		$etemnum = $pcconfig["NEWS"];
	
	$start = ( $pno - 1 ) * $etemnum ;
	
	$query = "SELECT recommend.uid  , subject , body , htmltag , emote , hostname , created , recuser , nid , username , corpusname , description  ".
		 "FROM recommend , users ".
		 "WHERE recommend.uid = users.uid ".
		 "ORDER BY state DESC , rid DESC ".
		 "LIMIT ".$start." , ".$etemnum." ;";
	$result = mysql_query($query,$link);
	$num_rows = mysql_num_rows($result);
	
	$recommendBlogs = array();
	$recommendBlogs["channel"] = array(
			"siteaddr" => "http://".$pcconfig["SITE"],
			"title" => $pcconfig["BBSNAME"]."推荐Blog日志" ,
			"pcaddr" => "http://".$pcconfig["SITE"],
			"desc" => $pcconfig["BBSNAME"]."最新".$etemnum."个推荐日志",
			"email" => $pcconfig["BBSNAME"],
			"publisher" => $pcconfig["BBSNAME"],
			"creator" => $pcconfig["BBSNAME"],
			"rights" => $pcconfig["BBSNAME"],
			"date" => date("Y-m-d"),
			"updatePeriod" => "10分钟更新一次",
			"updateFrequency" => "最新的".$etemnum."个推荐日志",
			"updateBase" => date("Y-m-d H:i:s"),
			);
	for( $i = 0 ; $i < $num_rows ; $i ++ )
	{
		$rows = mysql_fetch_array($result);
		$body = "<br>\n".
			"来自: ".$rows["corpusname"]."<br>\n".
			"作者: ".$rows["username"]."<br>\n".
			"发信站: ".$pcconfig["BBSNAME"]."<br>\n".
			"时间: ".time_format($rows["created"])."<br>\n".
			"<hr size=1>\n".
			html_format($rows["body"],TRUE,$rows["htmltag"]).
			"<hr size=1>\n".
			"(<a href=\"http://".$pcconfig["SITE"]."/pc/pccon.php?id=".$rows[0]."&nid=".$rows["nid"]."&s=all\">浏览全文</a>\n".
			"<a href=\"http://".$pcconfig["SITE"]."/pc/pccom.php?act=pst&nid=".$rows["nid"]."\">发表评论</a>)<br>\n".
			"<a href=\"http://".$pcconfig["SITE"]."/pc/rss.php?userid=".$rows["username"]."\"><img src=\"http://".$pcconfig["SITE"]."/pc/images/xml.gif\" border=\"0\" align=\"absmiddle\" alt=\"XML\">Blog地址：http://".$pcconfig["SITE"]."/pc/rss.php?userid=".$rows["user"]."</a>";
		$recommendBlogs["useretems"][$i] = array(
					"addr" => "http://".$pcconfig["SITE"]."/pc/pccon.php?id=".$rows[0]."&amp;nid=".$rows[nid],
					"subject" => htmlspecialchars($rows["subject"]),
					"desc" => $body,
					"tid" => 0,
					"nid" => $rows["nid"],
					"publisher" => $pcconfig["BBSNAME"],
					"creator" => $rows["username"],
					"pc" => $rows[0],
					"created" => time_format($rows["created"]),
					"rights" => $rows["username"].".bbs@".$pcconfig["SITE"]
					);
	}
	mysql_free_result($result);
	return $recommendBlogs;
}

function getNewUsers($link,$userNum=0)
{
	$userNum = intval( $userNum );
	if(!$userNum) $userNum = 10;
	$query = "SELECT username,corpusname,description FROM users WHERE pctype < 2 ORDER BY createtime DESC LIMIT 0,".intval($userNum).";";
	$result = mysql_query($query,$link);
	$newUsers = array();
	while($rows = mysql_fetch_array($result))
		$newUsers[] = $rows;
	mysql_free_result($result);
	return $newUsers;
}

function getMostVstUsers($link,$userNum=0)
{
	$userNum = intval( $userNum );
	if(!$userNum) $userNum = 10;
	$query = "SELECT username , corpusname , description FROM users WHERE pctype < 2 ORDER BY visitcount DESC LIMIT 0,".intval($userNum).";";
	$result = mysql_query($query,$link);
	$mostVstUsers = array();
	while($rows = mysql_fetch_array($result))
		$mostVstUsers[] = $rows;
	mysql_free_result($result);
	return $mostVstUsers;
}