X-Git-Url: http://p2p-next.cs.pub.ro/gitweb/?a=blobdiff_plain;f=application%2Fmodels%2Fusers_model.php;fp=application%2Fmodels%2Fusers_model.php;h=ad4caf055e26c494555c00d74805eb729476ee39;hb=adc2c33c37c781444c4234c6fed38e95d084ed8d;hp=0000000000000000000000000000000000000000;hpb=14163bd2cf49ea2c6d30530515e5f27cf7b5850b;p=living-lab-site.git

diff --git a/application/models/users_model.php b/application/models/users_model.php
new file mode 100644
index 0000000..ad4caf0
--- /dev/null
+++ b/application/models/users_model.php
@@ -0,0 +1,54 @@
+<?php
+
+/**
+ * Class Users_model models user information from DB
+ * 
+ * @category 	Model
+ * @author 		calinburloiu
+ *
+ */
+class Users_model extends CI_Model {
+	public $db = NULL;
+
+	public function __construct()
+	{
+		parent::__construct();
+
+		if ($this->db === NULL)
+		{
+			$this->load->library('singleton_db');
+			$this->db = $this->singleton_db->connect();
+		}
+	}
+
+	/**
+	 * Check authentication credentials. $username can be username or e-mail.
+	 * 
+	 * @param string $username
+	 * @param string $password
+	 */
+	public function login($username, $password)
+	{
+		$this->load->helper('email');
+		
+		// User logs with e-mail address.
+		if (! valid_email($username))
+			$cond_user = "username = '$username'";
+		else
+			$cond_user = "email = '$username'";
+		
+		$enc_password = sha1($password);
+		
+		// TODO select only required fields.
+		$query = $this->db->query("SELECT * FROM `users` 
+			WHERE $cond_user AND password = '$enc_password'");
+		
+		if ($query->num_rows() !== 1)
+			return FALSE;
+
+		return $query->row_array();
+	}
+}
+
+/* End of file users_model.php */
+/* Location: ./application/models/users_model.php */