From a60168c9376bff59ffd6cdd137ab7b7642cdce27 Mon Sep 17 00:00:00 2001 From: Jeffrey Armstrong Date: Tue, 14 Sep 2021 13:53:58 -0400 Subject: Fixed insert-update statement for acknowledging checkins --- captain/db.f90 | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/captain/db.f90 b/captain/db.f90 index 448c17d..42f1bfc 100644 --- a/captain/db.f90 +++ b/captain/db.f90 @@ -1210,7 +1210,8 @@ contains call date_and_time(values=right_now) if(stmt%prepare(db, & - "INSERT OR UPDATE INTO checkin(player, year, month, day, hour, minute, second, platform) VALUES(?, ?, ?)") & + "INSERT OR UPDATE INTO checkin(player, year, month, day, hour, minute, second, platform)" & + //" VALUES(?, ?, ?, ?, ?, ?, ?, ?)") & == SQLITE_OK) & then if(stmt%bind_int(1, player) == SQLITE_OK .AND. & -- cgit v1.2.3