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');