garten
view 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 |
line source
1 #include <stdio.h>
2 #include <stdlib.h>
4 #include "db.h"
5 #include "game.h"
9 void inc_time() {
10 /* get current time */
11 sprintf(query, "select time from game;");
12 db_query(query);
13 if (sqlite3_step(stmt) == SQLITE_ROW) {
14 gametime = sqlite3_column_int(stmt, 0);
15 printf("gametime: %d\n", gametime);
16 } else {
17 fprintf(stderr, "error: %s\n", sqlite3_errmsg(db));
18 }
19 sqlite3_finalize(stmt);
21 /* increment time */
22 sprintf(query, " update game set time = '%d';", ++gametime);
23 db_query(query);
24 if (sqlite3_step(stmt) == SQLITE_DONE) {
25 printf("time update successful\n");
26 printf("virtual time: %d\n", gametime);
27 } else {
28 printf("error: time update failed: %s\n", sqlite3_errmsg(db));
29 }
30 sqlite3_finalize(stmt);
31 }
34 int main(int argc, char* argv[]) {
35 printf(" --> clock\n");
37 /* init */
38 if (argc != 2) {
39 printf("usage: %s <game>\n", argv[0]);
40 exit(1);
41 }
42 database = argv[1];
44 db_connect();
45 read_time();
47 inc_time();
49 /*
50 while ((row = mysql_fetch_row(result)) != NULL) {
51 for (i = 0; i < mysql_num_fields(result); i++) {
52 printf("%10s ", row[i]);
53 }
54 printf("\n");
55 }
56 */
61 db_close();
63 printf(" --< clock\n");
64 return 0;
65 }