aboutsummaryrefslogtreecommitdiff
path: root/src/main/java/com/juick/service
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2023-11-24 14:30:06 +0300
committerGravatar Vitaly Takmazov2023-11-24 14:30:06 +0300
commitc1cc470eca4262ee6ef10a08c0c07fc3d7a5bbb6 (patch)
tree519e1a943d9e2b41296ad3494076a09bbaf9eccc /src/main/java/com/juick/service
parent7e52c9e6e16bb53f375cdb0496a6200525e815dd (diff)
ActivityPub: count public posts only
Diffstat (limited to 'src/main/java/com/juick/service')
-rw-r--r--src/main/java/com/juick/service/InfoService.java2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/java/com/juick/service/InfoService.java b/src/main/java/com/juick/service/InfoService.java
index fbf75b86..b10e325e 100644
--- a/src/main/java/com/juick/service/InfoService.java
+++ b/src/main/java/com/juick/service/InfoService.java
@@ -63,7 +63,7 @@ public class InfoService {
Integer.class, ZonedDateTime.now().minus(6, ChronoUnit.MONTHS).toLocalDateTime()));
Usage usage = new Usage();
usage.setUsers(userStats);
- usage.setLocalPosts(jdbcTemplate.queryForObject("SELECT COUNT(*) FROM messages",
+ usage.setLocalPosts(jdbcTemplate.queryForObject("SELECT COUNT(*) FROM messages WHERE privacy=1",
Integer.class));
usage.setLocalComments(jdbcTemplate.queryForObject("SELECT COUNT(*) FROM replies WHERE reply_uri IS NULL",
Integer.class));