MacPorts Portfiles
The MacPorts Project currently distributes ports, organized across
different categories and available below for viewing. This form allows
you to search the MacPorts software index, last updated on ' . $date . ' at ' . $time . ''; ?>.
Or view the complete ports list (
ports).
Port Categories\n\n
";
$max_entries_per_column = floor($portsdb_info['num_categories']/4);
$columns = 0;
while ($columns < 4) {
print "- \n
\n";
$entries_per_colum = 0;
while ($row = mysql_fetch_assoc($result)) {
print '- '
. htmlspecialchars($row['category']) . '
';
if ($entries_per_colum == $max_entries_per_column) break;
$entries_per_colum++;
}
print "
\n ";
$columns++;
}
print "
\n\n
";
}
}
if ($by && ($substr || $by == "all")) {
$fields = "name, path, version, description";
$query = "1";
$tables = "$portsdb_name.portfiles p";
if ($by == "name") {
$query .= " AND p.name LIKE '%" . mysql_real_escape_string($substr) . "%'";
}
if ($by == "category") {
$tables .= ", $portsdb_name.categories c";
$query .= " AND c.portfile=p.name AND c.category='" . mysql_real_escape_string($substr) . "'";
}
if ($by == "maintainer") {
$tables .= ", $portsdb_name.maintainers m";
$query .= " AND m.portfile=p.name AND m.maintainer LIKE '%" . mysql_real_escape_string($substr) . "%'";
}
if ($by == "dependency") {
$query .= " AND p.name='" . mysql_real_escape_string($substr) . "'";
}
if ($by == "variant") {
$tables .= ", $portsdb_name.variants v";
$query .= " AND v.portfile=p.name AND v.variant='" . mysql_real_escape_string($substr) . "'";
}
if ($by == "platform") {
$tables .= ", $portsdb_name.platforms pl";
$query .= " AND pl.portfile=p.name AND pl.platform ='" . mysql_real_escape_string($substr) . "'";
}
$query = "SELECT DISTINCT $fields FROM $tables WHERE $query ORDER BY name";
$result = mysql_query($query);
if ($result) {
?>
Query Results
-
-
Maintained by:
"; }
else { print " "; }
$addr = obfuscate_email($nrow[0]);
print $addr;
if ($primary) { print ""; }
$primary = 0;
}
}
/* CATEGORIES */
$nquery = "SELECT category FROM $portsdb_name.categories WHERE portfile='" . mysql_real_escape_string($row['name']) .
"' ORDER BY is_primary DESC, category";
$nresult = mysql_query($nquery);
if ($nresult) {
?>
Categories:
"; }
?>
"; }
$primary = 0;
}
}
/* PLATFORMS */
$nquery = "SELECT platform FROM $portsdb_name.platforms WHERE portfile='" . mysql_real_escape_string($row['name']) .
"' ORDER BY platform";
$nresult = mysql_query($nquery);
if ($nresult && mysql_num_rows($nresult) > 0) {
?>
Platforms:
0) {
?>
Dependencies:
libpng
// might need adapting to the new port: depspec
$library = eregi_replace("^([^:]*:[^:]*:|[^:]*:)", "", $nrow[0]);
?>
0) {
?>
Variants: