diff game.h @ 11:176ee28e7464

switched from mysql to sqlite; (+ some cleanups)
author meillo@marmaro.de
date Wed, 23 Jul 2008 11:41:38 +0200
parents 3ff1fbe4693d
children 8db6497d6065
line wrap: on
line diff
--- a/game.h	Wed Jul 23 11:40:45 2008 +0200
+++ b/game.h	Wed Jul 23 11:41:38 2008 +0200
@@ -1,25 +1,15 @@
-char query[1024];
-char* gamename;
-int gameid;
 int gametime;
 
 
-void check_game() {
-	int rows;
-	MYSQL_ROW row;
-
-	sprintf(query, "select id, time from game where name = '%s' ", gamename);
+int read_time() {
+	sprintf(query, "select time from game;");
 	db_query(query);
-	result = mysql_store_result(conn);
-	rows = mysql_num_rows(result);
-	row = mysql_fetch_row(result);
-	gameid = atoi(row[0]);
-	gametime = atoi(row[1]);
-	mysql_free_result(result);
-	
-	if (rows != 1) {
-		printf("game '%s' does not exist\n", gamename);
+	if (sqlite3_step(stmt) != SQLITE_ROW) {
+		printf("error: %s\n", sqlite3_errmsg(db));
 		exit(1);
 	}
+	gametime = sqlite3_column_int(stmt, 0);
+	sqlite3_finalize(stmt);
+	return gametime;
 }