merchant

commit 1c1ec9c54e09e9b90ea7a91e81bf5a6eb878c53b
parent fd8a415ed428b9a524a49cf73c75933420eba508
Author: Sebastian <sebasjm@gmail.com>
Date:   Sat, 16 Dec 2023 01:20:43 -0300

hide deactivated accounts

Diffstat:
M
src/backenddb/pg_select_accounts.c
 | 
9
+++++----

1 file changed, 5 insertions(+), 4 deletions(-)
diff --git 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,