okbbs.php

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

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


function ReadBlockInfo($blockid) {
  global $BLOCK_TABLE;
  global $english,$chinese;

  $SQL="SELECT * FROM $BLOCK_TABLE WHERE blockid='$blockid'";

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

  $row=mysql_fetch_Array($result);

  $english=$row[english];
  $chinese=$row[chinese];
}


function ReadList() {
  global $BBS_TABLE,$PAGE_MAX_LINE;
  global $bbsid,$mainid,$blockid,$mood,$title,$size,$writer,
         $writetime,$read_value,$sub_value,$hot_value;
  global $count,$block,$chinese;

  $SQL="SELECT bbsid,mainid,blockid,mood,title,size,writer,writetime,
                 read_value,sub_value,hot_value
          FROM $BBS_TABLE
          WHERE bbssub=0
          ORDER BY read_value DESC
          LIMIT 0,10";

  $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];
      $blockid[$i]=$row[blockid];
      ReadBlockInfo($blockid[$i]);
      $block[$i]=$chinese;
  }
}


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

  for ($i=0;$i<$count;$i++) {
//    if (date("m.d",$writetime[$i])==date("m.d")) {
      echo "  <TR class=wdBlack>\n";
      echo "    <TD width=18% height=22 bgcolor=white align=center>$block[$i]</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=50% height=22 bgcolor=white><A href=bbsread.php?id=$id&blockid=$blockid[$i]&mainid=$mainid[$i]>";
      echo ($title[$i]) ? $title[$i] : "无主题";
      echo "</TD>";
      echo "    <TD width=12% height=22 bgcolor=white><A href=who.php?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";
//    }
  }
}

  ReadUserid();

  ReadList();

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

<TABLE width=95% border=0 align=center>
  <TR class=wdBlack>
    <TD width=25%>　<FONT class=wdBlue>●</FONT> 今日社区十大人气贴</TD>
    <TD width=50%>&nbsp;</TD>
    <TD width=25% align=center></TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=92% size=1>
<BR>
<TABLE width="90%" border="0" align="center" bgcolor="white" class="wdBlack">
  <TR bgcolor=<? echo $HEADER_COLOR; ?>>
    <TD width=18% height=20 align=center>版 区</TD>
    <TD width=5% height=20>&nbsp;</TD>
    <TD width=50% height=20 align=center>主　　　　　　　　　　　　题</TD>
    <TD width=12% height=20 align=center>作 者</TD>
    <TD width=15% height=20 align=center>时 间</TD>
  </TR>
  <? PrintList(); ?>
  <TR bgcolor=<? echo $HEADER_COLOR; ?>>
    <TD width=18% height=20 align=center>版 区</TD>
    <TD width=5% height=20>&nbsp;</TD>
    <TD width=50% height=20 align=center>主　　　　　　　　　　　　题</TD>
    <TD width=12% height=20 align=center>作 者</TD>
    <TD width=15% height=20 align=center>时 间</TD>
  </TR>
</TABLE>
<BR>
<DIV align="center"><a href="<? echo "bbsdefault.php?id=$id"; ?>">&lt;&lt;返回&gt;&gt;</a></DIV>

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

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

</BODY>
</HTML>