View Issue Detail

ID	Project	Category	Submitted / Last Updated
02016	UserSpice	ACP Code	2024-05-23 15:02:02 / 2024-05-27 10:33:45
Reported	Dan Hoover	Resolved By	Dan Hoover
Priority	none	Reported	5.7.0
Status	resolved fixed	Resolution Version and Commit	5.7.4
Summary	users/verify.php
Description	if (is_numeric($user_id)) { //this is a passwordless login $ts = date("Y-m-d H:i:s"); $db->query("UPDATE us_email_logins set expired = 1 WHERE expired = 0 AND expires < ?", array($ts)); $searchQ = $db->query("SELECT l.*, u.email_verified FROM us_email_logins l LEFT OUTER JOIN users u ON l.user_id = u.id WHERE l.user_id = ? AND l.vericode = ? AND l.expired = 0" , array($user_id, $vericode));