From 99878506b2373a6017f982e7b43a09a947250853 Mon Sep 17 00:00:00 2001 From: Christopher Milan Date: Sun, 16 Mar 2025 23:03:25 -0700 Subject: [PATCH] fix leader.cgi --- leader.cgi | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) diff --git a/leader.cgi b/leader.cgi index d356c0e..7b956da 100755 --- a/leader.cgi +++ b/leader.cgi @@ -20,7 +20,7 @@ my $query_today = qq{ SELECT u.name, SUM(g.util * (1.0/60.0)) AS gpu_hours FROM usage g JOIN users u ON g.uid = u.uid - WHERE u.time >= datetime('now', 'start of day') + WHERE g.time >= datetime('now', 'start of day') GROUP BY u.uid ORDER BY gpu_hours DESC; }; @@ -29,7 +29,7 @@ my $query_week = qq{ SELECT u.name, SUM(g.util * (1.0/60.0)) AS gpu_hours FROM usage g JOIN users u ON g.uid = u.uid - WHERE u.time >= datetime('now', 'start of day', '-' || strftime('%w', 'now') || ' days') + WHERE g.time >= datetime('now', 'start of day', '-' || strftime('%w', 'now') || ' days') GROUP BY u.uid ORDER BY gpu_hours DESC; }; @@ -38,7 +38,7 @@ my $query_month = qq{ SELECT u.name, SUM(g.util * (1.0/60.0)) AS gpu_hours FROM usage g JOIN users u ON g.uid = u.uid - WHERE u.time >= datetime('now', 'start of month') + WHERE g.time >= datetime('now', 'start of month') GROUP BY u.uid ORDER BY gpu_hours DESC; }; @@ -145,6 +145,9 @@ END # Finish HTML and cleanup print end_html; -$sth->finish(); +$sth_today->finish(); +$sth_week->finish(); +$sth_month->finish(); +$sth_alltime->finish(); $dbh->disconnect(); -- 2.43.0