Revert "BUGFIX: hour is 0 at midnight, so has to account for that"

[ndwebbie.git] / ND / Web / Pages / DefLeeches.pm

diff --git a/ND/Web/Pages/DefLeeches.pm b/ND/Web/Pages/DefLeeches.pm
index aa921b7255d0ca2318ec66ed97a56492773a57a2..21f7dcb5948dbe8fd7d0fe192aaccd23e294cbf6 100644 (file)
--- a/ND/Web/Pages/DefLeeches.pm
+++ b/ND/Web/Pages/DefLeeches.pm
@@ -34,7 +34,7 @@ sub render_body {
        $self->{TITLE} = 'Def Leeches';
        my $DBH = $self->{DBH};
 
-       return $self->noAccess unless $self->isHC;
+       return $self->noAccess unless $self->isDC;
 
        my $query = $DBH->prepare(q{SELECT username,defense_points,count(id) AS calls, SUM(fleets) AS fleets, SUM(recalled) AS recalled
                FROM (SELECT username,defense_points,c.id,count(f.target) AS fleets, count(NULLIF(f.landing_tick + f.eta -1 = f.back,TRUE)) AS recalled
@@ -42,7 +42,7 @@ sub render_body {
                        WHERE (f.mission = 'Defend') OR f.target IS NULL
                        GROUP BY username,defense_points,c.id
                        ) d
-               GROUP BY username,defense_points ORDER BY fleets DESC
+               GROUP BY username,defense_points ORDER BY fleets DESC, defense_points
                });
        $query->execute;