Alexander Nicolaysen Sørnes : Fix code for getting random apps with screenshots on front page

[Chris Morgan]

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

Author: Alexander Nicolaysen Sørnes 
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)