/*
+-----------------------------------------------------------------------------+
|                          SRPBoard V2.0 GB                                   |
+-----------------------------------------------------------------------------+
|                        http://www.srpboard.org                              |
+-----------------------------------------------------------------------------+
|  DISCLAIMER AND STATEMENT                                                   |
|    This program is free software.                                           |
|    You can redistribute it and/or modify it under the terms of              |
|    the GNU General Public License as published by                           |
|    the Free Software Foundation;                                            |
|    either version 2 of the License                                          |
+-----------------------------------------------------------------------------+
| Team Members:                                                               |
|          cking                            <cking@srpboard.org>              |
|          ppboy                            <ppboy@srpboard.org>              |
|          devil                            <devil@srpboard.org>              |
|          jerry                            <jerry@srpboard.org>              |
|          hennlong                         <hennlong@srpboard.org>           |
+-----------------------------------------------------------------------------+
| Last Update: Dec 24, 2003                                                   |
+-----------------------------------------------------------------------------+
*/

########################################################################
# ˰װĵ SRPBoard.org ṩսȨ SRPBoard.org    #
########################################################################

#
#
#  * Ȩ SRPBoard.org
#  ҳַ:   http://www.SRPBoard.org
#  ֧̳:   http://bbs.SRPBoard.org
#
#  cking
#  E-mail  :   cking@srpboard.org
#  ICQ     :   864905
#
#  ppboy
#  E-mail  :   ppboy@srpboard.org
#  OICQ    :   2263026
#
#  devil
#  E-mail  :   devil@srpboard.org
#  ICQ     :   899717
#
#  jerry
#  E-mail  :   jerry@srpboard.org
#
#  hennlong
#  E-mail  :   hennlong@srpboard.org
#
#

===================================== Ƽ ===============================
 Ƽʹ ˾ http://www.eastol.net ṩ SRPBoard
̳κ⣬ҿռṩȫİװṩҪļָ
̳ռȫɶ˾ṩ
=============================================================================

#ʹЭ顿
#
# ʽΪ塣ʹñ̳ʽҲڻϼʽʹ
# 񴫲ͬʱ뱣Ҳ޸һйسʽߵϢԼذȨ˵
# ˳ʽκηʽñʽĲȡҵ档ڱʽκ޸ıͨ
# ֪ԭߣ˵ΥʹЭΪ߱һзϵȨ
#
#ֲ̳᡿
# й̳İװ,ʹ  οֲ̳ᡣ
# صַ http://www.srpboard.org/download/SRPBoard_Manual_GB.zip
#
#
#
#
# κʹñʽɵʧʽԭ߲κΡͬ⣬ʹñʽ
#
#
#Ȩ
#
# Ϊ(shareware)ṩûʹãͼΪɾ
# Ȩͼ Powered By SRPBoad.org
#
# ̳ṩ˵ĵװʹ̳ά̳УжԽű
# עΪǵĻԱǻΪṩļ֧֡
#
# ̳עƶLB5000ǲͬģLB5000ҪҵûҪע,ʽû
# κûڲΥʹЭ¶ʹá:-)
#
#
#رл
# ҪرлһЩˡ
# пС devil ΪԼ̳ܴŬ
# йٷ̳İjerry<jerry@srpboard.org> ҲΪ̳ܴס
#
# ΪSRPBoardͶǣ˵лл
#

˵
ϲվҳʾ̳ķЩǼʱµģôվҳͨһ
CGIļҲǴͨ˵ php jsp perl ȵȡ

һҳ棬ܣÿܶǶġ

 ʹʱ滻е PATH Ϊʵֵ(PATH滻οLogin.txt)

<?php
#################################
#      ²Ϊ̳ļ      #
#################################
include("data/configure.inc.php"); // 滻PATH
mysql_connect($db_host, $db_user, $db_pin) or die("ݿʧ");
mysql_select_db($db_database) or die("ݿʧ");

// ϲֱ

