del_email.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
include_once( "inc/utility_sms1.php" );
if ( $DELETE == "del" || $DELETE == "unread" )
{
	if ( $DELETE == "del" )
	{
		$query = "select EMAIL_ID,EMAIL.BODY_ID,SUBJECT,TO_ID,FROM_ID,ATTACHMENT_ID,ATTACHMENT_NAME from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."'  and SEND_FLAG='1' and DELETE_FLAG='1'";
	}
	else if ( $DELETE == "unread" )
	{
		$query = "select EMAIL_ID,EMAIL.BODY_ID,SUBJECT,TO_ID,FROM_ID,ATTACHMENT_ID,ATTACHMENT_NAME from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."'  and SEND_FLAG='1' and (DELETE_FLAG='' or DELETE_FLAG='0') and READ_FLAG!='1'";
	}
	$cursor0 = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor0 ) )
	{
		$EMAIL_ID = $ROW['EMAIL_ID'];
		$BODY_ID = $ROW['BODY_ID'];
		$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
		$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
		$FROM_ID = $ROW['FROM_ID'];
		$TO_ID = $ROW['TO_ID'];
		$SUBJECT = $ROW['SUBJECT'];
		if ( $DELETE == "unread" )
		{
			$SMS_CONTENT = "请查收我的邮件！\n主题：".csubstr( $SUBJECT, 0, 100 );
			delete_remind_sms( 2, $LOGIN_USER_ID, $SMS_CONTENT );
		}
		$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 );
				$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 where EMAIL_ID='".$EMAIL_ID."'";
		exequery( $connection, $query );
	}
}
else
{
	$query = "update EMAIL,EMAIL_BODY set DELETE_FLAG='2' where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."' and SEND_FLAG='1' and (DELETE_FLAG='' or DELETE_FLAG='0') and READ_FLAG='1'";
	exequery( $connection, $query );
	$query = "update EMAIL,EMAIL_BODY set DELETE_FLAG='4' where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."' and SEND_FLAG='1' and DELETE_FLAG='3' and READ_FLAG='1'";
	exequery( $connection, $query );
}
$query = "delete from EMAIL_BODY where FROM_ID='".$LOGIN_USER_ID."' and find_in_set(BODY_ID,'{$BODY_ID_STR}')";
exequery( $connection, $query );
header( "location: index.php?PAGE_START=".$PAGE_START."&FIELD={$FIELD}&ASC_DESC={$ASC_DESC}" );
echo "\r\n";
?>