Exemplo n.º 1
0
            ORDER BY cc DESC LIMIT 100', Db::FETCH_STMT);
        $rank = [];
        while ($o = $res->fetch(PDO::FETCH_OBJ)) {
            $gc = Db::query(['SELECT COUNT("hcid") AS cc FROM "groups_comments" WHERE "from" = :from ' . (!$mo ? $un_ti : ''), [':from' => $o->from]], Db::FETCH_OBJ);
            $us = User::getUsername($o->from);
            $n = $o->cc + $gc->cc;
            $rank[$us] = $n;
            $stupid = Stuff::stupid($n);
            $ss[$us] = $stupid['now'];
        }
        asort($rank);
        $rank = array_reverse($rank, true);
        $i = 0;
        $ret = [];
        foreach ($rank as $username => $val) {
            $ret[$i]['position_n'] = $i + 1;
            $ret[$i]['username4link_n'] = Utils::userLink($username);
            $ret[$i]['username_n'] = $username;
            $ret[$i]['comments_n'] = $val;
            $ret[$i]['stupidstuff_n'] = $ss[$username];
            ++$i;
        }
        return $ret;
    }, 3600);
}
$vals['list_a'] = $ret;
$vals['monthly_b'] = !$mo;
$vals['lastupdate_n'] = $user->getDateTime(Utils::apc_getLastModified($path));
require_once $_SERVER['DOCUMENT_ROOT'] . '/pages/common/vars.php';
$user->getTPL()->assign($vals);
$user->getTPL()->draw('base/rank');