diff options
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLectureNetshare.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLectureNetshare.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLectureNetshare.java index 30843d31..0e132712 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLectureNetshare.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLectureNetshare.java @@ -59,7 +59,7 @@ public class DbLectureNetshare { MysqlStatement netsharestmt = connection.prepareStatement( "SELECT pns.shareid, IFNULL(pns.sharedata, ns.sharedata) AS sharedata FROM networkshare ns" + " LEFT JOIN presetnetworkshare pns ON (ns.sharepresetid = pns.shareid)" - + " WHERE ns.lectureid = :lectureid"); + + " WHERE ns.lectureid = :lectureid AND (pns.active IS NULL OR pns.active <> 0)"); netsharestmt.setString("lectureid", lectureId); ResultSet rs = netsharestmt.executeQuery(); while (rs.next()) { |