Alexander Nicolaysen Sørnes : Top 25: Don't show queued or deleted versions

[Alexander Nicolaysen Sørnes]

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

Author: Alexander Nicolaysen Sørnes <alex at thehandofagony.com>
Date:   Sun Jul 12 23:20:42 2009 +0200

Top 25: Don't show queued or deleted versions

---

 votestats.php |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/votestats.php b/votestats.php
index c1db7e6..58cb715 100644
--- a/votestats.php
+++ b/votestats.php
@@ -131,7 +131,8 @@ if(empty($aClean['iCategoryId']))
                        count(userId) as count
                            FROM appVotes, appFamily, appVersion
                            WHERE appVotes.versionId = appVersion.versionId AND
-                           appFamily.appId = appVersion.appId
+                           appFamily.appId = appVersion.appId AND
+                           appVersion.state = 'accepted'
                            GROUP BY appVotes.versionId ORDER BY count DESC LIMIT ?", 
                                $aClean['iTopNumber']);
 } else
@@ -149,6 +150,7 @@ if(empty($aClean['iCategoryId']))
                   FROM appFamily AS f, appCategory AS c, appVotes AS v, appVersion
                   WHERE appVersion.appId = f.appId
                   AND appVersion.versionId = v.versionId
+                  AND appVersion.state = 'accepted'
                   AND f.catId = c.catId
                   AND (
                         c.catId = '?'