Add user_level property to user

2 files changed, 6 insertions, 2 deletions

diff --git a/model/User.php b/model/User.php
index 89a14a5..469a9a1 100644
--- a/model/User.php
+++ b/model/User.php
@@ -4,9 +4,10 @@ class User {
 	public $id;
 	public $name = 'Unknown';
 	public $date = 0;
+	public $level = 0;
 
 	function get_by_name($name, $dbc) {
-		$sql = "SELECT user_id, user_date FROM users WHERE user_name = ?";
+		$sql = "SELECT user_id, user_date, user_level FROM users WHERE user_name = ?";
 		$stmt = mysqli_stmt_init($dbc);
 
 		if (!mysqli_stmt_prepare($stmt, $sql)) {
@@ -24,6 +25,7 @@ class User {
 				$this->id = $row['user_id'];
 				$this->name = $name;
 				$this->date = $row['user_date'];
+				$this->level = $row['user_level'];
 			}
 		}
 
@@ -32,7 +34,7 @@ class User {
 	}
 
 	function get_by_id($id, $dbc) {
-		$sql = "SELECT user_name, user_date FROM users WHERE user_id = " . mysqli_real_escape_string($dbc, $id);
+		$sql = "SELECT user_name, user_date, user_level FROM users WHERE user_id = " . mysqli_real_escape_string($dbc, $id);
 		$result = mysqli_query($dbc, $sql);
 	
 		if (!$result) {
@@ -45,6 +47,7 @@ class User {
 				$this->id = $id;
 				$this->name = $row['user_name'];
 				$this->date = $row['user_date'];
+				$this->level = $row['user_level'];
 			}
 		}
 	
diff --git a/setup.sql b/setup.sql
index a826cd3..b362798 100644
--- a/setup.sql
+++ b/setup.sql
@@ -2,6 +2,7 @@ CREATE TABLE users (
 	user_id INT(8) NOT NULL AUTO_INCREMENT,
 	user_name VARCHAR(30) NOT NULL,
 	user_pass VARCHAR(255) NOT NULL,
+	user_level INT(8) NOT NULL DEFAULT 0,
 	user_date DATETIME NOT NULL,
 	UNIQUE INDEX user_name_unique (user_name),
 	PRIMARY KEY (user_id)