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 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'model/User.php')

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'];
 			}
 		}
 	
-- 
cgit v1.2.3