From dffae725026a5f19303c36d5250779cf5e8523ab Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Fri, 10 Jul 2020 11:54:33 -0400 Subject: Add -l and -r options --- networks.c | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'networks.c') diff --git a/networks.c b/networks.c index f397bab..7f974c4 100644 --- a/networks.c +++ b/networks.c @@ -26,7 +26,7 @@ const char *NetworksQuery = SQL( SELECT time, context FROM events ORDER BY event DESC - LIMIT 500 // TODO: Configurable. + LIMIT :recent ), activeNetworks AS ( SELECT DISTINCT network FROM contexts @@ -55,6 +55,8 @@ enum kcgi_err pageNetworks(struct kreq *req) { || htmlNav(&html, NULL, NULL); if (error) return error; + dbBindInt(stmt.networks, ":recent", pageRecent); + enum State { None, Active, -- cgit 1.4.1