Mercurial > 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 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; }