📄 comment.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/conn.php");
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>讨论区 - 读文章</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function delete_comment(COMMENT_ID)
{
  msg="确定要删除该文章吗?";
  if(window.confirm(msg))
  {
    URL="delete.php?BOARD_ID=<?=$BOARD_ID?>&PAGE_START=<?=$PAGE_START?>&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"];
   $BOARD_NAME = $ROW["BOARD_NAME"];
   $ANONYMITY_YN = $ROW["ANONYMITY_YN"];

   $BOARD_NAME=str_replace("<","&lt",$BOARD_NAME);
   $BOARD_NAME=str_replace(">","&gt",$BOARD_NAME);
   $BOARD_NAME=stripslashes($BOARD_NAME);
 }
?>

<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"><span class="big3"> 讨论区</span></a><span class="big3"> - </span><a href="board.php?BOARD_ID=<?=$BOARD_ID?>"><span class="big3"><?=$BOARD_NAME?></span></a><span class="big3"> - 查看文章</span><br>
    </td>
  </tr>
</table>

<br>


<table border="0" cellspacing="1" width="90%" class="small" bgcolor="#000000" cellpadding="3" align="center">

<?
 //-------- 阅读数加1 ---------
 $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"];
   $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($PARENT == 0)
      $COMMENT_ID_ROOT=$COMMENT_ID;

   $CONTENT=stripslashes($CONTENT);
?>
    <tr class="TableHeader">
      <td>
      <span class="big"><?=$SUBJECT?></span>
      </td>
      <td nowrap width="10%" align="right">
        <input type="button" value="回复" class="SmallButton" onclick="location='edit.php?REPLY=1&BOARD_ID=<?=$BOARD_ID?>&COMMENT_ID=<?=$COMMENT_ID_ROOT?>&PAGE_START=<?=$PAGE_START?>';" title="回复此文章">
<?
        if($LOGIN_USER_ID == $USER_ID)
        {
?>
        <input type="button" value="编辑" class="SmallButton" onclick="location='edit.php?BOARD_ID=<?=$BOARD_ID?>&COMMENT_ID=<?=$COMMENT_ID?>&PAGE_START=<?=$PAGE_START?>';" title="编辑此文章">
<?
        }
        if($USER_ID==$LOGIN_USER_ID || $LOGIN_USER_PRIV==1)
       {
?>
        <input type="button" value="删除" class="SmallButton" onclick="delete_comment('<?=$COMMENT_ID?>');" title="删除此文章">
<?
        }
?>
    </td>
    </tr>
    <tr class="TableData">
      <td colspan="2"><?=$CONTENT?>
      <br><br><b>作者：
<?
if($ANONYMITY_YN==0  && $USER_NAME!=$AUTHOR_NAME)
{
?>
      <?=$USER_NAME?></b>&nbsp;&nbsp;<i><?=$SUBMIT_TIME?></i>
<?
}
else
{
?>
      <?=$AUTHOR_NAME?></b>&nbsp;&nbsp;<i><?=$SUBMIT_TIME?></i>
<?
}
      if($ATTACHMENT_NAME!="")
      {
?>
      <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, ".",",");
?>
           <img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a> (<?=$ATTACH_SIZE?>字节)
<?
           if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")||stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")||stristr($ATTACHMENT_NAME_ARRAY[$I],".xls"))
           {
?>
	       <input type="button" value="阅读" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=5','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
<?
           }
           else if(is_media($ATTACHMENT_NAME_ARRAY[$I]))
           {
?>
	       <input type="button" value="播放" class="SmallButton" onClick="window.open('/module/mediaplayer/index.php?MEDIA_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&MEDIA_URL=<?=urlencode("/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I]))?>','media<?=$ATTACHMENT_ID_ARRAY[$I]?>','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($IMG_WIDTH>600)
                  $IMG_WIDTH=600;
?>
         <br><img src="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" border="0" width="<?=$IMG_WIDTH?>" alt="文件名：<?=$ATTACHMENT_NAME_ARRAY[$I]?>">
<?
            }
           echo "<br>";
         }//for
      }//if
?>
     <br>
     </td>
    </tr>
<?
 }//while
?>
  </table>

  <br>
  <div align="center">
  <input type="button" value="返回" class="BigButton" onClick="location='board.php?BOARD_ID=<?=$BOARD_ID?>&PAGE_START=<?=$PAGE_START?>';">
  </div>

</body>
</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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