⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 delete_garbage.php

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

function delete_children( $SORT_PARENT )
{
	global $ROW_COUNT;
	global $SPACE_COUNT;
	global $connection;
	$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 = "delete from ADDRESS where USER_ID!='' and not FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "delete from ADDRESS_GROUP where USER_ID!='' and not FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "delete from AFFAIR where not FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "delete from CALENDAR where not FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "delete from DIARY where not FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "delete from EMAIL_BOX where not FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$BODY_ID_STR = "";
$query = "select * from EMAIL where (DELETE_FLAG='2' or DELETE_FLAG='4') and not find_in_set(TO_ID,'".$USER_ID_STR."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$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 != "" )
		{
			delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
		}
		$BODY_ID_STR .= $BODY_ID.",";
	}
}
$query = "delete from EMAIL_BODY where find_in_set(BODY_ID,'".$BODY_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "delete from EMAIL where (DELETE_FLAG='2' or DELETE_FLAG='4') and not find_in_set(TO_ID,'".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "update EMAIL set DELETE_FLAG='1' where (DELETE_FLAG='3' or DELETE_FLAG='' or DELETE_FLAG='0') and not find_in_set(TO_ID,'".$USER_ID_STR."')";
exequery( $connection, $query );
$query = "select * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and (DELETE_FLAG='1' or READ_FLAG!='1') and not find_in_set(FROM_ID,'".$USER_ID_STR."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_ID = $ROW['EMAIL_ID'];
	$BODY_ID = $ROW['BODY_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$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'];
	$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 != "" )
		{
			delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
		}
		$BODY_ID_STR .= $BODY_ID.",";
	}
	if ( $READ_FLAG == "0" )
	{
		$SMS_CONTENT = "请查收我的邮件！\n主题：".csubstr( $SUBJECT, 0, 100 );
		$query = "delete from SMS where SMS_TYPE='2' and FROM_ID='".$FROM_ID."' and TO_ID='{$TO_ID}' and CONTENT='{$SMS_CONTENT}'";
		exequery( $connection, $query );
		$ROW_COUNT += mysql_affected_rows( );
	}
	$EMAIL_ID_STR .= $EMAIL_ID.",";
}
$query = "delete from EMAIL where find_in_set(EMAIL_ID,'".$EMAIL_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "delete from EMAIL_BODY where find_in_set(BODY_ID,'".$BODY_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$query = "update EMAIL,EMAIL_BODY set DELETE_FLAG='2' where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and  (DELETE_FLAG='' or DELETE_FLAG='0') and READ_FLAG='1' and not find_in_set(FROM_ID,'".$USER_ID_STR."')";
exequery( $connection, $query );
$query = "update EMAIL,EMAIL_BODY set DELETE_FLAG='4' where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and  DELETE_FLAG='3' and READ_FLAG='1' and not find_in_set(FROM_ID,'".$USER_ID_STR."')";
exequery( $connection, $query );
$query = "delete from EMAIL where BODY_ID=0 or TO_ID=''";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$BODY_ID_STR = "";
$query = "select * from EMAIL_BODY left join EMAIL on EMAIL.BODY_ID = EMAIL_BODY.BODY_ID where EMAIL_ID is null";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$BODY_ID_STR .= $ROW['BODY_ID'].",";
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
}
$query = "delete from EMAIL_BODY where find_in_set(BODY_ID,'".$BODY_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$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 not 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 not FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
$cursor = exequery( $connection, $query );
$query = "delete from URL where USER!='' and not FIND_IN_SET(USER, '".$USER_ID_STR."')";
exequery( $connection, $query );
$ROW_COUNT += mysql_affected_rows( );
$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 + -