Separate Login and User Name

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
User avatar
nota
Registered User
Posts: 75
Joined: Sun Jun 01, 2003 9:42 pm
Name: Joe
Contact:

Re: Separate Login and User Name

Post by nota » Sun Nov 29, 2009 5:22 am

Had problems with the ubiquity of this mod:
I'm not entirely sure if all the initial changes in this are necessary, please double check. However, I thought it weird that you logged in with loginname but retrieved your password with the user name


includes\ucp\ucp_remind.php
FIND:

Code: Select all

$username	= request_var('username', '', true);
AFTER ADD:

Code: Select all

$loginname	= request_var('loginname', '', true);
FIND:

Code: Select all

$sql = 'SELECT user_id, username, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason
				FROM ' . USERS_TABLE . "
				WHERE user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "'
					AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";
REPLACE WITH:

Code: Select all

$sql = 'SELECT user_id, username, loginname, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason
				FROM ' . USERS_TABLE . "
				WHERE user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "'
					AND loginname_clean = '" . $db->sql_escape(utf8_clean_string($loginname)) . "'";
styles\prosilver\template\ucp_remind.html
FIND:

Code: Select all

		<dl>
			<dt><label for="username">{L_USERNAME}:</label></dt>
			<dd><input class="inputbox narrow" type="text" name="username" id="username" size="25" /></dd>
		</dl>
REPLACE WITH:

Code: Select all

		<dl>
			<dt><label for="{LOGINNAME_CREDENTIAL}">{L_LOGINNAME}:</label></dt>
			<dd><input type="text" tabindex="1" name="loginname" id="loginname" size="25" value="" class="inputbox narrow" /></dd>
		</dl>
REPLACE WITH:

Code: Select all

$sql = 'SELECT user_id, username, loginname, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason
				FROM ' . USERS_TABLE . "
				WHERE user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "'
					AND loginname_clean = '" . $db->sql_escape(utf8_clean_string($loginname)) . "'";
FIND:

Code: Select all

'USERNAME'		=> htmlspecialchars_decode($user_row['username']),
AFTER ADD:

Code: Select all

'LOGINNAME'		=> htmlspecialchars_decode($user_row['loginname']),

nouveau
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: Separate Login and User Name

Post by nouveau » Sun Nov 29, 2009 8:07 am

Hi Nota,

Thanks for the heads up, I didn't even realise I had overlooked that part.

I haven't yet tested the MOD on 3.0.6 so will update and correct for that and correct the retrieve password section at the same time along with a few other issues.
Formerly known as xceler8shun

Peter77sx
Registered User
Posts: 3255
Joined: Wed Nov 09, 2005 2:51 pm

Re: Separate Login and User Name

Post by Peter77sx » Wed Dec 02, 2009 12:20 am

xceler8shun wrote:Hi Nota,

Thanks for the heads up, I didn't even realise I had overlooked that part.

I haven't yet tested the MOD on 3.0.6 so will update and correct for that and correct the retrieve password section at the same time along with a few other issues.


Are we going to see any of the changes so that we don't have to wait for it to get re-validted?

Peter77sx
Registered User
Posts: 3255
Joined: Wed Nov 09, 2005 2:51 pm

Re: Separate Login and User Name

Post by Peter77sx » Tue Dec 08, 2009 1:22 am

A shameless bump here. I see a few people had problems from the get-go installing it on 3.0.5. Are we better off waiting for your next release, will all those issues get ironed out :?:

Crew
Registered User
Posts: 30
Joined: Tue Mar 11, 2008 7:52 pm

Re: Separate Login and User Name

Post by Crew » Tue Dec 08, 2009 6:23 pm

Had problems with the ubiquity of this mod:
I'm not entirely sure if all the initial changes in this are necessary, please double check. However, I thought it weird that you logged in with loginname but retrieved your password with the user name
Sorry, but is this answer on my question?
nota wrote: includes\ucp\ucp_remind.php
FIND:
.....
AFTER ADD:
.....
FIND:
.....
REPLACE WITH:
.....

styles\prosilver\template\ucp_remind.html
FIND:
.....
REPLACE WITH:
.....
OK. This code is all clear. But what about next instructions? In ucp_remind.html there isn't such code.
nota wrote: REPLACE WITH:

Code: Select all

$sql = 'SELECT user_id, username, loginname, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason
				FROM ' . USERS_TABLE . "
				WHERE user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "'
					AND loginname_clean = '" . $db->sql_escape(utf8_clean_string($loginname)) . "'";
FIND:

Code: Select all

'USERNAME'		=> htmlspecialchars_decode($user_row['username']),
AFTER ADD:

Code: Select all

'LOGINNAME'		=> htmlspecialchars_decode($user_row['loginname']),
Where find this code and what file I sould edit?

User avatar
jonnilaumann
Registered User
Posts: 56
Joined: Mon Nov 30, 2009 12:32 am

Re: Separate Login and User Name

Post by jonnilaumann » Wed Jan 20, 2010 7:43 pm

Nice Mod..Finally :D

.looking forward to try.... I will test and install as soon as problems solved

I HAVE been hacked MANY times... and had to stop new accounts in forum..make further ACP settings..etc :x


..think phpbb default have HUGE security issues with out a MOD like this..

..also users weird login names show in post.(fikum1266_monster) or (anna1234). That looks like

...toooo Obvious for a hacker to guess its a login name
..the login name is usually users login for many other sites, and now its out in the open..BAD

