$oUser->addStatusMessage(_('email address check error'), 'warning'); } else { $check_email = \Ease\Shared::db()->queryToValue("SELECT COUNT(*) AS total FROM user WHERE email = '" . $oPage->EaseAddSlashes($email_address) . "'"); if ($check_email > 0) { $error = true; $oUser->addStatusMessage(_('email address allready registred'), 'warning'); } } if (strlen($password) < 5) { $error = true; $oUser->addStatusMessage(_('password is too short'), 'warning'); } elseif ($password != $confirmation) { $error = true; $oUser->addStatusMessage(_('password confirmation does not match'), 'warning'); } $allreadyExists = \Ease\Shared::db()->queryToValue('SELECT id FROM user WHERE login=\'' . $oPage->EaseAddSlashes($login) . '\''); if ($allreadyExists) { $error = true; $oUser->addStatusMessage(sprintf(_('Given Username %s already exists'), $login), 'warning'); } if ($error == false) { $newOUser = new User(); $customerData = ['firstname' => $firstname, 'lastname' => $lastname, 'email' => $email_address, 'password' => $newOUser->encryptPassword($password), 'login' => $login]; $customerID = $newOUser->insertToSQL($customerData); if ($customerID) { $newOUser->setMyKey($customerID); $oUser->addStatusMessage(_('Account Was Created'), 'success'); $newOUser->loginSuccess(); $email = $oPage->addItem(new \Ease\Mail($newOUser->getDataValue('email'), _('New LinkQuick account'))); $email->setMailHeaders(['From' => EMAIL_FROM]); $email->addItem(new \Ease\Html\Div(_("Welcome to LinkQuick") . "\n"));
/** * Give you number of codes for given domain * * @param string $domain * @return int codes for domain in database */ public static function getCodeCount($domain) { return (int) \Ease\Shared::db()->queryToValue('SELECT count(*) FROM entry WHERE domain=\'' . $domain . '\''); }