public function save(User $user) { $query = "SELECT * FROM users WHERE username = ?"; $this->db->query($query, [$user->getUsername()]); $result = $this->db->row(); if ($result) { echo 'The username already taken!'; die; } $query = "\n INSERT INTO users (username, email, cash, roleId, password)\n VALUES (?, ?, ?, ?, ?)\n "; $params = [$user->getUsername(), $user->getEmail(), floatval($user->getCash()), $user->getRole(), $user->getPassword()]; if ($user->getId()) { $query = "UPDATE players SET username = ?, password = ? WHERE id = ?"; $params[] = $user->getId(); } $this->db->query($query, $params); return $this->db->rows() > 0; }
public static function registerUser(User $user) { $db = Database::getInstance(); $query = $db->prepare('INSERT INTO users (firstname, lastname, username, password, email) VALUES (?, ?, ?, ?, ?)'); $query->execute([$user->getFirstName(), $user->getLastName(), $user->getUsername(), $user->getPassword(), $user->getEmail()]); $affected = $query->rowCount(); if ($affected == 1) { redirect(\route\Route::get("index")->generate()); } else { ?> <script> document.getElementById("failedRegister").innerHTML = "User already exists."; </script> <?php } }
/** * {@inheritDoc} */ public function getUsername() { $this->__initializer__ && $this->__initializer__->__invoke($this, 'getUsername', array()); return parent::getUsername(); }
public function create() { if ($_POST['regPassword'] != $_POST['regPassword2']) { $this->addPopup('danger', 'Hesla se neshodují.'); redirectTo("/registrace"); } if (!User::checkRegistrationValidity()) { redirectTo("/registrace"); } $existing = User::checkExistingUsernameEmail(); if ($existing != NULL) { if ($existing->getUsername() == $_POST["regUsername"]) { $this->addPopup('danger', 'Uživatel se stejným uživatelským jménem je již zaregistrován.'); } elseif ($existing->getEmail() == $_POST["regEmail"]) { $this->addPopup('danger', 'Uživatel se stejnou emailovou adresou je již zaregistrován.'); } redirectTo("/registrace"); } else { $token = token(50); $user = new User(); $user->setIdImage(6); $user->setUsername(strip_tags($_POST['regUsername'])); $user->setPassword(strip_tags(sha1($_POST['regPassword']))); $user->setEmail(strip_tags($_POST['regEmail'])); $user->setUrl(strip_tags($_POST['regUsername'])); $user->setEmailConfirmToken($token); $user->setPasswordResetToken(NULL); $user->setPermissions(0); $user->setSigninCount(0); sendEmailConfirmationToken($user->getUsername(), $user->getEmailConfirmToken(), $user->getEmail()); $user->save(); $this->addPopup('success', 'Registrace proběhla úspěšně! Nyní se můžete přihlásit.'); redirectTo("/"); } }
private static function insert(User $model) { $db = Database::getInstance('app'); $query = "INSERT INTO users (username,email,password,role_id,f_name,l_name,gender,date_of_birth,registered_at) VALUES (:username, :email, :password, :role_id, :f_name, :l_name, :gender, :date_of_birth, :registered_at);"; $result = $db->prepare($query); $result->execute([':username' => $model->getUsername(), ':email' => $model->getEmail(), ':password' => $model->getPassword(), ':role_id' => $model->getRole_id(), ':f_name' => $model->getF_name(), ':l_name' => $model->getL_name(), ':gender' => $model->getGender(), ':date_of_birth' => $model->getDate_of_birth(), ':registered_at' => $model->getRegistered_at()]); $model->setId($db->lastId()); }
public function addUser(User $user) { $result = $this->db->prepare("\n\t\t\tINSERT INTO user(username, password_digest, money, banned)\n\t\t\tVALUES(?, ?, ?, ?);\n\t\t"); $result->execute([$user->getUsername(), $user->getPasswordDigest(), $user->getMoney(), $user->getBanned()]); }
public function __construct(\Models\User $user) { $this->username = $user->getUsername(); $this->pwd = $user->getPwd(); $this->email = $user->getEmail(); }
protected function create() { if (isset($_POST["email"]) && isset($_POST["username"]) && isset($_POST["password"])) { $user = new User(); $emailConfirmToken = uniqid() . generateRandomString(19); $user->fromArray(array("Email" => $_POST["email"], "Username" => $_POST["username"], "Password" => $_POST["password"], "EmailConfirmToken" => $emailConfirmToken)); if (!$user->save()) { $failures = $user->getValidationFailures(); if (count($failures) > 0) { foreach ($failures as $failure) { $this->sendFlashMessage("You have not been signed up. " . $failure->getMessage(), "error"); } } } else { $this->sendFlashMessage('You have been successfuly signed up. Please confirm your email address, we have send confirmation link. <a class="link" href="/user/' . $user->getUsername() . '/send-email-confirm-email">Send new email confirm link?</a>', "success"); $body = '<p>You have created new account on Starling.</p><br /><p>Please virify your email address by clicking this url:</p><a href="' . $this->siteURL . '/user/' . $user->getUsername() . '/email-confirm/' . urlencode($emailConfirmToken) . '">' . $this->siteURL . '/user/' . $user->getUsername() . '/email-confirm/' . urlencode($emailConfirmToken) . '</a>'; $transport = \Swift_SmtpTransport::newInstance('smtp.gmail.com', 465, 'ssl')->setUsername($this->emailAddress)->setPassword($this->emailPassword); $mailer = \Swift_Mailer::newInstance($transport); $message = \Swift_Message::newInstance()->setSubject('Email verification')->setFrom(array($this->emailAddress => 'Starling admin'))->setTo(array($user->getEmail() => $user->getUsername()))->setBody($body, 'text/html'); $result = $mailer->send($message); } $this->redirect("/"); } else { setHTTPStatusCode("400"); } }
private static function insert(User $model) { $db = Database::getInstance('app'); $query = "INSERT INTO user (username,password,registerDate,emailVerified,email,createdAt,updatedAt) VALUES (:username, :password, :registerDate, :emailVerified, :email, :createdAt, :updatedAt);"; $result = $db->prepare($query); $result->execute([':username' => $model->getUsername(), ':password' => $model->getPassword(), ':registerDate' => $model->getRegisterDate(), ':emailVerified' => $model->getEmailVerified(), ':email' => $model->getEmail(), ':createdAt' => $model->getCreatedAt(), ':updatedAt' => $model->getUpdatedAt()]); $model->setId($db->lastId()); }