Page 71 of 71

Re: Log IP Address on Registration

Posted: Fri Jul 04, 2008 11:27 am
by RMcGirr83

Re: Log IP Address on Registration

Posted: Fri Jul 04, 2008 11:59 am
by Rikonen
Does it run on phpBB 2.0.23???

Re: Log IP Address on Registration

Posted: Fri Jul 04, 2008 5:25 pm
by TerraFrost
Rikonen wrote:Does it run on phpBB 2.0.23???
Yes.

Re: Log IP Address on Registration

Posted: Mon Jul 07, 2008 7:41 am
by T12VNG
by RMcGirr83 on Fri Jul 04, 2008 12:27 pm
Knowledge Base - How to Install MODs

Read number 11 :)
Rich McGirr
I'll have a read through & see if I can sort it out, thank you again :) .

Re: Log IP Address on Registration

Posted: Thu Jul 17, 2008 3:44 pm
by sceltic
Good mod.
Is it possible to log IP'S of failed login attempts. This would be useful against those trying to guess passwords of active members.

something simple like a emal to admin with the user name attempted and ip used

Re: Log IP Address on Registration

Posted: Thu Jul 17, 2008 3:46 pm
by Brf
That would be a totally different mod.
This one involves registration, not login.

Re: Log IP Address on Registration

Posted: Thu Jul 17, 2008 5:10 pm
by sceltic
Sure, thinking more, I understand now that they are going to be different.
Ok does, Anyone know if there is there such a mod that logs the ip of failed logins?

Re: Log IP Address on Registration

Posted: Thu Jul 17, 2008 5:34 pm
by Jim_UK
This is a support topic for a mod and not to be used for mod requests.
The phpBB2 mod requests forum is closed to posting but you could search the database and maybe try over at phpbbhacks.

Jim

Re: Log IP Address on Registration

Posted: Fri Jul 18, 2008 8:04 pm
by microtekblue
Hello,

I understand the php part of this mod, but not too good with the sql.

Is there a step by step guide on how to do the sql changes?

Thanks :)

Re: Log IP Address on Registration

Posted: Fri Jul 18, 2008 8:24 pm
by Jim_UK
microtekblue wrote:Hello,

I understand the php part of this mod, but not too good with the sql.

Is there a step by step guide on how to do the sql changes?

Thanks :)
There is only one change and very easy to do.
Access your database with phpmyadmin and click the database name in the left hand column. Now click the SQL tab at the top right window.
Now copy and paste this

Code: Select all

ALTER TABLE phpbb_users ADD user_regip CHAR(8) NOT NULL DEFAULT '0';
into the small window and click "Go"

If you do not have access to a database tool such as that then you can generate a PHP file to run with your browser such as this

Code: Select all

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey
 *   project              : http://sourceforge.net/projects/dbgenerator
 *   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_regip CHAR(8) NOT NULL DEFAULT '0'";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successful</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>Installation Complete</th></tr><tr><td><span class="genmed">Please be sure to delete this file now.<br />If you require any further assistance, please visit the <a href="http://www.phpbbhacks.com/forums">phpBBHacks.com Support Forums</a>.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Go back to your index page</a>.</span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>
Copy that into Notepad and save as db_update.php
Place it into a directory called "install" and ftp to the root of your board.
Log in and then run the file with your browser.
Now delete the install directory

Jim

Re: Log IP Address on Registration

Posted: Fri Jul 18, 2008 8:38 pm
by microtekblue
wow great Thank you Very much!! :D