
Login with email address? (General)
Hello,
the SQL statement selects the users by the names - see where
-condition at the end of this statement:
SELECT user_id, user_name, user_pw, user_type, UNIX_TIMESTAMP(last_login) AS last_login, UNIX_TIMESTAMP(last_logout) AS last_logout, thread_order, user_view, sidebar, fold_threads, thread_display, category_selection, auto_login_code, activate_code, LANGUAGE, time_zone, time_difference, theme, tou_accepted, dps_accepted FROM ".$db_settings['userdata_table']." WHERE LOWER(user_name) = '". mysqli_real_escape_string($connid, my_strtolower($request_username, $lang['charset'])) ."'")
Maybe(!), it is possible to add a further condition to the email field user_email
, i.e.,
WHERE LOWER(user_name) = '". mysqli_real_escape_string($connid, my_strtolower($request_username, $lang['charset'])) ."'") OR lower(user_email) = '". mysqli_real_escape_string($connid, my_strtolower($request_username, $lang['charset'])) ."'")
Please note: There is a negative side effect (security issue). Currently, the email filed is NOT a unique field. Different users can have identical mail addresses. This is critical, because the email-password combination is not bijective.
/Micha
--
applied-geodesy.org - OpenSource Least-Squares Adjustment Software for Geodetic Sciences
Complete thread:
- Login with email address? -
Stephan Sander,
2021-03-01, 07:35
- Login with email address? -
Micha,
2021-03-01, 08:22
- Login with email address? -
Stephan Sander,
2021-03-01, 09:21
- Login with email address? - Micha, 2021-03-01, 09:44
- Login with email address? -
Micha,
2021-03-01, 10:13
- Login with email address? -
Auge,
2021-03-01, 11:39
- Login with email address? -
Micha,
2021-03-01, 17:22
- Login with email address? -
Auge,
2021-03-01, 21:59
- Login with email address? -
Micha,
2021-03-05, 16:36
- Login with email address? - Auge, 2021-03-05, 16:57
- Login with email address? -
Micha,
2021-03-05, 16:36
- PHP 8 und @ -
Taurec,
2021-03-11, 09:06
- PHP 8 und @ -
Auge,
2021-03-11, 14:19
- PHP 8 Kommentarzeichen -
Micha,
2021-03-11, 16:52
- PHP 8 Kommentarzeichen -
Auge,
2021-03-11, 21:22
- PHP 8 Kommentarzeichen -
Micha,
2021-03-12, 07:26
- PHP 8 Kommentarzeichen -
Auge,
2021-03-12, 12:01
- PHP 8 Kommentarzeichen -
Micha,
2021-03-12, 12:14
- PHP 8 Kommentarzeichen -
Auge,
2021-03-12, 13:17
- PHP 8 Kommentarzeichen -
Micha,
2021-03-12, 13:47
- MySQL-Libs in PHP -
Auge,
2021-03-12, 14:30
- MySQL-Libs in PHP -
Micha,
2021-03-12, 14:49
- MySQL-Libs in PHP -
Emil,
2021-06-02, 19:47
- MySQL-Libs in PHP -
Auge,
2021-06-03, 08:26
- MySQL-Libs in PHP -
Emil,
2021-06-03, 17:20
- MySQL-Libs in PHP - Auge, 2021-06-04, 12:46
- MySQL-Libs in PHP -
Emil,
2021-06-03, 17:20
- MySQL-Libs in PHP -
Auge,
2021-06-03, 08:26
- MySQL-Libs in PHP -
Emil,
2021-06-02, 19:47
- MySQL-Libs in PHP -
Micha,
2021-03-12, 14:49
- MySQL-Libs in PHP -
Auge,
2021-03-12, 14:30
- PHP 8 Kommentarzeichen -
Micha,
2021-03-12, 13:47
- PHP 8 Kommentarzeichen -
Auge,
2021-03-12, 13:17
- PHP 8 Kommentarzeichen -
Micha,
2021-03-12, 12:14
- PHP 8 Kommentarzeichen -
Auge,
2021-03-12, 12:01
- PHP 8 Kommentarzeichen -
Micha,
2021-03-12, 07:26
- PHP 8 Kommentarzeichen -
Auge,
2021-03-11, 21:22
- PHP 8 Kommentarzeichen -
Micha,
2021-03-11, 16:52
- PHP 8 und @ -
Auge,
2021-03-11, 14:19
- Login with email address? -
Auge,
2021-03-01, 21:59
- Login with email address? -
Micha,
2021-03-01, 17:22
- Login with email address? -
Auge,
2021-03-01, 11:39
- Login with email address? -
Stephan Sander,
2021-03-01, 09:21
- Login with email address? -
Micha,
2021-03-01, 08:22