From 57acc97e1f9d76c2edbb4eeabae4ea3dd635bb77 Mon Sep 17 00:00:00 2001 From: Ian C Date: Wed, 27 Mar 2024 18:58:09 +0000 Subject: Updated for new download table format. --- Pages/Report.cshtml.cs | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'Pages/Report.cshtml.cs') diff --git a/Pages/Report.cshtml.cs b/Pages/Report.cshtml.cs index 365041f..76cfabf 100644 --- a/Pages/Report.cshtml.cs +++ b/Pages/Report.cshtml.cs @@ -36,17 +36,16 @@ public class ReportModel : PageModel conn.Open(); - using var cmd = new NpgsqlCommand("SELECT key, ip_address, user_agent, time FROM download ORDER BY time", conn); + using var cmd = new NpgsqlCommand("SELECT key, info, time FROM download ORDER BY time", conn); using var reader = cmd.ExecuteReader(); while(reader.Read()) { string key = (string)reader["key"]; - string ip_address = (string)reader["ip_address"]; - string user_agent = (string)reader["user_agent"]; + string[] info = (string[])reader["info"]; DateTime time = (DateTime)reader["time"]; - Rows.Add(new Download(key, ip_address, user_agent, time)); + Rows.Add(new Download(key, info, time)); } } catch(Exception e) -- cgit v1.2.3