Alexander Nicolaysen Sørnes : Remove ' browse downloadable apps'
Chris Morgan
cmorgan at winehq.org
Sun Jun 15 10:45:23 CDT 2008
Module: appdb
Branch: master
Commit: a8bdb129e7d554173f7878563cb728ba83ab8e8b
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=a8bdb129e7d554173f7878563cb728ba83ab8e8b
Author: Alexander Nicolaysen Sørnes <alex at thehandofagony.com>
Date: Sun Jun 15 01:04:01 2008 +0200
Remove 'browse downloadable apps'
---
browse_downloadable.php | 163 -----------------------------------------------
include/sidebar.php | 1 -
2 files changed, 0 insertions(+), 164 deletions(-)
diff --git a/browse_downloadable.php b/browse_downloadable.php
deleted file mode 100644
index 199bdeb..0000000
--- a/browse_downloadable.php
+++ /dev/null
@@ -1,163 +0,0 @@
-<?php
-
-/**
-* Browse downloadable applications
-*/
-
-require("path.php");
-require(BASE."include/incl.php");
-
-apidb_header("Browse Downloadable Applications");
-
-echo "<div class='default_container'>\n";
-
-/* Match specific license? */
-$sLicenseString = isset($aClean['sLicense']) ? $aClean['sLicense'] : '';
-$sLicense = version::checkLicense( $sLicenseString );
-
-/* Set default values */
-if(!isset($aClean['iNumVersions']) || $aClean['iNumVersions'] > 200 || $aClean['iNumVersions'] < 0)
- $aClean['iNumVersions'] = 25;
-
-if( !isset($aClean['iPage']) )
- $aClean['iPage'] = 1;
-
-/* Count the possible matches */
-$sQuery = "SELECT DISTINCT appFamily.appName,
- appVersion.versionName, appVersion.versionId, appFamily.description
- FROM appFamily, appVersion, appData
- WHERE appData.type = '?' AND appData.versionId = appVersion.versionId
- AND appFamily.appId = appVersion.appId AND appVersion.state = 'accepted'";
-
-if(!$sLicense)
- $hResult = query_parameters($sQuery, "downloadurl");
-else
-{
- $sQuery .= " AND license = '?'";
- $hResult = query_parameters($sQuery, "downloadurl", $sLicense);
-}
-
-if($hResult && query_num_rows($hResult))
- $num = query_num_rows($hResult);
-
-$iNumPages = isset($num) ? ceil($num/$aClean['iNumVersions']) : 0;
-
-/* Check page logic */
-$aClean['iPage'] = min($aClean['iPage'], $iNumPages);
-
-/* Calculate values for the LIMIT clause */
-$iLimitLower = ($aClean['iPage'] - 1) * $aClean['iNumVersions'];
-
-/* Page selection */
-echo "<div align=\"center\">\n";
-echo "<b>Page ".$aClean['iPage']." of $iNumPages</b><br>\n";
-// $iPageRange is non-existent here? creating it
-$iPageRange = 10;
-display_page_range($aClean['iPage'], $iPageRange, $iNumPages,
- $_SERVER['PHP_SELF']."?iNumVersions=".$aClean['iNumVersions']."&sLicense=".
- $sLicenseString);
-
-/* Selector for how many versions to display */
-echo "<form method=\"get\" action=\"".$_SERVER['PHP_SELF']."\">\n";
-echo "<b>How many versions to display:</b>\n";
-echo "<select name=\"iNumVersions\">\n";
-
-$numVersionsArray = array(1, 25, 50, 100, 200);
-
-foreach($numVersionsArray as $i)
-{
- if($i == $aClean['iNumVersions'])
- echo "<option selected=\"selected\">$i</option>\n";
- else
- echo "<option>$i</option>\n";
-}
-
-echo "</select>\n";
-
-echo "<b>Filter by license</b>\n";
-$oVersion = new Version();
-echo $oVersion->makeLicenseList($sLicense);
-
-echo " <input type=\"submit\" value=\"Refresh\">\n";
-echo "</form></div>\n<br>\n";
-
-if(!isset($num))
-{
- echo "<div align=\"center\"><font color=\"red\">No matches found</font></div>\n";
- echo html_frame_end(" ");
- exit;
-}
-
-$sQuery = "SELECT DISTINCT appFamily.appName,
- appVersion.versionName, appVersion.versionId, appFamily.description
- FROM appFamily, appVersion, appData
- WHERE appData.type = '?' AND appData.versionId = appVersion.versionId
- AND appFamily.appId = appVersion.appId
- AND appVersion.state = 'accepted' ";
-
-if(!$sLicense)
-{
- $sQuery .= "ORDER BY appFamily.appName LIMIT ?, ?";
- $hResult = query_parameters($sQuery, "downloadurl", $iLimitLower,
- $aClean['iNumVersions']);
-} else
-{
- $sQuery .= "AND license = '?' ORDER BY appFamily.appName LIMIT ?, ?";
- $hResult = query_parameters($sQuery,
- "downloadurl", $sLicense, $iLimitLower,
- $aClean['iNumVersions']);
-}
-
-if($hResult && query_num_rows($hResult))
-{
- echo html_frame_start("", "90%");
-
- $oTable = new Table();
- $oTable->SetWidth("100%");
- $oTable->SetAlign("center");
-
- $oTableRow = new TableRow();
- $oTableCell = new TableCell("Name");
- $oTableCell->SetBold(true);
- $oTableRow->AddCell($oTableCell);
- $oTableCell = new TableCell("Description");
- $oTableCell->SetBold(true);
- $oTableRow->AddCell($oTableCell);
-
- $oTableRow->SetClass("color4");
- $oTable->AddRow($oTableRow);
-
- for($iIndex = 1; $oRow = query_fetch_object($hResult); $iIndex++)
- {
- $oVersion = new version($oRow->versionId);
-
- $oTableRow = new TableRow();
- if($iIndex % 2)
- $sColor = "color1";
- else
- $sColor = "color0";
-
- $oTableRow->SetClass($sColor);
-
- $oTableRowHighlight = GetStandardRowHighlight($iIndex);
-
- $oTableRowClick = new TableRowClick($oVersion->objectMakeUrl());
- $oTableRowClick->SetHighlight($oTableRowHighlight);
-
- $oTableRow->SetRowClick($oTableRowClick);
-
- $oTableRow->AddCell(new TableCell(version::fullNameLink($oVersion->iVersionId)));
- $oTableRow->AddCell(new TableCell($oRow->description));
- $oTable->AddRow($oTableRow);
- }
-
- echo $oTable->GetString();
-
- echo html_frame_end(" ");
-}
-
-echo "</div>\n";
-
-apidb_footer();
-
-?>
diff --git a/include/sidebar.php b/include/sidebar.php
index 69c4517..da0ab3a 100644
--- a/include/sidebar.php
+++ b/include/sidebar.php
@@ -23,7 +23,6 @@ function global_sidebar_menu()
$g->add("Screenshots", BASE."objectManager.php?sClass=screenshot&sTitle=View+Screenshots");
$g->add("Browse Apps", BASE."objectManager.php?sClass=application&".
'sTitle=Browse%20Applications&sOrderBy=appId&bAscending=false');
- $g->add("Downloadable Apps", BASE."browse_downloadable.php");
$g->add("Top 25", BASE."votestats.php");
$g->add("Submit Application", BASE."objectManager.php?sClass=application_queue&".
"sTitle=Submit+Application&sAction=add");
More information about the wine-cvs
mailing list