X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FdbObjects%2FUser.java;h=e6f06921c08b2ad4e0a53633b12660d86ebf198b;hp=55e567f5dd6a93a793a9c358cde85c7242360748;hb=7f0229055197cf353db26e61b1f5d84ddf5b58df;hpb=ba0e2099f18fc222c05abb0e293c2eb1bb01f0e9 diff --git a/src/org/cacert/gigi/dbObjects/User.java b/src/org/cacert/gigi/dbObjects/User.java index 55e567f5..e6f06921 100644 --- a/src/org/cacert/gigi/dbObjects/User.java +++ b/src/org/cacert/gigi/dbObjects/User.java @@ -409,8 +409,12 @@ public class User extends CertificateOwner { } public List getOrganisations() { + return getOrganisations(false); + } + + public List getOrganisations(boolean isAdmin) { List orgas = new ArrayList<>(); - try (GigiPreparedStatement query = new GigiPreparedStatement("SELECT `orgid` FROM `org_admin` WHERE `memid`=? AND `deleted` IS NULL")) { + try (GigiPreparedStatement query = new GigiPreparedStatement("SELECT `orgid` FROM `org_admin` WHERE `memid`=? AND `deleted` IS NULL" + (isAdmin ? " AND master='y'" : ""))) { query.setInt(1, getId()); try (GigiResultSet res = query.executeQuery()) { while (res.next()) {