meillo@1: char query[1024]; meillo@1: char* gamename; meillo@1: int gameid; meillo@1: int gametime; meillo@1: meillo@1: meillo@1: void check_game() { meillo@1: int rows; meillo@1: MYSQL_ROW row; meillo@1: meillo@1: sprintf(query, "select id, time from game where name = '%s' ", gamename); meillo@1: db_query(query); meillo@1: result = mysql_store_result(conn); meillo@1: rows = mysql_num_rows(result); meillo@1: row = mysql_fetch_row(result); meillo@1: gameid = atoi(row[0]); meillo@1: gametime = atoi(row[1]); meillo@1: mysql_free_result(result); meillo@1: meillo@1: if (rows != 1) { meillo@1: printf("game '%s' does not exist\n", gamename); meillo@1: exit(1); meillo@1: } meillo@1: } meillo@1: