From 6d93913ca2893a7fc5499c0cb5d6e70831e7af50 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 11 Apr 2018 16:54:13 +0200 Subject: status quo --- scripts/build-slaves.php | 49 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 49 insertions(+) create mode 100644 scripts/build-slaves.php (limited to 'scripts/build-slaves.php') diff --git a/scripts/build-slaves.php b/scripts/build-slaves.php new file mode 100644 index 0000000..b6afc2d --- /dev/null +++ b/scripts/build-slaves.php @@ -0,0 +1,49 @@ +list of build slaves +connect_error) { + die("Connection to mysql database failed: " . $conn->connect_error); + } + + if (!$result = + $conn->query( + "SELECT" . + " `build_slaves`.`name`," . + "`build_slaves`.`operator`," . + "`package_sources`.`pkgbase`," . + "`build_slaves`.`last_connection`," . + "`build_slaves`.`logged_lines`," . + "`build_slaves`.`last_action`" . + " FROM `build_slaves`" . + " LEFT JOIN `build_assignments` ON" . + " `build_slaves`.`currently_building`=`build_assignments`.`id`" . + " LEFT JOIN `package_sources` ON" . + " `build_assignments`.`package_source`=`package_sources`.`id`" . + " ORDER BY `build_slaves`.`last_connection`" + )) + die($conn->error); + + print "\n"; + if ($result->num_rows > 0) { + print "\n"; + while ($row = $result -> fetch_assoc()) { + foreach ($row as $key => $value) { + if ($value=="") { + $row[$key]=" "; + } + } + print ""; + print ""; + print ""; + print ""; + print ""; + print ""; + print ""; + print "\n"; + } + } + print "
nameoperatorcurrently buildinglast connectionlogged lineslast action
".$row["name"]."".$row["operator"]."".$row["pkgbase"]."".$row["last_connection"]."".$row["logged_lines"]."".$row["last_action"]."
\n"; + +?> + -- cgit v1.2.3-70-g09d2