Login by username or email

This code modification was made as part of a request in this thread: https://vborg.vbsupport.ru/showthrea...5&page=1&pp=15

All that it does is allow to use the email address instead of the username to be used to login (username also still works).

Since people where stating that it should be released, well here it goes.

1 File edit:
in file includes/functions_login.php, find:

PHP Code:

    if ($vbulletin->userinfo = $vbulletin->db->query_first("SELECT userid, usergroupid, membergroupids, username, password, salt FROM " . TABLE_PREFIX . "user WHERE username = '" . $vbulletin->db->escape_string(htmlspecialchars_uni($username)) . "'")) 


and replace by:

PHP Code:

 // Start hack login with mail address (MarcoH64)
//    if ($vbulletin->userinfo = $vbulletin->db->query_first("SELECT userid, usergroupid, membergroupids, username, password, salt FROM " . TABLE_PREFIX . "user WHERE username = '" . $vbulletin->db->escape_string(htmlspecialchars_uni($username)) . "'"))
if (!$vbulletin->userinfo = $vbulletin->db->query_first("SELECT userid, usergroupid, membergroupids, username, password, salt FROM " . TABLE_PREFIX . "user WHERE username = '" . $vbulletin->db->escape_string(htmlspecialchars_uni($username)) . "'"))
{
$vbulletin->userinfo = $vbulletin->db->query_first("SELECT userid, usergroupid, membergroupids, username, password, salt FROM " . TABLE_PREFIX . "user WHERE email = '" . $vbulletin->db->escape_string(htmlspecialchars_uni($username)) . "'");
}
if ($vbulletin->userinfo)
// End hack login with mail address (MarcoH64) 


This will allow logging in with either mail or username.

good idea, anyway, this is only a if statement to add, so it's not complicated to enhance if needed (like register by email only...)

[Marco van Herwaarden]

email only would even be easier, just replace 1 word in the original file.

[Lurk]

Wow, this is awesome.. except I won't be using it, maybe later. I like the concept and idea, it can be like a passport system if you integrate it into many sites.

[Marco van Herwaarden]

Just a pitty it has to be a code change.

[deathemperor]

how about extend this to allow userid logging ?

[Marco van Herwaarden]

How you mean? Log what about a userid?

This is a simple code mod that make it possible to login with email address, there is no logging involved in this, and there won't be also.

i think he was referring to login via with our userid indead of email or username... this becomes a little useless here... who remembers their userid better than their username?!

[Marco van Herwaarden]

Lol, well logging in with userid could be done the same way, but it won't be easier to remember.

[deathemperor]

Originally Posted by nexialys

i think he was referring to login via with our userid indead of email or username... this becomes a little useless here... who remembers their userid better than their username?!

me and most of my member

ppl who have joined for a long period of time would remember it.

well whatever, just an idea