Changeset 312

Timestamp:

09/11/07 14:43:23 (6 years ago)

Author:

arthur

Message:

filter bananas page based on end of year being end of june

Files:

• components/bananas.php (modified) (3 diffs)

components/bananas.php

@@ -1 +1 @@
 <?php
+
+/* as far as bananas are concerned, year ends after the beach party */
+$yearstart = date("Y")."-06-30";
 
 /* Banana viewing component. Looking a little obsolete since most of this is now in the members component */
@@ -18 +21 @@
 
 if ($mode == "detail") {
-        $smarty->assign("awards",$DB->GetAll("SELECT *, date_trunc('second', whn) FROM awards WHERE username=? AND archive=0 ORDER BY whn DESC", array($who)));
+        $smarty->assign("awards",$DB->GetAll("SELECT *, date_trunc('second', whn) FROM awards WHERE username=? AND whn > ? ORDER BY whn DESC", array($who, $yearstart)));
         if ($session->loggedin) {
                 include("../lib/banana-admin.php");
@@ -24 +27 @@
 }
 
-$users = $DB->GetAll("SELECT username, sum(score) AS sum FROM awards WHERE archive=0 GROUP BY username ORDER BY sum(score) DESC, username");
+$users = $DB->GetAll("SELECT username, sum(score) AS sum FROM awards WHERE whn > ? GROUP BY username ORDER BY sum(score) DESC, username", array($yearstart));
 
 $smarty->assign('mode', "$mode");