Changeset 311 for components/bananas.php

Show
Ignore:
Timestamp:
09/11/07 14:25:03 (6 years ago)
Author:
arthur
Message:

hide the old bananas

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • components/bananas.php

    r175 r311  
    1818 
    1919if ($mode == "detail") { 
    20         $smarty->assign("awards",$DB->GetAll("select *, date_trunc('second', whn) from awards where username=? order by whn desc", array($who))); 
     20        $smarty->assign("awards",$DB->GetAll("SELECT *, date_trunc('second', whn) FROM awards WHERE username=? AND archive=0 ORDER BY whn DESC", array($who))); 
    2121        if ($session->loggedin) { 
    2222                include("../lib/banana-admin.php"); 
    … …  
    2424} 
    2525 
    26 $users = $DB->GetAll("SELECT username, sum(score) AS sum FROM awards GROUP BY username ORDER BY sum(score) DESC, username"); 
     26$users = $DB->GetAll("SELECT username, sum(score) AS sum FROM awards WHERE archive=0 GROUP BY username ORDER BY sum(score) DESC, username"); 
    2727 
    2828$smarty->assign('mode', "$mode");