diff options
| -rw-r--r-- | Dozentenmodulserver/bin/util/XMLCreator.class | bin | 6292 -> 6327 bytes | |||
| -rw-r--r-- | Dozentenmodulserver/src/util/XMLCreator.java | 6 |
2 files changed, 3 insertions, 3 deletions
diff --git a/Dozentenmodulserver/bin/util/XMLCreator.class b/Dozentenmodulserver/bin/util/XMLCreator.class Binary files differindex 025904a6..9700459e 100644 --- a/Dozentenmodulserver/bin/util/XMLCreator.class +++ b/Dozentenmodulserver/bin/util/XMLCreator.class diff --git a/Dozentenmodulserver/src/util/XMLCreator.java b/Dozentenmodulserver/src/util/XMLCreator.java index 8a8bd701..3f5866e6 100644 --- a/Dozentenmodulserver/src/util/XMLCreator.java +++ b/Dozentenmodulserver/src/util/XMLCreator.java @@ -33,7 +33,7 @@ public class XMLCreator { private String filePath = "/srv/openslx/nfs/temp/"; // phone param not existing - private String query = "SELECT m_VLData_imageInfo.image_path ,vorname, nachname, mail, shortdescription, description, m_operatingSystem.name as os, m_VLData_lecture.admin_changeTime as time " + private String query = "SELECT m_VLData_imageInfo.image_path ,vorname, nachname, mail, shortdescription, description, m_operatingSystem.name as os, m_VLData_lecture.admin_changeTime as time, m_VLData_lecture.name as lectureName " + "FROM bwLehrpool.m_VLData_lecture, bwLehrpool.m_VLData_imageInfo, bwLehrpool.m_user, bwLehrpool.m_operatingSystem " + "WHERE m_user.userID = m_VLData_lecture.admin_owner " + "AND m_VLData_imageInfo.GUID_imageID = m_VLData_lecture.imageID " @@ -118,7 +118,7 @@ public class XMLCreator { Element imgName = doc.createElement("image_name"); entry.appendChild(imgName); String imagePath = rs.getString("image_path").substring( - rs.getString("image_path").lastIndexOf("/")); + rs.getString("image_path").lastIndexOf("/")+1); //+1 um das "/" los zu werden imgName.setAttribute("param", imagePath); @@ -138,7 +138,7 @@ public class XMLCreator { Element shortDesc = doc.createElement("short_description"); entry.appendChild(shortDesc); - shortDesc.setAttribute("param", rs.getString("shortdescription")); + shortDesc.setAttribute("param", rs.getString("lectureName")); // TODO append latest change date and time Element longDesc = doc.createElement("long_description"); |