summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSebastian <sebasjm@gmail.com>2023-12-16 01:20:43 -0300
committerSebastian <sebasjm@gmail.com>2023-12-16 01:20:43 -0300
commit1c1ec9c54e09e9b90ea7a91e81bf5a6eb878c53b (patch)
treee3e19b60620a3bf0b84c046e4edcbae339202507
parentfd8a415ed428b9a524a49cf73c75933420eba508 (diff)
downloadmerchant-1c1ec9c54e09e9b90ea7a91e81bf5a6eb878c53b.tar.gz
merchant-1c1ec9c54e09e9b90ea7a91e81bf5a6eb878c53b.tar.bz2
merchant-1c1ec9c54e09e9b90ea7a91e81bf5a6eb878c53b.zip
hide deactivated accounts
-rw-r--r--src/backenddb/pg_select_accounts.c9
1 files changed, 5 insertions, 4 deletions
diff --git a/src/backenddb/pg_select_accounts.c b/src/backenddb/pg_select_accounts.c
index cf15a765..ffb6c4c9 100644
--- a/src/backenddb/pg_select_accounts.c
+++ b/src/backenddb/pg_select_accounts.c
@@ -143,10 +143,11 @@ TMH_PG_select_accounts (void *cls,
",credit_facade_credentials"
",active"
" FROM merchant_accounts"
- " WHERE merchant_serial="
- " (SELECT merchant_serial "
- " FROM merchant_instances"
- " WHERE merchant_id=$1);");
+ " WHERE active"
+ " AND merchant_serial="
+ " (SELECT merchant_serial "
+ " FROM merchant_instances"
+ " WHERE merchant_id=$1);");
qs = GNUNET_PQ_eval_prepared_multi_select (pg->conn,
"select_accounts",
params,