<?php
class User_model extends CI_Model {

    public $userID = '';
    public $verifyHash = '';

    function __constructor()
    {
        parent :: __construct();
    }

    function registerUser($username, $password, $email, $firstName, $lastName, $registrationKey)
    {
        function GenPassHash($logPass)
        {
            $usersalt = substr(md5(uniqid(rand(), true)), 0, 11);
            $encPass = sha1($logPass);
            $sltPass = $encPass . $usersalt;$encSPass = sha1($sltPass);
            $passArray = array($encSPass,$usersalt);
            return $passArray;
        }

        function myDomainName() {
            $my_domain = $_SERVER['HTTP_HOST'];
            $my_domain = str_replace('www.', '', $my_domain);
            return $my_domain;
        }

        $password = GenPassHash($password);

        $query_str = "INSERT INTO kowmanager_users (username, password, password2, email, firstName, lastName, accessLevelID) VALUES (?, ?, ?, ?, ?, ?, ?)";
        $this->db->query($query_str, array($username, $password[0], $password[1], $email, $firstName, $lastName, '1',));

        $id = $this->db->insert_id();

        $this->db->select_max('userID');
        $query = $this->db->get('kowmanager_users');
        $row = $query->row();
        $userID = $row->userID;

        $userID = $userID + 1;

        $data = array('userID' => $userID);

        $where = "id = '".$id."'";

        $str = $this->db->update_string('kowmanager_users', $data, $where);
        $my_update = $this->db->query($str);

        $myMD5string = $userID.$email.$registrationKey;
        $verifyHash = md5($myMD5string);

        function getRealIPAddress()
        {
            if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet
            {
                $ip=$_SERVER['HTTP_CLIENT_IP'];
            }
            elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy
            {
                $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
            }
            else
            {
                $ip=$_SERVER['REMOTE_ADDR'];
            }
            return $ip;
        }

        $query_str = "INSERT INTO kowmanager_users_registrations (userID, registrationDate, registrationKey, verifyHash, ipAddress) VALUES (?, ?, ?, ?, ?)";
        $this->db->query($query_str, array($userID, date('Y-m-d H:i:s'), $registrationKey, $verifyHash, getRealIPAddress()));
    }

    function confirmRegistration($registrationKey)
    {
        $query_str = "SELECT userID kowmanager_users_registrations WHERE registrationKey = ?";
        $result = $this->db->query($query_str, $registrationKey);

        $row = $query->row();
        $userID = $row->userID;

        if ($result->num_rows() == 1)
        {
            $query_str = "UPDATE kowmanager_users_registrations SET registrationKey = '' WHERE registrationKey = ?";
            $this->db->query($query_str, $registrationKey);

            $query_str = "UPDATE kowmanager_users SET statusID = '2' WHERE userID = ?";
            $this->db->query($query_str, $userID);

            return true;
        }
        else
        {
            return false;
        }
    }

    function checkExistsUsername($username)
    {
        $query_str = "SELECT username FROM kowmanager_users WHERE username = ?";
        $result = $this->db->query($query_str, $username);

        if ($result->num_rows() > 0)
        {
            return true;
        }
        else
        {
            return false;
        }

    }

    function checkExistsEmail($email)
    {
        $query_str = "SELECT email FROM kowmanager_users WHERE email = ?";
        $result = $this->db->query($query_str, $email);

        if ($result->num_rows() > 0)
        {
            return true;
        }
        else
        {
            return false;
        }

    }

}