path: root/packages/pkginfo.php

<?php

  function throw_http_error($error_number, $error_message, $extra_message = "") {
    header("Status: " . $error_number . " " . $error_message);
    print "Error " . $error_number . ": " . $error_message . "\n";
    if ($extra_message != "")
      print "<br>\n" . $extra_message;
    die();
  };

  function die_500($message) {
    throw_http_error(500, "Internal Server Error", $message);
  };

  $json_content = json_decode(
    file_get_contents(
      "https://pkgapi.arch32.tyzoid.com/package/".$_GET["repo"].":".$_GET["pkgname"]
    ),
    true
  );

  if (!isset($json_content["package"]))
    throw_http_error(404, "Package Not Found In Sync Database");

  $json_content = $json_content["package"];

  $mysql = new mysqli("localhost", "webserver", "empty", "buildmaster");
  if ($mysql->connect_error)
    die_500("Connection to database failed: " . $mysql->connect_error);

  if (! $mysql_result = $mysql -> query(
    "SELECT DISTINCT " .
    "`binary_packages`.`id`," .
    "`binary_packages`.`pkgname`," .
    "`package_sources`.`pkgbase`," .
    "CONCAT(" .
      "IF(`binary_packages`.`epoch`=\"0\",\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," .
      "`binary_packages`.`pkgver`,\"-\"," .
      "`binary_packages`.`pkgrel`,\".\"," .
      "`binary_packages`.`sub_pkgrel`" .
    ") AS `version`," .
    "`repositories`.`stability` AS `repo_stability`," .
    "`repository_stabilities`.`name` AS `repo_stability_name`," .
    "`repositories`.`name` AS `repo`," .
    "`architectures`.`name` AS `arch`," .
    "`git_repositories`.`name` AS `git_repo`," .
    "`package_sources`.`uses_upstream`," .
    "`package_sources`.`uses_modification`" .
    " FROM `binary_packages`" .
    " JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" .
    " JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id`" .
    " JOIN `repository_stabilities` ON `repositories`.`stability`=`repository_stabilities`.`id`" .
    " JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id`" .
    " JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id`" .
    " JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id`" .
    " JOIN `git_repositories` ON `upstream_repositories`.`git_repository`=`git_repositories`.`id`" .
    " WHERE `binary_packages`.`pkgname`=from_base64(\"" . base64_encode($_GET["pkgname"]) . "\")" .
    " AND `architectures`.`name`=from_base64(\"" . base64_encode($_GET["arch"]) . "\")" .
    " AND `repositories`.`name`=from_base64(\"" . base64_encode($_GET["repo"]) . "\")"
    ))
    die_500("Query failed: " . $mysql->error);

  if ($mysql_result -> num_rows != 1)
    throw_http_error(404, "Package Not Found In Buildmaster's Database");

  $mysql_content = $mysql_result -> fetch_assoc();

  $same_keys = array (
    array("mysql" => "pkgname", "json" => "Name"),
    array("mysql" => "version", "json" => "Version", "suffix_diff" => ".0"),
    array("mysql" => "repo", "json" => "Repository"),
    array("mysql" => "arch", "json" => "Architecture")
  );

  foreach ($same_keys as $same_key)
    if (($mysql_content[$same_key["mysql"]] != $json_content[$same_key["json"]]) &&
      ((!isset($same_key["suffix_diff"])) ||
        ($mysql_content[$same_key["mysql"]] != $json_content[$same_key["json"]].$same_key["suffix_diff"])))
      die_500("Inconsistency in Database found:<br>\n" .
        "buildmaster[" . $same_key["mysql"] . "] != repositories[" . $same_key["json"] . "]:<br>\n" .
        "\"" . $mysql_content[$same_key["mysql"]] . "\" != \"" . $json_content[$same_key["json"]] . "\"");

  // query _all_ dependencies

  if (! $mysql_result = $mysql -> query(
    "SELECT DISTINCT " .
    "`dependency_types`.`name` AS `dependency_type`," .
    "GROUP_CONCAT(" .
    "CONCAT(\"\\\"\",`install_target_providers`.`id`,\"\\\": \",\"{\\n\"," .
      "\"  \\\"repo\\\": \\\"\",`repositories`.`name`,\"\\\",\\n\"," .
      "\"  \\\"arch\\\": \\\"\",`architectures`.`name`,\"\\\",\\n\"," .
      "\"  \\\"pkgname\\\": \\\"\",`binary_packages`.`pkgname`,\"\\\"\\n\"," .
      "\"}\"" .
    ")) AS `deps`," .
    "`install_targets`.`name` AS `install_target`" .
    " FROM `dependencies`" .
    " JOIN `dependency_types` ON `dependency_types`.`id`=`dependencies`.`dependency_type`" .
    " JOIN `install_targets` ON `install_targets`.`id`=`dependencies`.`depending_on`" .
    " AND `install_targets`.`name` NOT IN (\"base\",\"base-devel\")" .
    " LEFT JOIN (" .
      "`install_target_providers`" .
      " JOIN `binary_packages` ON `install_target_providers`.`package`=`binary_packages`.`id`" .
      " JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" .
      " JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id`" .
      " JOIN `repository_stability_relations` ON `repository_stability_relations`.`more_stable`=`repositories`.`stability`" .
      " AND `repository_stability_relations`.`less_stable`=" . $mysql_content["repo_stability"] .
    ") ON `install_target_providers`.`install_target`=`dependencies`.`depending_on`" .
    " WHERE `dependencies`.`dependent`=" . $mysql_content["id"] .
    " AND NOT EXISTS (" .
      "SELECT 1 FROM `binary_packages` AS `subst_bp`" .
      " JOIN `repositories` AS `subst_r` ON `subst_bp`.`repository`=`subst_r`.`id`" .
  // the substitue must be truly less stable than the dependency
      " JOIN `repository_stability_relations` AS `subst_rsr` ON `subst_rsr`.`less_stable`=`subst_r`.`stability`" .
      " AND `subst_rsr`.`less_stable`!=`subst_rsr`.`more_stable`" .
  // and more (or equally) stable than us
      " JOIN `repository_stability_relations` AS `subst_rsr2` ON `subst_rsr2`.`more_stable`=`subst_r`.`stability`" .
      " WHERE `subst_bp`.`pkgname`=`binary_packages`.`pkgname`" .
      " AND `subst_rsr`.`more_stable`=`repositories`.`stability`" .
      " AND `subst_rsr2`.`less_stable`=" . $mysql_content["repo_stability"] .
    ")" .
    " GROUP BY `install_targets`.`id`,`dependency_types`.`id`" .
    " ORDER BY FIELD (`dependency_types`.`name`,\"run\",\"make\",\"check\",\"link\"), `install_targets`.`name`"
    ))
    die_500("Query failed: " . $mysql->error);

  $dependencies = array();
  while ($row = $mysql_result -> fetch_assoc()) {
    $row["deps"] = json_decode("{".$row["deps"]."}",true);
    $dependencies[] = $row;
  }

  function dependency_is_runtime($dep) {
    return $dep["dependency_type"]=="run";
  };

  function dependency_extract_name($dep) {
    return $dep["install_target"];
  };

  $dep_it = array_filter( $dependencies, "dependency_is_runtime");
  $dep_it = array_map("dependency_extract_name", $dep_it);
  $dep_it = preg_replace("/[<=>].*$/","",$dep_it);
  $js_dep = preg_replace("/[<=>].*$/","",$json_content["Depends On"]);
  $dep_errors = implode(
    ", ",
    array_diff(
      array_merge($dep_it,$js_dep),
      array_intersect($dep_it,$js_dep)
    )
  );

  if ($dep_errors != "")
    die_500(
      "Dependencies differ: " . $dep_errors. "<br>\n" .
      "mysql: " . implode(", ",$dep_it) . "<br>\n" .
      "json: " . implode(", ",$js_dep)
    );

  // query dependent packages

  if (! $mysql_result = $mysql -> query(
    "SELECT DISTINCT " .
    "`dependency_types`.`name` AS `dependency_type`," .
    "`install_targets`.`name` AS `install_target`," .
    "`repositories`.`name` AS `repo`," .
    "`architectures`.`name` AS `arch`," .
    "`binary_packages`.`pkgname`" .
    " FROM `install_target_providers`" .
    " JOIN `install_targets` ON `install_targets`.`id`=`install_target_providers`.`install_target`" .
    " AND `install_targets`.`name` NOT IN (\"base\",\"base-devel\")" .
    " JOIN `dependencies` ON `install_target_providers`.`install_target`=`dependencies`.`depending_on`" .
    " JOIN `dependency_types` ON `dependency_types`.`id`=`dependencies`.`dependency_type`" .
    " JOIN `binary_packages` ON `dependencies`.`dependent`=`binary_packages`.`id`" .
    " JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" .
    " JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id`" .
    " JOIN `repository_stability_relations` ON `repository_stability_relations`.`less_stable`=`repositories`.`stability`" .
    " AND `repository_stability_relations`.`more_stable`=" . $mysql_content["repo_stability"] .
    " WHERE `install_target_providers`.`package`=" . $mysql_content["id"] .
    " AND NOT EXISTS (" .
      "SELECT 1 FROM `binary_packages` AS `subst_bp`" .
      " JOIN `repositories` AS `subst_r` ON `subst_bp`.`repository`=`subst_r`.`id`" .
  // the substitue must be truly less stable than we
      " JOIN `repository_stability_relations` AS `subst_rsr` ON `subst_rsr`.`less_stable`=`subst_r`.`stability`" .
      " AND `subst_rsr`.`less_stable`!=`subst_rsr`.`more_stable`" .
  // and more (or equally) stable than the required-by
      " JOIN `repository_stability_relations` AS `subst_rsr2` ON `subst_rsr2`.`more_stable`=`subst_r`.`stability`" .
      " WHERE `subst_bp`.`pkgname`=from_base64(\"" . base64_encode($mysql_content["pkgname"]) . "\")" .
      " AND `subst_rsr2`.`less_stable`=`repositories`.`stability`" .
      " AND `subst_rsr`.`more_stable`=" . $mysql_content["repo_stability"] .
    ")" .
    " GROUP BY `binary_packages`.`id`,`dependency_types`.`id`" .
    " ORDER BY FIELD (`dependency_types`.`name`,\"run\",\"make\",\"check\",\"link\"), `install_targets`.`name`!=`binary_packages`.`pkgname`, `install_targets`.`name`, `binary_packages`.`pkgname`"
    ))
    die_500("Query failed: " . $mysql->error);

  $dependent = array();
  while ($row = $mysql_result -> fetch_assoc())
    $dependent[] = $row;

  $content = array_merge($mysql_content,$json_content);

  // query substitutes

  if (! $mysql_result = $mysql -> query(
    "SELECT " .
    "`binary_packages`.`pkgname` AS `pkgname`," .
    "`repositories`.`name` AS `repo`," .
    "`architectures`.`name` AS `arch`," .
    "CONCAT(" .
      "IF(`binary_packages`.`epoch`=\"0\",\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," .
      "`binary_packages`.`pkgver`,\"-\"," .
      "`binary_packages`.`pkgrel`,\".\"," .
      "`binary_packages`.`sub_pkgrel`" .
    ") AS `version`" .
    " FROM `binary_packages` " .
    " JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" .
    " JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id`" .
    " JOIN `binary_packages` AS `original`" .
    " ON `binary_packages`.`pkgname`=`original`.`pkgname`" .
    " AND `binary_packages`.`id`!=`original`.`id`" .
    " WHERE `original`.`id`=" . $mysql_content["id"]
    ))
    die_500("Query failed: " . $mysql->error);

  $elsewhere = array();
  while ($row = $mysql_result -> fetch_assoc())
    $elsewhere[] = $row;

?>
<!DOCTYPE html>

<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>Arch Linux 32 - <?php print $content["Name"] . " " . $content["Version"] . " (" . $content["Architecture"]; ?>)</title>
    <link rel="stylesheet" type="text/css" href="/static/archweb.css" media="screen, projection" />
    <link rel="icon" type="image/x-icon" href="/static/favicon.ico" />
    <link rel="shortcut icon" type="image/x-icon" href="/static/favicon.ico" />
    
</head>
<body class="">
    <div id="archnavbar" class="anb-packages">
        <div id="archnavbarlogo"><h1><a href="/" title="Return to the main page">Arch Linux</a></h1></div>
        <div id="archnavbarmenu">
            <ul id="archnavbarlist">
                <li id="anb-home"><a href="https://www.archlinux32.org/">Home</a></li>
                <li id="anb-news"><a href="https://news.archlinux32.org/">News</a></li>
                <li id="anb-packages"><a href="https://packages.archlinux32.org/">Packages</a></li>
                <li id="anb-forums"><a href="https://bbs.archlinux32.org/">Forums</a></li>
                <li id="anb-bugs"><a href="https://bugs.archlinux32.org/" title="Report and track bugs">Bugs</a></li>
                <li id="anb-mailing-list"><a href="https://lists.archlinux.org/listinfo/arch-ports">Mailing List</a></li>
                <li id="anb-download"><a href="https://www.archlinux32.org/download/" title="Get Arch Linux">Download</a></li>
                <li id="anb-arch-linux-official"><a href="https://www.archlinux.org/">Arch Linux Official</a></li>
            </ul>
        </div>
    </div>
    <div id="content">
        <div id="archdev-navbar">
            
        </div>
        
        

<div id="pkgdetails" class="box">
    <h2><?php print $content["Name"]." ".$content["Version"]; ?></h2>

    <div id="detailslinks" class="listing">
        <div id="actionlist">
        <h4>Package Actions</h4>
            <ul class="small">
                <li>
<?php
  if ($content["uses_upstream"]) {
    print "<a href=\"https://projects.archlinux.org/svntogit/";
    print $content["git_repo"];
    print ".git/tree/trunk?h=packages/";
    print $content["pkgbase"];
    print "\" title=\"View upstream's source files for ";
    print $content["pkgname"];
    print "\">Upstream's Source Files</a> / ";
    print "<a href=\"https://projects.archlinux.org/svntogit/";
    print $content["git_repo"];
    print ".git/log/trunk?h=packages/";
    print $content["pkgbase"];
    print "\" title=\"View upstream's changes for ";
    print $content["pkgname"];
    print "\">Upstream's Changes</a>";
    if ($content["uses_modification"])
      print "<br>\n";
  }
  if ($content["uses_modification"]) {
    print "<a href=\"https://github.com/archlinux32/packages/tree/master/";
    print $content["repo"];
    print "/";
    print $content["pkgbase"];
    print "\" title=\"View archlinux32's source files for ";
    print $content["pkgname"];
    print "\">Archlinux32's Source Files</a> / ";
    print "<a href=\"https://github.com/archlinux32/packages/commits/master/";
    print $content["repo"];
    print "/";
    print $content["pkgbase"];
    print "\" title=\"View upstream's changes for ";
    print $content["pkgname"];
    print "\">Archlinux32's Changes</a>";
  }
?>
                </li>
                <li>
<?php
  print "<a href=\"https://bugs.archlinux32.org/index.php?string=";
  print $content["Name"];
  print "\" title=\"View existing bug tickets for ";
  print $content["Name"];
  print "\">Bug Reports</a> / ";
  print "<a href=\"https://bugs.archlinux32.org/index.php?do=newtask&project=1&product_category=";
  if ($content["repo_stability_name"]=="stable")
    print "8"; // stable
  elseif ($content["repo_stability_name"]=="testing")
    print "6"; // testing
  elseif ($content["repo_stability_name"]=="unbuilt")
    print "7"; // build-list
  else
    print "1"; // packages
  print "&item_summary=%5B";
  print $content["Name"];
  print "%5D+PLEASE+ENTER+SUMMARY\" title=\"Report new bug for ";
  print $content["Name"];
  print "\">Add New Bug</a>";
?>
                </li>
                <li><a href="http://pool.mirror.archlinux32.org/i686/<?php print $content["repo"]."/".$content["pkgname"]."-".$content["Version"]."-".$content["arch"]; ?>.pkg.tar.xz" rel="nofollow" title="Download <?php print $content["Name"]; ?> from mirror">Download From Mirror</a></li>
            </ul>

            
        </div>

<?php

if (count($elsewhere)>0) {
  print "<div id=\"elsewhere\" class=\"widget\">\n";
  print "<h4>Versions Elsewhere</h4>\n";
  foreach ($elsewhere as $subst) {
    print "<ul>\n";
    print "<li><a href=\"/" . $subst["repo"] . "/" . $subst["arch"] . "/" . $subst["pkgname"] ."/\"";
    print " title=\"Package details for " . $subst["pkgname"] ."\">";
    print $subst["pkgname"] . "-" . $subst["version"] . " [" . $subst["repo"] . "] (" . $subst["arch"] . ")</a></li>\n";
    print "</ul>\n";
  }
  print "</div>\n";
}

?>
    </div>

    <div itemscope itemtype="http://schema.org/SoftwareApplication">
    <meta itemprop="name" content="<?php print $content["Name"]; ?>"/>
    <meta itemprop="version" content="<?php print $content["Version"]; ?>"/>
    <meta itemprop="softwareVersion" content="<?php print $content["Version"]; ?>"/>
    <meta itemprop="fileSize" content="<?php print $content["Download Size"]; ?>"/>
    <meta itemprop="dateCreated" content="<?php print $content["Build Date"]; ?>"/>
    <meta itemprop="datePublished" content="<?php print $content["Build Date"]; ?>"/>
    <meta itemprop="operatingSystem" content="Arch Linux 32"/>
    <table id="pkginfo">
        <tr>
            <th>Architecture:</th>
            <td><a href="/?arch=<?php print $content["Architecture"]; ?>"
                    title="Browse packages for <?php print $content["Architecture"]; ?> architecture"><?php print $content["Architecture"]; ?></a></td>
        </tr><tr>
            <th>Repository:</th>
            <td><a href="/?repo=<?php print $content["Repository"]; ?>"
                    title="Browse the <?php print $content["Repository"]; ?> repository"><?php print $content["Repository"]; ?></a></td>
        </tr>
        
        
        
        <tr>
            <th>Description:</th>
            <td class="wrap" itemprop="description"><?php print $content["Description"]; ?></td>
        </tr><tr>
            <th>Upstream URL:</th>
            <td><a itemprop="url" href="<?php print $content["URL"]; ?>"
                    title="Visit the website for <?php print $content["Name"]; ?>"><?php print $content["URL"]; ?></a></td>
        </tr><tr>
            <th>License(s):</th>
            <td class="wrap"><?php
  if (is_array($content["Licenses"]))
    print implode(", ",$content["Licenses"]);
  else
    print $content["Licenses"];
