1.1 --- a/game.h	Wed Jul 23 11:40:45 2008 +0200
     1.2 +++ b/game.h	Wed Jul 23 11:41:38 2008 +0200
     1.3 @@ -1,25 +1,15 @@
     1.4 -char query[1024];
     1.5 -char* gamename;
     1.6 -int gameid;
     1.7  int gametime;
     1.8  
     1.9  
    1.10 -void check_game() {
    1.11 -	int rows;
    1.12 -	MYSQL_ROW row;
    1.13 -
    1.14 -	sprintf(query, "select id, time from game where name = '%s' ", gamename);
    1.15 +int read_time() {
    1.16 +	sprintf(query, "select time from game;");
    1.17  	db_query(query);
    1.18 -	result = mysql_store_result(conn);
    1.19 -	rows = mysql_num_rows(result);
    1.20 -	row = mysql_fetch_row(result);
    1.21 -	gameid = atoi(row[0]);
    1.22 -	gametime = atoi(row[1]);
    1.23 -	mysql_free_result(result);
    1.24 -	
    1.25 -	if (rows != 1) {
    1.26 -		printf("game '%s' does not exist\n", gamename);
    1.27 +	if (sqlite3_step(stmt) != SQLITE_ROW) {
    1.28 +		printf("error: %s\n", sqlite3_errmsg(db));
    1.29  		exit(1);
    1.30  	}
    1.31 +	gametime = sqlite3_column_int(stmt, 0);
    1.32 +	sqlite3_finalize(stmt);
    1.33 +	return gametime;
    1.34  }
    1.35