summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-11 13:40:14 +0200
committerErich Eckner <git@eckner.net>2018-06-11 13:40:14 +0200
commit33d3a112b92b120119b243b2e891efd414da69c0 (patch)
tree3343b32a9693e945650e53e12d854348ce2fec8e
parent4ce761c0145ae343b2a464742cd4eeca03b84e4b (diff)
downloadarchweb32-33d3a112b92b120119b243b2e891efd414da69c0.tar.xz
buildmaster/gpg-keys.php new
-rw-r--r--buildmaster/gpg-keys.php49
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>