Mercurial > garten

annotate weather.c @ 5:26ca6c79fc22

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added a Makefile (which needs improvement)
author meillo@marmaro.de
date Wed, 14 May 2008 21:10:45 +0200
parents 0c19ad487f02
children 9bd0a2100694
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
1 #include <stdio.h>
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
2 #include <stdlib.h>
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
3 #include <mysql.h>
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
4
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
5 #include "db.h"
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
6 #include "game.h"
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
7
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
8
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
9
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
10
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
11 void set_weather() {
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
12 int temperature, sun, rain, wind, humidity;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
13
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
14 /* get last weather and calculate the next one *
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
15 sprintf(query, "select time from simulation where name = '%s' ", gamename);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
16 db_query(query);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
17 result = mysql_store_result(conn);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
18 if (mysql_num_rows(result)) {
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
19 row = mysql_fetch_row(result);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
20 time = atoi(row[0]);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
21 }
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
22 mysql_free_result(result);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
23 */
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
24
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
25 temperature = 20;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
26 sun = 5;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
27 rain = 1;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
28 wind = 10;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
29 humidity = 40;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
30
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
31
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
32 /* set weather */
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
33 sprintf(query, " insert into weather \
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
34 (tick, game_id, temperature, sun, rain, wind, humidity) \
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
35 values ('%d', '%d', '%d', '%d', '%d', '%d', '%d') ",
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
36 gametime, gameid, temperature, sun, rain, wind, humidity);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
37 db_query(query);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
38 if (mysql_affected_rows(conn) > 0) {
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
39 printf("weather successful inserted\n");
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
40 } else {
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
41 printf("E: weather insertion failed\n");
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
42 }
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
43
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
44 }
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
45
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
46
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
47 int main(int argc, char* argv[]) {
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
48 printf(" --> weather\n");
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
49
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
50 /* init */
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
51 if (argc != 2) {
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
52 printf("usage: %s <game>\n", argv[0]);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
53 exit(1);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
54 }
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
55 gamename = argv[1];
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
56
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
57 db_connect();
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
58 check_game();
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
59
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
60 set_weather();
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
61
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
62
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
63 db_close();
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
64
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
65 printf(" --< weather\n");
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
66 return 0;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
67 }