1 #include <stdio.h>

2 #include <stdlib.h>

3 #include <mysql.h>

4

5 #include "db.h"

6

7 char query[512];

8

9

10 int check_game(char* gamename) {

11 int rows;

12

13 sprintf(query, "select id from simulation where name = '%s' ", gamename);

14 db_query(query);

15 result = mysql_store_result(conn);

16 rows = mysql_num_rows(result);

17 mysql_free_result(result);

18 return rows;

19 }

20

21

22 void inc_time(char* gamename) {

23 int time = 0;

24

25 /* get current time */

26 sprintf(query, "select time from simulation where name = '%s' ", gamename);

27 db_query(query);

28 result = mysql_store_result(conn);

29 if (mysql_num_rows(result)) {

30 row = mysql_fetch_row(result);

31 time = atoi(row[0]);

32 }

33 mysql_free_result(result);

34

35

36 /* increment time */

37 sprintf(query, " update simulation set time = '%d' where name = '%s' ", ++time, gamename);

38 db_query(query);

39 if (mysql_affected_rows(conn) > 0) {

40 printf("time update successful\n");

41 printf("simulation time: %d\n", time);

42 } else {

43 printf("E: time update failed\n");

44 }

45

46 }

47

48

49 int main(int argc, char* argv[]) {

50 int i;

51 char* gamename;

52

53 /* init */

54 if (argc != 2) {

55 printf("usage: %s <game>\n", argv[0]);

56 exit(1);

57 }

58 gamename = argv[1];

59

60 printf("gamename: %s\n", gamename);

61

62 db_connect();

63

64 if (check_game(gamename) != 1) {

65 printf("game '%s' does not exist\n", gamename);

66 exit(1);

67 }

68

69 inc_time(gamename);

70

71 /*

72 while ((row = mysql_fetch_row(result)) != NULL) {

73 for (i = 0; i < mysql_num_fields(result); i++) {

74 printf("%10s ", row[i]);

75 }

76 printf("\n");

77 }

78 */

79

80

81

82

83 db_close();

84

85 printf("the garten program\n");

86 return 0;

87 }