appdb/. browse_downloadable.php

[WineHQ]

ChangeSet ID:	30913
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	wineowner(a)winehq.org	2007/01/27 17:44:00

Modified files:
	.              : browse_downloadable.php 

Log message:
	Alexander Nicolaysen Sørnes <alex(a)thehandofagony.com>
	Hide queued version in the downloadable apps list

Patch: http://cvs.winehq.org/patch.py?id=30913

Old revision  New revision  Changes     Path
 1.2           1.3           +3 -2       appdb/browse_downloadable.php

Index: appdb/browse_downloadable.php
diff -u -p appdb/browse_downloadable.php:1.2 appdb/browse_downloadable.php:1.3
--- appdb/browse_downloadable.php:1.2	27 Jan 2007 23:44: 0 -0000
+++ appdb/browse_downloadable.php	27 Jan 2007 23:44: 0 -0000
@@ -24,7 +24,7 @@ $sQuery = "SELECT DISTINCT appFamily.app
     appVersion.versionName, appVersion.versionId, appFamily.description
         FROM appFamily, appVersion, appData
             WHERE appData.type = '?' AND appData.versionId = appVersion.versionId
-            AND appFamily.appId = appVersion.appId";
+            AND appFamily.appId = appVersion.appId AND appVersion.queued = 'false'";
 
 if(!$sLicense)
     $hResult = query_parameters($sQuery, "downloadurl");
@@ -86,7 +86,8 @@ $sQuery = "SELECT DISTINCT appFamily.app
         appVersion.versionName, appVersion.versionId, appFamily.description
             FROM appFamily, appVersion, appData
                 WHERE appData.type = '?' AND appData.versionId = appVersion.versionId
-                AND appFamily.appId = appVersion.appId ";
+                AND appFamily.appId = appVersion.appId 
+                AND appVersion.queued = 'false' ";
 
 if(!$sLicense)
 {