#################################
#      1 - Աͳ       #
#################################
$query = 'SELECT * FROM srp_forum WHERE groupid = 0';
$result = mysql_query($query);
$tmp = mysql_fetch_array($result);
$tmp = $tmp['extra'];
$tmp = explode("\t",$tmp);

$new_member = $tmp[0]; // »Ա
$new_memberid = $tmp[1]; // »ԱID
$member_no = $tmp[2]; // Ա

echo "»Ա ";
echo $new_member;
echo "\n";

echo "»ԱID ";
echo $member_no;
echo "\n";

echo "Ա ";
echo $new_memberid;
echo "\n";

echo "\n";

#################################
#      2 - ̳ͳ       #
#################################
$query = 'SELECT * FROM srp_forum WHERE groupid = 0';
$result = mysql_query($query);
$tmp = mysql_fetch_array($result);
$tmp = $tmp['extra'];
$tmp = explode("\t",$tmp);

$peak_no = $tmp[3]; // ֵ
$peak_time = $tmp[4]; // ֵʱ

echo "ֵ ";
echo $peak_no;
echo "\n";

echo "ֵʱ䣺 ";
echo $peak_time;
echo "\n";

echo "\n";

#################################
#      3 - ̳ͳ       #
#################################
$query = 'SELECT sum(post) as topic, sum(reply) as reply from srp_forum';
$result = mysql_query($query);
$tmp = mysql_fetch_array($result);

$topic_no = $tmp['topic']; // ̳
$reply_no = $tmp['reply']; // ̳ظ

echo "̳ ";
echo $topic_no;
echo "\n";

echo "̳ظ ";
echo $reply_no;
echo "\n";

echo "\n";

#################################
#      4 - ̳ʾ       #
#################################
$new_no = 10;//  иĴֵ
$query = "select * from srp_index t1,srp_forum t2 where t1.forumid = t2.forumid order by topicid DESC limit ".$new_no;
$result = mysql_query($query);
while($tmp = mysql_fetch_array($result)) {
	$new_topic = $tmp['topic']; // 
	$forum_id = $tmp['forumid']; // ̳ID
	$forum_name = $tmp['name']; // ̳
	$topic_id = $tmp['topicid']; // ID
	$read_times = $tmp['views']; // Ķ
	$reply_times = $tmp['replies']; // ظ

	echo "⣺ ";
	echo $tmp['topic'];
	echo "\n";

	echo "̳ID ";
	echo $tmp['forumid'];
	echo "\n";

	echo "̳ƣ ";
	echo $tmp['name'];
	echo "\n";

	echo "ID ";
	echo $tmp['topicid'];
	echo "\n";

	echo "Ķ ";
	echo $tmp['views'];
	echo "\n";

	echo "ظ ";
	echo  $tmp['replies'];
	echo "\n";

	echo "\n";
}
?>

ҿԳ԰ļ test.php, סҪ滻еPATHȻд򿪸ļ

 SRPBoard ٷվӹҲο
http://www.srpboard.org/index.php Ϊվҳ̳Ŀ¼ SRPBoard ¡Ҳ
˵ͨ http://www.srpboard.org/SRPBoard/index.php ̳

˵ǴΪ test.php, ͨ http://www.srpboard.org/test.php ʸҳ档
øҳվҳʾ̳ͳϡ
 PATH Ϊ SRPBoard 滻󼴿ϴļ

http://www.srpboard.org/test.php ӡһЩҿԲο˵Ա
ÿܵʹáÿܶǶģҲ˵ "̳ļ" + ÿĹ ͿԵ
ʹá󣬼ԼϺʵ HTML 롣ȷûٰЩֲ
index.php ļ

--------------------------------------------------------------------------------------
ף󣮣ңʹã䣮죡
--------------------------------------------------------------------------------------

-=-=-=-=-=-=-=-=-=-=-=-=-=
SRPBoard Development Team
=-=-=-=-=-=-=-=-=-=-=-=-=-
_________________________________________
ռ/: SRPBoard.org (SRPBoard ٷվ)
10:00 AM, Dec 24, 2003