<?php

class register {

	private static $_instance = NULL;
	private $db;

	private function __construct() {
		global $db;
		$this->db = $db;
	}

	public function getInstance() {
        if (!isset(self::$_instance)) {
            $class = __CLASS__;
            self::$_instance = new $class;
        }
        return self::$_instance;
	}

	public static function add_user($user = array()) {
		if (empty($user)) { return false; }
		$user['firstname'] = $this->db->escape($user['firstname']);
		$user['lastname'] = $this->db->escape($user['lastname']);
		//$user['username'] = $this->db->escape($user['username']);
		$user['email'] = $this->db->escape($user['email']);
		$user['password'] = $this->db->escape($user['password']);
		$user['password'] = md5($user['password']);
		$user['cust_status'] = $this->db->escape($user['cust_status']);
		$user['discover'] = $this->db->escape($user['discover']);
		$user['site_id'] = $this->db->escape($user['site_id']);
		return (self::insert_user($user)) ? true : false;
	}

	private static function insert_user($user) {
    	$password = md5($password);
    	$created = time();
    	$sql="INSERT INTO users (login, password, admin, created, modified, enabled, type)
    	      VALUES('{$user['email']}', '{$user['password']}', '0', '$created', '$created', '0','0')";
    	$this->db->query($sql) or $this->db->error();
    	$next_id = $this->db->nextid();
    	$sql = "INSERT INTO user_info (id, site_id, discover, customer_status) VALUES ('$next_id', '{$user['site_id']}', '{$user['discover']}', '{$user['cust_status']}')";
    	return ($this->db->query($this->sql)) ? true : $this->db->error();
	}

	public static function user_exists($username) {
		global $this->db;
		if (empty($username)) { return false; }
        $username = $this->db->escape($username);
        $sql = "SELECT login
                  FROM users
                 WHERE login = '$username'";
        if (!($result = $this->db->query($sql))) {
              $this->db->error();
        }
        if (this->->count_rows($result)) {
            $row = $this->db->fetchrow($result);
            if (strtolower($row['login']) == strtolower($username)) {
             	$this->db->freeresult();
                return true;
            }
        }
        $this->db->freeresult();
        unset($sql);
        unset($result);
        unset($row);
        return false;
	}

	public static function email_exists($email) {
		if (empty($email)) { return false; }
        $email = $this->db->escape($email);
        $sql = "SELECT login
                  FROM users
                 WHERE login = '$email'";
        if (!($result = $this->db->query($sql))) {
            $this->db->error();
        }
        if ($this->db->count_rows($result)) {
            $row = $this->db->fetchrow($result);
            if (strtolower($row['login']) == $email) {
              	$this->db->freeresult();
                return true;
            }
        }
        $this->db->freeresult();
        unset($sql,$result,$row);
        return false;
	}

	public static function activate_user($email) {
	    if (empty($email)) { return false; }
	    $user_email = $this->db->escape($email);
	    return (self::enable_user($email)) ? true : false;
	}

    private static function enable_user($email) {
        $sql = "UPDATE users SET enabled = 1 WHERE login = '$email'";
        return ($this->db->query($sql)) ? true : $this->db->error();
    }

    public static function is_user_enabled($email) {
        if (empty($email)) { return false; }
        $email = $this->db->escape($email);
        return (self::user_enabled($email));
    }

    private static function user_enabled($email) {
        $sql = "SELECT enabled FROM users WHERE login = '$email'";
        if (!$result = $this->db->query($sql)) { $this->db->error(); }
        if ($this->db->count_rows($result)) {
            $row = $this->db->fetchrow($result);
            $enabled = $row['enabled'];
        }
        $this->db->freeresult();
        unset($sql,$result,$row);
        return ($enabled == 1) ? true : false;
    }
}

?>