Mercurial > hg > fapweb

changeset 335:cd2fbd5e0b1a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix the assigned key results calculation as well.
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 28 Nov 2013 06:35:59 +0200
parents a02422200eca
children 49094cfbd674
files results.inc.php
diffstat 1 files changed, 10 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/results.inc.php	Thu Nov 28 06:30:56 2013 +0200
+++ b/results.inc.php	Thu Nov 28 06:35:59 2013 +0200
@@ -83,6 +83,16 @@
             "LEFT JOIN attendees ON votes.key_id=attendees.key_id ".
             "WHERE entries.compo_id=".$compo["id"]." ".
             "AND attendees.key_id<>0";
+
+          $sql =
+            "SELECT entries.*, ".
+              "(SELECT SUM(votes.value) FROM votes ".
+              "LEFT JOIN votekeys ON votes.key_id=votekeys.id ".
+              "LEFT JOIN attendees ON votekeys.id=attendees.key_id ".
+              "WHERE votes.entry_id=entries.id AND attendees.key_id<>0) ".
+              "AS votesum ".
+            "FROM entries ".
+            "WHERE entries.compo_id=".$compo["id"];
           break;
       }