comment.php

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

PHP
281
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>讨论区 - 读文章</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  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>
</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_NAME = $ROW['BOARD_NAME'];
    $ANONYMITY_YN = $ROW['ANONYMITY_YN'];
    $BOARD_HOSTER = $ROW['BOARD_HOSTER'];
    $BOARD_NAME = str_replace ('<', '&lt', $BOARD_NAME);
    $BOARD_NAME = str_replace ('>', '&gt', $BOARD_NAME);
    $BOARD_NAME = stripslashes ($BOARD_NAME);
  }
  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 ();
  }
  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>';
  echo '<s';
  echo 'pan class="big3"> - 查看文章</span><br>
    </td>
  </tr>
</table>
<br>
<table border="0" cellspacing="1" width="90%" class="small" bgcolor="#000000" cellpadding="3" align="center">
';
  $query = ((''.'update BBS_COMMENT set READ_CONT=READ_CONT+1 where COMMENT_ID=').$COMMENT_ID);
  $cursor = exequery ($connection, $query);
  $query = (((((''.'SELECT * from BBS_COMMENT where COMMENT_ID=').$COMMENT_ID).' OR PARENT=').$COMMENT_ID).' ORDER BY PARENT,COMMENT_ID');
  $cursor = exequery ($connection, $query);
  $COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$COUNT;
    $BOARD_ID = $ROW['BOARD_ID'];
    $COMMENT_ID = $ROW['COMMENT_ID'];
    $USER_ID = $ROW['USER_ID'];
    $AUTHOR_NAME = $ROW['AUTHOR_NAME'];
    $SUBJECT = $ROW['SUBJECT'];
    $CONTENT = $ROW['CONTENT'];
    $SUBMIT_TIME = $ROW['SUBMIT_TIME'];
    $READEDER = $ROW['READEDER'];
    $OLD_SUBMIT_TIME = $ROW['OLD_SUBMIT_TIME'];
    if (($OLD_SUBMIT_TIME == '0000-00-00 00:00:00'))
    {
      $OLD_SUBMIT_TIME = $SUBMIT_TIME;
    }
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    if (($COUNT == 1))
    {
      $SUBMIT_TIME = $OLD_SUBMIT_TIME;
    }
    else
    {
      $SUBMIT_TIME = $SUBMIT_TIME;
    }
    $PARENT = $ROW['PARENT'];
    $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))
    {
      $USER_NAME = $ROW['USER_NAME'];
    }
    if (!find_id ($READEDER, $LOGIN_USER_ID))
    {
      ($READEDER .= ($LOGIN_USER_ID.','));
      $query1 = (((((''.'update BBS_COMMENT set READEDER=\'').$READEDER).'\' where COMMENT_ID=\'').$COMMENT_ID).'\'');
      exequery ($connection, $query1);
    }
    if (($PARENT == 0))
    {
      $COMMENT_ID_ROOT = $COMMENT_ID;
    }
    $CONTENT = stripslashes ($CONTENT);
    echo '    <tr class="TableHeader">
      <td>
      ';
    echo '<s';
    echo 'pan class="big">';
    echo $SUBJECT;
    echo '</span>
      </td>
      <td nowrap width="10%" align="right">
        <input type="button" value="回复" class="SmallButton" onclick="location=\'edit.php?REPLY=1&BOARD_ID=';
    echo $BOARD_ID;
    echo '&COMMENT_ID=';
    echo $COMMENT_ID_ROOT;
    echo '&PAGE_START=';
    echo $PAGE_START;
    echo '\';" title="回复此文章">
';
    if (($LOGIN_USER_ID == $USER_ID))
    {
      echo '        <input type="button" value="编辑" class="SmallButton" onclick="location=\'edit.php?BOARD_ID=';
      echo $BOARD_ID;
      echo '&COMMENT_ID=';
      echo $COMMENT_ID;
      echo '&PAGE_START=';
      echo $PAGE_START;
      echo '\';" title="编辑此文章">
';
    }
    if (((($USER_ID == $LOGIN_USER_ID) OR ($LOGIN_USER_PRIV == 1)) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID)))
    {
      echo '        <input type="button" value="删除" class="SmallButton" onclick="delete_comment(\'';
      echo $COMMENT_ID;
      echo '\');" title="删除此文章">
';
    }
    echo '    </td>
    </tr>
    <tr class="TableData">
      <td colspan="2">';
    echo $CONTENT;
    echo '      <br><br><b>作者:
