<?php

class Database {

	function connect() {
		include(SITE_ROOT . "/include/" . "config.inc.php");
		$handler = mysql_connect($db_host, $db_user, $db_pass);
		$db = mysql_select_db($db_name);

		if ($db) {
			return 0;
		} else {
			return 1;
		}
	}

	function checkUser($user, $pass) {

		$this->connect();
		$query = "SELECT pass FROM users WHERE user='" . $user . "'";
		$result = mysql_query($query);
		$row = mysql_fetch_row($result);

		/*
		 * User does not exists, create new one
		 */

		if (!$row) {

			/*
			 * Create user
			 */

			$query = "INSERT INTO users(user, pass) VALUES ('" . $user . "', '" . md5($pass) . "')";
			$result = mysql_query($query);

			/*
			 * Create empty highscore row
			 */

			$query = "INSERT INTO highscores (user, score, gamesplayed) VALUES ('$user', 0, 0)";
			$result = mysql_query($query);

			/*
			 * New user created
			 */

			return 2;

		} else {

			/*
			 * If user exists check his password
			 * 0 = match, 1 = no match
			 */

			return strcmp($row[0], md5($pass));

		}
	}

	function getHighscores() {
		$data = array();

		$handle = $this->connect();
		$query = "SELECT * FROM highscores";
		$result = mysql_query($query);

		while ($row = mysql_fetch_row($result)) {

			$user = $row[1];
			$score = $row[2];
			$gamesplayed = $row[3];

			$data[] = array($user, $score / $gamesplayed, $gamesplayed);

		}
		
		return $data;
	}

	function saveScore($user, $score) {
		$this->connect();
		if ($score > 21) $score = 0;

		/*
		 * Save highscore to database
		 */

		$query = "UPDATE highscores SET score = score + $score, gamesplayed = gamesplayed + 1 WHERE user = '$user'";
		$result = mysql_query($query);
	}

}