diff options
| -rw-r--r-- | model/User.php | 7 | ||||
| -rw-r--r-- | 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']; } } @@ -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) |