Mercurial > garten

comparison game.h @ 11:176ee28e7464

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
switched from mysql to sqlite; (+ some cleanups)
author meillo@marmaro.de
date Wed, 23 Jul 2008 11:41:38 +0200
parents 3ff1fbe4693d
children 8db6497d6065
comparison
equal deleted inserted replaced
10:13c6828bd4a5 11:176ee28e7464
1 char query[1024];
2 char* gamename;
3 int gameid;
4 int gametime; 1 int gametime;
5 2
6 3
7 void check_game() { 4 int read_time() {
8 int rows; 5 sprintf(query, "select time from game;");
9 MYSQL_ROW row;
10
11 sprintf(query, "select id, time from game where name = '%s' ", gamename);
12 db_query(query); 6 db_query(query);
13 result = mysql_store_result(conn); 7 if (sqlite3_step(stmt) != SQLITE_ROW) {
14 rows = mysql_num_rows(result); 8 printf("error: %s\n", sqlite3_errmsg(db));
15 row = mysql_fetch_row(result);
16 gameid = atoi(row[0]);
17 gametime = atoi(row[1]);
18 mysql_free_result(result);
19
20 if (rows != 1) {
21 printf("game '%s' does not exist\n", gamename);
22 exit(1); 9 exit(1);
23 } 10 }
11 gametime = sqlite3_column_int(stmt, 0);
12 sqlite3_finalize(stmt);
13 return gametime;
24 } 14 }
25 15