1 files changed, 48 insertions, 0 deletions
diff --git a/buildmaster/gpg-keys.php b/buildmaster/gpg-keys.php
new file mode 100644
index 0000000..db990c2
--- /dev/null
+++ b/buildmaster/gpg-keys.php
@@ -0,0 +1,48 @@
+<?php
+require_once "../init.php";
+require_once BASE . "/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`" .
+    mysql_join_email_actions_allowed_email_actions() .
+    " RIGHT" . mysql_join_allowed_email_actions_gpg_keys() .
+    mysql_join_gpg_keys_persons() .
+    " 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><a href=\"http://pgp.mit.edu/pks/lookup?op=get&search=0x" .
+        substr($row["fingerprint"],-16) .
+        "\">" . $row["fingerprint"] . "</a></td>";
+      print "</tr>\n";
+    }
+  }
+  print "</table>\n";
+
+?>
+</body></html>