From e40703b249d47bd582adbc09b5f20415e6931546 Mon Sep 17 00:00:00 2001
From: Janis Streib <janis@dogcraft.de>
Date: Sat, 6 Dec 2014 11:40:23 +0100
Subject: [PATCH] added searchUserIdByDomain

---
 src/org/cacert/gigi/dbObjects/Domain.java | 12 ++++++++++++
 1 file changed, 12 insertions(+)

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;
+        }
+    }
+
 }
-- 
2.39.2