/*
+-----------------------------------------------------------------------------+
|                                   SRPBoard                                  |
+-----------------------------------------------------------------------------+
|                        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                                          |
+-----------------------------------------------------------------------------+
| Authors:                                                                    |
|          cking                            <cking@srpboard.org>              | 
|          PPBoy                            <ppboy@srpboard.org>              |
|                                                                             |
| T-Chins:                                                                    |
|          Henglong                         <henglong@srpboard.org>           |
|          devil                            <devil@srpboard.org>              |
+-----------------------------------------------------------------------------+
*/

########################################################################
# wˤɥ SRPBoard.org ѡAåB̲׸vk SRPBoard.org Ҧ   #
########################################################################

#
#
#  * vҦ SRPBoard.org
#  Da}:   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
#
#  Henglong
#  E-mail  :   hennlong@srpboard.org
#

===================================== D ===============================
 ˱zϥ Fpq http://www.eastol.net o̴ѪDm SRPBoard
׾¡A|X{DAåBŶӴѧwUAѥn޳NɡC
׾ªŶѪFpqѡC
=============================================================================

#iϥΨĳj
#
# {@ɳnCziHKOϥΥ׾µ{A]iHbpW~Ǽ{Aϥ
# ǼPɡAzOdåBoק@{@̪HHάvCz
# o榹{Ϊ̥HL覡QΥ{Ȩӷ~QqC󥻵{ק沈q
# @̡AêWCHϦϥΨĳ欰A@̫Od@k߶D^vQC
#
#i׾¤Uj
# ׾ªw,ϥ ѦhƶA аѦҽ׾¤UC
# Ua} http://www.srpboard.org/download/Manual_GB.zip
#
#
#iKdnj
#
# ϥΥ{ylA{@̤tdCpGzPNAФŨϥΥ{C
#
#
#ivnj
#
# n鬰@ɳn(shareware)ѵΤKOϥΡAФťΩLϧQ欰AýФŧR
# vϼ Powered By SRPBoad.org
#
# ׾´ѪɨiHzwˡAϥν׾©M@׾ª`BAOpGz}
# 譱SݨDAеUڭ̪|Aڭ̷|zѯS޳NC
#
# ׾ªU׻PLB5000OPALB5000nDӷ~Τ᳣nU,ӥ{SoӻݨD
# ΤbHϨϥΨĳpUiHKOϥΡC:-)
#
#
#iSOP¡j
# ڭ̦bo̭nSOP¤@ǤHC
# 䤤}opժ Devil c骩ѦhƶAHν׾´հXܤjVOC
# ٦x׾ªDuVv<jerry@srpboard.org> ]׾´հXܤj^mC
#
# ڭ̦VҦSRPBoardIXLҰʪH̡An¡C
#

iIj
jawܽ׾ªopCpGoǼƾڬOήɧsAq`O@
CGIA]NOjaq`һ php jsp perl C

HUO@ӧ㪺A]thӥ\ACӥ\ೣOWߪC

 ϥήɡAд{Ǥ PATH XA(PATHAаѦLogin.txt)C

<?php
#################################
#      HUޥν׾¤      #
#################################
include("data/configure.inc.php"); // PATH
mysql_connect($db_host, $db_user, $db_pin) or die("ƾڮws");
mysql_select_db($db_database) or die("ƾڮws");

// HWsb

#################################
#      \1 - |έp       #
#################################
$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]; // ̷s|
$new_memberid = $tmp[1]; // ̷s|ID
$member_no = $tmp[2]; // |`

echo "̷s|G ";
echo $new_member;
echo "\n";

echo "̷s|IDG ";
echo $member_no;
echo "\n";

echo "|`ơG ";
echo $new_memberid;
echo "\n";

echo "\n";

#################################
#      \2 - ׾¦buέp       #
#################################
$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]; // pȦbuH
$peak_time = $tmp[4]; // pȦbuɶ

echo "pȦbuHơG ";
echo $peak_no;
echo "\n";

echo "pȦbuɶG ";
echo $peak_time;
echo "\n";

echo "\n";

#################################
#      \3 - ׾¥DDέp       #
#################################
$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']; // ׾¥DD
$reply_no = $tmp['reply']; // ׾¦^Ƽ

echo "׾¥DDơG ";
echo $topic_no;
echo "\n";

echo "׾¦^ƼơG ";
echo $reply_no;
echo "\n";

echo "\n";

#################################
#      \4 - ׾·s       #
#################################
$new_no = 10;// sӼ iۦ惡
$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']; // sDD
	$forum_id = $tmp['forumid']; // DDҦb׾ID
	$forum_name = $tmp['name']; // DDҦb׾¦W
	$topic_id = $tmp['topicid']; // DDID
	$read_times = $tmp['views']; // DD\Ū
	$reply_times = $tmp['replies']; // DD^_

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

	echo "DDҦb׾IDG ";
	echo $tmp['forumid'];
	echo "\n";

	echo "DDҦb׾¦W١G ";
	echo $tmp['name'];
	echo "\n";

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

	echo "DD\ŪơG ";
	echo $tmp['views'];
	echo "\n";

	echo "DD^_ơG ";
	echo  $tmp['replies'];
	echo "\n";

	echo "\n";
}
?>

jaiHէWzNXs test.php, On䤤PATHCMAs}ӤC

| SRPBoard xҤlѤjaѦҡC
http://www.srpboard.org/index.php ڭ̺A׾©mbؿ SRPBoard UC]N
Oڭ̳qL http://www.srpboard.org/SRPBoard/index.php Xݽ׾¡C

pڭ̦sWzNX test.php, åBqL http://www.srpboard.org/test.php XݸӭC
ڭ̷Qθӭܽ׾²έpơC
o̪ PATH  SRPBoard AYiWǸӤC

http://www.srpboard.org/test.php N|LX@ǰѼơCjaiHѬݤWAHKz
C\઺ϥΡCHWC\ೣOWߪA]NO "ޥν׾¤" + CWߪ\ NiHW
ϥΡCjazѤWzNXAYiH[WXA HTML NXCbTHSDAAoǥNXӤJA
index.php C

--------------------------------------------------------------------------------------
DDDjDDDaDDDϡDDDΡDDDrDDD֡II
--------------------------------------------------------------------------------------

-=-=-=-=-=-=-=-=-=-=-=-=-=
SRPBoard Development Team
=-=-=-=-=-=-=-=-=-=-=-=-=-
_________________________________________
/z: SRPBoard.org (SRPBoard x)
10:00 AM, July 29, 2003