1 #include <stdio.h>

2 #include <stdlib.h>

3 #include <mysql.h>

4

5 #include "db.h"

6 #include "game.h"

7

8

9

10

11 void grow_plants() {

12 int i;

13 unsigned char r[6];

14

15 /* get weather and last environments to calculate the next one */

16 sprintf(query, "select\

17 f.id, f.size, f.age, p.size, p.growspeed, p.age\

18 from field f\

19 join plant p on f.plant_id = p.id\

20 where f.game_id = '%d' ",

21 gameid);

22 db_query(query);

23 result = mysql_store_result(conn);

24 printf("number of plants to process: %d\n", (int)mysql_num_rows(result));

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

26 for (i = 0; i < 6; i++) {

27 r[i] = atoi(row[i]);

28 }

29

30 sprintf(query, "update field set \

31 size = '%d', age = '%d' \

32 where id = '%d' ",

33 (r[1] + 1), r[2]+1, r[0]);

34 db_query(query);

35

36 if (mysql_affected_rows(conn) > 0) {

37 printf("update successful ++ %s\n", query);

38 } else {

39 printf("E: update failed ++ %s\n", query);

40 }

41

42 }

43 mysql_free_result(result);

44

45

46

47

48 }

49

50

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

52 printf(" --> %s\n", argv[0]);

53

54 /* init */

55 if (argc != 2) {

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

57 exit(1);

58 }

59 gamename = argv[1];

60

61 db_connect();

62 check_game();

63

64 grow_plants();

65

66

67 db_close();

68

69 printf(" --< %s\n", argv[0]);

70 return 0;

71 }