<?

################################################################################################################################
#	database class
################################################################################################################################

class database {
	private $db_host = "localhost";
	private $db_name = "db";
	private $db_user = "user";
	private $db_pass = "pass";

	function __construct() {
		$this->connect();
	}

	function connect() {
		if (mysql_connect($db_host,$db_user,$db_pass)) echo "connected";
		mysql_select_db($db_name);
	}

	// with destruct youll never need to call that disconnect
	function __destruct() {
		mysql_close();
		echo "db closed";
	}

}


################################################################################################################################
#	cms_user class
################################################################################################################################

class cms_user {

	var $id,$email,$first_name,$last_name,$user_level;
	var $table_name = "cms_users";

	# ------------------------------------------------------------------------------------------------------------------------------
	#	__construct() - creates or looks up a user
	# ------------------------------------------------------------------------------------------------------------------------------

	function __construct($user_id,$email,$password,$first_name,$last_names,$user_level) {
		if ($user_id=0) {
			$this->createUser($email,$password,$first_name,$last_names,$user_level);
		} else {
			// return WHERE id = $user_id
		}
	}


	# ------------------------------------------------------------------------------------------------------------------------------
	#	createUser() - called by construct
	# ------------------------------------------------------------------------------------------------------------------------------

	function createUser($email,$password,$first_name,$last_names,$user_level) {

		$sql = "INSERT INTO {$this->table_name} SET
			email = '{$email}',
			password = '{$password}',
			first_name = '{$name}',
			last_name = '{$last_name}',
			user_level = '{$user_level}'";

		mysql_query($sql);
	}

	# ------------------------------------------------------------------------------------------------------------------------------
	#	deleteUser()
	# ------------------------------------------------------------------------------------------------------------------------------

	function deleteUser() {
		$sql = "DELETE FROM  {$this->table_name}  WHERE id = {$this->user_id} LIMIT 1";
		mysql_query($sql);
	}


}


################################################################################################################################
#	cms_user_list class
################################################################################################################################


class cms_user_list extends cms_user {

	function __construct($group = "") {
		if ($group = "") {
			$this->getAllUsers();
		} else {
			$this->getUsersFromGroup($group);
		}
	}


	# ------------------------------------------------------------------------------------------------------------------------------
	#	getUserList() - returns list of users
	# ------------------------------------------------------------------------------------------------------------------------------


	function getAllUsers() {
		$sql = "SELECT * FROM {$this->table_name}";
		$result = mysql_query($sql);
		return mysql_fetch_object($result);
	}

	function getUsersFromGroup($group) {
		$sql = "SELECT * FROM {$this->table_name} WHERE group=$group";
		$result = mysql_query($sql);
		return mysql_fetch_object($result);
	}

}



?>