1 files changed, 21 insertions, 20 deletions
diff --git a/buildmaster/to-delete.php b/buildmaster/to-delete.php
index dfa5a39..4da10a2 100644
--- a/buildmaster/to-delete.php
+++ b/buildmaster/to-delete.php
@@ -1,3 +1,24 @@
+<?php
+
+  include "lib/mysql.php";
+
+  $result = mysql_run_query(
+    "SELECT " .
+    "`repositories`.`name` AS `repo`," .
+    "`binary_packages`.`pkgname`," .
+    "`binary_packages`.`epoch`," .
+    "`binary_packages`.`pkgver`," .
+    "`binary_packages`.`pkgrel`," .
+    "`binary_packages`.`sub_pkgrel`," .
+    "`architectures`.`name` AS `arch` " .
+    "FROM `binary_packages` " .
+    "JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` " .
+    "JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id` " .
+    "WHERE `binary_packages`.`is_to_be_deleted` " .
+    "AND NOT `repositories`.`name` IN (\"build-support\",\"build-list\",\"deletion-list\")"
+  );
+
+?>
 <html>
 <head>
 <title>List of packages to be deleted</title>
@@ -6,26 +27,6 @@
 <body>
 <?php
 
-$mysql = new mysqli("localhost", "webserver", "empty", "buildmaster");
-if ($mysql->connect_error) {
-  die("Connection failed: " . $mysql->connect_error);
-}
-
-$result = $mysql -> query(
-  "SELECT " .
-  "`repositories`.`name` AS `repo`," .
-  "`binary_packages`.`pkgname`," .
-  "`binary_packages`.`epoch`," .
-  "`binary_packages`.`pkgver`," .
-  "`binary_packages`.`pkgrel`," .
-  "`binary_packages`.`sub_pkgrel`," .
-  "`architectures`.`name` AS `arch` " .
-  "FROM `binary_packages` " .
-  "JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` " .
-  "JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id` " .
-  "WHERE `binary_packages`.`is_to_be_deleted` " .
-  "AND NOT `repositories`.`name` IN (\"build-support\",\"build-list\",\"deletion-list\")"
-);
 if ($result -> num_rows > 0) {
 
   $count = 0;