Alexander Nicolaysen Sørnes : Only show accepted versions on the front page

[Chris Morgan]

Module: appdb
Branch: master
Commit: 80fd412592f1be0e1658313cd2c19bfce76110d4
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=80fd412592f1be0e1658313cd2c19bfce76110d4

Author: Alexander Nicolaysen Sørnes <alex at 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 ?";