Mercurial > garten
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(); }