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 + -
显示快捷键?