diff options
| -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> |