btcpay-admin.sh

#!/bin/bash
query()
{
  PASS=$(</etc/nodl/maria-btcpay.pwd)
  echo "$*" | mysql -u btcpay -p$PASS btcpay
}

case "$1" in
  disable-multifactor)
    query "DELETE FROM U2FDevices WHERE ApplicationUserId = (SELECT Id FROM AspNetUsers WHERE upper('$2') = NormalizedEmail)"
    query "UPDATE AspNetUsers SET TwoFactorEnabled=false WHERE upper('\$2') = NormalizedEmail"
    ;;
  set-user-admin)
    query "INSERT INTO AspNetUserRoles Values ( (SELECT Id FROM AspNetUsers WHERE upper('$2') = NormalizedEmail), (SELECT Id FROM AspNetRoles WHERE NormalizedName='SERVERADMIN'))"
    ;;
  reset-server-policy)
    query "DELETE FROM Settings WHERE Id = 'BTCPayServer.Services.PoliciesSettings'"
    ;;
  *)
    echo "Usage: $0 [command]"
    echo
    echo "Commands:"
    echo "         disable-multifactor <email>"
    echo "         set-user-admin <email>"
    echo "         reset-server-policy"
esac

exit 0