dashed-slug.net › Forums › TurtleCoin Adapter extension support › Balance vs Available Balance.
Tagged: available balance, balance, user balances
- This topic has 5 replies, 2 voices, and was last updated 1 month, 2 weeks ago by
alexg.
-
AuthorPosts
-
November 21, 2020 at 11:59 pm #9492
d3vnu77
ParticipantYou will notice the is a balance of 127.02 ARMS in a users wallet vs and available balance of 5217.24 ARMS in a uses wallet. What is correct and why is it displaying 127.02 as the balance when there is more in that users wallet than that?
Attachments:
You must be logged in to view attached files.November 23, 2020 at 9:07 am #9497alexg
KeymasterHello,
I am currently investigating what could be the issue here.
In the mean time, can you please tell me if you are on a multisite installation, and if so, is the plugin network-activated?
with regards
November 23, 2020 at 9:55 am #9499alexg
KeymasterIn addition to the above, please do the following:
1. Determine the user_id of this user. If you click on the user name, the user’s admin profile link will contain the user id.
2. Please run the following query, substituting USER_ID with the actual id number.
SELECT account, symbol, category, status, amount, fee FROM wp_wallets_txs WHERE account = USER_ID AND symbol = 'ARMS' AND ( ( amount < 0 && status IN ( 'unconfirmed', 'pending', 'done' ) ) OR ( amount > 0 && status = 'done' ) ) ORDER BY id;
3. Email me the result so I can determine the issue. Please send me the result as text rather than a screenshot, if possible.
To give you some background:
The user’s balance is the sum of the user’s transactions in a
done
state. Normally it is calculated here, but for this particular admin screen, it is calculated here.The user’s “available balance”, is the sum of all the user’s transactions in a
done
state, plus any crediting transactions (amount<0) that are in anunconfirmed
orpending
state. It is always calculated with this code.Thus, the “available balance” includes any outstanding withdrawals and transfers to other users, but not any outstanding deposits. It’s essentially the maximum amount that a user can withdraw, and should always be less than the total user’s balance.
Since in this case it is larger, I will need to go through each transaction to see what the problem is.
Looking forward to your reply.
with regards
November 29, 2020 at 3:43 pm #9513d3vnu77
ParticipantSorry for the delay, took a nice Thanksgiving holiday.
Yes, it is on a multisite installation. Yes, it is network activated.
November 29, 2020 at 3:52 pm #9515d3vnu77
ParticipantEmailed you in this regard.
November 30, 2020 at 11:48 am #9520alexg
KeymasterThank you. I have replied to your email.
-
AuthorPosts
- You must be logged in to reply to this topic.