summaryrefslogtreecommitdiff
path: root/buildmaster/ssh-log.php
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-04-17 16:12:32 +0200
committerErich Eckner <git@eckner.net>2018-04-17 16:12:32 +0200
commit93e86de87f4bde6c9ab13651bb437533cc856633 (patch)
treea678955102e4577c317dae0d16fab34a9cfc93ef /buildmaster/ssh-log.php
parentba0bfb1336a9667ba1a9809f36bb684fc015dcd4 (diff)
downloadarchweb32-93e86de87f4bde6c9ab13651bb437533cc856633.tar.xz
buildmaster/ssh-log.php new
Diffstat (limited to 'buildmaster/ssh-log.php')
-rw-r--r--buildmaster/ssh-log.php53
1 files changed, 53 insertions, 0 deletions
diff --git a/buildmaster/ssh-log.php b/buildmaster/ssh-log.php
new file mode 100644
index 0000000..d293ebb
--- /dev/null
+++ b/buildmaster/ssh-log.php
@@ -0,0 +1,53 @@
+<?php
+
+ include "lib/mysql.php";
+
+ $result = mysql_run_query(
+ "SELECT `ssh_log`.`date`," .
+ "`build_slaves`.`name`," .
+ "`ssh_log`.`action`," .
+ "`ssh_log`.`parameters`" .
+ " FROM `ssh_log`" .
+ " JOIN `build_slaves` ON `ssh_log`.`build_slave`=`build_slaves`.`id`" .
+ " WHERE TIMEDIFF(NOW(),`ssh_log`.`date`) < \"10:00\"" .
+ " ORDER BY `ssh_log`.`date` DESC"
+ );
+
+?>
+<html>
+ <head>
+ <title>ssh-log</title>
+ <link rel="stylesheet" type="text/css" href="/static/style.css">
+ </head>
+ <body>
+ <table>
+ <tr>
+ <th>
+ date
+ </th>
+ <th>
+ build slave
+ </th>
+ <th>
+ action
+ </th>
+ <th>
+ parameters
+ </th>
+ </tr>
+<?php
+
+ while ($row = $result -> fetch_assoc()) {
+ print " <tr>\n";
+ foreach ($row as $val) {
+ print " <td>\n";
+ print " " . $val . "\n";
+ print " </td>\n";
+ }
+ print " </tr>\n";
+ }
+
+?>
+ </table>
+ </body>
+</html>