diff options
author | Yuuta Liang <yuuta@yuuta.moe> | 2024-04-03 13:36:30 -0700 |
---|---|---|
committer | Yuuta Liang <yuuta@yuuta.moe> | 2024-04-03 13:36:30 -0700 |
commit | c9e129681bd042f358a5c63f9ac91ce4c33ef603 (patch) | |
tree | 01637d563e49baa23f15ed97a4efed90346ac740 /db.c | |
parent | 04a1de508aa4977c56b0e59a383a2ce7c1d3e340 (diff) | |
download | ksyxbot-c9e129681bd042f358a5c63f9ac91ce4c33ef603.tar ksyxbot-c9e129681bd042f358a5c63f9ac91ce4c33ef603.tar.gz ksyxbot-c9e129681bd042f358a5c63f9ac91ce4c33ef603.tar.bz2 ksyxbot-c9e129681bd042f358a5c63f9ac91ce4c33ef603.zip |
Add ranking
Diffstat (limited to 'db.c')
-rw-r--r-- | db.c | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -164,7 +164,7 @@ void db_init(void) { goto sql_err; } - if ((r = sqlite3_prepare_v2(db, "SELECT i FROM stats WHERE user = ?", -1, &stmt_personal_stat, NULL))) { + if ((r = sqlite3_prepare_v2(db, "SELECT * FROM (SELECT i FROM stats WHERE user = ?), (SELECT COUNT(i) FROM stats WHERE i >= (SELECT i FROM stats WHERE user = ?)), (SELECT COUNT(i) FROM stats)", -1, &stmt_personal_stat, NULL))) { errmsg = (char *) sqlite3_errstr(r); goto sql_err; } |