board.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 495 行

PHP
495 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $PAGE_SIZE = 10;
  echo '
<html>
<head>
<title>讨论区</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function set_page()
{
 PAGE_START=(PAGE_NUM.value-1)*';
  echo $PAGE_SIZE;
  echo '+1;
 location="board.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '&PAGE_START="+PAGE_START;
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $query = (((''.'SELECT * from BBS_BOARD where BOARD_ID=\'').$BOARD_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DEPT_ID = $ROW['DEPT_ID'];
    $PRIV_ID = $ROW['PRIV_ID'];
    $USER_ID1 = $ROW['USER_ID'];
    $BOARD_HOSTER = $ROW['BOARD_HOSTER'];
    $BOARD_NAME = $ROW['BOARD_NAME'];
    $WELCOME_TEXT = $ROW['WELCOME_TEXT'];
    $ANONYMITY_YN = $ROW['ANONYMITY_YN'];
    $BOARD_NAME = str_replace ('<', '&lt', $BOARD_NAME);
    $BOARD_NAME = str_replace ('>', '&gt', $BOARD_NAME);
    $BOARD_NAME = stripslashes ($BOARD_NAME);
    $WELCOME_TEXT = str_replace ('<', '&lt', $WELCOME_TEXT);
    $WELCOME_TEXT = str_replace ('>', '&gt', $WELCOME_TEXT);
    $WELCOME_TEXT = stripslashes ($WELCOME_TEXT);
  }
  if (!((((($DEPT_ID == 'ALL_DEPT') OR find_id ($DEPT_ID, $LOGIN_DEPT_ID)) OR find_id ($PRIV_ID, $LOGIN_USER_PRIV)) OR find_id ($USER_ID1, $LOGIN_USER_ID)) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID)))
  {
    exit ();
  }
  $BOARD_HOSTER_NAME = '';
  $TOK = strtok ($BOARD_HOSTER, ',');
  while (($TOK != ''))
  {
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$TOK).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      ($BOARD_HOSTER_NAME .= ($ROW['USER_NAME'].','));
    }
    $TOK = strtok (',');
  }
  $BOARD_HOSTER_NAME = substr ($BOARD_HOSTER_NAME, 0, -1);
  $query = (((''.'SELECT count(*) from BBS_COMMENT where BOARD_ID=\'').$BOARD_ID).'\' and PARENT=0');
  $cursor = exequery ($connection, $query);
  $COMMENT_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $COMMENT_COUNT = $ROW[0];
  }
  if (($COMMENT_COUNT == 0))
  {
    echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/bbs.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><a href="index.php">';
    echo '<s';
    echo 'pan class="big3">讨论区</span></a>';
    echo '<s';
    echo 'pan class="big3"> - </span><a href="board.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '">';
    echo '<s';
    echo 'pan class="big3">';
    echo $BOARD_NAME;
    echo '</span></a><br>
    </td>
  </tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
  <tr>
      <td class="small1">';
    echo $WELCOME_TEXT;
    echo '</td>
      <td valign="bottom" class="small1">版主：';
    echo $BOARD_HOSTER_NAME;
    echo '&nbsp;
      <td nowrap align="right">
          <input type="button"  value="发帖" class="SmallButton" onClick="location=\'edit.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '\';" title="发表新文章">&nbsp;
          <input type="button"  value="积分榜" class="SmallButton" onClick="location=\'user_top.php\';" title="积分排行榜">&nbsp;
          <input type="button"  value="其它讨论区" class="SmallButton" onClick="location=\'index.php\';" title="返回讨论区目录">
      </td>
  </tr>
</table>
<br>
';
    message ('', '该讨论区尚无文章');
    exit ();
  }
  $PAGE_TOTAL = ($COMMENT_COUNT / $PAGE_SIZE);
  $PAGE_TOTAL = ceil ($PAGE_TOTAL);
  if (($COMMENT_COUNT <= $PAGE_SIZE))
  {
    $LAST_PAGE_START = 1;
  }
  else
  {
    if ((($COMMENT_COUNT % $PAGE_SIZE) == 0))
    {
      $LAST_PAGE_START = (($COMMENT_COUNT - $PAGE_SIZE) + 1);
    }
    else
    {
      $LAST_PAGE_START = (($COMMENT_COUNT - ($COMMENT_COUNT % $PAGE_SIZE)) + 1);
    }
  }
  if (($PAGE_START == ''))
  {
    $PAGE_START = 1;
  }
  if (($COMMENT_COUNT < $PAGE_START))
  {
    $PAGE_START = $LAST_PAGE_START;
  }
  if (($PAGE_START < 1))
  {
    $PAGE_START = 1;
  }
  $PAGE_END = (($PAGE_START + $PAGE_SIZE) - 1);
  if (($COMMENT_COUNT < $PAGE_END))
  {
    $PAGE_END = $COMMENT_COUNT;
  }
  $PAGE_NUM = ((($PAGE_START - 1) / $PAGE_SIZE) + 1);
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/bbs.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><a href="index.php">';
  echo '<s';
  echo 'pan class="big3">讨论区</span></a>';
  echo '<s';
  echo 'pan class="big3"> - </span><a href="board.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '">';
  echo '<s';
  echo 'pan class="big3">';
  echo $BOARD_NAME;
  echo '</span></a><br>
    </td>
    <td valign="bottom" class="small1">共';
  echo '<s';
  echo 'pan class="big4">&nbsp;';
  echo $COMMENT_COUNT;
  echo '</span>&nbsp;篇文章
    </td>
    <td valign="bottom" class="small1">
    当前为第<b>';
  echo $PAGE_START;
  echo '</b>至<b>';
  echo $PAGE_END;
  echo '</b>篇 (第';
  echo $PAGE_NUM;
  echo '页，共';
  echo $PAGE_TOTAL;
  echo '页，每页最多';
  echo $PAGE_SIZE;
  echo '篇)</font>
    </td>
    </tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
  <tr>
      <td class="small1">';
  echo $WELCOME_TEXT;
  echo '</font></td>
      <td valign="bottom" class="small1">版主：';
  echo $BOARD_HOSTER_NAME;
  echo '&nbsp;
      </td>
      <td nowrap align="right">
          <input type="button"  value="发帖" class="SmallButton" onClick="location=\'edit.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '\';" title="发表新文章">&nbsp;
          <input type="button"  value="搜索" class="SmallButton" onClick="location=\'query.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '\';" title="搜索文章">&nbsp;
          <input type="button"  value="热门文章" class="SmallButton" onClick="location=\'comment_top.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '\';" title="热门文章">&nbsp;
          <input type="button"  value="积分榜" class="SmallButton" onClick="location=\'user_top.php\';" title="积分排行榜">&nbsp;
          <input type="button"  value="其它讨论区" class="SmallButton" onClick="location=\'index.php\';" title="返回讨论区目录">
      </td>
  </tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadd';
  echo 'ing="3">
  <tr class="TableHeader">
      <td nowrap align="center">作者</td>
