Added admin function to give a list of users

2 files changed, 44 insertions, 1 deletions

diff --git a/database/sqlite/CMakeLists.txt b/database/sqlite/CMakeLists.txt
index bed0559..f1d5fef 100644
--- a/database/sqlite/CMakeLists.txt
+++ b/database/sqlite/CMakeLists.txt
@@ -11,6 +11,7 @@ SET(COMMON
 	../../common/eurephia_log.c
         ../../common/eurephiadb_session_common.c
         ../../common/eurephia_values.c
+        ../../common/eurephia_admin_common.c
         ../../common/passwd.c
         ../../common/sha512.c
 )
diff --git a/database/sqlite/administration.c b/database/sqlite/administration.c
index 29face8..7612c6d 100644
--- a/database/sqlite/administration.c
+++ b/database/sqlite/administration.c
@@ -12,6 +12,7 @@
 #include <eurephia_nullsafe.h>
 #include <eurephia_context.h>
 #include <eurephia_admin_struct.h>
+#include <eurephia_admin_common.h>
 #include <eurephia_log.h>
 #include <eurephia_values.h>
 #include <eurephiadb_session_struct.h>
@@ -327,7 +328,48 @@ int eDBadminConfigDelete(eurephiaCTX *ctx, const char *key) {
 }
 
 eurephiaUSERLIST *eDBadminGetUserList(eurephiaCTX *ctx, const char *sortkeys) {
-        return NULL;
+        eurephiaUSERINFO *list = NULL, *rec = NULL, *last = NULL;
+        eurephiaUSERLIST *ret = NULL;
+        dbresult *res = NULL;
+        int i = 0;
+
+        assert((ctx != NULL) && (ctx->dbc != 0));
+
+        res = sqlite_query(ctx,
+                           "SELECT username, activated, deactivated, last_accessed, uid"
+                           "  FROM openvpn_users"
+                           "%s", (sortkeys != NULL ? sortkeys : ""));
+        if( res == NULL ) {
+                eurephia_log(ctx, LOG_ERROR, 0, "Error querying the user database");
+                return NULL;
+        }
+
+        ret = (eurephiaUSERLIST *) malloc(sizeof(eurephiaUSERLIST)+2);
+        assert(ret != NULL);
+        memset(ret, 0, sizeof(eurephiaUSERLIST)+2);
+
+        ret->num_users = sqlite_get_numtuples(res);
+
+        for( i = 0; i < ret->num_users; i++ ) {
+                rec = eAdminPopulateUSERINFO(
+                                             atoi_nullsafe(sqlite_get_value(res, i, 4)), // uid
+                                             sqlite_get_value(res, i, 0),                // username
+                                             NULL,                                       // passwd
+                                             sqlite_get_value(res, i, 1),                // activated
+                                             sqlite_get_value(res, i, 2),                // deactivated
+                                             sqlite_get_value(res, i, 3)                 // last accessed
+                                             );
+                if( list == NULL ) {
+                        list = rec;
+                        last = list;
+                } else {
+                        last->next = rec;
+                        last = rec;
+                }
+        }
+        sqlite_free_results(res);
+
+        return ret;
 }
 
 eurephiaUSERINFO *eDBadminGetUserInfo(eurephiaCTX *ctx, eurephiaUSERINFO *srchkey) {