06.05.2022, 13:43
(06.05.2022, 08:26)admin Wrote: Via .lp file:Many thanks for your help
Code:<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<link rel="stylesheet" href="/apps/css/bootstrap.css">
</head>
<body>
<table class="table table-striped">
<tr>
<th>Date/time</th>
<th>Login</th>
<th>Name</th>
<th>IP</th>
</tr>
<?
require('apps')
items = db:getall([[
SELECT user_logs.*, users.name
FROM user_logs
JOIN users ON user_logs.login=users.login
ORDER BY user_logs.id DESC
LIMIT 50
]])
for _, item in ipairs(items) do
cls = toboolean(item.failed) and 'danger' or 'success'
datetime = os.date('%Y.%m.%d %H:%M:%S', item.created)
?>
<tr class="<?=cls?>">
<td><?=datetime?></td>
<td><?=escape(item.login)?></td>
<td><?=escape(item.name)?></td>
<td><?=escape(item.ip)?></td>
</tr>
<? end ?>
</table>
</body>
</html>