:x shame on you phpBB :oops:
Last edited by jonnilaumann on Thu Jan 21, 2010 10:14 am, edited 2 times in total.

tiemco
Registered User
Posts: 3
Joined: Fri Jan 15, 2010 12:18 pm
Location: The Netherlands
Contact:

Re: Separate Login and User Name

Post by tiemco » Thu Jan 21, 2010 9:45 am

Nice MOD. Just what I was looking for.

I installed it op phpBB 3.0.6 with AutoMod 1.0.0-rc3.
Next to the DIY actions, this required some manual editting in

Code: Select all

styles/prosilver/template/ucp_register.html
and in

Code: Select all

styles/subsilver2/template/ucp_register.html
.
After install it looks as if it works.

However I have some problems with it:
  • When changing the username to a full name, ldap authentication breaks. It should probably use the loginname. Is my assumption correct?
  • When changing the username, but not the username_clean it looks like we want it, but this breaks ACP User Admin.
  • The ACP Add User MOD http://www.phpbb.com/community/viewtopi ... 8#p3193539 breaks.
We want have posts only from users that have a valid Active Directory account. However those account are more numbers than human readable names.

Any suggestions?
With kind regards,
Tiemco

Zason
Registered User
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX
Contact:

Re: Separate Login and User Name

Post by Zason » Sun Jan 24, 2010 6:32 pm

This is an excellent mod. I just installed it on PHPBB3 3.0.6 and it appears to work just fine.

This is in no way a negative comment! I would perfer it to have added a display name rather than the login replace the username as someone noticed, it makes other mods who use the username for things to be more difficult to add.

I had a few issues with the install, had some errors but after sticking with it, replacing functions.php and redoing the edits, it worked. It did not let me run the install... some how in may tinkering it added the tables for me. I may have navigated to a file in the install directory that ran the mysql command. No complaint. I like it. >:+)

"Z"
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.

Zason
Registered User
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX
Contact:

Re: Separate Login and User Name

Post by Zason » Tue Jan 26, 2010 6:47 pm

RESOLVED!
General Error
SQL ERROR [ mysqli ]

Duplicate entry '' for key 2 [1062]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
This was obtained when a user tried registering for my forums.
I am using this Mod, Application Form Mod and Warning Reasons Mod with 3.0.6
I registered a Test User and it worked with no problems (first registered user)
I asked a friend to register and he received the above error.
I checked the DB and the username_clean for the test user I made was blank.
I filled it in manually with all lowercase letters.
Tried to register my friend and it worked as normal but now his username_clean is blank

New Info: I have this error on 2 different forums.

I went back and edited fresh .php files (did not redo the .html files) and now it works. O_o
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.

nouveau
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: Separate Login and User Name

Post by nouveau » Fri Jan 29, 2010 5:04 am

Update.

I have been doing some testing over the last few days and tested and installed on 3.0.6 without issue thus far. I have also incorporated the UMIL install system which I would hope will solve many if not all of the database install issues people are having.

I have a few tweaks to go yet and a bit more testing, but I will make available 1.0.7 on here before validation submission for people to test out, preferably not on a live forum unless 100% comfortable with it.

I would expect a package file to be available in the next 2 days if everything works according to plan.
Formerly known as xceler8shun

Zason
Registered User
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX
Contact:

Re: Separate Login and User Name

Post by Zason » Fri Jan 29, 2010 2:59 pm

Good to hear, this is a mod I want to see staying alive! >:+) Thank you for your hard work. I currently have this mod working with PHPBB Primetime and a few others. This is a solid mod here.
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.

nouveau
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: Separate Login and User Name

Post by nouveau » Sat Jan 30, 2010 9:24 am

Ok, have updated the modification to 1.0.7 and fixed all the errors I hope that users have raised.

Also updated to modx version 1.2.3 and tested working on phpbb version 3.0.6

Here is the link to the unvalidated 1.0.7 version.

Modification Download: Unvalidated Version - 1.0.7

Changelog from 1.0.6 to 1.0.7
  • Tested working on 3.0.6
  • Updated to MODX 1.2.3
  • Incorporated UMIL (Unified MOD Install Library) to make database and module installation easier and less prone to error.
  • Fixed errors regarding reset password using username instead of loginname.
  • Fixed errors regarding using username instead of loginname in some language files.
There is still no LDAP support at this time, although it is on the todo list.
Formerly known as xceler8shun

aw11tech
Registered User
Posts: 28
Joined: Mon Jan 25, 2010 8:42 pm
Location: uk
Contact:

Re: Separate Login and User Name

Post by aw11tech » Sat Jan 30, 2010 2:44 pm

very excited about this mod..kudos..
will wait for the validated version coming soon..

Zason
Registered User
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX
Contact:

Re: Separate Login and User Name

Post by Zason » Sat Jan 30, 2010 4:42 pm

Having to reinstall my boards. First time to try this Auto Mod... why I waited, no idea.

I am new to Auto Mod so I do not know if this is how it works. Separate Login 1.0.6 had issues when using Auto Mod with phpbb 3.0.6 however Separate Login 1.0.7 installed without a hitch! I still had to navigate to the install_seplogin.php to install db fields. I do not know if that is normal for auto mod or not, but wow, smooth job and install.

"Z"
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.

nouveau
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: Separate Login and User Name

Post by nouveau » Sat Jan 30, 2010 11:31 pm

HI Zason, glad to hear it installed without a hitch.

I believe with automod, you still need to run the database install files separately as automod only does code changes.
Formerly known as xceler8shun

Locked

Return to “[3.0.x] MOD Database Releases”