Failed Login Logging

This is a hack that was suggested by paulomt1, all it does is log failed logins and stores them in a table. An admin can then look at the failed logins in the admin panel, searching based on ip, username, password or date. They can also prune the old logs to save space.

You will be required to create a table this can be done via phpmyAdmin or the hack by Firefly which allows you to run queries via the admin panel. You then have to edit member.php to add the query to insert the failed login information and /admin/index.php to add the links to the loginlog.php file.

Updated 25th November 2001 @ 22:15

Added additions suggested by Mike to the file. Instructions on how to upgrade from the pervious version of this hack is included within install.txt, you will need to run 2 sql queries to adjust the table, adjust the line in member.php and upload loginlog.php again to complete the upgrade.

Scott

[haas]

Seems to be a really good hack. Installing

[GOD-Dblade]

bad ass hack...works with 2.2.5

[GOD-Dblade]

well maybe not.....i tried logging into a account with a fake pass and all says is Showing record of 1 to 0 of 0

[wooolF[RM]]

]Admin CP -> Login Failures -> View -> List all failed logins ->

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: SELECT loginid,username,password,ip,userid,FROM_UNIXTIME(atime) as atime FROM loginlog WHERE 1=1 ORDER BY username  LIMIT 0,99999999
mysql error: Table 'mpc.loginlog'  doesn't exist

mysql error number: 1146

Date: Wednesday 17th of April 2002 12:29:58 PM
Script: http://www.mysite.com/forum/forum/admin/loginlog.php?s=&action=find 
Referer: http://www.mysite.com/forum/admin/lo...tion=modify&s=

1) Why does it look after 'mpc.loginlog' table and not loginlog table? my main database called mpc, table called loginlog. I can't understand why it mixes these two
2) Why does it point to "http://www.mysite.com/forum/forum"? Can u see it? Forum stays 2 times...

I have done everything after instruction and double checked it...

[wooolF[RM]]

]I have also tried to run this query:

CREATE TABLE mpc.loginlog  (
  loginid int(10) unsigned NOT NULL auto_increment,
  ip varchar(20) NOT NULL default '',
  username varchar(50) NOT NULL default '',
  password varchar(50) NOT NULL default '',
  userid int(10) unsigned NOT NULL default '0',
  atime int(10) unsigned NOT NULL default '0',
  KEY id (loginid)
);

but got next error:

Error

SQL-query :  

CREATE TABLE mpc.loginlog (
  loginid int(10) unsigned NOT NULL auto_increment,
  ip varchar(20) NOT NULL default '',
  username varchar(50) NOT NULL default '',
  password varchar(50) NOT NULL default '',
  userid int(10) unsigned NOT NULL default '0',
  atime int(10) unsigned NOT NULL default '0',
  KEY id (loginid)
)

MySQL said: 


Table 'loginlog' already exists

This sounds weird... First it says it doesn't exist, then it exist... hmmm. Please help

[James5mith]

Btw....
Axel,

Couldn't you also include one additional field similar to the others below the next section of the member.php? The part where it says cookie login? I mean in order to log people returning to the boards who are browsing with cookies?

I'm installing PPN's hack now, and making your modifications, Axel. I will let you all know how it works out.

[James5mith]

[QUOTE]Originally posted by Axel Foley
In this way I can log TWO TYPES of FAILED LOGINS, and all the successful logins too. I added two fields to the database.

[Scott MacVicar]

thats an unusual error for the table, its there but its not there for vB? What version of php and mysql are you running?

[wooolF[RM]]

]Server Type
Linux / PHP v4.1.2-hostdemon Safe Mode

MySQL
v3.23.36

vBB
2.2.4

( https://vborg.vbsupport.ru/showthrea...604#post241604 ) = (my problem, this thread, post 44)

[GOD-Dblade]

edit