📄 delete_garbage.php

📁 极限网络智能办公系统 - Office Automation 2.8 100％源码
💻 PHP
字号:
<?php

function delete_children( $SORT_PARENT )
{
	global $ROW_COUNT;
	global $SPACE_COUNT;
	$connection = openconnection( );
	$query = "select * from FILE_CONTENT where SORT_ID={$SORT_PARENT}";
	$cursor1 = exequery( $connection, $query );
	while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		++$ROW_COUNT;
		$ATTACHMENT_ID = $ROW1['ATTACHMENT_ID'];
		$ATTACHMENT_NAME = $ROW1['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	)
		{
			$SPACE_COUNT += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
			delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
		}
	}
	$query = "delete from FILE_CONTENT where SORT_ID={$SORT_PARENT}";
	exequery( $connection, $query );
	$query = "select * from FILE_SORT where SORT_PARENT={$SORT_PARENT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$ROW_COUNT;
		$SORT_ID = $ROW['SORT_ID'];
		delete_children( $SORT_ID );
	}
	$query = "delete from FILE_SORT where SORT_ID={$SORT_PARENT}";
	exequery( $connection, $query );
}

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 = "select * from USER order by USER_ID";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_ID_STR .= $ROW['USER_ID'].",";
}
$USER_ID_STR = substr( $USER_ID_STR, 0, -1 );
$ROW_COUNT = $SPACE_COUNT = 0;
$query = "select count(*) from ADDRESS where USER_ID!='' and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ROW_COUNT += $ROW[0];
}
$query = "delete from ADDRESS where USER_ID!='' and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
exequery( $connection, $query );
$query = "select count(*) from ADDRESS_GROUP where USER_ID!='' and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ROW_COUNT += $ROW[0];
}
$query = "delete from ADDRESS_GROUP where USER_ID!='' and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
exequery( $connection, $query );
$query = "select count(*) from AFFAIR where not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ROW_COUNT += $ROW[0];
}
$query = "delete from AFFAIR where not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
exequery( $connection, $query );
$query = "select count(*) from CALENDAR where not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ROW_COUNT += $ROW[0];
}
$query = "delete from CALENDAR where not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
exequery( $connection, $query );
$query = "select count(*) from DIARY where not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ROW_COUNT += $ROW[0];
}
$query = "delete from DIARY where not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
exequery( $connection, $query );
$query = "select count(*) from EMAIL_BOX where USER_ID!='' and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ROW_COUNT += $ROW[0];
}
$query = "delete from EMAIL_BOX where not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
exequery( $connection, $query );
$query = "select * from EMAIL where not FIND_IN_SET(FROM_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_ID = $ROW['EMAIL_ID'];
	$FROM_ID = $ROW['FROM_ID'];
	$TO_ID = $ROW['TO_ID'];
	$READ_FLAG = $ROW['READ_FLAG'];
	$DELETE_FLAG = $ROW['DELETE_FLAG'];
	$SEND_FLAG = $ROW['SEND_FLAG'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	if ( $FROM_ID != $TO_ID && $SEND_FLAG == "1" && $DELETE_FLAG != "1" && $READ_FLAG == "1" )
	{
		$query = "update EMAIL set DELETE_FLAG='2' where EMAIL_ID={$EMAIL_ID}";
		exequery( $connection, $query );
	}
	else
	{
		if ( $ATTACHMENT_NAME != "" )
		{
			$query1 = "select count(*) from EMAIL where ATTACHMENT_ID='{$ATTACHMENT_ID}' and ATTACHMENT_NAME='{$ATTACHMENT_NAME}'";
			$cursor1 = exequery( $connection, $query1 );
			if ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				$ATTACHMENT_COUNT = $ROW[0];
				if ( $ATTACHMENT_COUNT == 1 )
				{
					$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	)
					{
						$SPACE_COUNT += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
						delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
					}
				}
			}
		}
		++$ROW_COUNT;
		$query = "delete from EMAIL where EMAIL_ID={$EMAIL_ID}";
		exequery( $connection, $query );
	}
}
$query = "select * from EMAIL where not FIND_IN_SET(TO_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_ID = $ROW['EMAIL_ID'];
	$FROM_ID = $ROW['FROM_ID'];
	$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'];
	if ( $FROM_ID != $TO_ID && $DELETE_FLAG != "2" )
	{
		$query = "update EMAIL set DELETE_FLAG='1' where EMAIL_ID={$EMAIL_ID}";
		exequery( $connection, $query );
	}
	else
	{
		if ( $ATTACHMENT_NAME != "" )
		{
			$query1 = "select count(*) from EMAIL where ATTACHMENT_ID='{$ATTACHMENT_ID}' and ATTACHMENT_NAME='{$ATTACHMENT_NAME}'";
			$cursor1 = exequery( $connection, $query1 );
			if ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				$ATTACHMENT_COUNT = $ROW[0];
				if ( $ATTACHMENT_COUNT == 1 )
				{
					$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	)
					{
						$SPACE_COUNT += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
						delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
					}
				}
			}
		}
		++$ROW_COUNT;
		$query = "delete from EMAIL where EMAIL_ID={$EMAIL_ID}";
		exequery( $connection, $query );
	}
}
$query = "select * from FILE_SORT where SORT_TYPE='4' and SORT_PARENT=0 and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$ROW_COUNT;
	$SORT_ID = $ROW['SORT_ID'];
	delete_children( $SORT_ID );
}
$query = "delete from FILE_SORT where SORT_TYPE='4' and SORT_PARENT=0 and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
exequery( $connection, $query );
$query = "select * from FILE_CONTENT where SORT_ID=0 and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	++$ROW_COUNT;
	$ATTACHMENT_ID = $ROW1['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW1['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	)
	{
		$SPACE_COUNT += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
		delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
	}
}
$query = "delete from FILE_CONTENT where SORT_ID=0 and not FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
$query = "select * from HRMS where FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	++$ROW_COUNT;
	$PHOTO = $ROW1['PHOTO'];
	$PHOTO = $ATTACH_PATH."hrms_pic/".$PHOTO;
	if ( file_exists( $PHOTO ) )
	{
		unlink( $PHOTO );
	}
	$ATTACHMENT_ID = $ROW1['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW1['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	)
	{
		$SPACE_COUNT += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
		delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
	}
}
$query = "delete from HRMS where FIND_IN_SET(USER_ID, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
$query = "select count(*) from URL where USER!='' and not FIND_IN_SET(USER, '{$USER_ID_STR}')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ROW_COUNT += $ROW[0];
}
$query = "delete from URL where USER!='' and not FIND_IN_SET(USER, '{$USER_ID_STR}')";
exequery( $connection, $query );
$ROW_COUNT = number_format( $ROW_COUNT, 0, ".", "," );
$SPACE_COUNT = number_format( $SPACE_COUNT / 1024 / 1024, 2, ".", "," );
$REMARK = "删除数据库记录：{$ROW_COUNT} 条<br>回收硬盘空间：{$SPACE_COUNT} MB";
add_log( 12, "系统垃圾清理[{$REMARK}]", $LOGIN_USER_ID );
message( "提示", $REMARK );
button_back( );
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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