Log Logins Hack

Log Logins Hack 1.1

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

• Files edited: 0
• Templates edited: 0
• Files to upload: 2
• Time to install: 1 minutes max

Updates:

Version 1.0 (11/05/05):

• GOLD Release of this hack for vBulletin version 3.5

Version 1.1 (11/06/05):

• Added logging of were the log was made. (Standard, Mod CP, or Admin CP)

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.

Pictures:

1. Admin Control Panel View of Stats

[Abe1]

Originally Posted by Boofo

One last question ... any way to prune this form the Admin CP if it starts to get large?

Yes. On the same page as you can view the logings, there is an option to prune.

[Boofo]

Thank you, sir, installing now.

[Mu5icMan]

very nice indeed, 'clicks install'

[seangworld]

ok, i took your suggestion on my request thread, abe, and im looking at this. as i see it, it appears that it will only keep track of those that have registered, but what i was looking for is something to track ips of those that ARE registered AND those that are NOT registered.

can this do that too?

[Abe1]

Originally Posted by seangworld

ok, i took your suggestion on my request thread, abe, and im looking at this. as i see it, it appears that it will only keep track of those that have registered, but what i was looking for is something to track ips of those that ARE registered AND those that are NOT registered.

can this do that too?

So you dont want just a log-in logger. You want something that logs all IP's that ever come to the forum. What would you do with it?

[derekivey]

Originally Posted by seangworld

ok, i took your suggestion on my request thread, abe, and im looking at this. as i see it, it appears that it will only keep track of those that have registered, but what i was looking for is something to track ips of those that ARE registered AND those that are NOT registered.

can this do that too?

Can't you just look at the raw apache log to determine who comes to the forum?

[Bro_Joey_Gowdy]

*Rowdy clicks install*

[jesus likes pie]

ooh i like this.

*installs and clicks on install*

[jesus likes pie]

Oh and now I see an sql error when entering a userid (Show Only Entries Generated By UserID: (leave blank to show all))

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

		SELECT COUNT(*) AS total
		FROM logins AS logins
		userid = 1;

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 'userid = 1' at line 3
Error Number : 1064
Date         : Monday, August 15th 2005 @ 01:30:36 PM
Script       : http://www.ugforums.org/ugforums/admincp/loginlog.php
Referrer     : http://www.ugforums.org/ugforums/admincp/loginlog.php
IP Address   : 71.241.238.138
Username     : ATI4EVER!
Classname    : vb_database

[Abe1]

Originally Posted by jesus likes pie

Oh and now I see an sql error when entering a userid (Show Only Entries Generated By UserID: (leave blank to show all))

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

		SELECT COUNT(*) AS total
		FROM logins AS logins
		userid = 1;

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 'userid = 1' at line 3
Error Number : 1064
Date         : Monday, August 15th 2005 @ 01:30:36 PM
Script       : http://www.ugforums.org/ugforums/admincp/loginlog.php
Referrer     : http://www.ugforums.org/ugforums/admincp/loginlog.php
IP Address   : 71.241.238.138
Username     : ATI4EVER!
Classname    : vb_database

I see were the error is. I'll go fix it tonight if I have a min.