From e37fd784eefe513eda7ab946dcf92b8e8fe1b8a6 Mon Sep 17 00:00:00 2001
From: Nils Schwabe
Date: Mon, 23 Jun 2014 15:12:57 +0200
Subject: Fix some issues with the ftp connection and the ftp user management
 Remove some not needed imports from various files

---
 src/main/java/org/openslx/imagemaster/db/DbUser.java | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'src/main/java/org/openslx/imagemaster/db')

diff --git a/src/main/java/org/openslx/imagemaster/db/DbUser.java b/src/main/java/org/openslx/imagemaster/db/DbUser.java
index 8cf4b55..ffc9d1a 100644
--- a/src/main/java/org/openslx/imagemaster/db/DbUser.java
+++ b/src/main/java/org/openslx/imagemaster/db/DbUser.java
@@ -71,4 +71,24 @@ public class DbUser extends User
 		return user.username;
 	}
 
+	/**
+	 * Checks if a user with id (userid@organization) exists
+	 * @param id
+	 * @return whether ther user exists
+	 */
+	public static boolean exists( String id )
+	{
+		String user = id.split( "@" )[0];
+		String organization = id.split( "@" )[1];
+		
+		DbUser dbUser = MySQL.findUniqueOrNull( DbUser.class,
+				"SELECT user.userid, user.username, user.password, user.organization, user.firstname, user.lastname, user.email, satellite.address FROM user"
+						+ " LEFT JOIN satellite USING (organization)"
+						+ " WHERE user.username = ? AND user.organization = ? LIMIT 1", user, organization);
+		
+		if ( dbUser == null ) return false;
+		
+		return true;
+	}
+
 }
-- 
cgit v1.2.3-55-g7522