userdata["acclevel"] < 80) die ("Access denied!");
?>
/downarrow.gif" width=9 height=6 border=0 align="middle" alt="downarrow.gif"> title; ?> (Last Days)
query("DROP TABLE IF EXISTS hlstats_AdminEventHistory");
$db->query("
CREATE TEMPORARY TABLE hlstats_AdminEventHistory
(
eventType VARCHAR(32) NOT NULL,
eventTime DATETIME NOT NULL,
eventDesc VARCHAR(255) NOT NULL,
serverName VARCHAR(32) NOT NULL,
map VARCHAR(32) NOT NULL
)
");
function insertEvents ($table, $select)
{
global $db;
$select = str_replace("
", "hlstats_Events_$table", $select);
$db->query("
INSERT INTO
hlstats_AdminEventHistory
(
eventType,
eventTime,
eventDesc,
serverName,
map
)
$select
");
}
insertEvents("Rcon", "
SELECT
CONCAT(.type, ' Rcon'),
.eventTime,
CONCAT('\"', command, '\"\nFrom: ', remoteIp, ', password: \"', password, '\"'),
hlstats_Servers.name,
.map
FROM
LEFT JOIN hlstats_Servers ON
hlstats_Servers.serverId = .serverId
");
insertEvents("Admin", "
SELECT
.type,
.eventTime,
IF(playerName != '',
CONCAT('\"', playerName, '\": ', message),
message
),
hlstats_Servers.name,
.map
FROM
LEFT JOIN hlstats_Servers ON
hlstats_Servers.serverId = .serverId
");
if ($type)
{
$where = "WHERE eventType='$type'";
}
else
{
$where = "";
}
$result = $db->query("
SELECT
eventTime,
eventType,
eventDesc,
serverName,
map
FROM
hlstats_AdminEventHistory
$where
ORDER BY
$table->sort $table->sortorder,
$table->sort2 $table->sortorder
LIMIT
$table->startitem,$table->numperpage
");
$resultCount = $db->query("
SELECT
COUNT(*)
FROM
hlstats_AdminEventHistory
$where
");
list($numitems) = $db->fetch_row($resultCount);
?>
draw($result, $numitems, 100, "");
?>