diff options
| author | Michael Wilson | 2014-11-03 12:16:39 +0100 |
|---|---|---|
| committer | Michael Wilson | 2014-11-03 12:16:39 +0100 |
| commit | 89c3e93c1f44545a744ad58a8a50800f74f96034 (patch) | |
| tree | b5174d8529ad7f35f502e7b00a4345e45d62c608 | |
| parent | Sonderzeichen nun auch im bearbeiten von Images erlaubt (diff) | |
| download | tutor-module-89c3e93c1f44545a744ad58a8a50800f74f96034.tar.gz tutor-module-89c3e93c1f44545a744ad58a8a50800f74f96034.tar.xz tutor-module-89c3e93c1f44545a744ad58a8a50800f74f96034.zip | |
.
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index c9615d41..7ec99092 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -509,7 +509,7 @@ public class SQL { // ResultSet
ResultSet res = stm
- .executeQuery("SELECT DISTINCT vl.GUID_imageID, vl.imageVersion, vl.image_name,vl_image_description, vl.cond_hasLicenseRestriction, os.name, os.architecture, '' as lecture, vl.image_update_time, Concat(u.Nachname,' ',u.Vorname) as user, vl.image_isTemplate FROM bwLehrpool.pm_VLData_image pmi, bwLehrpool.m_VLData_imageInfo vl, bwLehrpool.m_operatingSystem os, bwLehrpool.m_user u WHERE pmi.userID='"
+ .executeQuery("SELECT DISTINCT vl.GUID_imageID, vl.imageVersion, vl.image_name,vl.image_description, vl.cond_hasLicenseRestriction, os.name, os.architecture, '' as lecture, vl.image_update_time, Concat(u.Nachname,' ',u.Vorname) as user, vl.image_isTemplate FROM bwLehrpool.pm_VLData_image pmi, bwLehrpool.m_VLData_imageInfo vl, bwLehrpool.m_operatingSystem os, bwLehrpool.m_user u WHERE pmi.userID='"
+ userID
+ "' AND u.userID = pmi.userID AND pmi.image_admin = 1 AND pmi.GUID_imageID = vl.GUID_imageID AND vl.content_operatingSystem=os.operatingSystemID;");
|