From fda45cb6e80945f0e22ab0002facfa37ab40fede Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Thu, 7 Mar 2019 15:59:27 +0100
Subject: [server] Fix: Client gets disabled network shares on vm start

---
 .../java/org/openslx/bwlp/sat/database/mappers/DbLectureNetshare.java   | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'dozentenmodulserver')

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()) {
-- 
cgit v1.2.3-55-g7522