meillo@6: #include <stdio.h>
meillo@6: #include <stdlib.h>
meillo@6: #include "db.h"
meillo@6: #include "game.h"
meillo@6: 
meillo@6: 
meillo@6: void 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: 
meillo@6: 	/* set weather */
meillo@6: 	sprintf(query, " insert into environment \
meillo@11: 			(tick, groundwater, slugs, earthworms) \
meillo@11: 			values ('%d', '%d', '%d', '%d') ",
meillo@11: 			gametime, groundwater, slugs, earthworms);
meillo@12: 	if (!db_update(query)) {
meillo@11: 		printf("error: environment insertion failed: %s\n", sqlite3_errmsg(db));
meillo@6: 	}
meillo@6: 
meillo@6: }
meillo@6: 
meillo@6: 
meillo@12: void environment(void) {
meillo@6: 	set_environment();
meillo@6: }