pkginfo.php: started to integrate blacklist info

1 files changed, 31 insertions, 0 deletions

diff --git a/packages/pkginfo.php b/packages/pkginfo.php
index bf6812c..a66fb68 100644
--- a/packages/pkginfo.php
+++ b/packages/pkginfo.php
@@ -376,10 +376,23 @@ require_once BASE . "/lib/style.php";
     " WHERE `original`.`id`=" . $mysql_content["id"]
   );
 
+
   $elsewhere = array();
   while ($row = $mysql_result -> fetch_assoc())
     $elsewhere[] = $row;
 
+  // blacklist entry
+  $mysql_result = mysql_run_query( "select distinct architectures.name as architecture, " .
+    "package_sources.pkgbase as pkgname, " .
+    "is_black_listed as reason " .
+    "from architectures,package_sources,build_assignments " .
+    "where package_sources.id=package_source and architecture=architectures.id and " .
+    "package_sources.pkgbase='" . $_GET["pkgname"] . "' and is_black_listed is not null and " .
+    "architectures.name='" . $_GET["repo_arch"] . "'"  );
+  $blacklists = array();
+  while ($row = $mysql_result -> fetch_assoc())
+    $blacklists[] = $row;
+
   print_header($content["pkgname"] . " " . $content["version"] . " (" . $content["arch"] . ")");
 
 ?>
@@ -630,6 +643,24 @@ if ($count > 1 || $content["pkgname"] != $content["pkgbase"]) {
                 <?php print $content["last_moved"]."\n"; ?>
               </td>
             </tr>
+<?php
+  if (count($blacklists)>0) {
+    print <<<EOF
+            <tr>
+              <th>
+                Blacklisted:
+              </th>
+              <td>
+EOF;
+    foreach ($blacklists as $blacklist) {
+      print $blacklist["reason"];
+    }
+    print <<<EOF
+              </td>
+            </tr>
+EOF;
+  }
+?>
           </table>
         </div>
         <div id="metadata">