[28903] trunk/www/ports.php
source_changes at macosforge.org
source_changes at macosforge.org
Tue Sep 11 01:30:18 PDT 2007
Revision: 28903
http://trac.macosforge.org/projects/macports/changeset/28903
Author: jmpp at macports.org
Date: 2007-09-11 01:30:18 -0700 (Tue, 11 Sep 2007)
Log Message:
-----------
Whitespace changes only: convert to 4-space soft tabs, modeline will follow.
Modified Paths:
--------------
trunk/www/ports.php
Modified: trunk/www/ports.php
===================================================================
--- trunk/www/ports.php 2007-09-11 08:26:27 UTC (rev 28902)
+++ trunk/www/ports.php 2007-09-11 08:30:18 UTC (rev 28903)
@@ -1,219 +1,219 @@
<?php
- /* $Id$ */
+ /* $Id$ */
$MPWEB = $_SERVER['DOCUMENT_ROOT'] . dirname($_SERVER['SCRIPT_NAME']);
- include_once("$MPWEB/includes/common.inc");
- include_once("$MPWEB/includes/email.inc");
- print_header('MacPorts -- Available Ports', 'utf-8');
- $by = isset($_GET['by']) ? $_GET['by'] : '';
- $substr = isset($_GET['substr']) ? $_GET['substr'] : '';
+ include_once("$MPWEB/includes/common.inc");
+ include_once("$MPWEB/includes/email.inc");
+ print_header('MacPorts -- Available Ports', 'utf-8');
+ $by = isset($_GET['by']) ? $_GET['by'] : '';
+ $substr = isset($_GET['substr']) ? $_GET['substr'] : '';
?>
- <div id="content">
- <h2>MacPorts Portfiles</h2>
+<div id="content">
+ <h2>MacPorts Portfiles</h2>
- <p>
- This form allows you to search the current index of MacPorts software. <br />
- <i>Index last updated: </i>
- <?php
- $sql = "SELECT UNIX_TIMESTAMP(activity_time) FROM $portsdb.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]);
- }
- ?>
- </p>
+ <p>
+ This form allows you to search the current index of MacPorts software. <br />
+ <i>Index last updated: </i>
+<?php
+ $sql = "SELECT UNIX_TIMESTAMP(activity_time) FROM $portsdb.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]);
+ }
+?>
+ </p>
- <form action="<?php echo $_SERVER['PHP_SELF']; ?>">
- <table>
- <tr>
- <th>Search by:</th>
- <td>
- <select name="by">
- <option value="name"<?php if ($by == "name") { echo " selected=\"selected\""; } ?>>Software Title</option>
- <option value="desc"<?php if ($by == "desc") { echo " selected=\"selected\""; } ?>>Description</option>
- <option value="cat"<?php if ($by == "cat") { echo " selected=\"selected\""; } ?>>Category</option>
- <option value="maintainer"<?php if ($by == "maintainer") { echo " selected=\"selected\""; } ?>>Maintainer</option>
- </select>
- </td>
- <td><input type="text" name="substr" size="40" /></td>
- <td><input type="submit" value="Search" /></td>
- </tr>
- <tr><td colspan="4"><hr /></td></tr>
- <tr>
+ <form action="<?php echo $_SERVER['PHP_SELF']; ?>">
+ <table>
+ <tr>
+ <th>Search by:</th>
+ <td>
+ <select name="by">
+ <option value="name"<?php if ($by == "name") { echo " selected=\"selected\""; } ?>>Software Title</option>
+ <option value="desc"<?php if ($by == "desc") { echo " selected=\"selected\""; } ?>>Description</option>
+ <option value="cat"<?php if ($by == "cat") { echo " selected=\"selected\""; } ?>>Category</option>
+ <option value="maintainer"<?php if ($by == "maintainer") { echo " selected=\"selected\""; } ?>>Maintainer</option>
+ </select>
+ </td>
+ <td><input type="text" name="substr" size="40" /></td>
+ <td><input type="submit" value="Search" /></td>
+ </tr>
+ <tr><td colspan="4"><hr /></td></tr>
+ <tr>
<?php
- $result = mysql_query("SELECT count(*) from $portsdb.portfiles");
- if ($result) {
- $row = mysql_fetch_array($result);
- $count = $row[0];
- } else {
- $count = 0;
- }
+ $result = mysql_query("SELECT count(*) from $portsdb.portfiles");
+ if ($result) {
+ $row = mysql_fetch_array($result);
+ $count = $row[0];
+ } else {
+ $count = 0;
+ }
?>
- <td colspan="4" align="left"><a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=all">View All Software Titles (<?php echo $count; ?>)</a></td>
- </tr>
- <?php
- if (!$by || (!$substr && $by != "all")) {
- ?>
- <tr><td colspan="4"><hr /></td></tr>
- <tr><th colspan="4" align="left">View By Category:</th></tr>
- <?php
- $query = "SELECT DISTINCT category FROM $portsdb.categories ORDER BY category";
- $result = mysql_query($query);
- if($result) {
- while( $row = mysql_fetch_assoc($result) ) {
- ?>
- <tr><td colspan="4"><a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=cat&substr=<?php echo urlencode($row['category']); ?>"><?php echo htmlspecialchars($row['category']); ?></a></td></tr>
- <?php
- }
- }
- }
- ?>
- </table>
- </form>
- </div>
+ <td colspan="4" align="left"><a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=all">View All Software Titles (<?php echo $count; ?>)</a></td>
+ </tr>
+<?php
+ if (!$by || (!$substr && $by != "all")) {
+?>
+ <tr><td colspan="4"><hr /></td></tr>
+ <tr><th colspan="4" align="left">View By Category:</th></tr>
+<?php
+ $query = "SELECT DISTINCT category FROM $portsdb.categories ORDER BY category";
+ $result = mysql_query($query);
+ if ($result) {
+ while ( $row = mysql_fetch_assoc($result) ) {
+?>
+ <tr><td colspan="4"><a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=cat&substr=<?php echo urlencode($row['category']); ?>"><?php echo htmlspecialchars($row['category']); ?></a></td></tr>
+<?php
+ }
+ }
+ }
+?>
+ </table>
+ </form>
+</div>
<?php
- if ($by && ($substr || $by == "all")) {
- $fields = "name, path, version, description";
- $query = "1";
- $tables = "$portsdb.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.categories c";
- $query .= " AND c.portfile=p.name AND c.category='" . mysql_real_escape_string($substr) . "'";
- }
- if ($by == "variant") {
- $tables .= ", $portsdb.variants v";
- $query .= " AND v.portfile=p.name AND v.variant='" . mysql_real_escape_string($substr) . "'";
- }
- if ($by == "platform") {
- $tables .= ", $portsdb.platforms pl";
- $query .= " AND pl.portfile=p.name AND pl.platform ='" . mysql_real_escape_string($substr) . "'";
- }
- if ($by == "maintainer") {
- $tables .= ", $portsdb.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) {
+ if ($by && ($substr || $by == "all")) {
+ $fields = "name, path, version, description";
+ $query = "1";
+ $tables = "$portsdb.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.categories c";
+ $query .= " AND c.portfile=p.name AND c.category='" . mysql_real_escape_string($substr) . "'";
+ }
+ if ($by == "variant") {
+ $tables .= ", $portsdb.variants v";
+ $query .= " AND v.portfile=p.name AND v.variant='" . mysql_real_escape_string($substr) . "'";
+ }
+ if ($by == "platform") {
+ $tables .= ", $portsdb.platforms pl";
+ $query .= " AND pl.portfile=p.name AND pl.platform ='" . mysql_real_escape_string($substr) . "'";
+ }
+ if ($by == "maintainer") {
+ $tables .= ", $portsdb.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) {
?>
- <p>
- <i><?php echo mysql_num_rows($result) . ' ' . (mysql_num_rows($result) == 1 ? 'Portfile' : 'Portfiles') . ' Selected'; ?></i>
- </p>
- <dl>
+ <p>
+ <i><?php echo mysql_num_rows($result) . ' ' . (mysql_num_rows($result) == 1 ? 'Portfile' : 'Portfiles') . ' Selected'; ?></i>
+ </p>
+ <dl>
<?php
- while( $row = mysql_fetch_assoc($result) ) {
+ while ( $row = mysql_fetch_assoc($result) ) {
?>
- <dt><b><a href="http://trac.macports.org/projects/macports/browser/trunk/dports/<?php echo $row['path']; ?>/Portfile"><?php echo htmlspecialchars($row['name']); ?></a></b> <?php echo htmlspecialchars($row['version']); ?></dt>
- <dd>
- <?php echo htmlspecialchars($row['description']); ?><br />
- <?php
+ <dt><b><a href="http://trac.macports.org/projects/macports/browser/trunk/dports/<?php echo $row['path']; ?>/Portfile"><?php echo htmlspecialchars($row['name']); ?></a></b> <?php echo htmlspecialchars($row['version']); ?></dt>
+ <dd>
+ <?php echo htmlspecialchars($row['description']); ?><br />
+<?php
// MAINTAINERS
- $nquery = "SELECT maintainer FROM $portsdb.maintainers WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY is_primary DESC, maintainer";
- $nresult = mysql_query($nquery);
- if ($nresult) {
+ $nquery = "SELECT maintainer FROM $portsdb.maintainers WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY is_primary DESC, maintainer";
+ $nresult = mysql_query($nquery);
+ if ($nresult) {
?>
- <i>Maintained by:</i>
+ <i>Maintained by:</i>
<?php
- $primary = 1;
- while ( $nrow = mysql_fetch_array($nresult) ) {
- if ($primary) { echo "<b>"; }
- $addr = obfuscate_email($nrow[0]);
- print $addr;
- if ($primary) { echo "</b>"; }
- $primary = 0;
- }
- }
+ $primary = 1;
+ while ( $nrow = mysql_fetch_array($nresult) ) {
+ if ($primary) { echo "<b>"; }
+ $addr = obfuscate_email($nrow[0]);
+ print $addr;
+ if ($primary) { echo "</b>"; }
+ $primary = 0;
+ }
+ }
// CATEGORIES
- $nquery = "SELECT category FROM $portsdb.categories WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY is_primary DESC, category";
- $nresult = mysql_query($nquery);
- if ($nresult) {
+ $nquery = "SELECT category FROM $portsdb.categories WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY is_primary DESC, category";
+ $nresult = mysql_query($nquery);
+ if ($nresult) {
?>
- <br />
- <i>Categories:</i>
+ <br />
+ <i>Categories:</i>
<?php
- $primary = 1;
- while ( $nrow = mysql_fetch_assoc($nresult) ) {
- if ($primary) { echo "<b>"; }
- ?>
- <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=cat&substr=<?php echo urlencode($nrow['category']); ?>"><?php echo htmlspecialchars($nrow['category']); ?></a>
- <?php
- if ($primary) { echo "</b>"; }
- $primary = 0;
- }
- }
+ $primary = 1;
+ while ( $nrow = mysql_fetch_assoc($nresult) ) {
+ if ($primary) { echo "<b>"; }
+?>
+ <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=cat&substr=<?php echo urlencode($nrow['category']); ?>"><?php echo htmlspecialchars($nrow['category']); ?></a>
+<?php
+ if ($primary) { echo "</b>"; }
+ $primary = 0;
+ }
+ }
// PLATFORMS
- $nquery = "SELECT platform FROM $portsdb.platforms WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY platform";
- $nresult = mysql_query($nquery);
- if ($nresult && mysql_num_rows($nresult) > 0) {
+ $nquery = "SELECT platform FROM $portsdb.platforms WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY platform";
+ $nresult = mysql_query($nquery);
+ if ($nresult && mysql_num_rows($nresult) > 0) {
?>
- <br />
- <i>Platforms:</i>
+ <br />
+ <i>Platforms:</i>
<?php
- while ( $nrow = mysql_fetch_array($nresult) ) {
- $platform = $nrow[0];
- ?>
- <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=platform&substr=<?php echo urlencode($platform); ?>"><?php echo htmlspecialchars($platform); ?></a>
- <?php
- }
- }
+ while ( $nrow = mysql_fetch_array($nresult) ) {
+ $platform = $nrow[0];
+?>
+ <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=platform&substr=<?php echo urlencode($platform); ?>"><?php echo htmlspecialchars($platform); ?></a>
+<?php
+ }
+ }
// DEPENDENCIES
- $nquery = "SELECT library FROM $portsdb.dependencies WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY library";
- $nresult = mysql_query($nquery);
- if ($nresult && mysql_num_rows($nresult) > 0) {
+ $nquery = "SELECT library FROM $portsdb.dependencies WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY library";
+ $nresult = mysql_query($nquery);
+ if ($nresult && mysql_num_rows($nresult) > 0) {
?>
- <br />
- <i>Dependencies:</i>
+ <br />
+ <i>Dependencies:</i>
<?php
- while ( $nrow = mysql_fetch_array($nresult) ) {
- // lib:libpng.3:libpng -> libpng
- $library = eregi_replace("^([^:]*:[^:]*:|[^:]*:)", "", $nrow[0]);
- ?>
- <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=library&substr=<?php echo urlencode($library); ?>"><?php echo htmlspecialchars($library); ?></a>
- <?php
- }
- }
+ while ( $nrow = mysql_fetch_array($nresult) ) {
+ // lib:libpng.3:libpng -> libpng
+ $library = eregi_replace("^([^:]*:[^:]*:|[^:]*:)", "", $nrow[0]);
+?>
+ <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=library&substr=<?php echo urlencode($library); ?>"><?php echo htmlspecialchars($library); ?></a>
+<?php
+ }
+ }
/*
// VARIANTS
- $nquery = "SELECT variant FROM $portsdb.variants WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY variant";
- $nresult = mysql_query($nquery);
- if ($nresult && mysql_num_rows($nresult) > 0) {
+ $nquery = "SELECT variant FROM $portsdb.variants WHERE portfile='" . mysql_real_escape_string($row['name']) . "' ORDER BY variant";
+ $nresult = mysql_query($nquery);
+ if ($nresult && mysql_num_rows($nresult) > 0) {
?>
- <br />
- <i>Variants:</i>
+ <br />
+ <i>Variants:</i>
<?php
- while ( $nrow = mysql_fetch_array($nresult) ) {
- $variant = $nrow[0];
- ?>
- <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=variant&substr=<?php echo urlencode($variant); ?>"><?php echo htmlspecialchars($variant); ?></a>
- <?php
- }
- }
+ while ( $nrow = mysql_fetch_array($nresult) ) {
+ $variant = $nrow[0];
+?>
+ <a href="<?php echo $_SERVER['PHP_SELF']; ?>?by=variant&substr=<?php echo urlencode($variant); ?>"><?php echo htmlspecialchars($variant); ?></a>
+<?php
+ }
+ }
*/
- ?>
- <br />
- </dd>
+?>
+ <br />
+ </dd>
<?php
- }
- } else {
- echo "An Error Occurred. (501)";
- }
+ }
+ } else {
+ echo "An Error Occurred. (501)";
+ }
?>
</dl>
- </div>
+</div>
<?php
- }
- print_footer();
+ }
+ print_footer();
?>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macosforge.org/pipermail/macports-changes/attachments/20070911/d2145591/attachment.html
More information about the macports-changes
mailing list