From 10280968b8b45fe130bc50e2ede4ce3cabfe1e58 Mon Sep 17 00:00:00 2001
From: cflip <36554078+cflip@users.noreply.github.com>
Date: Mon, 12 Apr 2021 09:55:45 -0600
Subject: Add user_level property to user

---
 model/User.php | 7 +++++--
 setup.sql      | 1 +
 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)
-- 
cgit v1.2.3