1 char query[1024];

2 char* gamename;

3 int gameid;

4 int gametime;

5

6

7 void check_game() {

8 int rows;

9 MYSQL_ROW row;

10

11 sprintf(query, "select id, time from game where name = '%s' ", gamename);

12 db_query(query);

13 result = mysql_store_result(conn);

14 rows = mysql_num_rows(result);

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);

23 }

24 }

25