📄 delete_garbage.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);
for ($I = 0; $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 '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$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)
{
if ($SEND_FLAG == '1')
{
if ($DELETE_FLAG != '1')
{
if ($READ_FLAG == '1')
{
$query = 'update EMAIL set DELETE_FLAG=\'2\' where EMAIL_ID=' . $EMAIL_ID;
exequery ($connection, $query);
continue;
}
continue;
}
continue;
}
continue;
}
}
$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)
{
if ($DELETE_FLAG != '2')
{
$query = 'update EMAIL set DELETE_FLAG=\'1\' where EMAIL_ID=' . $EMAIL_ID;
exequery ($connection, $query);
continue;
}
continue;
}
}
$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);
for ($I = 0; $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);
for ($I = 0; $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 = '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 '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -