📄 insert.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_sms1.php");
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$CUR_TIME=date("Y-m-d H:i:s",time());
//------ 回复文章，增加被回复文章的回复计数 ------
if($REPLY=="1")
{
$query="update BBS_COMMENT set REPLY_CONT=REPLY_CONT+1,SUBMIT_TIME='$CUR_TIME' where COMMENT_ID=$COMMENT_ID";
exequery($connection, $query);
}
if($AUTHOR_NAME=="1")
$AUTHOR_NAME = $USER_NAME;
else
$AUTHOR_NAME = $NICK_NAME;
if($BBS_SIGNATURE=="on")
{
$query = "SELECT * from USER where USER_ID='$LOGIN_USER_ID'";
$cursor = exequery($connection, $query);
if($ROW=mysql_fetch_array($cursor))
{
$BBS_SIGNATURE=addslashes($ROW["BBS_SIGNATURE"]);
if($BBS_SIGNATURE!="")
$CONTENT.="<br><br>------------------ 以下是个人签名 -------------------<br>".str_replace("\n","<br>",$BBS_SIGNATURE);
}
}
//--------- 用户积分++ ----------
$query="update USER set BBS_COUNTER=BBS_COUNTER+1 where USER_ID='$LOGIN_USER_ID'";
exequery($connection, $query);
//--------- 上传附件 ----------
if($ATTACHMENT!="")
{
$ATTACHMENT_ID=upload($ATTACHMENT,$ATTACHMENT_NAME);
$ATTACHMENT_ID=$ATTACHMENT_ID.",";
$ATTACHMENT_NAME=$ATTACHMENT_NAME."*";
}
//--------- 保存文章 ----------
if($REPLY=="1")
$PARENT=$COMMENT_ID;
else
$PARENT=0;
$query="insert into BBS_COMMENT(BOARD_ID, USER_ID, AUTHOR_NAME, SUBJECT, CONTENT, ATTACHMENT_ID, ATTACHMENT_NAME, SUBMIT_TIME, REPLY_CONT, READ_CONT,PARENT,OLD_SUBMIT_TIME) values ( '$BOARD_ID', '$LOGIN_USER_ID', '$AUTHOR_NAME', '$SUBJECT', '$CONTENT', '$ATTACHMENT_ID', '$ATTACHMENT_NAME', '$CUR_TIME', 0, 0,'$PARENT', '$CUR_TIME')";
exequery($connection, $query);
$query1="select * from BBS_COMMENT where BOARD_ID=$BOARD_ID and USER_ID='$LOGIN_USER_ID' and AUTHOR_NAME='$AUTHOR_NAME' and SUBJECT='$SUBJECT' and CONTENT='$CONTENT' and ATTACHMENT_ID='$ATTACHMENT_ID' and ATTACHMENT_NAME='$ATTACHMENT_NAME' and SUBMIT_TIME='$CUR_TIME' and REPLY_CONT=0 and READ_CONT=0";
$cursor1 = exequery($connection, $query1);
if($ROW1=mysql_fetch_array($cursor1))
$COMMENT_ID_NEW=$ROW1["COMMENT_ID"];
if($REPLY=="1")
{
$query2="select * from BBS_COMMENT where COMMENT_ID=$COMMENT_ID";
$cursor2 = exequery($connection, $query2);
if($ROW2=mysql_fetch_array($cursor2))
{
$USER_ID=$ROW2["USER_ID"];
$SUBJECT=$ROW2["SUBJECT"];
}
if($SMS_REMIND=="on" && $LOGIN_USER_ID!=$USER_ID)
send_sms("",$LOGIN_USER_ID,$USER_ID,18,$SUBJECT."得到回复，请查看！");
if($SMS2_REMIND=="on" && $LOGIN_USER_ID!=$USER_ID)
send_mobile_sms_user("",$LOGIN_USER_ID,$USER_ID,$SUBJECT."得到回复，请查看！",18);
}
if($OP=="0")
header("location: edit.php?BOARD_ID=$BOARD_ID&PAGE_START=$PAGE_START&COMMENT_ID=$COMMENT_ID_NEW");
else if($REPLY=="1")
header("location: comment.php?BOARD_ID=$BOARD_ID&COMMENT_ID=$COMMENT_ID&PAGE_START=$PAGE_START");
else
header("location: board.php?BOARD_ID=$BOARD_ID&PAGE_START=$PAGE_START");
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -