X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FdbObjects%2FGroup.java;h=69f8e40bf7434422bf56a957ffaceec528a0601a;hb=4f60523bbf9ad5035a655c5089be79bcf9413598;hp=bdce278da0979f047d379ed0f1f1648481ec888f;hpb=6de1708def257130eca7f9e29ee41be8a28562ef;p=gigi.git

diff --git a/src/org/cacert/gigi/dbObjects/Group.java b/src/org/cacert/gigi/dbObjects/Group.java
index bdce278d..69f8e40b 100644
--- a/src/org/cacert/gigi/dbObjects/Group.java
+++ b/src/org/cacert/gigi/dbObjects/Group.java
@@ -2,6 +2,10 @@ package org.cacert.gigi.dbObjects;
 
 import java.util.HashMap;
 
+import org.cacert.gigi.database.DatabaseConnection;
+import org.cacert.gigi.database.GigiPreparedStatement;
+import org.cacert.gigi.database.GigiResultSet;
+
 public class Group {
 
     private static HashMap<String, Group> cache = new HashMap<>();
@@ -54,4 +58,20 @@ public class Group {
     public String getDatabaseName() {
         return dbName;
     }
+
+    public User[] getMembers(int offset, int count) {
+        GigiPreparedStatement gps = DatabaseConnection.getInstance().prepare("SELECT user FROM user_groups WHERE permission=? AND deleted is NULL LIMIT ?,?");
+        gps.setString(1, dbName);
+        gps.setInt(2, offset);
+        gps.setInt(3, count);
+        GigiResultSet grs = gps.executeQuery();
+        grs.last();
+        User[] users = new User[grs.getRow()];
+        int i = 0;
+        grs.beforeFirst();
+        while (grs.next()) {
+            users[i++] = User.getById(grs.getInt(1));
+        }
+        return users;
+    }
 }