<?php
include_once './includes/Database.php';

const USER_LEVEL_MODERATOR = 1;

class User
{
	public $id;
	public $name = 'Unknown';
	public $password;
	public $date = 0;
	public $level = 0;

	function get_by_name($name): bool
	{
		$sql = "SELECT user_id, user_date, user_level, user_pass FROM users WHERE user_name = ?";
		$result = Database::get()->query($sql, "s", $name);

		if (empty($result)) {
			return false;
		}

		$this->id = $result[0]['user_id'];
		$this->name = $name;
		$this->password = $result[0]['user_pass'];
		$this->date = $result[0]['user_date'];
		$this->level = $result[0]['user_level'];

		return true;
	}

	function get_by_id($id)
	{
		$sql = "SELECT user_name, user_date, user_level, user_pass FROM users WHERE user_id = ?;";
		$result = Database::get()->query($sql, "i", $id);

		$this->id = $id;
		$this->name = $result[0]['user_name'];
		$this->password = $result[0]['user_pass'];
		$this->date = $result[0]['user_date'];
		$this->level = $result[0]['user_level'];
	}
}