Separate Login and User Name

Post by **Extensions Robot** » Sat Sep 05, 2009 4:25 am

Modification name: Separate Login and User Name
Author: nouveau
Modification description: Creates a login name that is separate from the forum username. Can be controlled via the ACP / UCP.

The MOD will allow users to keep the same login name while their username (screen name) can be changed to whatever they like. This saves users forgetting their login name if "allow username changes" permissions are enabled and the users constantly change and their username.

The MOD can also add another layer of security if someone tries to access a user account thinking that the username is the loginname, the attacker will be trying to access a name that doesn't authenticate, this is only however if the user creates a different username from their login name.
Modification version: 1.0.11
Tested on phpBB version: 3.0.11

Download file: separate_login_and_user_name_1_0_11.zip
File size: 233.79 KiB

Modification overview page: View

The phpBB Team is not responsible nor required to provide support for this modification. By installing this MOD, you acknowledge that the phpBB Support Team or phpBB Extensions Team may not be able to provide support.

-->Modification support<--

YouTube · Post by **DavidIQ** » Sat Sep 05, 2009 4:25 am

Modification validated/released

Notes:

nouveau · Post by **nouveau** » Sat Sep 05, 2009 4:25 am

Fix error with reset password in 1.0.7

Open includes\ucp\ucp_remind.php

Find

Code: Select all

		//$username	= request_var('username', '', true);
		$loginname	= request_var('loginname', '', true);
		// End Sep Login Name Mod

After add

Code: Select all

		$email		= strtolower(request_var('email', ''));

nouveau · Post by **nouveau** » Sat Sep 05, 2009 10:54 am

Thanks for validating MOD team, took a while, but we finally got there.

ameisez · Post by **ameisez** » Sun Sep 06, 2009 2:54 pm

Congrats!

I really love this Mod but the issue with integration really got me stucked. I hope you will find a way on your own time to be able to work around the issue.

Again.. congrats!

PinoyEngine™ · Post by **PinoyEngine™** » Wed Sep 09, 2009 3:53 pm

This is what I am looking for! Thanks for this very wonderful MOD.

Robahall · Post by **Robahall** » Wed Sep 09, 2009 10:28 pm

Great mod, I'm sure many people will find this one very useful

vmd · Post by **vmd** » Thu Sep 10, 2009 10:59 am

Hi, this mod is exactly what I'm after. I am however having some issues installing it and have got myself in a bit of a mess! I hope this is the right place to post.

Firstly I'm using phpbb 3.0.5 and MS SQL 2000

I used the DIY instructions so copied across the files and then ran the index.php from install. When I first ran it I got a 404 error. I logged back in and tried it again and this time I got the following:

Code: Select all

General Error
SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'loginname' in table 'phpbb_users' is specified more than once. [S0021]

SQL

ALTER TABLE [phpbb_users] ADD [loginname] [varchar] (255) DEFAULT ('') NOT NULL

BACKTRACE


FILE: includes/db/mssql_odbc.php
LINE: 165
CALL: dbal->sql_error()

FILE: includes/db/db_tools.php
LINE: 900
CALL: dbal_mssql_odbc->sql_query()

FILE: includes/db/db_tools.php
LINE: 1219
CALL: phpbb_db_tools->_sql_run_sql()

FILE: install/index.php
LINE: 117
CALL: phpbb_db_tools->sql_column_add()

I half wondered whether this meant it had done something the first time I ran it, so I logged in and added dissallow login names via the system > mod mgt. When I then try to click on this under user security I get the following error:

Code: Select all

General Error
SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DISALLOW_LOGIN_TABLE'. [S0002]

SQL

SELECT * FROM DISALLOW_LOGIN_TABLE

BACKTRACE


FILE: includes/db/mssql_odbc.php
LINE: 165
CALL: dbal->sql_error()

FILE: includes/acp/acp_disallow_loginnames.php
LINE: 92
CALL: dbal_mssql_odbc->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_disallow_loginnames->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

I've looked at the SQL tables and it has created a table called 'phpbb_disallow_login' and within 'phpbb_users' there is a column called 'loginname' and 'loginname_clean'.

Have I missed something, or have I done something wrong? Any help is greatly appreciated. Thanks

nouveau · Post by **nouveau** » Thu Sep 10, 2009 1:21 pm

HI vmd,

First off, have you completed all of the file edits?

I haven't tested the mod on any version of mssql so not sure of th error there, but still looks as though it performed the database inserts and modifications.

vmd · Post by **vmd** » Fri Sep 11, 2009 7:57 am

Hi xceler8shun

Thanks for the reply. Sorry I'm not sure what you mean by have you completed all of the file edits?. I uploaded all of the files and put them in the various places i.e. acp to acp etc before running the install. Is there something else I should have done? Thanks again for your help.

nouveau · Post by **nouveau** » Fri Sep 11, 2009 1:38 pm

Yes, in the download there is a install.xml file that contains all the instructions and file edits that need to be completed.

load the install.xml file into firefox or internet explorer to view the file

yais · Post by **yais** » Fri Sep 11, 2009 7:16 pm

xceler8shun wrote:Yes, in the download there is a install.xml file that contains all the instructions and file edits that need to be completed.

load the install.xml file into firefox or internet explorer to view the file

did you then upload any files in the folder called root in the download?

nouveau · Post by **nouveau** » Fri Sep 11, 2009 11:58 pm

For those new to phpbb3 and Mods, I suggest a review of these two pages.

Opening a Modification for the First Time
http://www.phpbb.com/mods/opening/

Installing a Modification
http://www.phpbb.com/mods/installing/

ameisez · Post by **ameisez** » Sun Sep 13, 2009 8:50 pm

Hi xceler8shun,

Hope you will consider keeping the username as it was and add displayname instead on your future versions because bridging and integration will not be possible (i think) if this MOD is installed.

Thanks

Mudjosh · Post by **Mudjosh** » Tue Sep 15, 2009 9:53 pm

Is there any chance of being able to use automod to install this?

advertisements