1.1 --- a/growth.c	Wed Jul 23 11:40:45 2008 +0200
     1.2 +++ b/growth.c	Wed Jul 23 11:41:38 2008 +0200
     1.3 @@ -1,6 +1,5 @@
     1.4  #include <stdio.h>
     1.5  #include <stdlib.h>
     1.6 -#include <mysql.h>
     1.7  
     1.8  #include "db.h"
     1.9  #include "game.h"
    1.10 @@ -16,15 +15,12 @@
    1.11  	sprintf(query, "select\
    1.12  			f.id, f.size, f.age, p.size, p.growspeed, p.age\
    1.13  			from field f\
    1.14 -			join plant p on f.plant_id = p.id\
    1.15 -			where f.game_id = '%d' ",
    1.16 -			gameid);
    1.17 +			join plant p on f.plant_id = p.id ");
    1.18  	db_query(query);
    1.19 -	result = mysql_store_result(conn);
    1.20 -	printf("number of plants to process: %d\n", (int)mysql_num_rows(result));
    1.21 -	while ((row = mysql_fetch_row(result)) != NULL) {
    1.22 +	/* printf("number of plants to process: %d\n", (int)mysql_num_rows(result)); */
    1.23 +	while (sqlite3_step(stmt) == SQLITE_ROW) {
    1.24  		for (i = 0; i < 6; i++) {
    1.25 -			r[i] = atoi(row[i]);
    1.26 +			r[i] = (char) sqlite3_column_int(stmt, i);
    1.27  		}
    1.28  
    1.29  		sprintf(query, "update field set \
    1.30 @@ -32,15 +28,16 @@
    1.31  				where id = '%d' ",
    1.32  				(r[1] + 1), r[2]+1, r[0]);
    1.33  		db_query(query);
    1.34 +		;
    1.35  
    1.36 -		if (mysql_affected_rows(conn) > 0) {
    1.37 +		if (sqlite3_step(stmt) == SQLITE_DONE) {
    1.38  			printf("update successful  ++  %s\n", query);
    1.39  		} else {
    1.40 -			printf("E: update failed  ++  %s\n", query);
    1.41 +			printf("E: update failed  ++  %s\n", sqlite3_errmsg(db));
    1.42  		}
    1.43  
    1.44  	}
    1.45 -	mysql_free_result(result);
    1.46 +	sqlite3_finalize(stmt);
    1.47  
    1.48  
    1.49  
    1.50 @@ -53,13 +50,13 @@
    1.51  
    1.52  	/* init */
    1.53  	if (argc != 2) {
    1.54 -		printf("usage: %s <game>\n", argv[0]);
    1.55 +		printf("usage: %s <database>\n", argv[0]);
    1.56  		exit(1);
    1.57  	}
    1.58 -	gamename = argv[1];
    1.59 +	database = argv[1];
    1.60  
    1.61  	db_connect();
    1.62 -	check_game();
    1.63 +	read_time();
    1.64  
    1.65  	grow_plants();
    1.66