From 426e574b85d363cd5a1fa256034dc2a281fc7272 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Fri, 15 May 2020 17:24:05 +0200
Subject: [remoteaccess] New module

---
 modules-available/remoteaccess/install.inc.php | 60 ++++++++++++++++++++++++++
 1 file changed, 60 insertions(+)
 create mode 100644 modules-available/remoteaccess/install.inc.php

(limited to 'modules-available/remoteaccess/install.inc.php')

diff --git a/modules-available/remoteaccess/install.inc.php b/modules-available/remoteaccess/install.inc.php
new file mode 100644
index 00000000..11656218
--- /dev/null
+++ b/modules-available/remoteaccess/install.inc.php
@@ -0,0 +1,60 @@
+<?php
+
+$dbret = [];
+
+$dbret[] = tableCreate('remoteaccess_group', "
+	`groupid` int(11) NOT NULL AUTO_INCREMENT,
+	`groupname` varchar(100) NOT NULL,
+	`wolcount` smallint(11) NOT NULL,
+	`passwd` varchar(100) NOT NULL,
+	`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
+	PRIMARY KEY (`groupid`)
+");
+
+$dbret[] = tableCreate('remoteaccess_x_location', "
+	`groupid` int(11) NOT NULL,
+	`locationid` int(11) NOT NULL,
+	PRIMARY KEY (`groupid`, `locationid`)
+");
+
+$dbret[] = tableCreate('remoteaccess_machine', "
+	`machineuuid` char(36) CHARACTER SET ascii NOT NULL,
+	`password` char(8) CHARACTER SET ascii NULL DEFAULT NULL,
+	`woltime` int(10) UNSIGNED NOT NULL DEFAULT '0',
+	PRIMARY KEY (`machineuuid`)
+");
+
+$dbret[] = tableAddConstraint('remoteaccess_x_location', 'locationid', 'location', 'locationid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
+$dbret[] = tableAddConstraint('remoteaccess_x_location', 'groupid', 'remoteaccess_group', 'groupid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
+$dbret[] = tableAddConstraint('remoteaccess_machine', 'machineuuid', 'machine', 'machineuuid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
+if (tableExists('remoteaccess_location')
+		&& tableExists('remoteaccess_x_location')
+		&& tableExists('remoteaccess_group')) {
+	// Migrate old version
+	$wantedIdleCount = (int)Property::get('remoteaccess.wantedclients', 0);
+	$ret = Database::exec("INSERT IGNORE INTO remoteaccess_group (groupid, groupname, wolcount, passwd)
+			SELECT l.locationid, l.locationname, $wantedIdleCount AS blu, '' AS bla FROM location l
+			    INNER JOIN remoteaccess_location rl USING (locationid)");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, Database::lastError());
+	}
+	Property::set('remoteaccess.wantedclients', 0, 1);
+	$max = Database::queryFirst("SELECT groupid FROM remoteaccess_group ORDER BY groupid DESC LIMIT 1");
+	if ($max !== false) {
+		Database::exec("ALTER TABLE remoteaccess_group AUTO_INCREMENT = :next", ['next' => $max['groupid'] + 1]);
+	}
+	$ret = Database::exec("INSERT IGNORE INTO remoteaccess_x_location (groupid, locationid)
+			SELECT locationid, locationid FROM remoteaccess_location");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, Database::lastError());
+	}
+	Database::exec("DROP TABLE remoteaccess_location");
+}
+
+responseFromArray($dbret);
-- 
cgit v1.2.3-55-g7522