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