annotate clock.c @ 11:176ee28e7464
switched from mysql to sqlite; (+ some cleanups)
| author |
meillo@marmaro.de |
| date |
Wed, 23 Jul 2008 11:41:38 +0200 |
| parents |
8369454d4ec9 |
| children |
8db6497d6065 |
| rev |
line source |
|
meillo@0
|
1 #include <stdio.h>
|
|
meillo@0
|
2 #include <stdlib.h>
|
|
meillo@0
|
3
|
|
meillo@0
|
4 #include "db.h"
|
|
meillo@2
|
5 #include "game.h"
|
|
meillo@0
|
6
|
|
meillo@0
|
7
|
|
meillo@0
|
8
|
|
meillo@2
|
9 void inc_time() {
|
|
meillo@0
|
10 /* get current time */
|
|
meillo@11
|
11 sprintf(query, "select time from game;");
|
|
meillo@0
|
12 db_query(query);
|
|
meillo@11
|
13 if (sqlite3_step(stmt) == SQLITE_ROW) {
|
|
meillo@11
|
14 gametime = sqlite3_column_int(stmt, 0);
|
|
meillo@11
|
15 printf("gametime: %d\n", gametime);
|
|
meillo@11
|
16 } else {
|
|
meillo@11
|
17 fprintf(stderr, "error: %s\n", sqlite3_errmsg(db));
|
|
meillo@0
|
18 }
|
|
meillo@11
|
19 sqlite3_finalize(stmt);
|
|
meillo@0
|
20
|
|
meillo@0
|
21 /* increment time */
|
|
meillo@11
|
22 sprintf(query, " update game set time = '%d';", ++gametime);
|
|
meillo@0
|
23 db_query(query);
|
|
meillo@11
|
24 if (sqlite3_step(stmt) == SQLITE_DONE) {
|
|
meillo@0
|
25 printf("time update successful\n");
|
|
meillo@2
|
26 printf("virtual time: %d\n", gametime);
|
|
meillo@0
|
27 } else {
|
|
meillo@11
|
28 printf("error: time update failed: %s\n", sqlite3_errmsg(db));
|
|
meillo@0
|
29 }
|
|
meillo@11
|
30 sqlite3_finalize(stmt);
|
|
meillo@0
|
31 }
|
|
meillo@0
|
32
|
|
meillo@0
|
33
|
|
meillo@0
|
34 int main(int argc, char* argv[]) {
|
|
meillo@2
|
35 printf(" --> clock\n");
|
|
meillo@0
|
36
|
|
meillo@0
|
37 /* init */
|
|
meillo@0
|
38 if (argc != 2) {
|
|
meillo@0
|
39 printf("usage: %s <game>\n", argv[0]);
|
|
meillo@0
|
40 exit(1);
|
|
meillo@0
|
41 }
|
|
meillo@11
|
42 database = argv[1];
|
|
meillo@0
|
43
|
|
meillo@2
|
44 db_connect();
|
|
meillo@11
|
45 read_time();
|
|
meillo@0
|
46
|
|
meillo@2
|
47 inc_time();
|
|
meillo@0
|
48
|
|
meillo@0
|
49 /*
|
|
meillo@0
|
50 while ((row = mysql_fetch_row(result)) != NULL) {
|
|
meillo@0
|
51 for (i = 0; i < mysql_num_fields(result); i++) {
|
|
meillo@0
|
52 printf("%10s ", row[i]);
|
|
meillo@0
|
53 }
|
|
meillo@0
|
54 printf("\n");
|
|
meillo@0
|
55 }
|
|
meillo@0
|
56 */
|
|
meillo@0
|
57
|
|
meillo@0
|
58
|
|
meillo@0
|
59
|
|
meillo@0
|
60
|
|
meillo@0
|
61 db_close();
|
|
meillo@0
|
62
|
|
meillo@2
|
63 printf(" --< clock\n");
|
|
meillo@0
|
64 return 0;
|
|
meillo@0
|
65 }
|
