社区（php&&mysql）三

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>";


待续........