User connection statistics

Hello Everyone I want to do a user  use  report, someone knows what is the purpose of the table sys_ip_members_visit ? Because I want to use it to know the connections of each member did. Do you know if there is another table log that register the connections of each user did?

 

Thanks in advance.

Quote · 28 Oct 2016

What exact details do you want for this report ?

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 28 Oct 2016

I want to know how many distinct users logged in each day, and how many connectios they did each day.

 

Also I want to know from which table I can get this information in order to build the report. I found out the table sys_ip_members_visit but I don't know what process store this table. I was saving in another table the lastNav field from profile to know if someone connects today but Im not sure if is working because I have different results with the data in sys_ip_members_visit.

 

thanks modzzz for reply 

 

Regards

Quote · 28 Oct 2016

I would suggest to check DateLastNav field in Profiles table each day, this way you can get number of active users each day.

Rules → http://www.boonex.com/terms
Quote · 6 Nov 2016
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.