From 20cb0b8a0515c588fb9ac548b1b4c42538698a52 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 4 Jan 2023 07:20:02 +0300
Subject: Nodeinfo: exclude foreign comments

---
 src/main/java/com/juick/www/api/xnodeinfo2/Info.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/main')

diff --git a/src/main/java/com/juick/www/api/xnodeinfo2/Info.java b/src/main/java/com/juick/www/api/xnodeinfo2/Info.java
index 278462b5..9811cc4c 100644
--- a/src/main/java/com/juick/www/api/xnodeinfo2/Info.java
+++ b/src/main/java/com/juick/www/api/xnodeinfo2/Info.java
@@ -71,7 +71,7 @@ public class Info {
         usage.setUsers(userStats);
         usage.setLocalPosts(jdbcTemplate.queryForObject("SELECT COUNT(*) FROM messages",
                 Integer.class));
-        usage.setLocalComments(jdbcTemplate.queryForObject("SELECT COUNT(*) FROM replies",
+        usage.setLocalComments(jdbcTemplate.queryForObject("SELECT COUNT(*) FROM replies WHERE reply_uri IS NULL",
                 Integer.class));
         nodeInfo.setUsage(usage);
         return nodeInfo;
-- 
cgit v1.2.3