From 9cb35f2bf2127cc8ac077aae17514a57e576217d Mon Sep 17 00:00:00 2001
From: George Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Wed, 26 Apr 2023 04:43:12 +0300
Subject: alfa.2 version; seceral optimizations; added support for mail-relay

---
 public/app/models/admin/User_model.php | 38 +++++++++++++++++++++++++++++++++-
 public/app/models/cms/Course_model.php |  2 +-
 2 files changed, 38 insertions(+), 2 deletions(-)

(limited to 'public/app/models')

diff --git a/public/app/models/admin/User_model.php b/public/app/models/admin/User_model.php
index 62d99db..2885dc1 100644
--- a/public/app/models/admin/User_model.php
+++ b/public/app/models/admin/User_model.php
@@ -159,7 +159,10 @@ class User_model
         )->lastInsertID();
 
         // set default privileges
-        // self::set_user_privileges($new_user_id, $privileges);
+        self::set_user_privileges($new_user_id, $privileges);
+
+        // set reader role
+        self::set_user_role($new_user_id, 5);
 
         // update history
         History::trackUserAccess($new_user_id, TRACK_ACCOUNT, 'Create User Account');
@@ -173,6 +176,39 @@ class User_model
     }
 
 
+    /** set_user_privileges
+     * 
+     * @param $privileges (array)
+     */
+    public static function set_user_privileges($user, $privileges)
+    {
+        $db = Registry::use('database');    // database connection
+        foreach($privileges as $pri) {      // pri = privilege id
+            $db->runQuery(
+                "INSERT INTO user_privilege (user_id, privilege_id) VALUES (:user, :pri)",
+                [ ':user' => $user, ":pri" => $pri ]
+            );
+        }
+        return true;
+    }
+
+
+    /** set_user_role
+     * 
+     * user, role are (int) IDs
+     */
+    public static function set_user_role($user, $role)
+    {
+
+        Registry::use('database')->runQuery(
+            "INSERT INTO user_role (user_id, role_id) VALUES (:user, :role)",
+            [ ':user' => $user, ":role" => $role ]
+        );
+
+        return true;
+    }
+
+
     /** activate
      * 
      * check if activation code is valid;
diff --git a/public/app/models/cms/Course_model.php b/public/app/models/cms/Course_model.php
index 6378226..54f49cf 100644
--- a/public/app/models/cms/Course_model.php
+++ b/public/app/models/cms/Course_model.php
@@ -18,7 +18,7 @@ class Course_model {
 	public static function get_categories()
 	{
         return Registry::use('database')->runQuery(
-		    "SELECT * FROM course ORDER BY `order`",
+		    "SELECT * FROM course ORDER BY label",
             []
         );
 	}
-- 
cgit v1.2.3