summaryrefslogtreecommitdiff
path: root/Pages/Report.cshtml.cs
diff options
context:
space:
mode:
authorIan C <ianc@noddybox.co.uk>2024-03-27 18:58:09 +0000
committerIan C <ianc@noddybox.co.uk>2024-03-27 18:58:09 +0000
commit57acc97e1f9d76c2edbb4eeabae4ea3dd635bb77 (patch)
tree8298ce7c00cc59a87269ba58dcc4ecaa51215470 /Pages/Report.cshtml.cs
parentfe5c628725260d0bee594108afe0eec1e802e8b2 (diff)
Updated for new download table format.1.0
Diffstat (limited to 'Pages/Report.cshtml.cs')
-rw-r--r--Pages/Report.cshtml.cs7
1 files changed, 3 insertions, 4 deletions
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)