delete1.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 58 行

PHP
58
字号
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$query = "update EMAIL set DELETE_FLAG='3' where (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 DELETE_FLAG='2' and find_in_set(EMAIL_ID,'".$DELETE_STR."')";
exequery( $connection, $query );
$query = "select * from EMAIL where 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 DELETE_FLAG!='3' and find_in_set(EMAIL_ID,'".$DELETE_STR."')";
exequery( $connection, $query );
$query = "update EMAIL set DELETE_FLAG='1' where DELETE_FLAG='3' and find_in_set(EMAIL_ID,'".$DELETE_STR."')";
exequery( $connection, $query );
echo "<script>\r\nwindow.location=\"index.php?BOX_ID=";
echo $BOX_ID;
echo "&PAGE_START=";
echo $PAGE_START;
echo "\";\r\nparent.left.location=\"../left.php\";\r\n</script>\r\n\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?