view environment.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 set_environment() {
	int groundwater, slugs, earthworms;

	/* get weather and last environments to calculate the next one *
	sprintf(query, "select time from simulation");
	db_query(query);
	result = mysql_store_result(conn);
	if (mysql_num_rows(result)) {
		row = mysql_fetch_row(result);
		time = atoi(row[0]);
	}
	mysql_free_result(result);
	*/

	groundwater = 20;
	slugs = 5;
	earthworms = 10;

	/* set weather */
	sprintf(query,
			"insert into environment "
			"(tick, groundwater, slugs, earthworms) "
			"values ('%d', '%d', '%d', '%d') "
			, gametime
			, groundwater
			, slugs
			, earthworms
			);
	if (!db_update(query)) {
		db_error("environment insertion");
		return 0;
	}
	return 1;
}


int environment(void) {
	return set_environment();
}