annotate clock.c @ 20:17b2bcc42d72 default tip

added check for empty result; minor stuff
author meillo@marmaro.de
date Sun, 27 Jul 2008 21:34:54 +0200
parents 5937504619f2
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
1 #include <stdio.h>
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
2 #include <stdlib.h>
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
3 #include "db.h"
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
4
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
5
18
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
6 int inc_time() {
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
7 /* get current time */
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 2
diff changeset
8 sprintf(query, "select time from game;");
17
5e6c9260913a lots of cleanups and small fixes
meillo@marmaro.de
parents: 12
diff changeset
9 stmt = db_query(query);
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 2
diff changeset
10 if (sqlite3_step(stmt) == SQLITE_ROW) {
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 2
diff changeset
11 gametime = sqlite3_column_int(stmt, 0);
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 2
diff changeset
12 } else {
17
5e6c9260913a lots of cleanups and small fixes
meillo@marmaro.de
parents: 12
diff changeset
13 db_error("get current time");
18
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
14 return 0;
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
15 }
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 2
diff changeset
16 sqlite3_finalize(stmt);
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
17
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
18 /* increment time */
17
5e6c9260913a lots of cleanups and small fixes
meillo@marmaro.de
parents: 12
diff changeset
19 sprintf(query,
18
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
20 "update game "
17
5e6c9260913a lots of cleanups and small fixes
meillo@marmaro.de
parents: 12
diff changeset
21 "set time = '%d';"
5e6c9260913a lots of cleanups and small fixes
meillo@marmaro.de
parents: 12
diff changeset
22 , ++gametime
5e6c9260913a lots of cleanups and small fixes
meillo@marmaro.de
parents: 12
diff changeset
23 );
12
8db6497d6065 merged everything to only one program
meillo@marmaro.de
parents: 11
diff changeset
24 if (!db_update(query)) {
17
5e6c9260913a lots of cleanups and small fixes
meillo@marmaro.de
parents: 12
diff changeset
25 db_error("time update");
18
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
26 return 0;
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
27 }
18
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
28 return 1;
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
29 }
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
30
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
31
18
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
32 int worldclock(void) {
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
33 int ret;
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
34
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
35 ret = inc_time();
12
8db6497d6065 merged everything to only one program
meillo@marmaro.de
parents: 11
diff changeset
36 printf("gametime: %d\n", gametime);
18
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
37
5937504619f2 rename game.h -> modules.h; added some error handling; and more
meillo@marmaro.de
parents: 17
diff changeset
38 return ret;
0
831599184108 inital commit
meillo@marmaro.de
parents:
diff changeset
39 }