Fix some issues with the ftp connection and the ftp user management

Remove some not needed imports from various files

1 files changed, 20 insertions, 0 deletions

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