From: Janis Streib <janis@dogcraft.de>
Date: Sat, 6 Dec 2014 10:40:23 +0000 (+0100)
Subject: added searchUserIdByDomain
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=e40703b249d47bd582adbc09b5f20415e6931546

added searchUserIdByDomain
---

diff --git a/src/org/cacert/gigi/dbObjects/Domain.java b/src/org/cacert/gigi/dbObjects/Domain.java
index 13ee9f35..3cbd1e32 100644
--- a/src/org/cacert/gigi/dbObjects/Domain.java
+++ b/src/org/cacert/gigi/dbObjects/Domain.java
@@ -270,4 +270,16 @@ public class Domain implements IdCachable {
         return em;
     }
 
+    public static int searchUserIdByDomain(String domain) {
+        GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT memid FROM domains WHERE domain = ?");
+        ps.setString(1, domain);
+        GigiResultSet res = ps.executeQuery();
+        res.beforeFirst();
+        if (res.next()) {
+            return res.getInt(1);
+        } else {
+            return -1;
+        }
+    }
+
 }