Module: appdb Branch: master Commit: 0a42c3e36ce3f0234e31fd0d5783e9d0fa0706cc URL: http://source.winehq.org/git/appdb.git/?a=commit;h=0a42c3e36ce3f0234e31fd0d5...
Author: Alexander Nicolaysen Sørnes alex@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 = '?'