From 600316a94a7e40c5fef364d6f98abc3e509131ad Mon Sep 17 00:00:00 2001
From: Stefan Ritter <xeno@thehappy.de>
Date: Tue, 13 Mar 2012 11:36:26 +0100
Subject: Initial commit

---
 models/database.php | 94 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 94 insertions(+)
 create mode 100644 models/database.php

(limited to 'models/database.php')

diff --git a/models/database.php b/models/database.php
new file mode 100644
index 0000000..6229726
--- /dev/null
+++ b/models/database.php
@@ -0,0 +1,94 @@
+<?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);
+	}
+
+}
-- 
cgit v1.2.3