List of users online

0

I need to create a list of users online right now, or up to 20 minutes ago. The table with the data of the users is called 'User', and the table that has the accesses of these users is called 'Core.logs'.

I have no idea how to do this! Can anyone at least give me a hint?

    
asked by anonymous 16.03.2015 / 19:11

1 answer

2

As you can see, Core.logs is an audit table.

The date field should probably store date of actions that were taken by users.

You can pick up this date and do a check, where the last actions within 20 minutes show you the users' data in a list.

    
16.03.2015 / 22:37