Login with e-mail instead of username

Tomtefar2 · Post by **Tomtefar2** » Tue Nov 25, 2014 8:27 am

Hi,

I want users to log in with e-mail instead of username. Can someone instruct me how to modify my phpbb 3.1.1 board to achieve this? For obvious reasons I will not allow reuse of e-mail.

Thank you!

Holger · Post by **Holger** » Tue Nov 25, 2014 9:27 am

+1
Would be cool to have the choise!

Post by **stevemaury** » Tue Nov 25, 2014 2:30 pm

Add instructions telling them to use their email address as their username at registration?

Holger · Post by **Holger** » Tue Nov 25, 2014 2:39 pm

Nobody wants to show theire emailaddresses as usernames all over the place.
It would just be convenient to have the possibility to login either with username or with emailaddress. Only the username should be shown everywhere ...

Walther · Post by **Walther** » Tue Nov 25, 2014 4:07 pm

Basically you want this mod ported to an extension: https://www.phpbb.com/customise/db/mod/ ... via_email/

Wolfsblvt · Post by **Wolfsblvt** » Tue Nov 25, 2014 4:16 pm

I've done a quick check, there is no event in login functionality in phpBB 3.1, or I didn't found it.
So maybe you have to do an event reqeust first to get an event where you can implement code for this.

Otherwise the only solution I would know at the moment is do an own authorisation system.

Tomtefar2 · Post by **Tomtefar2** » Tue Nov 25, 2014 4:37 pm

Add instructions telling them to use their email address as their username at registration?

I have thought about this but then I would have to modify the entire forum to view the username.

Walther wrote:Basically you want this mod ported to an extension: https://www.phpbb.com/customise/db/mod/ ... via_email/

Yes, but I do not want usersame to be used as login at all (why?: viewtopic.php?f=466&t=2278011 )

I've done a quick check, there is no event in login functionality in phpBB 3.1, or I didn't found it.
So maybe you have to do an event reqeust first to get an event where you can implement code for this.

Otherwise the only solution I would know at the moment is do an own authorisation system.

Too bad, it would be nice to just redirect the verification to a different field.

Thank you for all your help so far!

jerome1362 · Post by **jerome1362** » Tue Jan 27, 2015 6:17 pm

Quelqu'un serait-il capable de créer une extension pour que les utilisateurs se connecte via leurs email au lieu de leur pseudo.

Simplement pour la connexion et non l'affichage sur le forum.

Merci.

marian0810 · Post by **marian0810** » Tue Jan 27, 2015 11:27 pm

jerome1362 wrote:Quelqu'un serait-il capable de créer une extension pour que les utilisateurs se connecte via leurs email au lieu de leur pseudo.

Simplement pour la connexion et non l'affichage sur le forum.

Merci.

We'd appreciate it if you stick to English only, thanks

promod · Post by **promod** » Mon Feb 01, 2016 4:27 pm

I have got a search result about login with email, Can anyone verify the same please.

How-to:
Open /phpbb_root/phpbb/auth/provider/db.php and search for $username_clean = utf8_clean_string($username);. Just below that, make sure the SQL-query looks like this instead:

Code: Select all

$sql = 'SELECT *
FROM ' . USERS_TABLE . "
WHERE user_email = '" . $this->db->sql_escape($username_clean) . "' OR username_clean = '" . $this->db->sql_escape($username_clean) . "'";

Source

SiteSplat · Post by **SiteSplat** » Mon Feb 01, 2016 4:32 pm

Tomtefar2 wrote:Hi,

I want users to log in with e-mail instead of username. Can someone instruct me how to modify my phpbb 3.1.1 board to achieve this? For obvious reasons I will not allow reuse of e-mail.

Thank you!

There is already an extension for this. https://github.com/ForumHulp/loginwithemail
You can use it with my premium themes as well.

promod · Post by **promod** » Thu Feb 04, 2016 7:57 am

Is this recommended to use with a live board?

Holger · Post by **Holger** » Thu Feb 04, 2016 8:01 am

When trying to activate the ext I get: The update process errored.

Edit: my fault, I did not install the ForumHulp Helper

promod · Post by **promod** » Sat Feb 06, 2016 5:32 am

SiteSplat wrote:There is already an extension for this. https://github.com/ForumHulp/loginwithemail
You can use it with my premium themes as well.

After enabling (including installing 'helper' and 'allow email login' i'm not able to succeed login with email,, Anything else to be done?

John P · Post by **John P** » Sat Feb 06, 2016 7:35 pm

Do you have a message in ACP log "Files succesfully changed" from Forumhulp helper?

advertisements