';
    if ((($ANONYMITY_YN == 0) AND ($USER_NAME != $AUTHOR_NAME)))
    {
      echo '      ';
      echo $USER_NAME;
      echo '</b>&nbsp;&nbsp;<i>';
      echo $SUBMIT_TIME;
      echo '</i>
';
    }
    else
    {
      echo '      ';
      if (($LOGIN_USER_PRIV == 1))
      {
        echo $USER_NAME;
      }
      echo '  [昵称:';
      echo $AUTHOR_NAME;
      echo ']</b>&nbsp;&nbsp;<i>';
      echo $SUBMIT_TIME;
      echo '</i>
';
    }
    if (($ATTACHMENT_NAME != ''))
    {
      echo '      <br><b>附件:</b>
';
      $ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
      $ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
      $IMG_TYPE_STR = 'gif,jpg,png,tiff,bmp,iff,jp2,jpx,jb2,jpc,xbm,wbmp,';
      $ARRAY_COUNT = sizeof ($ATTACHMENT_ID_ARRAY);
      for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
      {
        if (($ATTACHMENT_ID_ARRAY[$I] == ''))
        {
          break;
        }
        $ATTACH_SIZE = attach_size ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
        $ATTACH_SIZE = number_format ($ATTACH_SIZE, 0, '.', ',');
        echo '           <img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=';
        echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
        echo '&ATTACHMENT_NAME=';
        echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
        echo '">';
        echo $ATTACHMENT_NAME_ARRAY[$I];
        echo '</a> (';
        echo $ATTACH_SIZE;
        echo '字节)
';
        if (((stristr ($ATTACHMENT_NAME_ARRAY[$I], '.doc') OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.ppt')) OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.xls')))
        {
          echo '	       <input type="button" value="阅读" class="SmallButton" onClick="window.open(\'/module/OC?ATTACHMENT_ID=';
          echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
          echo '&ATTACHMENT_NAME=';
          echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
          echo '&OP=5\',\'';
          echo $ATTACHMENT_ID_ARRAY[$I];
          echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">&nbsp;
';
        }
        else
        {
          if (is_media ($ATTACHMENT_NAME_ARRAY[$I]))
          {
            echo '	       <input type="button" value="播放" class="SmallButton" onClick="window.open(\'/module/mediaplayer/index.php?MEDIA_NAME=';
            echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
            echo '&MEDIA_URL=';
            echo urlencode (((('/inc/attach.php?ATTACHMENT_ID='.(($ATTACHMENT_ID_ARRAY[$I] * 3) + 2)).'&ATTACHMENT_NAME=').urlencode ($ATTACHMENT_NAME_ARRAY[$I])));
            echo '\',\'media';
            echo $ATTACHMENT_ID_ARRAY[$I];
            echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">&nbsp;
';
          }
        }
        $EXT_NAME = substr (strrchr ($ATTACHMENT_NAME_ARRAY[$I], '.'), 1);
        $EXT_NAME = strtolower ($EXT_NAME);
        if (find_id ($IMG_TYPE_STR, $EXT_NAME))
        {
          $IMG_ATTR = getimagesize (((($ATTACH_PATH.$ATTACHMENT_ID_ARRAY[$I]).'/').$ATTACHMENT_NAME_ARRAY[$I]));
          $IMG_WIDTH = $IMG_ATTR[0];
          if ((600 < $IMG_WIDTH))
          {
            $IMG_WIDTH = 600;
          }
          echo '         <br><img src="/inc/attach.php?ATTACHMENT_ID=';
          echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
          echo '&ATTACHMENT_NAME=';
          echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
          echo '" border="0" width="';
          echo $IMG_WIDTH;
          echo '" alt="文件名:';
          echo $ATTACHMENT_NAME_ARRAY[$I];
          echo '">
';
        }
        echo '<br>';
      }
    }
    echo '     <br>
     </td>
    </tr>
';
  }
  echo '  </table>
  <br>
  <div align="center">
  <input type="button" value="返回" class="BigButton" onClick="location=\'board.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '&PAGE_START=';
  echo $PAGE_START;
  echo '\';">
  </div>
</body>
</html>';
?>

⌨️ 快捷键说明

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