';
  if ((($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID)))
  {
    echo '      <td nowrap align="center">实名</td>
';
  }
  echo '      <td nowrap align="center">标题</td>
      <td nowrap align="center">最近回复者</td>
      <td nowrap align="center">字节</td>
      <td nowrap align="center">阅</td>
      <td nowrap align="center">回</td>
      <td align="center">发表时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center">操作</td>
  </tr>
';
  $query = (((''.'SELECT * from BBS_COMMENT where BOARD_ID=\'').$BOARD_ID).'\' and PARENT=\'0\' order by TOP desc,SUBMIT_TIME desc');
  $cursor = exequery ($connection, $query);
  $COMMENT_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$COMMENT_COUNT;
    if (($COMMENT_COUNT < $PAGE_START))
    {
      continue;
    }
    if (($PAGE_END < $COMMENT_COUNT))
    {
      break;
    }
    $COMMENT_ID = $ROW['COMMENT_ID'];
    $USER_ID = $ROW['USER_ID'];
    $TOP = $ROW['TOP'];
    $JING = $ROW['JING'];
    $READEDER = $ROW['READEDER'];
    $AUTHOR_NAME = $ROW['AUTHOR_NAME'];
    $SUBJECT = $ROW['SUBJECT'];
    $SUBMIT_TIME = $ROW['SUBMIT_TIME'];
    $OLD_SUBMIT_TIME = $ROW['OLD_SUBMIT_TIME'];
    if (($OLD_SUBMIT_TIME == '0000-00-00 00:00:00'))
    {
      $OLD_SUBMIT_TIME = $SUBMIT_TIME;
    }
    $READ_CONT = $ROW['READ_CONT'];
    $REPLY_CONT = $ROW['REPLY_CONT'];
    $CONTENT = $ROW['CONTENT'];
    $CONTENT_SIZE = strlen ($CONTENT);
    $CONTENT_SIZE = number_format ($CONTENT_SIZE, 0, '.', ',');
    $AUTHOR_NAME = str_replace ('<', '&lt', $AUTHOR_NAME);
    $AUTHOR_NAME = str_replace ('>', '&gt', $AUTHOR_NAME);
    $AUTHOR_NAME = stripslashes ($AUTHOR_NAME);
    $SUBJECT = str_replace ('<', '&lt', $SUBJECT);
    $SUBJECT = str_replace ('>', '&gt', $SUBJECT);
    $SUBJECT = stripslashes ($SUBJECT);
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $AVATAR = $ROW['AVATAR'];
      $USER_NAME = $ROW['USER_NAME'];
    }
    else
    {
      $USER_NAME = $USER_ID;
      $AVATAR = '';
    }
    $query1 = (((''.'SELECT * from BBS_COMMENT where PARENT=\'').$COMMENT_ID).'\' order by SUBMIT_TIME desc limit 1');
    $cursor1 = exequery ($connection, $query1);
    $AUTHOR_NAME1 = '';
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $AUTHOR_NAME1 = $ROW['AUTHOR_NAME'];
    }
    if ((($COMMENT_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '  <tr class="';
    echo $TableLine;
    echo '">
    <td width="90" nowrap>
';
    if (($USER_NAME == $AUTHOR_NAME))
    {
      echo '    <img src="/images/avatar/';
      echo $AVATAR;
      echo '.gif" ';
      echo avatar_size ($AVATAR);
      echo ' align="absmiddle">
';
    }
    if ((($ANONYMITY_YN == 0) AND ($USER_NAME != $AUTHOR_NAME)))
    {
      echo '    ';
      echo $USER_NAME;
      echo '</td>
';
    }
    else
    {
      echo '    ';
      echo $AUTHOR_NAME;
      echo '</td>
';
    }
    if ((($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID)))
    {
      echo '     <td align="center" width="60" nowrap>';
      echo $USER_NAME;
      echo '</td>
';
    }
    if (($TOP == '1'))
    {
      $SUBJECT = (('<font color=red><b>'.$SUBJECT).'</b></font>');
    }
    echo '      <td>
      	<a href="comment.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '&COMMENT_ID=';
    echo $COMMENT_ID;
    echo '&PAGE_START=';
    echo $PAGE_START;
    echo '">';
    echo $SUBJECT;
    echo '</a>
';
    if (!find_id ($READEDER, $LOGIN_USER_ID))
    {
      echo '<img src=\'/images/new.gif\' height=11 width=28>    ';
    }
    if (($JING == 1))
    {
      echo '<img src=\'/images/jing.gif\' height=11 width=15>';
    }
    echo '
      </td>
      <td align="center">';
    echo $AUTHOR_NAME1;
    echo '</td>
      <td align="center" width="30" nowrap>';
    echo $CONTENT_SIZE;
    echo '</td>
      <td align="center" width="10" nowrap>';
    echo $READ_CONT;
    echo '</td>
      <td align="center" width="10" nowrap>';
    echo $REPLY_CONT;
    echo '</td>
      <td align="center" width="130" nowrap>';
    echo $OLD_SUBMIT_TIME;
    echo '</td>
      <td align="center" width="120" nowrap>
';
    if (((($USER_ID == $LOGIN_USER_ID) OR ($LOGIN_USER_PRIV == 1)) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID)))
    {
      echo '         <a href="javascript:;" onClick="window.open(\'move.php?BOARD_ID=';
      echo $BOARD_ID;
      echo '&COMMENT_ID=';
      echo $COMMENT_ID;
      echo '\',\'\',\'height=200,width=250,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=350,top=150,resizable=yes\');">转移</a>&nbsp;
         <a href="edit.php?BOARD_ID=';
      echo $BOARD_ID;
      echo '&COMMENT_ID=';
      echo $COMMENT_ID;
      echo '&PAGE_START=';
      echo $PAGE_START;
      echo '">编辑</a>&nbsp;
         <a href="javascript:delete_comment(';
      echo $COMMENT_ID;
      echo ');">删除</a><br>
';
      if ((($TOP == 0) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_top.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&TOP=1&BOARD_ID=';
        echo $BOARD_ID;
        echo '">置顶</a>&nbsp;
';
      }
      if ((($TOP == 1) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_top.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&TOP=0&BOARD_ID=';
        echo $BOARD_ID;
        echo '">取消置顶</a>
';
      }
      if ((($JING == 0) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_jing.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&JING=1&BOARD_ID=';
        echo $BOARD_ID;
        echo '">设置精华</a>&nbsp;
';
      }
      if ((($JING == 1) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_jing.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&JING=0&BOARD_ID=';
        echo $BOARD_ID;
        echo '">取消精华</a>&nbsp;
';
      }
    }
    echo '      </td>
  </tr>
';
  }
  if ((0 < $COMMENT_COUNT))
  {
    echo '  <tr class="TableControl">
  <td colspan="9" align="right">
     <input type="button"  value="首页" class="SmallButton"  ';
    if (($PAGE_START == 1))
    {
      echo 'disabled';
    }
    echo ' onclick="location=\'board.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '\'"> &nbsp;&nbsp;
     <input type="button"  value="上一页" class="SmallButton" ';
    if (($PAGE_START == 1))
    {
      echo 'disabled';
    }
    echo ' onclick="location=\'board.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '&PAGE_START=';
    echo ($PAGE_START - $PAGE_SIZE);
    echo '\'"> &nbsp;&nbsp;
     <input type="button"  value="下一页" class="SmallButton" ';
    if (($COMMENT_COUNT <= $PAGE_END))
    {
      echo 'disabled';
    }
    echo ' onclick="location=\'board.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '&PAGE_START=';
    echo ($PAGE_END + 1);
    echo '\'"> &nbsp;&nbsp;
     <input type="button"  value="末页" class="SmallButton"  ';
    if (($COMMENT_COUNT <= $PAGE_END))
    {
      echo 'disabled';
    }
    echo ' onclick="location=\'board.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '&PAGE_START=';
    echo $LAST_PAGE_START;
    echo '\'"> &nbsp;&nbsp;
     页数
     <input type="text" name="PAGE_NUM" value="';
    echo $PAGE_NUM;
    echo '" class="SmallInput" size="2"> <input type="button"  value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">&nbsp;&nbsp;
  </td>
  </tr>
</table>
';
  }
  echo '
';
  echo '<s';
  echo 'cript>
function delete_comment(COMMENT_ID)
{
  msg="确定要删除该文章吗?";
  if(window.confirm(msg))
  {
    URL="delete.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '&PAGE_START=';
  echo $PAGE_START;
  echo '&COMMENT_ID=" + COMMENT_ID;
    window.location=URL;
  }
}
</script>
</body>
</html>';
?>

board.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 board.php 源码文件，采用 PHP 编程语言编写，共 495 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?