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 at .
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 == "library") {
$query .= " AND p.name='" . mysql_real_escape_string($substr) . "'";
}
if ($by == "desc") {
$query .= " AND p.description LIKE '%" . mysql_real_escape_string($substr) . "%'";
}
if ($by == "cat") {
$tables .= ", $portsdb_name.categories c";
$query .= " AND c.portfile=p.name AND c.category='" . 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) . "'";
}
if ($by == "maintainer") {
$tables .= ", $portsdb_name.maintainers m";
$query .= " AND m.portfile=p.name AND m.maintainer LIKE '%" . 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: