search

ericgrandt / TotalEconomy

All in one economy plugin for Minecraft.
https://ericgrandt.github.io/TotalEconomy/
31 stars 33 forks source link

Fix SQL syntax error when creating virtual accounts. issue #323 #324

Closed jmecn closed 5 years ago

jmecn commented 5 years ago

There is SQL syntax error when creating a virtual account with uuid (String).

see https://github.com/Erigitic/TotalEconomy/issues/323

INSERT IGNORE INTO virtual_accounts (dollar_balance) VALUES ('100') WHERE uid='bc7fc8ed-f75b-45a0-ad9d-103313551c62'

It should be:

INSERT IGNORE INTO virtual_accounts (uuid) VALUES ('bc7fc8ed-f75b-45a0-ad9d-103313551c62');
UPDATE virtual_accounts SET dollar_balance='100' WHERE uid='bc7fc8ed-f75b-45a0-ad9d-103313551c62'
ericgrandt commented 5 years ago

Thanks for the PR. I'll be looking through this shortly and getting it merged in.