PlayerNguyen / OptEco

Paper/Spigot/Bukkit Points System Currency for your server
https://www.spigotmc.org/resources/76179/
MIT License
10 stars 6 forks source link

Speed Up MySQL refresh rate? #18

Closed iwentafk closed 3 years ago

iwentafk commented 3 years ago

Describe the bug Whenever my players use BossShopPro and OptEco linked to a MySQL database for points, they can go negative if they were to spam click items, it takes more points than it should. This seems to be because it's not refreshing to MySQL fast enough.

To Reproduce Steps to reproduce the behavior:

  1. Use BossShop For Point Hook
  2. Spam Click an item that accepts points.
  3. Immediately type /points me and see your amount hasn't change.
  4. Wait 5 seconds, ends up being way lower or going negative if you had a small amount of points.

Expected behavior Should be fluid and take points immediately, instead of waiting for a long refresh rate.

PlayerNguyen commented 3 years ago

As a little trick, you can change the duration of the updater to make BossShopGui works smoother by edit this value to lower valuation. (This can be changed to 0 whether you want your Server requests the updater for every single change on Player money)

Ảnh chụp Màn hình 2020-12-08 lúc 07 12 53
Hallowhead1 commented 3 years ago

This is an issue I am experiencing as well, allows players to buy more than they can actually afford and forces their balance below 0