社区(phpmysql)三

　　function prev_subj($id){
$DROOT=getenv(DOCUMENT_ROOT);
include("sql.php3");
$db=mysql_connect($sql[host], $sql[user] , $sql[passwd]);
$qstr="select id,aid from bbs_subj where id=$id";
$rs=mysql_db_query($sql[db],$qstr);
$row=mysql_fetch_array($rs);
$aid=$row[aid];

$qstr="select id from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql[db],$qstr);
$pid=$id;
while($row=mysql_fetch_array($rs)){
$tid=$row[id];
if($id==$tid) break;
$pid=$tid;
}

return $pid;
}
// 絞
function next_subj($id){
$DROOT=getenv(DOCUMENT_ROOT);
include("sql.php3");
$db=mysql_connect($sql[host], $sql[user] , $sql[passwd]);
$qstr="select id,aid from bbs_subj where id=$id";
$rs=mysql_db_query($sql[db],$qstr);
$row=mysql_fetch_array($rs);
$aid=$row[aid];

$qstr="select id from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql[db],$qstr);
$pid=$id;
while($row=mysql_fetch_array($rs)){
$pid=$row[id];
if($id==$pid) break;
}
if($row=mysql_fetch_array($rs)) {
$pid=$row[id];
}
return $pid;
}

//======================================================================
function viewbar() {
global $pgno;
global $PHP_SELF;
global $aid,$sid;
//global $OPEN_LIST;
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center align=center class=num>";
echo "<tr><td align=center>";
$nextid=next_subj($sid);
$previd=prev_subj($sid);
echo "<a href=$PHP_SELF?aid=$aid&sid=$sid>[夹肈跋]</a>";
echo "<a href=#re>[莱セ絞]</a>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid>[祇穝ゅ彻]</a>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$nextid&rid=$nextid>[絞]</a>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$previd&rid=$previd>[絞]</a>";
//echo "<a href=$PHP_SELF?proc=view&pgno=$pgno&aid=$aid&sid=$previd&rid=$previd>[程絞]</a>";

echo "</td>";

echo "</tr></table>";

}
//======================================================================
function view() {
global $PHP_SELF,$aid,$sid,$rid;
global $c_poster,$c_email;
//echo "$PHP_SELF,$aid,$sid,$rid,$pgno";
$type=0; //秨穝杠肈
if($sid && $rid) {
addhitviews($sid,$rid);
$type=1; //莱
$db_table="bbs_subj";
if($sid!=$rid)$db_table="bbs_docs";
$DROOT=getenv(DOCUMENT_ROOT);
include("sql.php3");
$db=mysql_connect($sql[host], $sql[user] , $sql[passwd]);
$qstr="select banner from bbs_area where id=$aid";
$rs=mysql_db_query($sql[db],$qstr);
echo mysql_error();
$row=mysql_fetch_array($rs);
$abanner=$row[banner];

$qsql="SELECT * from $db_table where id=$rid ";
$rs=mysql_db_query($sql[db],$qsql);
$row=mysql_fetch_array($rs);
$poster=$row[poster];
$pip=$row[pip];
$wdate=$row[wdate];
$rebanner=$banner=$row[banner];
$body=$row[body];
$body=htmlspecialchars($body);
$pbody=ereg_replace("n","<br>",$body);
$pbody =preg_replace( "/[
$pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", <a href="\1"target="_blank">\2</a>, $pbody );

echo "<center>";
echo "<font color=GREEN size=5><b>[$abanner]<br>";
echo "$banner</b></font></center>";
echo "<TABLE BORDER=0 width=95%align=center cellPadding=1 cellSpacing=0 class=tablefont>";
echo "<TR><TD >";
viewbar();
echo "</td></tr>";
echo "<TR><TD>";
//====ゅ彻==============
echo "<TABLE BORDER=0 width=100%align=center cellPadding=1 cellSpacing=0 class=tablefont>";
echo "<TR>";
echo "<TDwidth=120 align=right>";
echo ":";
echo "</TD>";
echo "<TD align=left>";
echo $poster;
echo "</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD width=120 align=right>";
echo ":";
echo "</TD>";
echo "<TD align=left>";
echo $pip;
echo "</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD width=120 align=right valign=top>";
echo "ゅ彻ず甧:";
echo "</TD>";
echo "<TD valign=top class=bodycolor align=left>";
echo $pbody;
echo "<hr size=1>";
echo "</TD>";
echo "</TR>";
echo "</TD></TR>";
echo "</TABLE>";
echo "<TR><TD >";

//=======籔狟ねだㄉ===============
echo "<TABLE BORDER=0 width=100%align=center cellPadding=3 cellSpacing=0 class=menufont>";
echo "<FORMname=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=mail_friend>";
echo "<input type=hidden name=sid value=$sid>";
echo "<input type=hidden name=aid value=$aid>";
echo "<input type=hidden name=rid value=$rid>";
echo "<input type=hidden name=poster value=$c_poster>";
echo "<input type=hidden name=email value=$c_email>";
echo "<TR>";
echo "<TD align=right width=250>";
echo "籔狟ねだㄉ硂絞ゅ彻:";
echo "</TD>";
echo "<TD>";
echo "<INPUT TYPE=TEXT NAME=frmail size=25 value=ねE-mail>";

echo "<INPUT TYPE=Submitvalue=癳>";
echo "</TD>";
echo "</TR>";
echo "</FORM>";
echo "</TABLE>";
echo "</td></tr>";
echo "<TR><TD >";
//=======mail List===============
echo "<TABLE BORDER=0 width=100%align=center cellPadding=3 cellSpacing=0 class=menufont>";
echo "<FORMname=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=mail_list>";
echo "<input type=hidden name=sid value=$sid>";
echo "<input type=hidden name=aid value=$aid>";
echo "<input type=hidden name=rid value=$rid>";
echo "<input type=hidden name=poster value=$c_poster>";
echo "<input type=hidden name=email value=$c_email>";

echo "<TR >";
echo "<TD align=right width=250>";
echo "璹境o肈尿癚阶:";
echo "</TD>";
echo "<TD>";
if(strlen($c_email)) $addmail=$c_email;
else $addmail="E-mail";
echo "<INPUT TYPE=TEXT NAME=email size=25 value=$addmail>";
echo "<INPUT TYPE=Submit name=way1 value=璹?>";
echo "<INPUT TYPE=Submit name=way2 value=璹?>";
$qsql="SELECT id from bbs_sml where sid=$sid";
$rs=mysql_db_query($sql[db],$qsql);
$nums=mysql_num_rows($rs);
echo "<br>硂肈ヘ玡璹兢H计:$nums";
echo "</TD>";
echo "</TR>";
echo "</FORM>";
echo "</TABLE>";

echo "</td></tr>";
echo "<TR><TD >";
viewbar();
echo "</td></tr>";
echo "</TABLE>";


待续........