Changeset 19225 for events/phpframework

Timestamp:

09/12/08 17:55:02 (5 years ago)

Author:

kenji

Message:

Add username/email unique checking

Files:

• events/phpframework/codeigniter/trunk/system/application/controllers/signup.php (modified) (2 diffs)

events/phpframework/codeigniter/trunk/system/application/controllers/signup.php

@@ -12 +12 @@
         function index() 
         {
+                $this->load->database();
                 $this->load->library('validation');
-                $this->validation->set_error_delimiters('<font color="red">', '</font>');
+                $this->validation->set_error_delimiters('<div class="red">', '</div>');
 
                 // Required Field Rules.
-                $rules['username']              = "trim|required|min_length[3]|max_length[100]";
+                $rules['username']              = "trim|required|alpha_dash|min_length[3]|max_length[100]|callback_check_username";
                 $rules['password']              = "trim|required|alpha_numeric|min_length[6]|max_length[64]|matches[password2]";
                 $rules['password2']     = "trim|required|alpha_numeric|min_length[6]|max_length[64]";
-                $rules['email']                 = "trim|required|valid_email|max_length[255]";
+                $rules['email']                 = "trim|required|valid_email|max_length[255]|callback_check_email";
                 //$rules['question']            = "required|max_lenght[80]";
                 //$rules['answer']              = "required|max_lenght[40]";
@@ -96 +97 @@
         }
 
+        function check_username($username)
+        {
+                $this->db->select('id');
+                $query = $this->db->get_where('users', array('username' => $username));
+
+                if ($query->num_rows() > 0)
+                {
+                        $this->validation->set_message('check_username', '%s はすでに登録されています。');
+                        return FALSE;
+                }
+                else
+                {
+                        return TRUE;
+                }
+        }
+
+        function check_email($email)
+        {
+                $this->db->select('id');
+                $query = $this->db->get_where('users', array('email' => $email));
+
+                if ($query->num_rows() > 0)
+                {
+                        $this->validation->set_message('check_email', '%s はすでに登録されています。');
+                        return FALSE;
+                }
+                else
+                {
+                        return TRUE;
+                }
+        }
+
         function activate($code = '')
         {