X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=NDWeb%2FPages%2FPoints.pm;h=250900b6696389ac3ef14ce8ad4349fec9a3e3e7;hb=961956798336852fd1430ea4298cae6b179deff8;hp=fb69b2ace3cbca3d434aae4e11799495b2c84381;hpb=a074bd17f5e8ba341a22bbfca1da7093b8351774;p=ndwebbie.git diff --git a/NDWeb/Pages/Points.pm b/NDWeb/Pages/Points.pm index fb69b2a..250900b 100644 --- a/NDWeb/Pages/Points.pm +++ b/NDWeb/Pages/Points.pm @@ -46,7 +46,7 @@ sub render_body { $order = 'ASC' if ($type eq 'rank'); my $limit = 'LIMIT 10'; - $limit = '' if $self->isHC; + $limit = '' if $self->isOfficer; my $query = $DBH->prepare(qq{SELECT username,defense_points,attack_points,scan_points,humor_points ,(attack_points+defense_points+scan_points/20) as total_points, rank, count(NULLIF(rc.launched,FALSE)) AS raid_points @@ -57,11 +57,9 @@ sub render_body { $query->execute; my @members; - my $i = 0; while (my ($username,$defense,$attack,$scan,$humor,$total,$rank,$raid) = $query->fetchrow){ - $i++; push @members,{Username => $username, Defense => $defense, Attack => $attack, Raid => $raid - , Scan => $scan, Humor => $humor, Total => $total, Rank => $rank, ODD => $i % 2}; + , Scan => $scan, Humor => $humor, Total => $total, Rank => $rank}; } $BODY->param(Members => \@members); return $BODY;