pcmain.php

来自「清华BBS源代码」· PHP 代码 · 共 434 行

<?php
require("pcfuncs.php");

function pcmain_blog_statistics_list()
{
	global $pcconfig;
	$query = "SELECT COUNT(*) FROM users;";
	$result = mysql_query($query);
	$rows = mysql_fetch_row($result);
	mysql_free_result($result);
	$totaluser = $rows[0];
	
	$query = "SELECT COUNT(*) FROM nodes WHERE type != 1;";
	$result = mysql_query($query);
	$rows = mysql_fetch_row($result);
	mysql_free_result($result);
	$totalnode = $rows[0];
	
	$query = "SELECT COUNT(*) FROM comments;";
	$result = mysql_query($query);
	$rows = mysql_fetch_row($result);
	mysql_free_result($result);
	$totalcomment = $rows[0];
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7>&gt;&gt; 本站Blog统计：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t8 style="line-height=20px">
					注册用户：<font color="#FF0000"><strong><?php echo $totaluser; ?></strong></font> 人<br />
					Blog主题：<font color="#FF0000"><strong><?php echo $totalnode; ?></strong></font> 篇<br />
					Blog回复：<font color="#FF0000"><strong><?php echo $totalcomment; ?></strong></font> 篇<br />
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php
}

function pcmain_blog_new_user()
{
	global $pcconfig,$link;
	$query = "SELECT username,corpusname,description FROM users ORDER BY createtime DESC LIMIT 0,10;";
	$result = mysql_query($query,$link);
	$num = mysql_num_rows($result);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7>&gt;&gt; 最新申请用户：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t8 style="line-height=20px">
				<ul>
<?php
	for($i = 0;$i<$num;$i++)
	{
		$rows = mysql_fetch_array($result);
		echo "<li><a href=\"index.php?id=".$rows[username]."\"><span title=\"".html_format($rows[description])."\">".html_format($rows[corpusname])."</span></a><br/>&nbsp;&lt;<a href=\"/bbsqry.php?userid=".$rows[username]."\">".$rows[username]."</a>&gt;</li>";	
	}
?>				
				</ul>
				<p align="right"><a href="pc.php?order=createtime&order1=DESC">&gt;&gt;更多</a></p>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php
}

function pcmain_blog_top_ten()
{
	global $pcconfig,$link;
	$query = "SELECT username , corpusname , description FROM users ORDER BY visitcount DESC LIMIT 0,10;";
	$result = mysql_query($query,$link);
	$num = mysql_num_rows($result);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7>&gt;&gt; 访问最多的十个Blog：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t8 style="line-height=20px">
				<ul>
<?php
	for($i = 0;$i<$num;$i++)
	{
		$rows = mysql_fetch_array($result);
		echo "<li><a href=\"index.php?id=".$rows[username]."\"><span title=\"".html_format($rows[description])."\">".html_format($rows[corpusname])."</span></a><br/>&nbsp;&lt;<a href=\"/bbsqry.php?userid=".$rows[username]."\">".$rows[username]."</a>&gt;</li>";	
	}
?>				
				</ul>
				<p align="right"><a href="pc.php?order=visitcount&order1=DESC">&gt;&gt;更多</a></p>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php
}

function pcmain_blog_last_update()
{
	global $pcconfig,$link;
	$query = "SELECT username , corpusname , description FROM users WHERE createtime != modifytime ORDER BY modifytime DESC LIMIT 0,10;";
	$result = mysql_query($query,$link);
	$num = mysql_num_rows($result);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7>&gt;&gt; 最近更新的十个Blog：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t8 style="line-height=20px">
				<ul>
<?php
	for($i = 0;$i<$num;$i++)
	{
		$rows = mysql_fetch_array($result);
		echo "<li><a href=\"index.php?id=".$rows[username]."\"><span title=\"".html_format($rows[description])."\">".html_format($rows[corpusname])."</span></a><br/>&nbsp;&lt;<a href=\"/bbsqry.php?userid=".$rows[username]."\">".$rows[username]."</a>&gt;</li>";	
	}
?>				
				</ul>
				<p align="right"><a href="pc.php?order=modifytime&order1=DESC">&gt;&gt;更多</a></p>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php
}

function pcmain_blog_sections()
{
	global $pcconfig;
	$keys = array_keys($pcconfig["SECTION"]);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7>&gt;&gt; Blog分类：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t8 style="line-height=20px">
				<ul>
<?php
	for($i = 0;$i<count($keys);$i++)
	{
		echo "<li><a href=\"pcsec.php?sec=".$keys[$i]."\">".html_format($pcconfig["SECTION"][$keys[$i]])."</a></li>";	
	}
?>				
				</ul>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php
}

