Administrative and Maintenance Tools - Login log - Log successful login attempts

Hi,

This plugin will allow you to log all successful login attempts of all users.
This can be useful to see if users share their account or if the account of someone got hijacked. Usernames and IP addresses can be clicked.

It will log the following
- Userid
- Username
- IP
- ISP (Internet Service Provider)
- Country
- HTTP user agent

Settings:
- Enable/disable the product.
- Exclude usergroups from being logged.
- Purge the logs.

Picture


Installation
1. Download the .zip file specified.
2. Upload the contents of the upload folder to the root of your forum.
3. Import the product with the .xml file in the import folder.

Note
The script will log using the current time on the server, in case there's a difference between the server time and your local computer time, you can change the offset in the loginlog.php script on line 12.

Also keep in mind that the country and/or ISP resolving might not be 100% accurate and that it might show no value in the logs.

Credits
Telize.com its API is being used to get the ISP and country off the IP address.

Let me know if it works well.


Changelog
11 June 2014 V4: Added the table_prefix global to the login hook.
5 June 2014 V3: Fixed searching only showing the last 25 entries. Pagination will now work as intended.
30 May 2014 V2: Changed hook location, added enable/disable setting and a setting to exclude usergroups.
28 May 2014 V1: Fixed a little mistake with the filter.

[Dave]

Yep, Telize took the public API down. I'll update the plugin soon.

[EvoDarrenshan]

Warning: file_get_contents(http://www.telize.com/geoip/ip): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in [path]/includes/functions_login.php(204) : eval()'d code on line 10

[Dave]

I just uploaded a new version which uses a different API.

[EvoDarrenshan]

Originally Posted by Dave

I just uploaded a new version which uses a different API.

I downloaded the latest one O.o Should i re-download?

[Dave]

Originally Posted by EvoDarrenshan

I downloaded the latest one O.o Should i re-download?

Yes, I uploaded a new one which should work.

[tareqbd]

Originally Posted by Dave

Yes, I uploaded a new one which should work.

Thanks Dave. But it is taking the cloudflare masks. How do I get the real IP.

[Dave]

Originally Posted by tareqbd

Thanks Dave. But it is taking the cloudflare masks. How do I get the real IP.

In the "Plugin Manager", find the plugin for this product and change $_SERVER['REMOTE_ADDR'] to $_SERVER['HTTP_CF_CONNECTING_IP'] or IPADDRESS.

[tareqbd]

Originally Posted by Dave

In the "Plugin Manager", find the plugin for this product and change $_SERVER['REMOTE_ADDR'] to $_SERVER['HTTP_CF_CONNECTING_IP'] or IPADDRESS.

Thanks. While checking the functions, I have faced some problems as below.

Warning: Missing argument 2 for vB_Database::execute_query(), called in ..../admincp/loginlog.php on line 41 and defined in ..../includes/class_core.php on line 412

Warning: mysql_query() expects parameter 2 to be resource, null given in ..../includes/class_core.php on line 417

And sql error:

Database error in vBulletin 4.2.2:

Invalid SQL:
;

MySQL Error :
Error Number : 0
Request Date : Sunday, January 17th 2016 @ 02:20:47 PM
Error Date : Sunday, January 17th 2016 @ 02:20:47 PM
Script : http://www.domain.com/admincp/loginlog.php?do=purgenow
Referrer : http://www.domain.com/admincp/loginlog.php?do=purge
IP Address : xxx.xxx.xx.xx
Username : pps
Classname : vB_Database
MySQL Version :

[Dave]

Did you change anything in the code? That error is never supposed to happen.

[tareqbd]

Originally Posted by Dave

Did you change anything in the code? That error is never supposed to happen.

Not really. I just changed the plugin code as you mentioned for bypassing the cloudflare.