diff growth.c @ 11:176ee28e7464

switched from mysql to sqlite; (+ some cleanups)
author meillo@marmaro.de
date Wed, 23 Jul 2008 11:41:38 +0200
parents b1e309dc0b98
children 8db6497d6065
line wrap: on
line diff
--- a/growth.c	Wed Jul 23 11:40:45 2008 +0200
+++ b/growth.c	Wed Jul 23 11:41:38 2008 +0200
@@ -1,6 +1,5 @@
 #include <stdio.h>
 #include <stdlib.h>
-#include <mysql.h>
 
 #include "db.h"
 #include "game.h"
@@ -16,15 +15,12 @@
 	sprintf(query, "select\
 			f.id, f.size, f.age, p.size, p.growspeed, p.age\
 			from field f\
-			join plant p on f.plant_id = p.id\
-			where f.game_id = '%d' ",
-			gameid);
+			join plant p on f.plant_id = p.id ");
 	db_query(query);
-	result = mysql_store_result(conn);
-	printf("number of plants to process: %d\n", (int)mysql_num_rows(result));
-	while ((row = mysql_fetch_row(result)) != NULL) {
+	/* printf("number of plants to process: %d\n", (int)mysql_num_rows(result)); */
+	while (sqlite3_step(stmt) == SQLITE_ROW) {
 		for (i = 0; i < 6; i++) {
-			r[i] = atoi(row[i]);
+			r[i] = (char) sqlite3_column_int(stmt, i);
 		}
 
 		sprintf(query, "update field set \
@@ -32,15 +28,16 @@
 				where id = '%d' ",
 				(r[1] + 1), r[2]+1, r[0]);
 		db_query(query);
+		;
 
-		if (mysql_affected_rows(conn) > 0) {
+		if (sqlite3_step(stmt) == SQLITE_DONE) {
 			printf("update successful  ++  %s\n", query);
 		} else {
-			printf("E: update failed  ++  %s\n", query);
+			printf("E: update failed  ++  %s\n", sqlite3_errmsg(db));
 		}
 
 	}
-	mysql_free_result(result);
+	sqlite3_finalize(stmt);
 
 
 
@@ -53,13 +50,13 @@
 
 	/* init */
 	if (argc != 2) {
-		printf("usage: %s <game>\n", argv[0]);
+		printf("usage: %s <database>\n", argv[0]);
 		exit(1);
 	}
-	gamename = argv[1];
+	database = argv[1];
 
 	db_connect();
-	check_game();
+	read_time();
 
 	grow_plants();