From d90b51ce89bcc693e3014b313fe8e3b975031adf Mon Sep 17 00:00:00 2001 From: George Halkiadakis Date: Fri, 17 Mar 2023 03:13:28 +0200 Subject: introduced history; will track user access --- html/app/models/admin/User_model.php | 23 ++++++++++++----------- 1 file changed, 12 insertions(+), 11 deletions(-) (limited to 'html/app/models/admin/User_model.php') diff --git a/html/app/models/admin/User_model.php b/html/app/models/admin/User_model.php index 63d826f..80ce113 100644 --- a/html/app/models/admin/User_model.php +++ b/html/app/models/admin/User_model.php @@ -3,7 +3,7 @@ namespace app\models\admin; use \Registry; -use app\models\admin\history; +use app\models\admin\History_model as History; class User_model { @@ -128,26 +128,27 @@ class User_model 'active' => 0 // needs email confirmation ]; - $sql = "INSERT INTO user (`prefix`, `name`, `surname`, email, `password`, user_id) - VALUES (:prrfic, :name, :surname, :email, :password, :userid)"; - $stmt = $this->pdo->prepare($sql); - $stmt->execute($user); - - $inserted_id = $this->pdo->lastInsertId(); + // insert new user record + $new_user_id = Registry::use('database')->query( + "INSERT INTO user + (`prefix`, `name`, `surname`, email, `password`, user_id) + VALUES + (:prefic, :name, :surname, :email, :password, :userid)" + [ $user ] + )->lastInsertID(); // set default privileges self::set_user_privileges($privileges); // update history + History::trackUserAccess($new_user_id, TRACK_ACCOUNT, 'Create User Account'); - - - return [ "success" => true, 'id' => $inserted_id ]; + // return success and user id + return [ "success" => true, 'id' => $new_user_id ]; } - /** inherited privileges * * list of all inhereted (sub-)privileges -- cgit v1.2.3