Login with your Email Address or Username

Tastatur
Ever had the experience that you tried to Login to a Website but you couldn't remember your Username? If you don't want your Users to go through this your simply have to change 2 lines of code in the checklogin.php

Search for:

Code:

1.	$check = safe_query("SELECT * FROM ".PREFIX."user WHERE username='".$ws_user."'");

Change to:

Code:

1.	$check = safe_query("SELECT * FROM ".PREFIX."user WHERE username='".$ws_user."' OR email='".$ws_user."'");

Search for:

Code:

1.	$check = safe_query("SELECT * FROM ".PREFIX."user WHERE username='".$ws_user."' AND activated='1'");

Change to:

Code:

1.	$check = safe_query("SELECT * FROM ".PREFIX."user WHERE username='".$ws_user."' OR email='".$ws_user."' AND activated='1'");

Wrapping it up

That's it! Your Users can now Login with their Username or their Email Address! You might want to tell them that they have both options now, open templates/login.html and add the information there.

written by Pascalmh
02.12.2010 - 15:28