Module: appdb
Branch: master
Commit: 80fd412592f1be0e1658313cd2c19bfce76110d4
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=80fd412592f1be0e1658313c…
Author: Alexander Nicolaysen Sørnes <alex(a)thehandofagony.com>
Date: Mon May 12 21:44:07 2008 +0200
Only show accepted versions on the front page
---
include/util.php | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/include/util.php b/include/util.php
index 5f4ce4d..719e0f9 100644
--- a/include/util.php
+++ b/include/util.php
@@ -304,6 +304,7 @@ function outputTopXRowAppsFromRating($sRating, $iNumApps)
FROM appVotes, appVersion
WHERE appVersion.rating = '?'
AND appVersion.versionId = appVotes.versionId
+ AND appVersion.state = 'accepted'
GROUP BY appVotes.versionId
ORDER BY c DESC
LIMIT ?";