require_once("$DOCUMENT_ROOT/en/includes/od_lib.inc.php");
require_once("$DOCUMENT_ROOT/includes/od_db.inc.php");
od_print_header("DarwinPorts Portfiles", "en", "iso-8859-1", "", 0);
?>
DarwinPorts Portfiles
This form allows you to search the current index of DarwinPorts software.
Index last updated:
$sql = "SELECT UNIX_TIMESTAMP(activity_time) FROM darwinports.log ORDER BY UNIX_TIMESTAMP(activity_time) DESC";
$result = mysql_query($sql);
if($result && $row = mysql_fetch_row($result)) {
echo date("d-M-Y H:i:s", $row[0]);
}
?>
if ($by && ($substr || $by == "all")) {
$fields = "name, path, version, description";
$query = "1";
$tables = "darwinports.portfiles p";
if ($by == "name") {
$query = $query . " AND p.name LIKE '%" . addslashes($substr) . "%'";
}
if ($by == "desc") {
$query = $query . " AND p.description LIKE '%" . addslashes($substr) . "%'";
}
if ($by == "cat") {
$tables = $tables . ", darwinports.categories c";
$query = $query . " AND c.portfile=p.name AND c.category='" . addslashes($substr) . "'";
}
if ($by == "variant") {
$tables = $tables . ", darwinports.variants v";
$query = $query . " AND v.portfile=p.name AND v.variant='" . addslashes($substr) . "'";
}
if ($by == "platform") {
$tables = $tables . ", darwinports.platforms pl";
$query = $query . " AND pl.portfile=p.name AND pl.platform ='" . addslashes($substr) . "'";
}
if ($by == "maintainer") {
$tables = $tables . ", darwinports.maintainers m";
$query = $query . " AND m.portfile=p.name AND m.maintainer LIKE '%" . addslashes($substr) . "%'";
}
$query = "SELECT DISTINCT $fields FROM $tables WHERE $query ORDER BY name";
$result = mysql_query($query);
if($result) {
?>
= mysql_num_rows($result); ?> Portfile if (mysql_num_rows($result) != 1) { echo "s"; } ?> Selected
while( $row = mysql_fetch_assoc($result) ) {
?>
- = $row['name']; ?> = $row['version']; ?>
-
= $row['description']; ?>
// MAINTAINERS
$nquery = "SELECT maintainer FROM darwinports.maintainers WHERE portfile='" . $row['name'] . "' ORDER BY is_primary DESC, maintainer";
$nresult = mysql_query($nquery);
if ($nresult) {
?>
Maintained by:
$primary = 1;
while ( $nrow = mysql_fetch_array($nresult) ) {
if ($primary) { echo ""; }
?>
= $nrow[0]; ?>
if ($primary) { echo ""; }
$primary = 0;
}
}
// CATEGORIES
$nquery = "SELECT category FROM darwinports.categories WHERE portfile='" . $row['name'] . "' ORDER BY is_primary DESC, category";
$nresult = mysql_query($nquery);
if ($nresult) {
?>
Categories:
$primary = 1;
while ( $nrow = mysql_fetch_assoc($nresult) ) {
if ($primary) { echo ""; }
?>
= $nrow['category']; ?>
if ($primary) { echo ""; }
$primary = 0;
}
}
// PLATFORMS
$nquery = "SELECT platform FROM darwinports.platforms WHERE portfile='" . $row['name'] . "' ORDER BY platform";
$nresult = mysql_query($nquery);
if ($nresult && mysql_num_rows($nresult) > 0) {
?>
Platforms:
while ( $nrow = mysql_fetch_array($nresult) ) {
$platform = $nrow[0];
?>
= $platform; ?>
}
}
// DEPENDENCIES
$nquery = "SELECT library FROM darwinports.dependencies WHERE portfile='" . $row['name'] . "' ORDER BY library";
$nresult = mysql_query($nquery);
if ($nresult && mysql_num_rows($nresult) > 0) {
?>
Dependencies:
while ( $nrow = mysql_fetch_array($nresult) ) {
// lib:libpng.3:libpng -> libpng
$library = eregi_replace("^[^:]*:[^:]*:", "", $nrow[0]);
?>
= $library; ?>
}
}
/*
// VARIANTS
$nquery = "SELECT variant FROM darwinports.variants WHERE portfile='" . $row['name'] . "' ORDER BY variant";
$nresult = mysql_query($nquery);
if ($nresult && mysql_num_rows($nresult) > 0) {
?>
Variants:
while ( $nrow = mysql_fetch_array($nresult) ) {
$variant = $nrow[0];
?>
= $variant; ?>
}
}
*/
?>
}
} else {
echo "An Error Occurred. (501)";
}
}
?>
od_print_footer("en");
?>