summaryrefslogtreecommitdiffstats
path: root/Dozentenmodulserver/src/util/XMLCreator.java
diff options
context:
space:
mode:
Diffstat (limited to 'Dozentenmodulserver/src/util/XMLCreator.java')
-rw-r--r--Dozentenmodulserver/src/util/XMLCreator.java10
1 files changed, 8 insertions, 2 deletions
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);