meillo@3: #include <stdio.h>
meillo@3: #include <stdlib.h>
meillo@3: #include <mysql.h>
meillo@3: 
meillo@3: #include "db.h"
meillo@3: #include "game.h"
meillo@3: 
meillo@3: 
meillo@3: 
meillo@3: 
meillo@3: void set_weather() {
meillo@3: 	int temperature, sun, rain, wind, humidity;
meillo@3: 
meillo@3: 	/* get last weather and calculate the next one *
meillo@3: 	sprintf(query, "select time from simulation where name = '%s' ", gamename);
meillo@3: 	db_query(query);
meillo@3: 	result = mysql_store_result(conn);
meillo@3: 	if (mysql_num_rows(result)) {
meillo@3: 		row = mysql_fetch_row(result);
meillo@3: 		time = atoi(row[0]);
meillo@3: 	}
meillo@3: 	mysql_free_result(result);
meillo@3: 	*/
meillo@3: 
meillo@3: 	temperature = 20;
meillo@3: 	sun = 5;
meillo@3: 	rain = 1;
meillo@3: 	wind = 10;
meillo@3: 	humidity = 40;
meillo@3: 
meillo@3: 
meillo@3: 	/* set weather */
meillo@3: 	sprintf(query, " insert into weather \
meillo@3: 			(tick, game_id, temperature, sun, rain, wind, humidity) \
meillo@3: 			values ('%d', '%d', '%d', '%d', '%d', '%d', '%d') ",
meillo@3: 			gametime, gameid, temperature, sun, rain, wind, humidity);
meillo@3: 	db_query(query);
meillo@3: 	if (mysql_affected_rows(conn) > 0) {
meillo@3: 		printf("weather successful inserted\n");
meillo@3: 	} else {
meillo@3: 		printf("E: weather insertion failed\n");
meillo@3: 	}
meillo@3: 
meillo@3: }
meillo@3: 
meillo@3: 
meillo@3: int main(int argc, char* argv[]) {
meillo@3: 	printf("  --> weather\n");
meillo@3: 
meillo@3: 	/* init */
meillo@3: 	if (argc != 2) {
meillo@3: 		printf("usage: %s <game>\n", argv[0]);
meillo@3: 		exit(1);
meillo@3: 	}
meillo@3: 	gamename = argv[1];
meillo@3: 
meillo@3: 	db_connect();
meillo@3: 	check_game();
meillo@3: 
meillo@3: 	set_weather();
meillo@3: 
meillo@3: 
meillo@3: 	db_close();
meillo@3: 
meillo@3: 	printf("  --< weather\n");
meillo@3: 	return 0;
meillo@3: }