📄 search.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
include_once 'inc/check_type.php';
include_once 'inc/ip2add.php';
echo '
<html>
<head>
<title>系统日志查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function delete_log(LOG_ID)
{
msg=\'确认要删除该系统日志么？\';
if(window.confirm(msg))
{
URL="delete.php?LOG_ID=" + LOG_ID;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
if ($BEGIN_DATE != '')
{
$TIME_OK = is_date_time ($BEGIN_DATE);
if (!($TIME_OK))
{
message ('错误', '起始时间格式不对，应形如 1999-1-2 14:55:20');
button_back ();
exit ();
}
}
if ($END_DATE != '')
{
$TIME_OK = is_date_time ($END_DATE);
if (!($TIME_OK))
{
message ('错误', '截止时间格式不对，应形如 1999-1-2 14:55:20');
button_back ();
exit ();
}
}
if ($BEGIN_DATE == '')
{
$query = 'SELECT * from SYS_LOG where TIME<=\'' . $END_DATE . '\'';
}
else
{
if ($END_DATE == '')
{
$query = 'SELECT * from SYS_LOG where TIME>=\'' . $BEGIN_DATE . '\'';
}
else
{
$query = 'SELECT * from SYS_LOG where TIME>=\'' . $BEGIN_DATE . '\' and TIME<=\'' . $END_DATE . '\'';
}
}
if ($TYPE != '')
{
$query .= ' and TYPE=\'' . $TYPE . '\'';
}
if ($IP != '')
{
$query .= ' and IP=\'' . $IP . '\'';
}
if ($OPERATION == '1')
{
$query = 'delete' . substr ($query, 8);
if ($TO_ID != '')
{
$query .= ' and FIND_IN_SET(USER_ID,\'' . $TO_ID . '\')';
}
exequery ($connection, $query);
$AFFACT_ROWS = mysql_affected_rows ();
echo '<br><br>';
message ('', '共删除 ' . $AFFACT_ROWS . ' 条日志记录');
button_back ();
exit ();
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/system.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 查询结果 （最多显示500条记录）</span>
</td>
</tr>
</table>
<br>
';
if ($TO_ID == '')
{
$query .= ' order by TIME desc';
$cursor = exequery ($connection, $query);
$LOG_COUNT = 0;
if ($ROW = mysql_fetch_array ($cursor))
{
++$LOG_COUNT;
if (!(500 < $LOG_COUNT))
{
$LOG_ID = $ROW['LOG_ID'];
$USER_ID = $ROW['USER_ID'];
$TIME = $ROW['TIME'];
$IP = $ROW['IP'];
$IP_ADD = convertip ($IP);
$TYPE = $ROW['TYPE'];
$REMARK = $ROW['REMARK'];
$USER_ID = addslashes ($USER_ID);
$USER_NAME = '';
$query1 = 'SELECT * from USER where USER_ID=\'' . $USER_ID . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$USER_NAME = $ROW1['USER_NAME'];
}
$TYPE_DESC = get_code_name ($TYPE, 'SYS_LOG');
if ($LOG_COUNT == 1)
{
echo ' <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
';
}
if ($LOG_COUNT % 2 == 1)
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $USER_NAME;
echo '</td>
<td nowrap align="center">';
echo $TIME;
echo '</td>
<td nowrap align="center">';
echo $IP;
echo '</td>
<td nowrap align="center">';
echo $IP_ADD;
echo '</td>
<td nowrap align="center">';
echo $TYPE_DESC;
echo '</td>
<td align="left">';
echo $REMARK;
echo '</td>
<td nowrap align="center">
<a href="javascript:delete_log(';
echo $LOG_ID;
echo ');">删除</a>
</td>
</tr>
';
}
}
}
else
{
$USER_ID_ARRAY = explode (',', $TO_ID);
$USER_ID_ARRAY_NUM = sizeof ($USER_ID_ARRAY) - 1;
$LOG_COUNT = 0;
for ($I = 0; $I < $USER_ID_ARRAY_NUM; ++$I)
{
$query1 .= $query . (' and USER_ID=\'' . $USER_ID_ARRAY[$I] . '\' order by TIME desc');
$cursor = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor))
{
++$LOG_COUNT;
if (!(500 < $LOG_COUNT))
{
$LOG_ID = $ROW['LOG_ID'];
$USER_ID = $ROW['USER_ID'];
$TIME = $ROW['TIME'];
$IP = $ROW['IP'];
$IP_ADD = convertip ($IP);
$TYPE = $ROW['TYPE'];
$REMARK = $ROW['REMARK'];
$USER_ID = addslashes ($USER_ID);
$USER_NAME = '';
$query2 = 'SELECT * from USER where USER_ID=\'' . $USER_ID . '\'';
$cursor2 = exequery ($connection, $query2);
if ($ROW2 = mysql_fetch_array ($cursor2))
{
$USER_NAME = $ROW2['USER_NAME'];
}
$TYPE_DESC = get_code_name ($TYPE, 'SYS_LOG');
if ($LOG_COUNT == 1)
{
echo '
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
';
}
if ($LOG_COUNT % 2 == 1)
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $USER_NAME;
echo '</td>
<td nowrap align="center">';
echo $TIME;
echo '</td>
<td nowrap align="center">';
echo $IP;
echo '</td>
<td nowrap align="center">';
echo $IP_ADD;
echo '</td>
<td nowrap align="center">';
echo $TYPE_DESC;
echo '</td>
<td nowrap align="center">';
echo $REMARK;
echo '</td>
<td nowrap align="center">
<a href="javascript:delete_log(';
echo $LOG_ID;
echo ');">删除</a>
</td>
</tr>
';
continue;
}
}
$query1 = '';
}
}
if ($LOG_COUNT == 0)
{
message ('', '无符合条件的日志记录');
button_back ();
exit ();
}
echo ' <thead class="TableHeader">
<td nowrap align="center">用户姓名</td>
<td nowrap align="center">时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center">IP地址</td>
<td nowrap align="center">IP所在地</td>
<td nowrap align="center">日志类型</td>
<td nowrap align="center">备注</td>
<td nowrap align="center">操作</td>
</thead>
</table>
';
button_back ();
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -