diff options
Diffstat (limited to 'stat.c')
-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_, |