Export Access Logs

[anagno@bluewin.ch]

I would like to export the Wiser's Access Logs. Is this possible?

[admin]

Use this to export to CSV. Then you can upload it to FTP, send via e-mail etc.

Code:

123456789101112131415161718

rows = {   '"date","login","ip","failed"' } items = db:getall('SELECT * FROM user_logs ORDER BY id DESC') for _, item in ipairs(items) do   date = os.date('%Y.%m.%d %H:%M:%S', item.created)   failed = toboolean(item.failed)   rows[ #rows + 1 ] = string.format('%q,%q,%q,%q',     date,     item.login or '?',     item.ip or '?',     failed and 'yes' or 'no'   ) end csv = table.concat(rows, '\n')

[anagno@bluewin.ch]

excellent! thank you very-very much