show comment of keys

1 files changed, 2 insertions, 2 deletions

diff --git a/html/maintenance.php b/html/maintenance.php
index b849814..f1d77ad 100644
--- a/html/maintenance.php
+++ b/html/maintenance.php
@@ -66,7 +66,7 @@ if (array_key_exists('machine',$_GET)) {
     $db -> add_key_for($_GET['machine'], $_GET['new_key'], $_GET['comment']);
 
   $stm = $db -> prepare(
-    'SELECT states.name, keys.key FROM machines' .
+    'SELECT states.name, keys.key, keys.comment FROM machines' .
     ' JOIN "values" ON "values".machine_id = machines.id' .
     ' JOIN permissions ON permissions.value_id = "values".id' .
     ' JOIN states ON "values".state_id = states.id' .
@@ -75,7 +75,7 @@ if (array_key_exists('machine',$_GET)) {
   $stm -> bindValue('machine', $_GET['machine']);
   $result = $stm -> execute();
   while ($row = $result -> fetchArray()) {
-    echo 'permission = "' . $row['name'] . '", key = "' . $row['key'] . '" <br>' . "\n";
+    echo 'permission = "' . $row['name'] . '", key = "' . $row['key'] . '", comment = "' . $row['comment'] . '" <br>' . "\n";
   }
   echo 'done.' . "\n";
   die();