From 61a8dfbe6186c29b5bec36c971a80b081b366091 Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Thu, 12 Jul 2012 01:16:37 +0200 Subject: Display nice error message if username exists already Signed-off-by: Florian Pritz --- application/controllers/user.php | 4 ++++ application/models/muser.php | 15 +++++++++++++++ 2 files changed, 19 insertions(+) diff --git a/application/controllers/user.php b/application/controllers/user.php index af908a63d..29d9eaeeb 100644 --- a/application/controllers/user.php +++ b/application/controllers/user.php @@ -152,6 +152,10 @@ class User extends CI_Controller { $error[]= "Invalid email."; } + if ($this->muser->username_exists($username)) { + $error[] = "Username already exists."; + } + if (!$password || $password != $password_confirm) { $error[]= "No password or passwords don't match."; } diff --git a/application/models/muser.php b/application/models/muser.php index eb7c3d385..a93865fd4 100644 --- a/application/models/muser.php +++ b/application/models/muser.php @@ -87,6 +87,21 @@ class Muser extends CI_Model { exit(); } + function username_exists($username) + { + $query = $this->db->query(" + SELECT id + FROM users + WHERE username = ? + ", array($username)); + + if ($query->num_rows() > 0) { + return true; + } else { + return false; + } + } + function hash_password($password) { -- cgit v1.2.3-24-g4f1b