diff options
Diffstat (limited to 'model/User.php')
| -rw-r--r-- | model/User.php | 7 |
1 files changed, 5 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']; } } |