Alexander Nicolaysen Sørnes : Fix code for getting random apps with screenshots on front page
Chris Morgan
cmorgan at winehq.org
Mon May 12 22:50:28 CDT 2008
Module: appdb
Branch: master
Commit: ef64981a1bb6a9e7e402cd590ec04d46c58713b0
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=ef64981a1bb6a9e7e402cd590ec04d46c58713b0
Author: Alexander Nicolaysen Sørnes <alex at thehandofagony.com>
Date: Mon May 12 21:45:42 2008 +0200
Fix code for getting random apps with screenshots on front page
---
include/util.php | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/include/util.php b/include/util.php
index 719e0f9..e878ae6 100644
--- a/include/util.php
+++ b/include/util.php
@@ -325,8 +325,9 @@ function outputTopXRowAppsFromRating($sRating, $iNumApps)
FROM appVersion, appData
WHERE appVersion.rating = '$sRating'
AND appVersion.versionId = appData.versionId
+ AND appVersion.state = 'accepted'
AND appData.type = 'screenshot'
- AND appData.queued = 'false'";
+ AND appData.state = 'accepted'";
/* make sure we exclude any apps we've already output */
foreach($aVersionId as $key=>$value)
More information about the wine-cvs
mailing list