From d6b7e14f8cca315a45366bf8fc18633fb9cccdef Mon Sep 17 00:00:00 2001
From: Nino Breuer
Date: Thu, 16 Oct 2014 21:01:06 +0200
Subject: -

---
 dozentenmodulserver/src/main/java/sql/SQL.java | 69 +++++++++++++++++++++++---
 1 file changed, 61 insertions(+), 8 deletions(-)

(limited to 'dozentenmodulserver/src/main/java/sql')

diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java
index e973ba54..3649a34f 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -638,9 +638,10 @@ public List<Image> getImageListPermissionLink(String userID) {
 			}
 			log.info(new Date() + " - 'image_name` = '"	+ newName+ "\n length of name="+newName.length());
 			
-			stm.executeUpdate("UPDATE `bwLehrpool`.`m_VLData_imageInfo` SET `imageVersion` = '"
+			log.info("now in UpdateImageData()");
+			log.info("UPDATE bwLehrpool.m_VLData_imageInfo SET imageVersion = "
 					+ newVersion
-					+ "',`image_name` = '"
+					+ ",image_name = '"
 					+ newName
 					+ "',`image_description` = '"
 					+ desc
@@ -660,16 +661,51 @@ public List<Image> getImageListPermissionLink(String userID) {
 					+ cpu
 					+ "',`image_isTemplate` = '"
 					//+ isTemplate
-					+ "'0'"
-					+ "',`content_operatingSystem` = '"
+					+ "0'"
+					+ ",`content_operatingSystem` = "
 					+ ospk
-					+ "',`image_filesize` = '"
+					+ ",`image_filesize` = "
 					+ filesize
-					+ "',`image_syncMode` = '"
+					+ ",`image_syncMode` = '"
 					+ shareMode
-					+ "' WHERE `GUID_imageID` = '"
+					+ "' WHERE GUID_imageID = '"
 					+ id
-					+ "' AND `imageVersion` = '" + version + "';");
+					+ "' AND imageVersion = " + version + ";");
+			
+			
+			stm.executeUpdate("UPDATE bwLehrpool.m_VLData_imageInfo SET imageVersion = "
+					+ newVersion
+					+ ",image_name = '"
+					+ newName
+					+ "',`image_description` = '"
+					+ desc
+					+ "',`image_path` = '"
+					+ image_path
+					+ "',`image_update_time` = '"
+					+ formatter.format(new Date())
+					+ "',`rec_change_time` = '"
+					+ formatter.format(new Date())
+					+ "',`cond_hasLicenseRestriction` = '"
+					+ license_bol
+					+ "',`cond_hasInternetRestriction` = '"
+					+ internet_bol
+					+ "',`cond_minRAM` = '"
+					+ ram
+					+ "',`cond_minCPUs` = '"
+					+ cpu
+					+ "',`image_isTemplate` = '"
+					//+ isTemplate
+					+ "0'"
+					+ "',`content_operatingSystem` = "
+					+ ospk
+					+ ",`image_filesize` = "
+					+ filesize
+					+ ",`image_syncMode` = "
+					+ shareMode
+					+ " WHERE GUID_imageID = '"
+					+ id
+					+ "' AND imageVersion = " + version + ";");
+			
 			con.commit();
 			con.close();
 			return 0;
@@ -1313,5 +1349,22 @@ public List<Image> getImageListPermissionLink(String userID) {
 		return success;
 		
 	}// end 
+
+	public void deleteAllAdditionalImagePermissions(String imageID,String userID) 
+	{
+		Connection con=getConnection();
+		Statement stm = null;
+		
+		
+			try {
+				
+				stm = con.createStatement();
+				int ret = stm.executeUpdate("DELETE FROM pm_VLData_Image WHERE imageID = '" + imageID + "' AND userID != '" + userID + "';");
+				
+			} catch (SQLException e) {
+				// TODO Auto-generated catch block
+				e.printStackTrace();
+			}	
+	}
 	
 }//end class
-- 
cgit v1.2.3-55-g7522