📄 delete2.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
$query = "update EMAIL set DELETE_FLAG='3' where TO_ID='".$LOGIN_USER_ID."' and (DELETE_FLAG='' or (DELETE_FLAG='' or DELETE_FLAG='0')) and find_in_set(EMAIL_ID,'{$DELETE_STR}')";
exequery( $connection, $query );
$query = "update EMAIL set DELETE_FLAG='4' where TO_ID='".$LOGIN_USER_ID."' and DELETE_FLAG='2' and find_in_set(EMAIL_ID,'{$DELETE_STR}')";
exequery( $connection, $query );
$query = "select * from EMAIL where TO_ID='".$LOGIN_USER_ID."' and DELETE_FLAG!='3' and find_in_set(EMAIL_ID,'{$DELETE_STR}')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$DELETE_FLAG = $ROW['DELETE_FLAG'];
$BODY_ID = $ROW['BODY_ID'];
$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 )
{
$query = "select * from EMAIL_BODY where BODY_ID='".$BODY_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
}
if ( $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; $I < $ARRAY_COUNT - 1; ++$I )
{
delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
}
$BODY_ID_STR .= $BODY_ID.",";
}
}
$query = "delete from EMAIL_BODY where find_in_set(BODY_ID,'".$BODY_ID_STR."')";
exequery( $connection, $query );
$query = "delete from EMAIL where TO_ID='".$LOGIN_USER_ID."' and DELETE_FLAG!='3' and find_in_set(EMAIL_ID,'{$DELETE_STR}')";
exequery( $connection, $query );
$query = "update EMAIL set DELETE_FLAG='1' where TO_ID='".$LOGIN_USER_ID."' and DELETE_FLAG='3' and find_in_set(EMAIL_ID,'{$DELETE_STR}')";
exequery( $connection, $query );
header( "location: index.php?BOX_ID=".$BOX_ID."&PAGE_START={$PAGE_START}&FIELD={$FIELD}&ASC_DESC={$ASC_DESC}" );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -