path: root/packages/pkginfo.php

<?php

  include "lib/mysql.php";
  include "lib/style.php";

  $json_content = json_decode(
    file_get_contents(
      "https://pkgapi.arch32.tyzoid.com/package/" .
        urlencode ($_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_result = mysql_run_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`," .
    "`binary_packages`.`last_moved`" .
    " 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"]) . "\")"
  );

  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

  $mysql_result = mysql_run_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\"," .
      "\"  \\\"is_to_be_deleted\\\": \\\"\",IF(`binary_packages`.`is_to_be_deleted`,\"1\",\"0\"),\"\\\"\\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`"
  );

  $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"]);
  if ($js_dep == "None")
    $js_dep = array();
  if (!isset($dep_it))
    $dep_it = array();
  $dep_errors = implode(
    ", ",
    array_diff(
      array_merge($dep_it,$js_dep),
      $dep_it
    )
  );

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

  foreach ($dependencies as $key => $dep) {
    if ($dep["dependency_type"]!="run") {
      $dependencies[$key]["json"]="not required";
      continue;
    }
    foreach ($js_dep as $js)
      if ($js == preg_replace("/[<=>].*$/","",$dep["install_target"]))
        $dependencies[$key]["json"]=$js;
  }

  // query dependent packages

  $mysql_result = mysql_run_query(
    "SELECT DISTINCT " .
    "`dependency_types`.`name` AS `dependency_type`," .
    "`install_targets`.`name` AS `install_target`," .
    "`repositories`.`name` AS `repo`," .
    "`repositories`.`is_on_master_mirror`," .
    "`architectures`.`name` AS `arch`," .
    "`binary_packages`.`pkgname`," .
    "IF(`binary_packages`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`" .
    " 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`," .
      " `repositories`.`stability`," .
      " `repositories`.`name`"
  );

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

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

  // query substitutes

  $mysql_result = mysql_run_query(
    "SELECT " .
    "`binary_packages`.`pkgname` AS `pkgname`," .
    "IF(`binary_packages`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`," .
    "`repositories`.`name` AS `repo`," .
    "`repositories`.`is_on_master_mirror`," .
    "`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"]
  );

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

  print_header($content["Name"] . " " . $content["Version"] . " (" . $content["Architecture"] . ")");

?>
      <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">
<?php
  if ($content["uses_upstream"]) {
    print "              <li>\n";
    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> /\n";
    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>\n";
    print "              </li>\n";
  }
  if ($content["uses_modification"]) {
    print "              <li>\n";
    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> /\n";
    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>\n";
    print "              </li>\n";
  }
?>
              <li>
<?php
  print "                <a href=\"https://www.archlinux.org/packages/?sort=&q=";
  print $content["Name"];
  print "&maintainer=&flagged=\">";
  print "Search for ".$content["Name"]." upstream";
  print "</a>\n";
?>
              </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> / \n";
  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>\n";
?>
              </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>\n";
    if ($subst["is_on_master_mirror"]) {
      print "                <a href=\"/" . $subst["repo"] . "/" . $subst["arch"] . "/" . $subst["pkgname"] ."/\"";
      print " title=\"Package details for " . $subst["pkgname"] ."\">";
    }
    if ($subst["is_to_be_deleted"])
      print "<s>";
    print $subst["pkgname"] . "-" . $subst["version"] . " [" . $subst["repo"] . "] (" . $subst["arch"] . ")";
    if ($subst["is_to_be_deleted"])
      print "</s>";
    if ($subst["is_on_master_mirror"])
      print "</a>\n";
    print "              </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["last_moved"]; ?>"/>
          <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"]."\n"; ?>
              </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"];
  print "\n";
?>
              </td>
            </tr>
            <tr>
              <th>
                Package Size:
              </th>
              <td>
                <?php print $content["Download Size"]."\n"; ?>
              </td>
            </tr>
            <tr>
              <th>
                Installed Size:
              </th>
              <td>
                <?php print $content["Installed Size"]."\n"; ?>
              </td>
            </tr>
            <tr>
              <th>
                Build Date:
              </th>
              <td>
                <?php print $content["Build Date"]."\n"; ?>
              </td>
            </tr>
            <tr>
              <th>
                Last Updated:
              </th>
              <td>
                <?php print $content["last_moved"]."\n"; ?>
              </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 (!isset ($dep["json"]))
      print "                (in database only)\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"])
      );
      print "                ";
      if ($virtual_dep) {
        print $dep["install_target"];
        print " <span class=\"virtual-dep\">(";
      };
      $first = true;
      foreach ($dep["deps"] as $d_p) {
        if (!$first)
          print ", ";
        $first = false;
        print "<a href=\"/".$d_p["repo"]."/".$d_p["arch"]."/".$d_p["pkgname"]."/\" ";
        print "title=\"View package details for ".$d_p["pkgname"]."\">";
        if ($d_p["is_to_be_deleted"])
          print "<s>";
        print $d_p["pkgname"];
        if ($d_p["is_to_be_deleted"])
          print "</s>";
        print "</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";
    print "                ";
    if ($dep["install_target"] != $content["Name"])
      print $dep["install_target"] . " (";
    if ($dep["is_on_master_mirror"]=="1") {
      print "<a href=\"/".$dep["repo"]."/".$dep["arch"]."/".$dep["pkgname"]."/\" ";
      print "title=\"View package details for ".$dep["pkgname"]."\">";
    }
    if ($dep["is_to_be_deleted"])
      print "<s>";
    print $dep["pkgname"];
    if ($dep["is_to_be_deleted"])
      print "</s>";
    if ($dep["repo"] != $content["repo"])
      print " [" . $dep["repo"] . "]";
    if ($dep["is_on_master_mirror"]=="1")
      print "</a>";
    if ($dep["install_target"] != $content["Name"])
      print ")\n";
    if ($dep["dependency_type"] != "run")
      print "                <span class=\"" . $dep["dependency_type"] . "-dep\">(" . $dep["dependency_type"] . ")</span>";
    print "\n";
    print "              </li>\n";
  }
?>
            </ul>
          </div>
          <div id="pkgfiles">
          </div>
        </div>
      </div>
<?php

  print_footer();