Merge branch 'master' of git.openslx.org:openslx-ng/tutor-module

4 files changed, 16 insertions, 9 deletions

diff --git a/Dozentenmodulserver/src/server/ServerHandler.java b/Dozentenmodulserver/src/server/ServerHandler.java
index c1ba8254..12985219 100644
--- a/Dozentenmodulserver/src/server/ServerHandler.java
+++ b/Dozentenmodulserver/src/server/ServerHandler.java
@@ -181,7 +181,7 @@ public class ServerHandler implements Server.Iface {
 				new Date(), pk_institution);
 		
 		//OS impl Select and write
-		
+		//ACHTUNG: Anzahl der Leerzeichen muss eingehalten werden: 'Windows 7 32 bit"
 		String pk_os=sql.getOSpk(os.substring(0, nthIndexOf(os, " ", 2)),os.substring(nthIndexOf(os," ", 2), os.lastIndexOf(" ")).replace(" ", ""));
 		
 		sql.setImageData(pk_person, license, internet, cpu, ram, imagename,desc,
diff --git a/Dozentenmodulserver/src/server/startServer.java b/Dozentenmodulserver/src/server/startServer.java
index 99189780..eb34d3a1 100644
--- a/Dozentenmodulserver/src/server/startServer.java
+++ b/Dozentenmodulserver/src/server/startServer.java
@@ -32,7 +32,7 @@ public class startServer {
 	public static void main(String[] args) {
 
 		String version = "Version: 1.0";
-		String buildDate = "Build Date: 21.08.2014";
+		String buildDate = "Build Date: 22.08.2014";
 
 		//get going and show basic information in logfile
 		BasicConfigurator.configure();
diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index f763eacd..a60cef59 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -760,7 +760,7 @@ public class SQL {
 			return 0;

 		} catch (SQLException e) {

 			// TODO Auto-generated catch block

-			log.info(new Date() + " - Failed to UpdateImageData.");

+			log.info(new Date() + " - Failed to UpdateImagePath.");

 			e.printStackTrace();

 		}

 		return -1;

@@ -793,7 +793,7 @@ public class SQL {
 		try {

 			Connection con=getConnection();

 			Statement stm = con.createStatement();

-			//log.info(new Date() + " - OS: "+os+" architecture: "+architecture);

+			log.info(new Date() + " - Getting PrimaryKey for OS: "+os+" architecture: "+architecture);

 			ResultSet rs=stm

 					.executeQuery("SELECT operatingSystemID FROM bwLehrpool.m_operatingSystem where name like '"

 							+ os

@@ -802,12 +802,13 @@ public class SQL {
 							+ "';");

 			rs.first();

 			String pkos=rs.getString("operatingSystemID");

+			log.info(new Date() + " - Key is "+pkos);

 			con.close();

 			return  pkos;

 

 		} catch (SQLException e) {

 			// TODO Auto-generated catch block

-			log.info(new Date() + " - Failed to getPathOfImage.");

+			log.info(new Date() + " - Failed to getOSpk.");

 			e.printStackTrace();

 		}

 

@@ -830,7 +831,7 @@ public class SQL {
 

 		} catch (SQLException e) {

 			// TODO Auto-generated catch block

-			log.info(new Date() + " - Failed to getPathOfImage.");

+			log.info(new Date() + " - Failed to getOS.");

 			e.printStackTrace();

 		}

 

@@ -861,7 +862,7 @@ public class SQL {
 			return map;

 		} catch (SQLException e) {

 			// TODO Auto-generated catch block

-			log.info(new Date() + " - Failed to getImageData.");

+			log.info(new Date() + " - Failed to getLectureData.");

 			e.printStackTrace();

 		}

 		return null;

diff --git a/Dozentenmodulserver/src/util/XMLCreator.java b/Dozentenmodulserver/src/util/XMLCreator.java
index e900be94..a39a415e 100644
--- a/Dozentenmodulserver/src/util/XMLCreator.java
+++ b/Dozentenmodulserver/src/util/XMLCreator.java
@@ -46,7 +46,7 @@ public class XMLCreator {
 	
 
 	// phone param not existing
-	private String query = "SELECT m_VLData_imageInfo.image_path ,vorname, nachname, mail, shortdescription, description, m_operatingSystem.guestOS as os, m_VLData_lecture.admin_changeTime as time, m_VLData_lecture.name as lectureName, m_user.institution as userInstitution, m_user.loginName as loginName,  m_institution.name as institutionName "
+	private String query = "SELECT m_VLData_imageInfo.image_path ,vorname, nachname, mail, shortdescription, description, m_operatingSystem.guestOS as os, m_VLData_lecture.admin_changeTime as time, m_VLData_lecture.name as lectureName, m_user.institution as userInstitution, m_user.loginName as loginName, m_VLData_lecture.isActive,  m_institution.name as institutionName "
 			+ "FROM bwLehrpool.m_VLData_lecture, bwLehrpool.m_VLData_imageInfo, bwLehrpool.m_user, bwLehrpool.m_operatingSystem, bwLehrpool.m_institution "
 			+ "WHERE m_user.userID = m_VLData_lecture.admin_owner "
 			+ "AND m_VLData_imageInfo.GUID_imageID = m_VLData_lecture.imageID "
@@ -189,7 +189,13 @@ public class XMLCreator {
 
 		Element active = doc.createElement("active");
 		entry.appendChild(active);
-		active.setAttribute("param", "true");
+		
+		//set activity
+		if(rs.getString("isActive").equals("1")){
+			active.setAttribute("param", "true");
+		} else if(rs.getString("isActive").equals("0")){
+			active.setAttribute("param", "false");
+		}
 
 		Element pools = doc.createElement("pools");
 		entry.appendChild(pools);