bbslist.php

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

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

function ReadList() {
  global $BBS_TABLE,$PAGE_MAX_LINE;
  global $bbsid,$mainid,$blockid,$mood,$title,$size,$writer,
         $writetime,$read_value,$sub_value,$hot_value;
  global $show,$total,$begin,$end,$count;

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

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

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

  $begin= ($total>0) ? $show*$PAGE_MAX_LINE+1 : 0;
  $end= ($total>0) ? ($show+1)*$PAGE_MAX_LINE : 0;

  if ($total>0) {
    $SQL="SELECT bbsid,mainid,mood,title,size,writer,writetime,
                 read_value,sub_value,hot_value
          FROM $BBS_TABLE
          WHERE blockid='$blockid' && bbssub=0
          ORDER BY writetime DESC
          LIMIT $show,$PAGE_MAX_LINE";

    $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];
      $mainid[$i]=$row[mainid];
      $mood[$i]=$row[mood];
      $title[$i]=$row[title];
      $size[$i]=$row[size];
      $writer[$i]=$row[writer];
      $writetime[$i]=$row[writetime];
      $read_value[$i]=$row[read_value];
      $sub_value[$i]=$row[sub_value];
      $hot_value[$i]=$row[hot_value];
    }

    if ($total<$PAGE_MAX_LINE) $end=$total;
  }
}


function PrintList() {
  global $mainid,$mood,$title,$writer,$writetime,$size,$read_value,$sub_value,$hot_value;
  global $id,$blockid,$count;

  for ($i=0;$i<$count;$i++) {
    echo "  <TR class=wdBlack>\n";
    echo "    <TD width=5% height=22 bgcolor=white align=center>";
    echo ($sub_value[$i]!=0) ? "<FONT color=red>[ +".$sub_value[$i]." ]</FONT>" : $size[$i];
    echo "</TD>";
    echo "    <TD width=5% height=22 bgcolor=white align=center>";
    echo ($read_value[$i]>=10) ? "<FONT color=red>".$read_value[$i]."</FONT>" : $read_value[$i];
    echo "</TD>";
    echo "    <TD width=5% height=22 bgcolor=white align=center><IMG src=images/mood".$mood[$i].".gif width=15 height=15></TD>\n";
    echo "    <TD width=60% height=22 bgcolor=white><A href=bbsread.php?id=$id&blockid=$blockid&mainid=$mainid[$i]>";
    echo ($title[$i]) ? $title[$i] : "无主题";
    echo "</TD>";
    echo "    <TD width=10% height=22 bgcolor=white><A href=who.php?id=$id&who=".$writer[$i].">".$writer[$i]."</A></TD>\n";
    echo "    <TD width=15% height=22 bgcolor=white align=center>".date("m.d H:i",$writetime[$i])."</TD>\n";
    echo "  </TR>\n";
  }
}

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

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

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

  ReadUserid();

  if ($userid=="") {
    echo "超时, 请<a href=\"login.php\" target=\"_top\">按此</a>重新登录!";
    exit;
  }

  ReadBlock();
  ReadList();

  if ($userid!=$DEFAULT_USER) $add="<A href=\"bbsadd.php?id=$id&blockid=$blockid\">发表</A>　<A href=\"prime.php?id=$id&blockid=$blockid\">精华区</A>";

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

<TABLE width=100% border=0 align=center>
  <TR class=wdBlack>
    <TD width=30%>　　<? echo ($blockid==0) ? "管理员" : "版主"; ?>： <A href=who.php?who=<? echo $sysop.">".$sysop; ?></A></TD>
    <TD width=40%><? echo ($blockid==0) ? "" : "讨论区："; ?> <FONT color=red><? echo $chinese."( ".$english." )"; ?></FONT></TD>
    <TD width=30%> 第 <FONT color=red><? echo $begin; ?></FONT> 篇 - 第 <FONT color=red><? echo $end; ?></FONT> 篇 共 <FONT color=red><? echo $total; ?></FONT> 篇</TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=100% size=1>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlue>
    <TD width=70%></TD>
    <TD width=30% align=center>　<? echo $add; Page(); ?>　</TD>
  </TR>
</TABLE>

<TABLE width=98% border=0 class=main cellspacing=2 cellpadding=2 align=center bgcolor=<? echo $BODY_COLOR; ?>>
  <TR class=wdBlack>
    <TD width=6% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>回 应</TD>
    <TD width=6% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>人 气</TD>
    <TD width=5% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=58% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>主　　　　　　　　　　　　题</TD>
    <TD width=10% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>作 者</TD>
    <TD width=15% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>时 间</TD>
  </TR>
<? PrintList(); ?>
  <TR class=wdBlack>
    <TD width=6% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=6% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=5% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=58% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=10% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=15% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
  </TR>
</TABLE>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlue>
    <TD width=70%></TD>
    <TD width=30% align=center>　<? echo $add; Page(); ?>　</TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=100% size=1>


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

</BODY>
</HTML>