Implemented `dispense <item>`

[tpg/opendispense2.git] / src / cokebank_sqlite / main.c

diff --git a/src/cokebank_sqlite/main.c b/src/cokebank_sqlite/main.c
index 504ec4e..6165107 100644 (file)
--- 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 )
@@ -450,7 +456,7 @@ int Bank_GetUserAuth(const char *Salt, const char *Username, const char *Passwor
 {
        Salt = Password = Username;     // Shut up GCC
        // DEBUG HACKS!
-       #if 1
+       #if 0
        return Bank_GetAcctByName(Username);
        #else
        return -1;
@@ -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;
@@ -586,6 +592,7 @@ sqlite3_stmt *Bank_int_QuerySingle(sqlite3 *Database, const char *Query)
  */
 int Bank_int_IsValidName(const char *Name)
 {
+       if( !Name )     return 0;
        while(*Name)
        {
                if( *Name == '\'' )     return 0;