Changeset 311

Timestamp:

09/11/07 14:25:03 (6 years ago)

Author:

arthur

Message:

hide the old bananas

Files:

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

components/bananas.php

@@ -18 +18 @@
 
 if ($mode == "detail") {
-        $smarty->assign("awards",$DB->GetAll("select *, date_trunc('second', whn) from awards where username=? order by whn desc", array($who)));
+        $smarty->assign("awards",$DB->GetAll("SELECT *, date_trunc('second', whn) FROM awards WHERE username=? AND archive=0 ORDER BY whn DESC", array($who)));
         if ($session->loggedin) {
                 include("../lib/banana-admin.php");
@@ -24 +24 @@
 }
 
-$users = $DB->GetAll("SELECT username, sum(score) AS sum FROM awards GROUP BY username ORDER BY sum(score) DESC, username");
+$users = $DB->GetAll("SELECT username, sum(score) AS sum FROM awards WHERE archive=0 GROUP BY username ORDER BY sum(score) DESC, username");
 
 $smarty->assign('mode', "$mode");