Mercurial > garten
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 |
rev | line source |
---|---|
0 | 1 #include <stdio.h> |
2 #include <stdlib.h> | |
3 #include "db.h" | |
4 | |
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 | 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 | 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 | 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 | 15 } |
11
176ee28e7464
switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents:
2
diff
changeset
|
16 sqlite3_finalize(stmt); |
0 | 17 |
18 /* increment time */ | |
17 | 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 | 21 "set time = '%d';" |
22 , ++gametime | |
23 ); | |
12 | 24 if (!db_update(query)) { |
17 | 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 | 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 | 29 } |
30 | |
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 | 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 | 39 } |