maintenance.php: fix join

1 files changed, 3 insertions, 2 deletions

diff --git a/html/maintenance.php b/html/maintenance.php
index 6d36eb0..0501b72 100644
--- a/html/maintenance.php
+++ b/html/maintenance.php
@@ -76,8 +76,9 @@ if (array_key_exists('machine',$_GET)) {
 
   $stm = $db -> prepare(
     'SELECT states.name, keys.key FROM machines' .
-    ' JOIN permissions ON permissions.machine_id = machines.id' .
-    ' JOIN states ON permissions.state_id = states.id' .
+    ' JOIN "values" ON "values".machine_id = machines.id' .
+    ' JOIN permissions ON permissions.value_id = "values".id' .
+    ' JOIN states ON "values".state_id = states.id' .
     ' JOIN keys ON permissions.key_id = keys.id' .
     ' WHERE machines.name=:machine');
   $stm -> bindValue('machine', $_GET['machine']);