function  pcmain_blog_recommend_nodes()
{
	global $pcconfig,$link;
	$query = "SELECT nid , subject , htmltag , body , uid FROM recommend ORDER BY rid DESC LIMIT 0 , 10;";
	$result = mysql_query($query,$link);
	$num = mysql_num_rows($result);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7> 推荐话题：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t5 style="line-height=20px">
				<ul>
<?php
	for($i = 0;$i < $num ;$i ++)
	{
		$rows = mysql_fetch_array($result);
		$pcinfor = pc_load_infor($link,"",$rows[uid]);
		echo "<li><a href=\"pccon.php?id=".$rows[uid]."&nid=".$rows[nid]."&s=all\">".html_format($rows[subject])."</a>\n".
			"[出自<a href=\"/bbsqry.php?userid=".$pcinfor[USER]."\">".$pcinfor[USER]."</a>的Blog:<a href=\"index.php?id=".$pcinfor[USER]."\">".$pcinfor[NAME]."</a>]\n<br/>";
		if($rows[htmltag])
			$body = undo_html_format(strip_tags($rows[body]));
		else
			$body = $rows[body];
		echo html_format(substr($body,0,300)." \n");
		if(strlen($body)>300) echo " ... ...\n";
		echo "</li>\n";	
	}
?>				
				</ul>
				<p align="right"><a href="pcreclist.php">更多推荐话题</a></p>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php		
}

function  pcmain_blog_most_hot()
{
	global $pcconfig,$link;
	$query = "SELECT nid , subject , htmltag , body , uid FROM nodes WHERE access = 0 AND type = 0 AND recommend != 2 AND created > ".date("YmdHis",time()-604800)." AND commentcount != 0 ORDER BY commentcount DESC , nid DESC LIMIT 0 , 10;";
	$result = mysql_query($query,$link);
	$num = mysql_num_rows($result);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7> 七日内最热门话题：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t5 style="line-height=20px">
				<ol>
<?php
	for($i = 0;$i < $num ;$i ++)
	{
		$rows = mysql_fetch_array($result);
		$pcinfor = pc_load_infor($link,"",$rows[uid]);
		echo "<li><a href=\"pccon.php?id=".$rows[uid]."&nid=".$rows[nid]."&s=all\">".html_format($rows[subject])."</a>\n".
			"[出自<a href=\"/bbsqry.php?userid=".$pcinfor[USER]."\">".$pcinfor[USER]."</a>的Blog:<a href=\"index.php?id=".$pcinfor[USER]."\">".$pcinfor[NAME]."</a>]\n<br/>";
		if($rows[htmltag])
			$body = undo_html_format(strip_tags($rows[body]));
		else
			$body = $rows[body];
		echo html_format(substr($body,0,200)." \n");
		if(strlen($body)>200) echo " ... ...\n";
		echo "</li>\n";	
	}
?>				
				</ol>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php		
}

function  pcmain_blog_most_trackback()
{
	global $pcconfig,$link;
	$query = "SELECT nid , subject , htmltag , body , uid FROM nodes WHERE access = 0 AND type = 0 AND recommend != 2 AND created > ".date("YmdHis",time()-604800)." AND trackbackcount != 0 ORDER BY trackbackcount DESC , nid DESC LIMIT 0 , 10;";
	$result = mysql_query($query,$link);
	$num = mysql_num_rows($result);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7> 七日内引用最多的话题：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t5 style="line-height=20px">
				<ol>
<?php
	for($i = 0;$i < $num ;$i ++)
	{
		$rows = mysql_fetch_array($result);
		$pcinfor = pc_load_infor($link,"",$rows[uid]);
		echo "<li><a href=\"pccon.php?id=".$rows[uid]."&nid=".$rows[nid]."&s=all\">".html_format($rows[subject])."</a>\n".
			"[出自<a href=\"/bbsqry.php?userid=".$pcinfor[USER]."\">".$pcinfor[USER]."</a>的Blog:<a href=\"index.php?id=".$pcinfor[USER]."\">".$pcinfor[NAME]."</a>]\n<br/>";
		if($rows[htmltag])
			$body = undo_html_format(strip_tags($rows[body]));
		else
			$body = $rows[body];
		echo html_format(substr($body,0,200)." \n");
		if(strlen($body)>200) echo " ... ...\n";
		echo "</li>\n";	
	}
?>				
				</ol>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php		
}