?></td>
        </tr>
        
        <tr>
            <th>Package Size:</th>
            <td><?php print $content["Download Size"]; ?></td>
        </tr><tr>
            <th>Installed Size:</th>
            <td><?php print $content["Installed Size"]; ?></td>
        </tr><tr>
            <th>Build Date:</th>
            <td><?php print $content["Build Date"]; ?></td>
        </tr>
        
    </table>
    </div>

    <div id="metadata">
        
        <div id="pkgdeps" class="listing">
            <h3 title="<?php print $content["Name"]; ?> has the following dependencies">
                Dependencies (<?php print count($dependencies); ?>)</h3>
            <ul id="pkgdepslist">
<?php
  foreach ($dependencies as $dep) {
    print "<li>\n";
    if (count($dep["deps"]) == 0) {
      print "<font color=\"#ff0000\">not satisfiable dependency: \"" . $dep["install_target"] . "\"</font>\n";
    } else {
      $virtual_dep = (
        (count($dep["deps"]) > 1) ||
        (array_values($dep["deps"])[0]["pkgname"] != $dep["install_target"])
      );
      if ($virtual_dep) {
        print $dep["install_target"];
        print " <span class=\"virtual-dep\">(";
      };
      $first = true;
      foreach ($dep["deps"] as $d_p) {
        if (!$first)
          print ",\n";
        $first = false;
        print "<a href=\"/".$d_p["repo"]."/".$d_p["arch"]."/".$d_p["pkgname"]."/\" ";
        print "title=\"View package details for ".$d_p["pkgname"]."\">".$d_p["pkgname"]."</a>";
      }
      if ($virtual_dep)
        print ")</span>";
      print "\n";
    };
    if ($dep["dependency_type"]!="run")
      print "<span class=\"" . $dep["dependency_type"] . "-dep\"> (" . $dep["dependency_type"] . ")</span>\n";
    print "</li>\n";
  }
?>
            </ul>
        </div>
        
        
        <div id="pkgreqs" class="listing">
            <h3 title="Packages that require <?php print $content["Name"]; ?>">
                Required By (<?php print count($dependent); ?>)</h3>
            <ul id="pkgreqslist">
<?php
  foreach ($dependent as $dep) {
    print "<li>\n";
    if ($dep["install_target"] != $content["Name"])
      print $dep["install_target"] . " (";
    print "<a href=\"/".$dep["repo"]."/".$dep["arch"]."/".$dep["pkgname"]."/\" ";
    print "title=\"View package details for ".$dep["pkgname"]."\">".$dep["pkgname"]."</a>";
    if ($dep["install_target"] != $content["Name"])
      print ")";
    print "\n";
    if ($dep["dependency_type"] != "run")
      print "<span class=\"" . $dep["dependency_type"] . "-dep\"> (" . $dep["dependency_type"] . ")</span>\n";
    print "</li>\n";
  }
?>
            </ul>
        </div>
        <div id="pkgfiles">
        </div>
    </div>
</div>


        <div id="footer">
            <p>Copyright © 2002-2018 <a href="mailto:jvinet@zeroflux.org"
                title="Contact Judd Vinet">Judd Vinet</a> and <a href="mailto:aaron@archlinux.org"
                title="Contact Aaron Griffin">Aaron Griffin</a>.</p>

            <p>The Arch Linux name and logo are recognized
            <a href="https://wiki.archlinux.org/index.php/DeveloperWiki:TrademarkPolicy"
                title="Arch Linux Trademark Policy">trademarks</a>. Some rights reserved.</p>

            <p>The registered trademark Linux® is used pursuant to a sublicense from LMI,
            the exclusive licensee of Linus Torvalds, owner of the mark on a world-wide basis.</p>
        </div>
    </div>
    <script type="application/ld+json">
    {
       "@context": "http://schema.org",
       "@type": "WebSite",
       "url": "/",
       "potentialAction": {
         "@type": "SearchAction",
         "target": "/?q={search_term}",
         "query-input": "required name=search_term"
       }
    }
    </script>
    
</body>
</html>