Mercurial > garten

annotate environment.c @ 11:176ee28e7464

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
switched from mysql to sqlite; (+ some cleanups)
author meillo@marmaro.de
date Wed, 23 Jul 2008 11:41:38 +0200
parents e3679f888813
children 8db6497d6065
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
1 #include <stdio.h>
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
2 #include <stdlib.h>
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
3
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
4 #include "db.h"
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
5 #include "game.h"
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
7
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
8
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
9
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
10 void set_environment() {
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
11 int groundwater, slugs, earthworms;
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
12
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
13 /* get weather and last environments to calculate the next one *
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
14 sprintf(query, "select time from simulation");
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
15 db_query(query);
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
16 result = mysql_store_result(conn);
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
17 if (mysql_num_rows(result)) {
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
18 row = mysql_fetch_row(result);
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
19 time = atoi(row[0]);
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
20 }
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
21 mysql_free_result(result);
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
22 */
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
23
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
24 groundwater = 20;
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
25 slugs = 5;
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
26 earthworms = 10;
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
27
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
28
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
29 /* set weather */
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
30 sprintf(query, " insert into environment \
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
31 (tick, groundwater, slugs, earthworms) \
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
32 values ('%d', '%d', '%d', '%d') ",
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
33 gametime, groundwater, slugs, earthworms);
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
34 db_query(query);
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
35 if (sqlite3_step(stmt) == SQLITE_DONE) {
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
36 printf("environment successful inserted\n");
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
37 } else {
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
38 printf("error: environment insertion failed: %s\n", sqlite3_errmsg(db));
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
39 }
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
40
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
41 }
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
42
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
43
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
44 int main(int argc, char* argv[]) {
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
45 printf(" --> environment\n");
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
46
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
47 /* init */
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
48 if (argc != 2) {
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
49 printf("usage: %s <database>\n", argv[0]);
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
50 exit(1);
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
51 }
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
52 database = argv[1];
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
53
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
54 db_connect();
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 6
diff changeset
55 read_time();
6
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
56
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
57 set_environment();
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
58
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
59
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
60 db_close();
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
61
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
62 printf(" --< environment\n");
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
63 return 0;
e3679f888813 added environment module (only static code)
meillo@marmaro.de
parents:
diff changeset
64 }