Administrative and Maintenance Tools - Log Logins Hack

Log Logins Hack

Click here to Nominate this Mod for Mod the Month

About this hack:
This hack will log the userid, username, ipaddress, where the login is, and time all your users log onto your forum.

Installation information on hack:

• Files edited: 0
• Templates edited: 0
• Files to upload via FTP: 2
• Time to install: 1 minute max

Updates:
Version 2.10 (05/03/10):

• First release of this hack for vb 4.0.

Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL!
You will get an email when a new version is released.

[Blooded]

Works great thanks a lot

[top dogs 360]

We have awards for log in streaks. A 1 month, 3 month, 6 month, 1 & 2 year streaks.

This allows us to track users log in accordingly. This information has nothing to do with privacy. It only has to do with seeing who is online and how often.

The goal is to reward your members for their activity on your site. They have many options out there and everyone should be lucky people spend their time on websites.


TD
www.xboxhounds.com

[top dogs 360]

Never mind doesnt work how I need it to because many member dont log in and out. They just stay logged in all day and night I guess? This track misses that because it does not track any activity.

[Videx]

Originally Posted by top dogs 360

... I need it to because many member dont log in and out. They just stay logged in all day and night I guess?

Some may, but not unless they try. Normally the Session Timeout number at AdminCP > Settings > Options > Cookies and HTTP Header Options will log them out automatically.

[kylek]

Thanks for this, installed!

[meeja]

Could I suggest this hack also record useragent (and maybe make it searchable too on that).

Such a great mod.

[lemonadesoda]

This is great. Thx.

However, the sort by IP view is missing. Please add this!

[nocte]

I'm using this hack on a big forum. Now i got this database error (only once):

Invalid SQL:
INSERT INTO logins (userid, username, ipaddress, phpdate, logintype)
VALUES (, '', 'XX.XX.XX.XX', 1293458891, '');

[OldSchoolDSL]

This can be useful.

Installed and working

4.1 PL2

[aileron79]

Hi!

First of all, thanks for the hack, it really does a great job! There is only one huge problem. Some users are "always", or better "automatically" logged in by their cookies. Thus, the IP addresses of those users are NOT recorded.

Admittedly, I have no clue how this could be achieved, the only idea would be to check if there is a record matching the same ip for a particular user when opening forum_home. This, however, may of course increase database load but is probably suitable for small forums.

Well, I definitely needed that... so I just wrote the required plugin by myself, you may include that in the original addon if you like... please test thoroughly before use!

PHP Code:

$cb_lastknown_ip = $vbulletin->db->query_first("SELECT ipaddress FROM " . TABLE_PREFIX . "logins WHERE userid=" . $vbulletin->userinfo['userid']. " ORDER BY phpdate DESC LIMIT 1");
if ($cb_lastknown_ip['ipaddress'] != IPADDRESS)
{
    $vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "logins (userid, username, ipaddress, phpdate, logintype) VALUES (" . $vbulletin->userinfo['userid'] . ", '" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "', '" . $vbulletin->db->escape_string(IPADDRESS) . "', " . TIMENOW . ", '$logintype')");
}
unset($cb_lastknown_ip); 


I created a new plugin for Log Logins Hack at hook forumhome_start (maybe ..._end would be better... let's see...). Don't forget to activate, use at your own risk.