[server] Write usb enabled/disabled to virt config

1 files changed, 4 insertions, 1 deletions

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
index d9135bb1..8a8f6bd9 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
@@ -513,10 +513,11 @@ public class DbLecture {
 		byte[] config;
 		String lectureName;
 		String osKeyword;
+		boolean usbAccess;
 		try (MysqlConnection connection = Database.getConnection()) {
 			// Get required data about lecture and used image
 			MysqlStatement stmt = connection.prepareStatement("SELECT"
-					+ " l.displayname AS lecturename, l.starttime, l.endtime, l.isenabled,"
+					+ " l.displayname AS lecturename, l.starttime, l.endtime, l.isenabled, l.hasusbaccess,"
 					+ " o.virtoskeyword, i.virtualizerconfig"
 					+ "                      FROM lecture l                 "
 					+ " INNER JOIN imageversion i USING (imageversionid)"
@@ -532,6 +533,7 @@ public class DbLecture {
 			config = rs.getBytes("virtualizerconfig");
 			lectureName = rs.getString("lecturename");
 			osKeyword = rs.getString("virtoskeyword");
+			usbAccess = rs.getBoolean("hasusbaccess");
 			// Everything worked so far, update statistics counters
 			MysqlStatement upStmt = connection.prepareStatement("UPDATE"
 					+ " lecture SET lastused = UNIX_TIMESTAMP(), usecount = usecount + 1"
@@ -553,6 +555,7 @@ public class DbLecture {
 		}
 		meta.addHddTemplate("%VM_DISK_PATH%", "%VM_DISK_MODE%", "%VM_DISK_REDOLOGDIR%");
 		meta.addEthernet(EthernetType.NAT); // TODO: Use config
+		meta.enableUsb(usbAccess);
 		meta.disableSuspend();
 		return meta;
 	}