Page 1 of 9

Separate Login and User Name

Posted: Sat Sep 05, 2009 4:25 am
by 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 Extensions Team may not be able to provide support.

-->Modification support<--

Separate Login and User Name

Posted: Sat Sep 05, 2009 4:25 am
by DavidIQ
Modification validated/released

Notes:

Separate Login and User Name

Posted: Sat Sep 05, 2009 4:25 am
by 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', ''));

Re: Separate Login and User Name

Posted: Sat Sep 05, 2009 10:54 am
by nouveau
Thanks for validating MOD team, took a while, but we finally got there.

Re: Separate Login and User Name

Posted: Sun Sep 06, 2009 2:54 pm
by 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! :)

Re: Separate Login and User Name

Posted: Wed Sep 09, 2009 3:53 pm
by PinoyEngineâ„¢
This is what I am looking for! Thanks for this very wonderful MOD. ;)

Re: Separate Login and User Name

Posted: Wed Sep 09, 2009 10:28 pm
by Robahall
Great mod, I'm sure many people will find this one very useful :)

Re: Separate Login and User Name

Posted: Thu Sep 10, 2009 10:59 am
by 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

Re: Separate Login and User Name

Posted: Thu Sep 10, 2009 1:21 pm
by 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.

Re: Separate Login and User Name

Posted: Fri Sep 11, 2009 7:57 am
by 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.

Re: Separate Login and User Name

Posted: Fri Sep 11, 2009 1:38 pm
by 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

Re: Separate Login and User Name

Posted: Fri Sep 11, 2009 7:16 pm
by yais
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?

Re: Separate Login and User Name

Posted: Fri Sep 11, 2009 11:58 pm
by 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/

Re: Separate Login and User Name

Posted: Sun Sep 13, 2009 8:50 pm
by 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

Re: Separate Login and User Name

Posted: Tue Sep 15, 2009 9:53 pm
by Mudjosh
Is there any chance of being able to use automod to install this? :?