Bug Manually changing usergroups *sometimes* deducts credits

[colcar]

Hi, I've noticed that occasionally when I switch a user to a new usergroup it might deduct a random amount of credits from their balance, the transaction log simply says it's an action by the "administrator" but I haven't set any process up that would do that.

When I try to test switching usergroups again it doesn't do it, just seems to happen at random times.

See the two users I changed usergroups below

A few weeks ago it took 36,681,939 credits from a user for no reason, so this isn't an insignificant problem.

 

[Fillip H.]

This happens if you modify the fields on the DB Credits tab when editing the user.

 

[colcar]

This happens if you modify the fields on the DB Credits tab when editing the user.

"modify the fields on the DB Credits tab"? I'm not doing that, not even sure what that means to be honest.

 

[Fillip H.]

The last two tabs there. Changes in those fields, or if they're out of sync with the database somehow, will cause an adjustment like the one seen in those logs.

 

[colcar]

View attachment 10041

The last two tabs there. Changes in those fields, or if they're out of sync with the database somehow, will cause an adjustment like the one seen in those logs.

Ok, I wasn't going into those tabs but you've given me an idea of what might be causing the problem.

I keep Chrome tabs open on the "Edit User" page of a few users that I have to edit the usergroups of frequently to save me for having to search for them constantly.

Is it possible that by editing a user on one Chrome tab, then going to another Chrome tab to edit another user without first refreshing the page could cause this issue?

 

[Fillip H.]

Is it possible that by editing a user on one Chrome tab, then going to another Chrome tab to edit another user without first refreshing the page could cause this issue?

No, but the fact that you keep those tabs open is what's causing the issue. Any credits earned between the last time you opened the tab, and the time you save their edits, will be lost unless you reload the tabs before making the edits.

 

[colcar]

Ok thanks, I'll keep an eye on that in future.

One more thing, is there a database query I can use that will give an entire usergroup a specific amount of credits?

I pay my VIP members a monthly paycheck based on what level VIP they are and at the moment I am having to Adjust each member manually, which takes a long time.

 

[Fillip H.]

I would recommend using the Paycheck event, rather than manually adjusting them.

 

[colcar]

I would recommend using the Paycheck event, rather than manually adjusting them.

I tried that once and it did not work very well. Is there a way to do it with a database query?

 

[Fillip H.]

Using database queries would not write entries to the transaction log, so it's unsupported. You would need to update the relevant column in the xf_user table.

 

[colcar]

Ok thanks, I know I'm asking a lot but could you tell me how that is done?

 

[Fillip H.]

Entirely untested, but something like UPDATE xf_user SET dbtech_credits_credits = dbtech_credits_credits + 1 WHERE FIND_IN_SET(secondary_group_ids, 1) to give people with secondary group ID 1 an extra 1 credits.

 

[colcar]

Entirely untested, but something like UPDATE xf_user SET dbtech_credits_credits = dbtech_credits_credits + 1 WHERE FIND_IN_SET(secondary_group_ids, 1) to give people with secondary group ID 1 an extra 1 credits.

Thanks for that. I gave it a try and got Matched Rows: 0 unfortunately.

 

[Fillip H.]

Looks like the argument order was flipped, it should be UPDATE xf_user SET dbtech_credits_credits = dbtech_credits_credits + 1 WHERE FIND_IN_SET(1, secondary_group_ids)

Source: https://www.w3schools.com/SQL/func_mysql_find_in_set.asp

 

[colcar]

Looks like the argument order was flipped, it should be UPDATE xf_user SET dbtech_credits_credits = dbtech_credits_credits + 1 WHERE FIND_IN_SET(1, secondary_group_ids)

Source: https://www.w3schools.com/SQL/func_mysql_find_in_set.asp

Worked perfectly, thanks so much for this

 

[DragonByte Technologies]

Hello @colcar,

We hope your ticket regarding DragonByte Credits has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @colcar,

As we have not heard back from you, your ticket regarding DragonByte Credits has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.