X-Git-Url: https://git.ucc.asn.au/?a=blobdiff_plain;f=src%2Fcokebank_sqlite%2Fmain.c;h=ef87b7bdd5c053b089a27139c0ca7bda07d39bb3;hb=72bf1b1bf64523fa64c2ee9c8617a4b47776d4db;hp=504ec4e58ec5fb9e24ed7dc6aecf85ca0701189d;hpb=9c119e47d915602306488e37909cf500898b722b;p=tpg%2Fopendispense2.git

diff --git a/src/cokebank_sqlite/main.c b/src/cokebank_sqlite/main.c
index 504ec4e..ef87b7b 100644
--- a/src/cokebank_sqlite/main.c
+++ b/src/cokebank_sqlite/main.c
@@ -15,6 +15,8 @@
 #include "../cokebank.h"
 #include <sqlite3.h>
 
+#define DEBUG	1
+
 const char * const csBank_DatabaseSetup = 
 "CREATE TABLE IF NOT EXISTS accounts ("
 "	acct_id INTEGER PRIMARY KEY NOT NULL,"
@@ -218,6 +220,10 @@ int Bank_SetFlags(int UserID, int Mask, int Value)
 		);
 	#undef MAP_FLAG
 
+	#if DEBUG
+	printf("Bank_SetFlags: query=\"%s\"\n", query);
+	#endif
+
 	// Execute Query
 	rv = sqlite3_exec(gBank_Database, query, NULL, NULL, &errmsg);
 	if( rv != SQLITE_OK )
@@ -553,7 +559,7 @@ sqlite3_stmt *Bank_int_QuerySingle(sqlite3 *Database, const char *Query)
 	// Prepare query
 	ret = Bank_int_MakeStatemnt(Database, Query);
 	if( !ret ) {
-		#if DEBUG
+		#if DEBUG >= 2
 		printf("Bank_int_QuerySingle: RETURN NULL ret=NULL\n");
 		#endif
 		return NULL;
@@ -563,7 +569,7 @@ sqlite3_stmt *Bank_int_QuerySingle(sqlite3 *Database, const char *Query)
 	rv = sqlite3_step(ret);
 	// - Empty result set
 	if( rv == SQLITE_DONE ) {
-		#if DEBUG
+		#if DEBUG >= 2
 		printf("Bank_int_QuerySingle: RETURN NULL (rv == SQLITE_DONE)\n");
 		#endif
 		return NULL;
@@ -575,7 +581,7 @@ sqlite3_stmt *Bank_int_QuerySingle(sqlite3 *Database, const char *Query)
 		return NULL;
 	}
 	
-	#if DEBUG
+	#if DEBUG >= 2
 	printf("Bank_int_QuerySingle: RETURN %p\n", ret);
 	#endif
 	return ret;