MX User Login Forum :: Login Statistics

Hi, I did a few weeks ago a very very simple user registration and login system using the MX user Login, the original idea was only to  grant access to certain users using a simple level redirection, however, my client asked me about to add some features to that system, the new features are:

a.       I want to see a log of what the users are doing on line
b.       When, what time did they log in, what pages did they see
c.       What IP address did they come from
d.       Anything else cool you might be able to do to track my users

Mt users table is this one:

CREATE TABLE `EndUsers` (
  `ID` int(6) NOT NULL auto_increment,
  `LoginName` varchar(255) NOT NULL default '',
  `Password` varchar(255) NOT NULL default '',
  `FullName` varchar(255) NOT NULL default '',
  `Companyname` varchar(255) NOT NULL default '',
  `CompanyAddress` varchar(255) NOT NULL default '',
  `City` varchar(255) NOT NULL default '',
  `State` varchar(255) NOT NULL default '',
  `Zip` varchar(255) NOT NULL default '',
  `PhoneNumber` varchar(255) NOT NULL default '',
  `FaxNumber` varchar(255) NOT NULL default '',
  `BusinessType` varchar(255) NOT NULL default '',
  `Active` varchar(255) NOT NULL default '',
  `Level` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

but thing is, do I have to change something in the web site?, or any idea on how to do this in the most easy way, without spend to much time and effort?

Thanks a lot!

Arturo

Hello Arturo,

If you use PHP, we provide a how-to in MX Kollection Pro documentation that may help you.

regards,
Ionut

hi Ionut, wow, that article it's very interesting, but now I've a doubt, how to catch the IP, and the login date - logout date?, because I need to fill that in the table but how to do that?, I think I can place some hidden fields, however, the tricky thing ( for me ) it's to catch those values, do you have any idea about that?

Regards!
Arturo

This info is automatically stored into the "logger_log" table, you just need to fill in the Login Settings correctly to use the proper database columns.

Ionut

hmm ok, I understand, but thing is, how can I catch that? the IP, which pages are visited by user and login / logout time

Best regards!

Arturo

Arturo,

MX Kollection Pro only handles this (in PHP): if Login Settings are correctly configured in Control Panel, the IP of the logged in user is automatically inserted as a record into the logger_log table, together with the login date and logout date.

The approach with statistic about visited pages is not handled by the product.

Ionut

I just found this tutorial and was beginning to do it but stumbled when on the Login Settings.  My version does not have the history or restrictions tab.

I have MX Kollection 3.7.1.

Is it also available in the adobe tool box?

Thanks,
Scott

Scott,

These features are only available for PHP. Maybe you are using ASP or CF.

Ionut

I am using php. It was an upgraded version from 3.6 I think (forgot the versioning sequence) 1. should it be available in the php version of the last Kollection available from the download. And if so I will need directions on how to correct it. I tried the directions from an earlier post but they were not detailed enough for me to understand. 2. Will this feature/tab be available on the ADDT. I don't have CS3 yet so I cannot answer it for myself. Thanks, Scott

If you have MX Kollection 3.7.1 Pro or Kollection 3.7.1 installed, this features should appear for PHP. Yes, they are also availbale in Developer Toolbox.

What you should do is try to delete the DW cache file or even reinstall the extension from scratch (with renaming the "Configuration" folder).

You will find info about doing these on this thread (ignore the title of the thread).

Ionut

Hi there, well, this is my table end users

--
-- Table structure for table `EndUsers`
--

CREATE TABLE `EndUsers` (
  `ID` int(6) NOT NULL auto_increment,
  `LoginName` varchar(255) NOT NULL default '',
  `Password` varchar(255) NOT NULL default '',
  `FullName` varchar(255) NOT NULL default '',
  `Companyname` varchar(255) NOT NULL default '',
  `CompanyAddress` varchar(255) NOT NULL default '',
  `City` varchar(255) NOT NULL default '',
  `State` varchar(255) NOT NULL default '',
  `Zip` varchar(255) NOT NULL default '',
  `PhoneNumber` varchar(255) NOT NULL default '',
  `FaxNumber` varchar(255) NOT NULL default '',
  `BusinessType` varchar(255) NOT NULL default '',
  `Active` varchar(255) NOT NULL default '',
  `Level` varchar(255) NOT NULL default '',
  `AddressIP` varchar(255) NOT NULL default '',
  `LastLogin` varchar(255) NOT NULL default '',
  `LastActivity` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ;

as you can see there's an AddressIP, LastLogin and LastActivity fields at the end, I allowed the control panel to write the history about this  fields, like the attached image, but it's only saving the LastActivity, why I'm not getting the other 2?

Regards!

Arturo