insert.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 108 行
PHP
108 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
include_once 'inc/utility_sms1.php';
echo '
<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);
}
$AUTHOR_NAME_TMEP = $AUTHOR_NAME;
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 ('
', '<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.'*');
}
($ATTACHMENT_ID .= copy_sel_attach ($ATTACH_NAME, $ATTACH_DIR, $DISK_ID));
($ATTACHMENT_NAME .= $ATTACH_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);
$COMMENT_ID_NEW = mysql_insert_id ();
$query = 'select * from SYS_PARA where PARA_NAME=\'SMS_REMIND\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PARA_VALUE = $ROW['PARA_VALUE'];
}
$SMS_REMIND1 = substr ($PARA_VALUE, 0, strpos ($PARA_VALUE, '|'));
$SMS2_REMIND1 = substr ($PARA_VALUE, (strpos ($PARA_VALUE, '|') + 1));
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') AND ($LOGIN_USER_ID != $USER_ID)) AND find_id ($SMS_REMIND1, 18)) AND ($AUTHOR_NAME_TMEP == '1')))
{
send_sms ('', $LOGIN_USER_ID, $USER_ID, 18, ($SUBJECT.'得到回复，请查看！'), $REMIND_URL);
}
if ((((($SMS2_REMIND == 'on') AND ($LOGIN_USER_ID != $USER_ID)) AND find_id ($SMS2_REMIND1, 18)) AND ($AUTHOR_NAME_TMEP == '1')))
{
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));
}
}
echo '
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?