bbsread.php

这是使用ＰＨＰ编程的虚拟社区ＭySQL的简易版

<?
  include "config.inc.php";
  include "func.php";

function ReadArticle() {
  global $BBS_TABLE,$PAGE_MAX_READ;
  global $bbsid,$mainid,$blockid,$mood,$title,$content,$writer,$signature,
         $writetime,$read_value,$bbsprime;
  global $show,$total,$count;

  if (!isset($show)) $show=0;

  $SQL="SELECT Count(*) AS total FROM $BBS_TABLE WHERE blockid='$blockid' && mainid='$mainid'";

  $result=mysql_query($SQL) or die(mysql_error());
  $row=mysql_fetch_Array($result);
  $total=$row[total];

  $SQL="SELECT bbsid,mainid,blockid,mood,title,content,writer,signature,writetime,read_value,bbsprime
        FROM $BBS_TABLE
        WHERE blockid='$blockid' && mainid='$mainid'
        ORDER BY writetime
        LIMIT $show,$PAGE_MAX_READ";

  $result=mysql_query($SQL) or die(mysql_error());

  $count=mysql_numrows($result);

  for ($i=0;$i<$count;$i++) {
    $row=mysql_fetch_Array($result);

    $bbsid[$i]=$row[bbsid];
    $mood[$i]=$row[mood];
    $title[$i]=$row[title];
    $content[$i]=ReadReplace($row[content]);
    $writer[$i]=$row[writer];
    $signature[$i]=$row[signature];
    $writetime[$i]=$row[writetime];
    if ($i==0) $read_value=$row[read_value];
    $bbsprime[$i]=$row[bbsprime];
  }

  $read_value++;

  $SQL="UPDATE $BBS_TABLE SET read_value='$read_value' WHERE blockid='$blockid' && mainid='$mainid'";

  $result=mysql_query($SQL) or die(mysql_error());
}


function PrintContents() {
  global $ADMIN,$DEFAULT_USER,$BODY_COLOR;
  global $bbsid,$mood,$title,$content,$writer,$writetime,$signature,$bbsprime;
  global $id,$userid,$blockid,$mainid,$sysop,$count;

  for ($i=0;$i<$count;$i++) {
    $This="?id=$id&blockid=$blockid&mainid=$mainid&bbsid=".$bbsid[$i];
    if ($bbsprime[$i]==1) $Op="<FONT color=red>★</FONT> 精华文章";
    else {
      switch ($userid) {
        case $ADMIN:
          if ($blockid==0) $Op="<A href=bbsdel.php$This>删除</A>　<A href=bbsedit.php$This>修改</A>　<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
          else $Op="<A href=bbsprime.php$This>加入精华区</A>　<A href=bbsdel.php$This>删除</A>　<A href=bbsedit.php$This>修改</A>　<a href=bbscopy.php$This>转贴</a>　<A href=bbsdown.php$This>打包</A>　<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
          break;
        case $sysop:
          if ($blockid==0) $Op="<A href=bbsdel.php$This>删除</A>　<A href=bbsedit.php$This>修改</A>　<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
          else {
            if ($userid!=$writer[$i]) $Op="<A href=bbsprime.php$This>加入精华区</A>　<A href=bbsdel.php$This>删除</A>　<a href=bbscopy.php$This>转贴</a>　<A href=bbsdown.php$This>打包</A>　<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
            else $Op="<A href=bbsprime.php$This>加入精华区</A>　<A href=bbsdel.php$This>删除</A>　<A href=bbsedit.php$This>修改</A>　<a href=bbscopy.php$This>转贴</a>";
          }
          break;
        case $writer[$i]:
          if ($blockid==0) $Op="<A href=bbsdel.php$This>删除</A>　<A href=bbsedit.php$This>修改</A>　<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
          else $Op="<A href=bbsdel.php$This>删除</A>　<A href=bbsedit.php$This>修改</A>　<a href=bbscopy.php$This>转贴</a>　<A href=bbsdown.php$This>打包</A>　<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
          break;
        case $DEFAULT_USER:
          $Op="";
          break;
        default:
          if ($blockid==0) $Op="<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
          else $Op="<a href=bbscopy.php$This>转贴</a>　<A href=bbsdown.php$This>打包</A>　<A href=bbsreply.php$This&writer=$writer[$i]>回应</A>";
          break;
      }
    }
    echo "<HR color=#E3E3E3 noshade width=98% size=1>\n";
    echo "<TABLE width=98% border=0 cellspacing=0 cellpadding=0 align=center bgcolor=$BODY_COLOR>\n";
    echo "  <TR class=wdBlack>\n";
    echo "    <TD width=3% height=20 bgcolor=white>&nbsp;</TD>\n";
    echo "    <TD width=50% height=20 bgcolor=white><IMG src=images/mood$mood[$i].gif align=absmiddle>　作者：<A href=who.php?id=$id&who=$writer[$i]>$writer[$i]</A>　　　时间： ".date("Y.m.d H:i",$writetime[$i])."</TD>\n";
    echo "    <TD width=44% height=20 bgcolor=white align=right>$Op</TD>\n";
    echo "    <TD width=3% height=20 bgcolor=white>&nbsp;</TD>\n";
    echo "  </TR>\n";
    echo "  <TR class=Text>\n";
    echo "    <TD width=3% height=85>&nbsp;</TD>\n";
    echo "    <TD height=85 colspan=2 valign=top><BR>".ReadProc($content[$i],1)."<BR>--<BR>".ReadProc($signature[$i],0)."</TD>\n";
    echo "    <TD height=85 width=3%>&nbsp;</TD>\n";
    echo "  </TR>\n";
    echo "  <TR class=wdBlack>\n";
    echo "    <TD width=3% height=30>&nbsp;</TD>\n";
    echo "    <TD height=30 colspan=2><FONT color=red>$TITLE</FONT></TD>\n";
    echo "    <TD width=3% height=30>&nbsp;</TD>\n";
    echo "  </TR>\n";
    echo "</TABLE>\n";
  }
}

function Page() {
  global $PAGE_MAX_READ;
  global $id,$blockid,$mainid,$show,$total;

  $next=$show+$PAGE_MAX_READ;
  $prev=$show-$PAGE_MAX_READ;

  if ($prev>=0) echo "　<A href=\"$PHP_SELF?id=$id&blockid=$blockid&mainid=$mainid&show=$prev\"><FONT color=red> &lt;&lt; </FONT></A>";
  if ($next<$total) echo "　<A href=\"$PHP_SELF?id=$id&blockid=$blockid&mainid=$mainid&show=$next\"><FONT color=red> &gt;&gt; </FONT></A>";
}

  ReadUserid();
  ReadBlock();
  ReadArticle();

  include "header.inc.php";
  include "ad.php";
?>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlack>
    <TD width=40%>　主题： <FONT color=red><? echo $title[0]; ?></FONT></TD>
    <TD width=40%>讨论区： <FONT color=red><? echo $chinese."( ".$english." )"; ?></FONT></TD>
    <TD width=20% align=center>同主题阅读：　共 <FONT color=red><? echo $total; ?></FONT> 篇</TD>
  </TR>
</TABLE>

<TABLE width=100% border=0 align=center bgcolor=<? echo $HEADER_COLOR; ?>>
  <TR>
    <TD width=80% class=wdBlack></TD>
    <TD width=20% class=wdBlue align=center><? Page(); ?>　<a href="<? echo "bbslist.php?id=$id&blockid=$blockid"; ?>"><FONT color=red>返回</FONT></a></TD>
  </TR>
</TABLE>

<? PrintContents(); ?>

<BR>

<TABLE width=100% border=0 align=center bgcolor=<? echo $HEADER_COLOR; ?>>
  <TR>
    <TD width=80% class=wdBlack></TD>
    <TD width=20% class=wdBlue align=center><? Page(); ?>　<a href="<? echo "bbslist.php?id=$id&blockid=$blockid"; ?>"><FONT color=red>返回</FONT></a></TD>
  </TR>
</TABLE>

<DIV class=wdBlack align=center><? echo $COPYRIGHT; ?></DIV><BR>

</BODY>
</HTML>