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));
+}