Mercurial > garten
view 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 |
line wrap: on
line source
#include <stdio.h> #include <stdlib.h> #include "db.h" int inc_time() { /* get current time */ sprintf(query, "select time from game;"); stmt = db_query(query); if (sqlite3_step(stmt) == SQLITE_ROW) { gametime = sqlite3_column_int(stmt, 0); } else { db_error("get current time"); return 0; } sqlite3_finalize(stmt); /* increment time */ sprintf(query, "update game " "set time = '%d';" , ++gametime ); if (!db_update(query)) { db_error("time update"); return 0; } return 1; } int worldclock(void) { int ret; ret = inc_time(); printf("gametime: %d\n", gametime); return ret; }