<?php
class User extends Model
{
    function __construct()
    {
        parent::__construct();

        $this->ci =& get_instance();
    }

    function login_username($username)
    {
        $this->ci->db->where('username', strtolower($username));

        $query = $this->ci->db->get('users');
        if($query->num_rows() == 0)
        {
            return false;
        }
        else
        {
            return $query->row();
        }
    }

    function is_key_valid($key)
    {
        $this->ci->db->select('user_id');
        $this->ci->db->where('key', $key);
        return $this->ci->db->get('user_verify_keys')->row('user_id');
    }

    function validate($user_id, $key)
    {
        $array = array(
            'active' => 1
        );
        $this->ci->db->where('user_id', $user_id);
        $this->ci->db->update('users', $array);

        $this->ci->db->delete('user_verify_keys', array('key' => $key));
    }

    function is_username_registered($username)
    {
        $this->db->select('count(user_id) AS count');
        $this->db->where('username', $username);
        return $this->db->get('users')->row()->count;
    }

    function is_email_registered($email)
    {
        $this->db->select('count(user_id) AS count');
        $this->db->where('email', $email);
        return $this->db->get('users')->row()->count;
    }

    function information()
    {
        $user_id = $this->ci->session->userdata('user_id');

        $this->ci->db->where('user_id', $user_id);

        $query = $this->ci->db->get('users');
        if($query->num_rows() == 0)
        {
            return false;
        }
        else
        {
            return $query->row();
        }
    }
}
?>