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.

[Gero50]

Great work I'm sure this will help us a lot.

[Taev]

Originally Posted by 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.

Hi

Exactly what I was looking for but unfortunately, all unregistered users are logged as well which is increasing the server load (and which is unnecessary information for me). Any chance to exclude this "usergroup"?


Thanks & Cheers
Taev

[welson]

Hi, i have successful install the file. but im not able to click the install button. It works fine. thank you for this useful logs. Can i change the title name from Log Logins Hack to Log Logins. Thank you again.

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?

[doubleclick]

Hello -

I downloaded this hack, as people were logging in to some of my test accounts, and I wanted to see where they were coming from. One is logged in now, according to the user's page in the admincp. However, they don't show up as being logged in from your hack. Does anyone know what this means?