From 5c5ed42237757efcf698a36c37cf9bd0630232c3 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 17 Apr 2018 10:04:07 +0200
Subject: buildmaster/*.php: use lib/mysql.php

---
 buildmaster/statistics.php | 43 ++++++++++++++++++++-----------------------
 1 file changed, 20 insertions(+), 23 deletions(-)

(limited to 'buildmaster/statistics.php')

diff --git a/buildmaster/statistics.php b/buildmaster/statistics.php
index 47f1418..8c13548 100644
--- a/buildmaster/statistics.php
+++ b/buildmaster/statistics.php
@@ -1,33 +1,30 @@
 <?php
 
+include "lib/mysql.php";
+
 if (isset($_GET["from"]))
   $min_time="from_base64(\"" . base64_encode("-".$_GET["from"]) . "\")";
 else
   $min_time="\"-7 00:00:00\"";
 
-$mysql = new mysqli("localhost", "webserver", "empty", "buildmaster");
-if ($mysql->connect_error) {
-  die("Connection failed: " . $mysql->connect_error);
-}
-if (! $result = $mysql -> query(
-    "SELECT DISTINCT ".
-    "UNIX_TIMESTAMP(`statistics`.`date`) AS `date`," .
-    "`statistics`.`pending_tasks_count`," .
-    "`statistics`.`pending_packages_count`," .
-    "`statistics`.`staging_packages_count`," .
-    "`statistics`.`testing_packages_count`," .
-    "`statistics`.`tested_packages_count`," .
-    "`statistics`.`broken_tasks_count`," .
-    "`statistics`.`dependency_loops_count`," .
-    "`statistics`.`dependency_looped_tasks_count`," .
-    "`statistics`.`locked_tasks_count`," .
-    "`statistics`.`blocked_tasks_count`," .
-    "`statistics`.`next_tasks_count`" .
-    "FROM `statistics` " .
-    "WHERE `statistics`.`date`>=ADDTIME(NOW()," . $min_time . ") " .
-    "ORDER BY `statistics`.`date`"
-  ))
-  die($mysql->error);
+$result = mysql_run_query(
+  "SELECT DISTINCT ".
+  "UNIX_TIMESTAMP(`statistics`.`date`) AS `date`," .
+  "`statistics`.`pending_tasks_count`," .
+  "`statistics`.`pending_packages_count`," .
+  "`statistics`.`staging_packages_count`," .
+  "`statistics`.`testing_packages_count`," .
+  "`statistics`.`tested_packages_count`," .
+  "`statistics`.`broken_tasks_count`," .
+  "`statistics`.`dependency_loops_count`," .
+  "`statistics`.`dependency_looped_tasks_count`," .
+  "`statistics`.`locked_tasks_count`," .
+  "`statistics`.`blocked_tasks_count`," .
+  "`statistics`.`next_tasks_count`" .
+  "FROM `statistics` " .
+  "WHERE `statistics`.`date`>=ADDTIME(NOW()," . $min_time . ") " .
+  "ORDER BY `statistics`.`date`"
+);
 
 $t_min = -1;
 $t_max = -1;
-- 
cgit v1.2.3