社区(php&&mysql)三-软之星SOFT

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( "/[www *]([x0-xff]*?)[/www *]/", "<a href="1" target="_blank">1</a>", $pbody ); $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 "<TD width="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 "<FORM name=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="Submit"value="癳?">"; 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 "<FORM name=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>"; 待续........