meillo@0: #include <stdio.h>
meillo@0: #include <stdlib.h>
meillo@0: #include <mysql.h>
meillo@0: 
meillo@0: #include "db.h"
meillo@0: 
meillo@0: char query[512];
meillo@0: 
meillo@0: 
meillo@0: int check_game(char* gamename) {
meillo@0: 	int rows;
meillo@0: 
meillo@0: 	sprintf(query, "select id from simulation where name = '%s' ", gamename);
meillo@0: 	db_query(query);
meillo@0: 	result = mysql_store_result(conn);
meillo@0: 	rows = mysql_num_rows(result);
meillo@0: 	mysql_free_result(result);
meillo@0: 	return rows;
meillo@0: }
meillo@0: 
meillo@0: 
meillo@0: void inc_time(char* gamename) {
meillo@0: 	int time = 0;
meillo@0: 
meillo@0: 	/* get current time */
meillo@0: 	sprintf(query, "select time from simulation where name = '%s' ", gamename);
meillo@0: 	db_query(query);
meillo@0: 	result = mysql_store_result(conn);
meillo@0: 	if (mysql_num_rows(result)) {
meillo@0: 		row = mysql_fetch_row(result);
meillo@0: 		time = atoi(row[0]);
meillo@0: 	}
meillo@0: 	mysql_free_result(result);
meillo@0: 
meillo@0: 
meillo@0: 	/* increment time */
meillo@0: 	sprintf(query, " update simulation set time = '%d' where name = '%s' ", ++time, gamename);
meillo@0: 	db_query(query);
meillo@0: 	if (mysql_affected_rows(conn) > 0) {
meillo@0: 		printf("time update successful\n");
meillo@0: 		printf("simulation time: %d\n", time);
meillo@0: 	} else {
meillo@0: 		printf("E: time update failed\n");
meillo@0: 	}
meillo@0: 
meillo@0: }
meillo@0: 
meillo@0: 
meillo@0: int main(int argc, char* argv[]) {
meillo@0: 	int i;
meillo@0: 	char* gamename;
meillo@0: 
meillo@0: 	/* init */
meillo@0: 	if (argc != 2) {
meillo@0: 		printf("usage: %s <game>\n", argv[0]);
meillo@0: 		exit(1);
meillo@0: 	}
meillo@0: 	gamename = argv[1];
meillo@0: 
meillo@0: 	printf("gamename: %s\n", gamename);
meillo@0: 
meillo@0: 	db_connect();
meillo@0: 
meillo@0: 	if (check_game(gamename) != 1) {
meillo@0: 		printf("game '%s' does not exist\n", gamename);
meillo@0: 		exit(1);
meillo@0: 	}
meillo@0: 
meillo@0: 	inc_time(gamename);
meillo@0: 
meillo@0: /*
meillo@0: 	while ((row = mysql_fetch_row(result)) != NULL) {
meillo@0: 		for (i = 0; i < mysql_num_fields(result); i++) {
meillo@0: 			printf("%10s  ", row[i]);
meillo@0: 		}
meillo@0: 		printf("\n");
meillo@0: 	}
meillo@0: 	*/
meillo@0: 
meillo@0: 
meillo@0: 
meillo@0: 
meillo@0: 	db_close();
meillo@0: 
meillo@0: 	printf("the garten program\n");
meillo@0: 	return 0;
meillo@0: }