From 58d04319139a590473e556ad9017e18127bfc70c Mon Sep 17 00:00:00 2001
From: Oliver Schinagl <oliver@schinagl.nl>
Date: Wed, 7 May 2008 09:31:33 +0000
Subject: cleaned

---
 reset/reset.c | 71 ++++++++---------------------------------------------------
 1 file changed, 9 insertions(+), 62 deletions(-)

diff --git a/reset/reset.c b/reset/reset.c
index b52f5c4..5a851ca 100644
--- a/reset/reset.c
+++ b/reset/reset.c
@@ -12,37 +12,12 @@
 #include <libpq-fe.h>
 
 int main(int argc, char *argv[]) {
-	int i;
-	int options;
-	int day;
-	int month;
-	int year;
 	PGconn *conn;
 	char SQL_query[512];
 	PGresult *res;
 
-	day = month = year = 0;
-	
 	conn = PQsetdbLogin(PGHOST, PGPORT, PGOPTIONS, PGTTY, DBNAME, LOGIN, PWD);
 
-	for(;-1 != (options = getopt(argc, argv, "hdmya"));) {
-		if('h' == options) {
-			printf(LONGHELP);
-		}
-		if('d' == options) {
-			day = 23;
-		}
-		if('m' == options) {
-			month = 31;
-		}
-		if('y' == options) {
-			year = 1;
-		}
-		if('a' == options) {
-			day = 23;
-			month = 31;
-		}
-	}
 
 	if(CONNECTION_BAD == PQstatus(conn)) {
 		fprintf(stderr, "Connection to database '%s' failed.\n %s", DBNAME, PQerrorMessage(conn));
@@ -50,46 +25,18 @@ int main(int argc, char *argv[]) {
 		return 1;
 	}
 	
-	if(0 < day) {
-		for(i = 0; i <= day; i++) {
-			sprintf(SQL_query, "UPDATE counter_day SET \"%0.2d\" = 0;", i);
-			res = PQexec(conn, SQL_query);
-			
-			if((NULL == res) || (PGRES_COMMAND_OK != PQresultStatus(res))) {
-				printf("Unable to execute query: %s\n %s\n", SQL_query, PQerrorMessage(conn));
-				PQclear(res);
-				PQfinish(conn);
-				return 1;
-			}
-			PQclear(res);
-		}
-	}
-	if(0 < month) {
-		for(i = 1; i <= month; i++) {
-			sprintf(SQL_query, "UPDATE counter_month SET \"%0.2d\" = 0;", i);
-			res = PQexec(conn, SQL_query);
-
-			if((NULL == res) || (PGRES_COMMAND_OK != PQresultStatus(res))) {
-				printf("Unable to execute query: %s\n %s\n", SQL_query, PQerrorMessage(conn));
-				PQclear(res);
-				PQfinish(conn);
-				return 1;
-			}
-			PQclear(res);
-		}
-	}
-	if(1 == year) {
-		sprintf(SQL_query, "INSERT INTO counter_year VALUES (counter_year.year +1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);");
-		res = PQexec(conn, SQL_query);
+	sprintf(SQL_query, "");
+	res = PQexec(conn, SQL_query);
 
-		if((NULL == res) || (PGRES_COMMAND_OK != PQresultStatus(res))) {
-			printf("Unable to execute query: %s\n %s\n", SQL_query, PQerrorMessage(conn));
-			PQclear(res);
-			PQfinish(conn);
-			return 1;
-		}
+			
+	if((NULL == res) || (PGRES_COMMAND_OK != PQresultStatus(res))) {
+		printf("Unable to execute query: %s\n %s\n", SQL_query, PQerrorMessage(conn));
 		PQclear(res);
+		PQfinish(conn);
+		return 1;
 	}
+	PQclear(res);
+
 	PQfinish(conn);
 
 	return 0;
-- 
cgit v0.12