delete.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 66 行
PHP
66 行
<?
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">
</head>
<body class="bodycolor" topmargin="5">
';
$query = (((''.'select EMAIL_ID,EMAIL.BODY_ID,SUBJECT,TO_ID,READ_FLAG,DELETE_FLAG,ATTACHMENT_ID,ATTACHMENT_NAME from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and (DELETE_FLAG=\'1\' or READ_FLAG!=\'1\') and find_in_set(EMAIL_ID,\'').$DELETE_STR).'\')');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$EMAIL_ID = $ROW['EMAIL_ID'];
$BODY_ID = $ROW['BODY_ID'];
$SUBJECT = $ROW['SUBJECT'];
$TO_ID = $ROW['TO_ID'];
$READ_FLAG = $ROW['READ_FLAG'];
$DELETE_FLAG = $ROW['DELETE_FLAG'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$query1 = ((''.'select count(*) from EMAIL where BODY_ID=').$BODY_ID);
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$GROUP_COUNT = $ROW[0];
}
if (($GROUP_COUNT <= 1))
{
if (($ATTACHMENT_NAME != ''))
{
$ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
$ARRAY_COUNT = sizeof ($ATTACHMENT_ID_ARRAY);
for ($I = 0; ($I < ($ARRAY_COUNT - 1)); ++$I)
{
delete_attach ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
}
}
($BODY_ID_STR .= ($BODY_ID.','));
}
if (($READ_FLAG == '0'))
{
$SMS_CONTENT = ('请查收我的邮件!
主题:'.csubstr ($SUBJECT, 0, 100));
$query = (((((((''.'delete from SMS where SMS_TYPE=\'2\' and FROM_ID=\'').$LOGIN_USER_ID).'\' and TO_ID=\'').$TO_ID).'\' and CONTENT=\'').$SMS_CONTENT).'\'');
exequery ($connection, $query);
}
$query = ((''.'delete from EMAIL where EMAIL_ID=').$EMAIL_ID);
exequery ($connection, $query);
}
$query = (((''.'delete from EMAIL_BODY where find_in_set(BODY_ID,\'').$BODY_ID_STR).'\')');
exequery ($connection, $query);
$query = (((''.'update EMAIL set DELETE_FLAG=\'2\' where (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\') and READ_FLAG=\'1\' and find_in_set(EMAIL_ID,\'').$DELETE_STR).'\')');
exequery ($connection, $query);
$query = (((''.'update EMAIL set DELETE_FLAG=\'4\' where DELETE_FLAG=\'3\' and READ_FLAG=\'1\' and find_in_set(EMAIL_ID,\'').$DELETE_STR).'\')');
exequery ($connection, $query);
header (((''.'location: index.php?PAGE_START=').$PAGE_START));
echo '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?