--- a/clock.c	Wed Jul 23 11:40:45 2008 +0200
+++ b/clock.c	Wed Jul 23 11:41:38 2008 +0200
@@ -1,6 +1,5 @@
 #include <stdio.h>
 #include <stdlib.h>
-#include <mysql.h>
 
 #include "db.h"
 #include "game.h"
@@ -8,28 +7,27 @@
 
 
 void inc_time() {
-
 	/* get current time */
-	sprintf(query, "select time from game where name = '%s' ", gamename);
+	sprintf(query, "select time from game;");
 	db_query(query);
-	result = mysql_store_result(conn);
-	if (mysql_num_rows(result)) {
-		row = mysql_fetch_row(result);
-		gametime = atoi(row[0]);
+	if (sqlite3_step(stmt) == SQLITE_ROW) {
+		gametime = sqlite3_column_int(stmt, 0);
+		printf("gametime: %d\n", gametime);
+	} else {
+		fprintf(stderr, "error: %s\n", sqlite3_errmsg(db));
 	}
-	mysql_free_result(result);
-
+	sqlite3_finalize(stmt);
 
 	/* increment time */
-	sprintf(query, " update game set time = '%d' where name = '%s' ", ++gametime, gamename);
+	sprintf(query, " update game set time = '%d';", ++gametime);
 	db_query(query);
-	if (mysql_affected_rows(conn) > 0) {
+	if (sqlite3_step(stmt) == SQLITE_DONE) {
 		printf("time update successful\n");
 		printf("virtual time: %d\n", gametime);
 	} else {
-		printf("E: time update failed\n");
+		printf("error: time update failed: %s\n", sqlite3_errmsg(db));
 	}
-
+	sqlite3_finalize(stmt);
 }
 
 
@@ -41,10 +39,10 @@
 		printf("usage: %s <game>\n", argv[0]);
 		exit(1);
 	}
-	gamename = argv[1];
+	database = argv[1];
 
 	db_connect();
-	check_game();
+	read_time();
 
 	inc_time();