From 2ec66caeb138690cd19584d7fd15058387225842 Mon Sep 17 00:00:00 2001
From: Trumeet <yuuta@yuuta.moe>
Date: Tue, 5 Apr 2022 14:08:13 -0700
Subject: Show total amount of says in /stat.

---
 stat.c | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/stat.c b/stat.c
index b6edfee..d60df31 100644
--- a/stat.c
+++ b/stat.c
@@ -8,6 +8,7 @@
 #include "db.h"
 
 #include <stdlib.h>
+#include <string.h>
 
 static char *praises[] = {
         "普天之下，莫非 K 土。TGCN 共有 %d 位 K 教授的虔诚学生卖了 %d 句菜。",
@@ -33,6 +34,13 @@ void stat(struct TdMessage *msg) {
              sqlite3_column_int(stmt, 0),
              sqlite3_column_int(stmt, 1));
     sqlite3_finalize(stmt);
+    stmt = NULL;
+
+    if ((r = sqlite3_prepare_v2(db, "SELECT COUNT(t) FROM says;", -1, &stmt, NULL))) goto sql_err;
+    if ((r = sqlite3_step(stmt)) != SQLITE_ROW) goto sql_err;
+    size_t len = strlen(m);
+    snprintf(&m[len], 1024 - len, "\n\n共有 %d 句教授语录。", sqlite3_column_int(stmt, 0));
+    sqlite3_finalize(stmt);
     goto send;
     send:
     td_send(TdCreateObjectSendMessage(msg->chat_id_,
-- 
cgit v1.2.3