function  pcmain_blog_most_view()
{
	global $pcconfig,$link;
	$query = "SELECT nid , subject , uid , body , htmltag FROM nodes WHERE access = 0 AND type = 0 AND recommend != 2 AND created > ".date("YmdHis",time()-604800)." AND visitcount != 0 ORDER BY visitcount DESC , nid DESC LIMIT 0 , 10;";
	$result = mysql_query($query,$link);
	$num = mysql_num_rows($result);
?>
<table cellspacing=0 cellpadding=3 width=98% class=f1>
<tr>
	<td class=t7> 七日内阅读最多的话题：</td>
</tr>
<tr>
	<td>
		<table cellspacing=0 cellpadding=10 width=100% class=t1>
			<tr>
				<td class=t5 style="line-height=24px">
				<ol>
<?php
	for($i = 0;$i < $num ;$i ++)
	{
		$rows = mysql_fetch_array($result);
		$pcinfor = pc_load_infor($link,"",$rows[uid]);
		echo "<li><a href=\"pccon.php?id=".$rows[uid]."&nid=".$rows[nid]."&s=all\">".html_format($rows[subject])."</a>\n".
			"[出自<a href=\"/bbsqry.php?userid=".$pcinfor[USER]."\">".$pcinfor[USER]."</a>的Blog:<a href=\"index.php?id=".$pcinfor[USER]."\">".$pcinfor[NAME]."</a>]\n<br/>";
		if($rows[htmltag])
			$body = undo_html_format(strip_tags($rows[body]));
		else
			$body = $rows[body];
		echo html_format(substr($body,0,200)." \n");
		if(strlen($body)>200) echo " ... ...\n";
		echo "</li>\n";	
	}
?>				
				</ol>
				</td>
			</tr>
		</table>
	</td>
</tr>
</table>
<?php		
}

//20min更新一次
if(pc_update_cache_header())
	return;

$link = pc_db_connect();
pc_html_init("gb2312" , $pcconfig["BBSNAME"]."Blog");
?>
<table cellspacing=0 cellpadding=5 width=100% border=0 class=f1>
<tr>
	<td colspan="2" class=t2>
	<a class="t2" href="pc.php">用户列表</a>
	<a class="t2" href="pcreclist.php">推荐话题</a>
	<a class="t2" href="pcsec.php">分类目录</a>
	<a class="t2" href="pcnew.php">最新文章</a>
	<a class="t2" href="pcnew.php?t=c">最新评论</a>
	<a class="t2" href="pcsearch2.php">Blog搜索</a>
	<a class="t2" href="pcnsearch.php">文章搜索</a>
	<a class="t2" href="/bbsdoc.php?board=<?php echo $pcconfig["BOARD"]; ?>">Blog论坛</a>
	<a class="t2" href="pcapp0.html">Blog申请</a>
	<a class="t2" href="index.php?id=<?php echo $pcconfig["ADMIN"]; ?>">帮助主题</a>
	</td>
</tr>
<tr>
	<td width="75%" class=t13 align="left" valign="top">
<?php
pcmain_blog_recommend_nodes();
pcmain_blog_most_hot();
pcmain_blog_most_view();
pcmain_blog_most_trackback();
?>
	</td>
	<td width="25%" align="left" valign="top">
<?php
pcmain_blog_statistics_list();
pcmain_blog_new_user();
pcmain_blog_top_ten();
pcmain_blog_last_update();
pcmain_blog_sections();
?>	
	<table cellspacing=0 cellpadding=5 width=100% border=0 class=f1>
		<tr>
		<td class=f1 style="line-height=28px"><ul>
			<li><a href="pc.php">用户列表</a></li>
			<li><a href="pcreclist.php">推荐话题</a></li>
			<li><a href="pcsec.php">分类目录</a></li>
			<li><a href="pcnew.php">最新文章</a></li>
			<li><a href="pcnew.php?t=c">最新评论</a></li>
			<li><a href="pcsearch2.php">Blog搜索</a></li>
			<li><a href="pcnsearch.php">文章搜索</a></li>
			<li><a href="/bbsdoc.php?board=<?php echo $pcconfig["BOARD"]; ?>">Blog论坛</a></li>
			<li><a href="pcapp0.html">Blog申请</a></li>
			<li><a href="index.php?id=<?php echo $pcconfig["ADMIN"]; ?>">帮助主题</a></li>
		</ul></td>
		</tr>
		<tr>
		<td class=f1>
		<p align="center"><b>RSS频道</b></p>
		<p align="center">
		最新日志
		<a href="rssnew.php"><img src="images/xml.gif" border="0" align="absmiddle" alt="本站最新Blog日志"></a>
		</p><p align="center">
		推荐文章
		<a href="rssrec.php"><img src="images/xml.gif" border="0" align="absmiddle" alt="本站推荐Blog日志"></a>
		</p></td>
		</tr>
	</table>
	</td>
</tr>
<tr>
	<td colspan=2 height=1 bgcolor=#999999> </td>
</tr>
<tr>
	<td colspan=2 class=f1>
	<center>版权所有 &copy; <?php echo $pcconfig["BBSNAME"]; ?></center>
	</td>
</tr>
<?php
pc_db_close($link);
html_normal_quit();
?>