社区(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 "

";
    echo "";

    echo "

";         $nextid=next_subj($sid);         $previd=prev_subj($sid);         echo "[夹肈跋]";         echo "[莱セ絞]";         echo "[祇穝ゅ彻]";         echo "[絞]";         echo "[絞]";         //echo "[程絞]";     echo "

";     

}
//======================================================================
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","
",$body);
    $pbody =preg_replace( "/[www *]([\x0-\xff]*?)[/www *]/", '\1', $pbody );  
    $pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", '\2', $pbody );  

    echo "";
    echo "[$abanner]
";
    echo "$banner ";
    echo "";
            echo "";
            echo "";
            echo "";
            echo "";
        echo "

";                 viewbar();             echo "

";             //====ゅ彻==============             echo "";             echo "";                 echo "";                 echo "";             echo "";             echo "";                 echo "";                 echo "";             echo "";             echo "";                 echo "";                 echo "";             echo "";             echo "";             echo " ";                     echo ":";                 echo " ";                     echo $poster;                 echo " ";                     echo "ㄓ:";                 echo " ";                     echo $pip;                 echo " ";                     echo "ゅ彻ず甧:";                 echo " ";                             echo $pbody;                             echo " ";                 echo " ";             echo "

";                 //=======籔狟ねだㄉ===============                 echo "";                      echo "";                 echo "";                 echo "";                 echo "";                 echo "";                 echo "";                     echo "";                        echo "";                        echo "";                     echo "";                 echo "";                      echo " ";                         echo "籔狟ねだㄉ硂絞ゅ彻:";                        echo " ";                         echo "";                         echo "";                        echo " ";                              echo "

";                 //=======mail List===============             echo "";                  echo "";                 echo "";                 echo "";                 echo "";                 echo "";                 echo "";             echo "";                echo "";                echo "";             echo "";                  echo "";             echo " ";                 echo "璹境o肈尿癚阶:";                echo " ";                 if(strlen($c_email)) $addmail=$c_email;                 else $addmail="E-mail";                 echo "";                 echo "                $rs=mysql_db_query($sql['db'],$qsql);                 $nums=mysql_num_rows($rs);                 echo " 硂肈ヘ玡璹兢H计:$nums";                echo " ";                  echo "

";                 viewbar();             echo "

";

         
待续........