meillo@6: #include <stdio.h>
meillo@6: #include <stdlib.h>
meillo@6: #include "db.h"
meillo@6: 
meillo@6: 
meillo@18: int set_environment() {
meillo@6: 	int groundwater, slugs, earthworms;
meillo@6: 
meillo@6: 	/* get weather and last environments to calculate the next one *
meillo@11: 	sprintf(query, "select time from simulation");
meillo@6: 	db_query(query);
meillo@6: 	result = mysql_store_result(conn);
meillo@6: 	if (mysql_num_rows(result)) {
meillo@6: 		row = mysql_fetch_row(result);
meillo@6: 		time = atoi(row[0]);
meillo@6: 	}
meillo@6: 	mysql_free_result(result);
meillo@6: 	*/
meillo@6: 
meillo@6: 	groundwater = 20;
meillo@6: 	slugs = 5;
meillo@6: 	earthworms = 10;
meillo@6: 
meillo@6: 	/* set weather */
meillo@17: 	sprintf(query,
meillo@17: 			"insert into environment "
meillo@17: 			"(tick, groundwater, slugs, earthworms) "
meillo@17: 			"values ('%d', '%d', '%d', '%d') "
meillo@17: 			, gametime
meillo@17: 			, groundwater
meillo@17: 			, slugs
meillo@17: 			, earthworms
meillo@17: 			);
meillo@12: 	if (!db_update(query)) {
meillo@17: 		db_error("environment insertion");
meillo@18: 		return 0;
meillo@6: 	}
meillo@18: 	return 1;
meillo@6: }
meillo@6: 
meillo@6: 
meillo@18: int environment(void) {
meillo@18: 	return set_environment();
meillo@6: }