diff options
| author | Erich Eckner <git@eckner.net> | 2018-06-11 13:40:14 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-06-11 13:40:14 +0200 |
| commit | 33d3a112b92b120119b243b2e891efd414da69c0 (patch) | |
| tree | 3343b32a9693e945650e53e12d854348ce2fec8e /buildmaster | |
| parent | 4ce761c0145ae343b2a464742cd4eeca03b84e4b (diff) | |
| download | archweb32-33d3a112b92b120119b243b2e891efd414da69c0.tar.xz | |
buildmaster/gpg-keys.php new
Diffstat (limited to 'buildmaster')
| -rw-r--r-- | buildmaster/gpg-keys.php | 49 |
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]=" "; + } + } + 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> |