Separate Login and User Name

[Extensions Robot]

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 Extension Customisations Team may not be able to provide support.

-->Modification support<--

[DavidIQ]

Modification validated/released

Notes:

[nouveau]

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]

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

[ameisez]

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™]

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

[Robahall]

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

[vmd]

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]

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]

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]

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]

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]

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]

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]

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