From 69521f63d0c066a7f4e153f11f1fe92b1c2cd94a Mon Sep 17 00:00:00 2001
From: 尹姜谊 <yinjiangyi@iie.ac.cn>
Date: Thu, 21 Mar 2024 13:35:03 +0800
Subject: Fix: windscribe sql配置错误
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 config24.01.yaml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'config24.01.yaml')

diff --git a/config24.01.yaml b/config24.01.yaml
index 905fba5..f9f3b30 100644
--- a/config24.01.yaml
+++ b/config24.01.yaml
@@ -93,7 +93,7 @@ protonvpn:
     plugin_id: 4
     object_type: ip
     confidence: confirmed
-    sql: SELECT server_ip FROM {$db_name}.{$table_name} WHERE {$time_filter} AND (server_port IN (443, 7770, 8443, 88, 5060, 51820, 500, 80, 1224, 4500, 4569, 5060, 1194)) GROUP BY server_ip HAVING length(ports) > 10
+    sql: SELECT server_ip, groupUniqArray(port) as ports FROM {$db_name}.{$table_name} WHERE {$time_filter} AND (server_port IN (443, 7770, 8443, 88, 5060, 51820, 500, 80, 1224, 4500, 4569, 5060, 1194)) GROUP BY server_ip HAVING length(ports) > 10
 
 
 # tsg系统内置Cyberghost-UDP APP获取新增活跃IP
-- 
cgit v1.2.3