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 diff
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