root/components/bananas.php @ 311

<?php

/* Banana viewing component. Looking a little obsolete since most of this is now in the members component */

$banana_index = array_search("Bananas", $pathlist);
if ((sizeof($pathlist) > $banana_index + 1) && (trim($pathlist[$banana_index + 1]) != "")) {
    $mode = "detail";
    $who = $pathlist[$banana_index + 1];
} else {
    $mode = "summary";
}

if (isset($who))
    $smarty->assign('who', "$who");

// banana admin bits


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)));
    if ($session->loggedin) {
        include("../lib/banana-admin.php");
    }
}

$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");
$smarty->assign('users', $users);

$result = $smarty->fetch('bananas.tpl');
$smarty->assign('title', "Banana Awards");
$smarty->assign('body', $result);



?>