1 files changed, 49 insertions, 0 deletions
diff --git a/buildmaster/gpg-keys.php b/buildmaster/gpg-keys.php
new file mode 100644
index 0000000..56e7801
--- /dev/null
+++ b/buildmaster/gpg-keys.php
@@ -0,0 +1,49 @@
+<?php
+
+  include "lib/mysql.php";
+
+  $result = mysql_run_query(
+    "SELECT" .
+    " GROUP_CONCAT(`email_actions`.`name`) AS `action`," .
+    "`persons`.`name` AS `person`," .
+    "`gpg_keys`.`fingerprint`" .
+    " FROM `email_actions`" .
+    " JOIN `allowed_email_actions` ON" .
+    " `email_actions`.`id`=`allowed_email_actions`.`action`" .
+    " RIGHT JOIN `gpg_keys` ON" .
+    " `allowed_email_actions`.`gpg_key`=`gpg_keys`.`id`" .
+    " JOIN `persons` ON" .
+    " `gpg_keys`.`owner`=`persons`.`id`" .
+    " GROUP BY `gpg_keys`.`id`" .
+    " ORDER BY `persons`.`name`"
+  );
+
+?>
+<html>
+  <head>
+    <title>list of gpg-keys</title>
+  </head>
+  <body>
+<?php
+show_warning_on_offline_slave();
+
+  print "<table border=1>\n";
+  if ($result->num_rows > 0) {
+    print "<tr><th>person</th><th>action</th><th>fingerprint</th></tr>\n";
+    while ($row = $result -> fetch_assoc()) {
+      foreach ($row as $key => $value) {
+        if ($value=="") {
+          $row[$key]="&nbsp;";
+        }
+      }
+      print "<tr>";
+      print "<td>".$row["person"]."</td>";
+      print "<td>".$row["action"]."</td>";
+      print "<td>".$row["fingerprint"]."</td>";
+      print "</tr>\n";
+    }
+  }
+  print "</table>\n";
+
+?>
+</body></html>