From e7e590327abe2fb6820685fdee9240e163bad397 Mon Sep 17 00:00:00 2001
From: Nino Breuer
Date: Tue, 9 Sep 2014 16:29:11 +0200
Subject: some corrections, new logo in main menu

---
 Dozentenmodulserver/src/sql/SQL.java | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'Dozentenmodulserver/src/sql/SQL.java')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index cf1da45c..9a115f09 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -491,7 +491,7 @@ public class SQL {
 			Connection con=getConnection();
 			Statement stm = con.createStatement();
 			ResultSet data=stm
-					.executeQuery("SELECT i.GUID_imageID, i.imageVersion, i.image_name,i.image_description,i.image_update_time,i.cond_hasInternetRestriction,i.cond_hasLicenseRestriction, i.cond_minCPUs,i.cond_minRAM, i.image_syncMode,i.image_filesize,i.image_path, i.image_isTemplate,os.GuestOS, concat(u.Nachname,' ',u.Vorname) as Owner FROM bwLehrpool.m_VLData_imageInfo i,bwLehrpool.m_user u,bwLehrpool.m_operatingSystem os where i.image_owner=u.userID and i.content_operatingSystem=os.operatingSystemID and GUID_imageID = '"	+ id + "' and imageVersion = '" + version + "' ;");
+					.executeQuery("SELECT u.mail, i.GUID_imageID, i.imageVersion, i.image_name,i.image_description,i.image_update_time,i.cond_hasInternetRestriction,i.cond_hasLicenseRestriction, i.cond_minCPUs,i.cond_minRAM, i.image_syncMode,i.image_filesize,i.image_path, i.image_isTemplate,os.GuestOS, concat(u.Nachname,' ',u.Vorname) as Owner FROM bwLehrpool.m_VLData_imageInfo i,bwLehrpool.m_user u,bwLehrpool.m_operatingSystem os where i.image_owner=u.userID and i.content_operatingSystem=os.operatingSystemID and GUID_imageID = '"	+ id + "' and imageVersion = '" + version + "' ;");
 			while (data.next()) {
 				map.put("name", data.getString("image_name"));
 				map.put("internet",
@@ -509,6 +509,7 @@ public class SQL {
 				map.put("desc", data.getString("image_description"));
 				map.put("id", data.getString("GUID_imageID"));
 				map.put("version", data.getString("imageVersion"));
+				map.put("mail", data.getString("mail"));
 
 			}
 			con.close();
-- 
cgit v1.2.3-55-g7522