garten
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 diff
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