/**
* Provides an user from the database by email verification code. If null is returned the code might be invalid.
*
* @param string $userCode
* @return User|null
*/
public function getUserByVerificationCode($userCode)
{
global $sql_prefix;
if (strlen(trim($userCode)) < 1) {
return null;
}
$user = null;
$result = db_query(sprintf("SELECT * FROM `%s_users` WHERE `EMailVerifyCode`='%s'", $sql_prefix, $userCode));
if (db_num($result) > 0) {
$row = db_fetch_assoc($result);
$user = new User($row['ID']);
$user->fillInfo($row);
$this->_users[$row['ID']] = $user;
}
return $user;
}
