summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTrumeet <yuuta@yuuta.moe>2022-04-05 14:08:13 -0700
committerTrumeet <yuuta@yuuta.moe>2022-04-05 14:08:13 -0700
commit2ec66caeb138690cd19584d7fd15058387225842 (patch)
treea588a7549fc9ca9289eb14ebd543b8b06537730b
parent6a3ffc7cfa063666bf298ea7f62a2430dc02e7f3 (diff)
downloadksyxbot-2ec66caeb138690cd19584d7fd15058387225842.tar
ksyxbot-2ec66caeb138690cd19584d7fd15058387225842.tar.gz
ksyxbot-2ec66caeb138690cd19584d7fd15058387225842.tar.bz2
ksyxbot-2ec66caeb138690cd19584d7fd15058387225842.zip
Show total amount of says in /stat.
-rw-r--r--stat.c8
1 files changed, 8 insertions, 0 deletions
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_,