This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.
Logic Machine Forum › LogicMachine eco-system › Scripting v
User Access Log on Vis

Threaded Mode
User Access Log on Vis
sjfp Offline
Member
Posts: 99
Threads: 39
Joined: Apr 2018
Reputation: 0
#1
03.05.2022, 08:38 (This post was last modified: 03.05.2022, 08:40 by sjfp.)
Hi, is there a way to display the user access logs in a frame on a vis page.
Only want to show user accounts and exclude ADMIN logins
Find
Reply
admin Offline
Administrator
Posts: 7758
Threads: 42
Joined: Jun 2015
Reputation: 447
#2
06.05.2022, 08:26
Via .lp file:
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>
Find
Reply
sjfp Offline
Member
Posts: 99
Threads: 39
Joined: Apr 2018
Reputation: 0
#3
06.05.2022, 13:43
(06.05.2022, 08:26)admin Wrote: Via .lp file:
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>
 Many thanks for your help
Find
Reply
khalil Offline
Senior Member
Posts: 321
Threads: 72
Joined: Jan 2021
Reputation: 0
#4
07.05.2022, 09:57
Hello
how does the full code looks like?
BR,
Best Regards,
Find
Reply
Erwin van der Zwart Offline
Senior Member
Posts: 1764
Threads: 6
Joined: Jul 2015
Reputation: 117
#5
07.05.2022, 18:22
It is the full code (:
Find
Reply
khalil Offline
Senior Member
Posts: 321
Threads: 72
Joined: Jan 2021
Reputation: 0
#6
08.05.2022, 15:47
(07.05.2022, 18:22)Erwin van der Zwart Wrote: It is the full code (:

Aha 
Seems I miss how to use it Smile
should I have something like this at the beginning or its done in another way

dst = '/www/user/accesslog.lp'

io.writefile(dst, [[..... accesss log code....

]])
Best Regards,
Find
Reply
Erwin van der Zwart Offline
Senior Member
Posts: 1764
Threads: 6
Joined: Jul 2015
Reputation: 117
#7
09.05.2022, 06:49 (This post was last modified: 09.05.2022, 06:50 by Erwin van der Zwart.)
Well this code is enabling you to automatically write it to a file on the FTP server, but you could have also just manually upload the code as a .lp file to the FTP server...
Find
Reply


Forum Jump: