Share stmt_global_stat

1 files changed, 8 insertions, 10 deletions

diff --git a/stat.c b/stat.c
index 143a98d..0e5906f 100644
--- a/stat.c
+++ b/stat.c
@@ -19,18 +19,16 @@ static char *praises[] = {
 void stat(struct TdMessage *msg) {
     int r;
     char m[1024];
-    sqlite3_stmt *stmt = NULL;
-    if ((r = sqlite3_prepare_v2(db, "SELECT * FROM stats_global;", -1, &stmt, NULL))) {
+    if ((r = sqlite3_step(stmt_global_stat)) != SQLITE_ROW) {
         goto sql_err;
         sql_err:
         {
             snprintf(m, 1024, "Cannot query statistics: %s.", sqlite3_errstr(r));
             LOGEV("%s", m);
-            if (stmt) sqlite3_finalize(stmt);
+            sqlite3_reset(stmt_global_stat);
             goto send;
         }
     }
-    if ((r = sqlite3_step(stmt)) != SQLITE_ROW) goto sql_err;
 
     snprintf(m, sizeof(m), "%s"
                                   "TGCN 共有 %d 位 K 教授的虔诚学生卖了 %d 句菜，"
@@ -40,13 +38,13 @@ void stat(struct TdMessage *msg) {
                                   "共有 %d 句教授语录。\n"
                                   "Bot 已运行 %ld 秒。",
              praises[rand() % (sizeof(praises) / sizeof(char *))],
-             sqlite3_column_int(stmt, 0),
-             sqlite3_column_int(stmt, 1),
-             sqlite3_column_int(stmt, 2),
-             sqlite3_column_int(stmt, 3),
-             sqlite3_column_int(stmt, 4),
+             sqlite3_column_int(stmt_global_stat, 0),
+             sqlite3_column_int(stmt_global_stat, 1),
+             sqlite3_column_int(stmt_global_stat, 2),
+             sqlite3_column_int(stmt_global_stat, 3),
+             sqlite3_column_int(stmt_global_stat, 4),
              time(NULL) - start_time);
-    sqlite3_finalize(stmt);
+    sqlite3_reset(stmt_global_stat);
     goto send;
     send:
     td_send(TdCreateObjectSendMessage(msg->chat_id_,