summary refs log tree commit diff
diff options
context:
space:
mode:
-rw-r--r--networks.c2
1 files changed, 2 insertions, 0 deletions
diff --git a/networks.c b/networks.c
index 91f5131..f1f8c89 100644
--- a/networks.c
+++ b/networks.c
@@ -37,6 +37,7 @@ const char *NetworksQuery = SQL(
 	), allNetworks AS (
 		SELECT DISTINCT network
 		FROM contexts
+		WHERE query <= NOT :public
 		ORDER BY network COLLATE NOCASE
 	)
 	SELECT network, 1 FROM activeNetworks
@@ -59,6 +60,7 @@ enum kcgi_err networksPage(struct kreq *req) {
 
 	sqlite3_reset(stmt.networks);
 	dbBindInt(stmt.networks, ":recent", contextsRecent);
+	dbBindInt(stmt.networks, ":public", contextsPublic);
 
 	enum State {
 		None,
commit/bin/man1/bit.1?id=0206100e2000399a7879e00da04df11234c3bc7a&follow=1'>Simplify and build bitJune McEnroe 2019-05-29Add xx -p optionJune McEnroe 2019-05-27Add FrontierJune McEnroe 2019-05-27Break nicks with ZWNJJune McEnroe 2019-05-26Add DawnJune McEnroe 2019-05-20Declare vasprintf(3) for GNUJune McEnroe 2019-05-20Fix comparison warning in ttpreJune McEnroe 2019-05-20Add AuthorityJune McEnroe 2019-05-19Specify precedence of unary versions of operatorsJune McEnroe 2019-05-18Add compound assignment operators to orderJune McEnroe 2019-05-15Support simple assignment in orderJune McEnroe 2019-05-15Implement sizeof in orderJune McEnroe 2019-05-15Add orderJune McEnroe 2019-05-12Add T suffix in bitJune McEnroe 2019-05-10Highlight yacc and lex files as CJune McEnroe 2019-05-10Use val instead of suboptargJune McEnroe 2019-05-09Add Parable of the SowerJune McEnroe 2019-05-07Add bit without buildJune McEnroe 2019-05-04Fix MANDIR typoJune McEnroe 2019-05-04Move relay to binJune McEnroe