#include "../cokebank.h"
#include <sqlite3.h>
-#define DEBUG 1
+#define DEBUG 0
const char * const csBank_DatabaseSetup =
"CREATE TABLE IF NOT EXISTS accounts ("
return 1;
}
- Log_Info("SQLite database rebuilt");
+ Log_Info("SQLite database rebuilt (%s)", Argument);
}
else
{
// Take from the source
query = mkstr("UPDATE accounts SET acct_balance=acct_balance-%i,acct_last_seen=datetime('now') WHERE acct_id=%i", Ammount, SourceUser);
- printf("query = \"%s\"\n", query);
+// printf("query = \"%s\"\n", query);
rv = sqlite3_exec(gBank_Database, query, NULL, NULL, &errmsg);
free(query);
if( rv != SQLITE_OK )
// Give to the destination
query = mkstr("UPDATE accounts SET acct_balance=acct_balance+%i,acct_last_seen=datetime('now') WHERE acct_id=%i", Ammount, DestUser);
- printf("query = \"%s\"\n", query);
+// printf("query = \"%s\"\n", query);
rv = sqlite3_exec(gBank_Database, query, NULL, NULL, &errmsg);
free(query);
if( rv != SQLITE_OK )
);
#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 )
{
Salt = Password = Username; // Shut up GCC
// DEBUG HACKS!
- #if 1
+ #if 0
return Bank_GetAcctByName(Username);
#else
return -1;
// 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;
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;
return NULL;
}
- #if DEBUG
+ #if DEBUG >= 2
printf("Bank_int_QuerySingle: RETURN %p\n", ret);
#endif
return ret;
*/
int Bank_int_IsValidName(const char *Name)
{
+ if( !Name ) return 0;
while(*Name)
{
if( *Name == '\'' ) return 0;