hello, can you explain me how to divide or multiple points of all users to 10 at once, for example?
multiple or divide given points of all users
- The points are calculated based on the credits received. So to affect all points you would have to modify the database directly.
UPDATE #__aworewards SET points = points / 10
WHERE credit_type = "points" AND points IS NOT NULL AND points > 0
AND ( points_paid = 0 OR points_paid IS NULL );
Where #__ is changed to your database prefix. Note it will only affect points where no payment has been made.Please BACKUP the #__aworewards table before running this query, so you can always revert back if you see an issue.