diff options
| author |  Vitaly Takmazov | 2023-11-24 14:30:06 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-11-24 14:30:06 +0300 |
| commit | c1cc470eca4262ee6ef10a08c0c07fc3d7a5bbb6 (patch) | |
| tree | 519e1a943d9e2b41296ad3494076a09bbaf9eccc | |
| parent | 7e52c9e6e16bb53f375cdb0496a6200525e815dd (diff) | |
ActivityPub: count public posts only
| -rw-r--r-- | src/main/java/com/juick/service/InfoService.java | 2 |
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)); |