Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Login log - Log successful login attempts Details »
Login log - Log successful login attempts
Mod Version: 4.1, by Dave (Moderator) Dave is offline
Developer Last Online: Nov 2020 I like it Show Printable Version Email this Page

vB Version: 4.x.x Rating: (5 votes - 4.80 average) Installs: 37
Released: 28 May 2014 Last Update: 16 Jan 2016 Downloads: 245
Supported DB Changes Uses Plugins Re-usable Code External Content  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	Untitled.jpg
Views:	1221
Size:	87.5 KB
ID:	149210  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #31  
Old 24 Feb 2015, 21:07
sevenmix's Avatar
sevenmix sevenmix is offline
 
Join Date: Apr 2009
How do i give full access to this product to a s-mod?
__________________
ForoBeta - Comunidad de bloggers en espaņol.
Reply With Quote
  #32  
Old 24 Feb 2015, 21:11
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by sevenmix View Post
How do i give full access to this product to a s-mod?
Unfortunately it's only accessible in the admincp.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #33  
Old 10 Mar 2015, 14:15
X-or X-or is offline
 
Join Date: Nov 2005
Originally Posted by Dave View Post
The API I use is open-source so you could simply integrate it on your own server and change the API URL I call in the script to your own local URL. https://github.com/fcambus/telize
thanks! good to know :-)
Reply With Quote
  #34  
Old 05 Oct 2015, 17:29
jscherbel jscherbel is offline
 
Join Date: Sep 2009
Looks like telize.com no longer exists so this is now preventing logins to my site and my administrative area. Anyone know how to disable it from the database level directly?

Update: I went into the file that throws the error/warning about cookies and commented out the line that contains the eval() (line 204 of my functions_login.php). Logged into the administrative panel. Disabled the mod. Re-added the code I commented out. Hope that helps someone else.

Thanks!

Last edited by jscherbel; 05 Oct 2015 at 17:40.
Reply With Quote
  #35  
Old 06 Oct 2015, 10:03
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by jscherbel View Post
Looks like telize.com no longer exists so this is now preventing logins to my site and my administrative area. Anyone know how to disable it from the database level directly?

Update: I went into the file that throws the error/warning about cookies and commented out the line that contains the eval() (line 204 of my functions_login.php). Logged into the administrative panel. Disabled the mod. Re-added the code I commented out. Hope that helps someone else.

Thanks!
That's weird, the site still seems online to me. Maybe it was down for a little bit?
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #36  
Old 07 Oct 2015, 10:50
friendlymela's Avatar
friendlymela friendlymela is offline
 
Join Date: Dec 2012
Real name: Zeeshan Shams
good for the security
Reply With Quote
  #37  
Old 07 Oct 2015, 19:32
blah100 blah100 is offline
 
Join Date: Oct 2014
Getting this database error after a login from a certain member:

Invalid SQL:
INSERT INTO loginlog (userid, username, loginstamp, browser, ip, isp, country) VALUES (24528, 'membername', NOW(), 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36', 'IP number', '', '');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'membername', NOW(), 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (' at line 1
Error Number : 1064
It's the same member, and a database error happens for each login attempt. Is it the case that if a member fails in trying to login that this database error happens?
Reply With Quote
  #38  
Old 08 Oct 2015, 11:20
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by blah100 View Post
Getting this database error after a login from a certain member:



It's the same member, and a database error happens for each login attempt. Is it the case that if a member fails in trying to login that this database error happens?
I uploaded a new version which should fix that.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #39  
Old 13 Jan 2016, 05:38
sevenmix's Avatar
sevenmix sevenmix is offline
 
Join Date: Apr 2009
Hi, im getting this error after i installed php 5.5:

in /home/********/public_html/includes/functions_login.php(204) : eval()'d code on line 102
[13-Jan-2016 05:37:04 UTC] PHP Warning: file_get_contents(http://www.telize.com/geoip/***.4.219.***): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found

What could be the problem? greetings.
__________________
ForoBeta - Comunidad de bloggers en espaņol.
Reply With Quote
  #40  
Old 13 Jan 2016, 08:28
z3r0's Avatar
z3r0 z3r0 is offline
 
Join Date: Apr 2005
Location: Lancashire, UK
Telize have a notice on the front page of their site that they have shut down the public API, that is probably the cause.
Reply With Quote
  #41  
Old 13 Jan 2016, 15:26
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Yep, Telize took the public API down. I'll update the plugin soon.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #42  
Old 16 Jan 2016, 16:42
EvoDarrenshan EvoDarrenshan is offline
 
Join Date: May 2014

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #43  
Old 16 Jan 2016, 17:05
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
I just uploaded a new version which uses a different API.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #44  
Old 16 Jan 2016, 17:15
EvoDarrenshan EvoDarrenshan is offline
 
Join Date: May 2014
Originally Posted by Dave View Post
I just uploaded a new version which uses a different API.
I downloaded the latest one O.o Should i re-download?
Reply With Quote
  #45  
Old 16 Jan 2016, 17:37
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by EvoDarrenshan View Post
I downloaded the latest one O.o Should i re-download?
Yes, I uploaded a new one which should work.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:56.

Layout Options | Width: Wide Color: