Mercurial > garten
diff db.c @ 17:5e6c9260913a
lots of cleanups and small fixes
author | meillo@marmaro.de |
---|---|
date | Wed, 23 Jul 2008 17:14:38 +0200 |
parents | 3c104b5f5158 |
children | 5937504619f2 |
line wrap: on
line diff
--- a/db.c Wed Jul 23 16:49:10 2008 +0200 +++ b/db.c Wed Jul 23 17:14:38 2008 +0200 @@ -45,6 +45,18 @@ } +int db_rows(sqlite3_stmt* stmt) { + int i = 0; + + sqlite3_reset(stmt); + while (sqlite3_step(stmt) == SQLITE_ROW) { + i++; + } + sqlite3_reset(stmt); + return i; +} + + int read_time() { sprintf(query, "select time from game;"); stmt = db_query(query); @@ -57,3 +69,7 @@ return gametime; } + +void db_error(char* info) { + fprintf(stderr, "%s%sSQL error: %s\n", (info) ? info : "", (info) ? ": " : "", sqlite3_errmsg(db)); +}