summaryrefslogtreecommitdiff
path: root/db.c
diff options
context:
space:
mode:
Diffstat (limited to 'db.c')
-rw-r--r--db.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/db.c b/db.c
index 44cf0d8..6b13058 100644
--- a/db.c
+++ b/db.c
@@ -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;
}