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")) {
$query = "SELECT DISTINCT name,path,version,description,maintainer FROM darwinports.portfiles p, darwinports.maintainers m, darwinports.categories c WHERE p.name=m.portfile AND p.name=c.portfile AND m.is_primary=1";
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") {
$query = $query . " AND c.category='" . addslashes($substr) . "'";
}
$query = $query . " ORDER BY name";
$result = mysql_query($query);
if($result) {
while( $row = mysql_fetch_assoc($result) ) {
?>
- = $row['name']; ?> = $row['version']; ?>
-
= $row['description']; ?>
Maintained by: = $row['maintainer']; ?>
Categories:
$nquery = "SELECT category FROM darwinports.categories WHERE portfile='" . $row['name'] . "' ORDER BY is_primary DESC, category";
$nresult = mysql_query($nquery);
if ($nresult) {
$primary = 1;
while ( $nrow = mysql_fetch_assoc($nresult) ) {
if ($primary) { echo ""; }
?>
= $nrow['category']; ?>
if ($primary) { echo ""; }
$primary = 0;
}
}
?>
}
} else {
echo "An Error Occurred. (501)";
}
}
?>
od_print_footer("en");
?>