diff options
author | Trumeet <yuuta@yuuta.moe> | 2022-04-05 14:08:13 -0700 |
---|---|---|
committer | Trumeet <yuuta@yuuta.moe> | 2022-04-05 14:08:13 -0700 |
commit | 2ec66caeb138690cd19584d7fd15058387225842 (patch) | |
tree | a588a7549fc9ca9289eb14ebd543b8b06537730b | |
parent | 6a3ffc7cfa063666bf298ea7f62a2430dc02e7f3 (diff) | |
download | ksyxbot-2ec66caeb138690cd19584d7fd15058387225842.tar ksyxbot-2ec66caeb138690cd19584d7fd15058387225842.tar.gz ksyxbot-2ec66caeb138690cd19584d7fd15058387225842.tar.bz2 ksyxbot-2ec66caeb138690cd19584d7fd15058387225842.zip |
Show total amount of says in /stat.
-rw-r--r-- | stat.c | 8 |
1 files changed, 8 insertions, 0 deletions
@@ -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_, |