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;
}