X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=web%2Fmbd-status.pl;h=d8ac74e0431889c3575e8d21a3774b59b36b7a10;hb=496f69b68c05fd79f83178deac6b3fc34f13684f;hp=cf97ea1b8454ec6c4ab807dbfebe6be5e8f08125;hpb=f6cc98a589e8dd3b1b98151a70f6b5db98b2b04f;p=nms diff --git a/web/mbd-status.pl b/web/mbd-status.pl index cf97ea1..d8ac74e 100755 --- a/web/mbd-status.pl +++ b/web/mbd-status.pl @@ -25,7 +25,7 @@ print <<"EOF"; EOF -my $q = $dbh->prepare('select description,sum(active_servers) as active_servers from (select distinct on (game,port) * from mbd_log where ts >= now() - interval \'30 minutes\' order by game,port,ts desc ) t1 group by game,description order by sum(active_servers) desc, description;'); +my $q = $dbh->prepare('select description,sum(active_servers) as active_servers from (select distinct on (game,port) * from mbd_log where ts >= now() - interval \'10 minutes\' order by game,port,ts desc ) t1 group by game,description order by sum(active_servers) desc, description;'); $q->execute(); while (my $ref = $q->fetchrow_hashref()) { print <<"EOF";