Query
Código:
Declare @login varchar(20) = 'admin' -- Login do Player
Declare @WC int = 100 -- Quantidade de WCoinC
Declare @WP int = 100 -- Quantidade de WCoinP
Declare @GP int = 0 -- Quantidade de GoblinPoint
begin
if exists (select AccountID from CashShopData where AccountID = @login)
UPDATE CashShopData SET [WCoinC] = [WCoinC] + @WC, [WCoinP] = [WCoinP] + @WP, [GoblinPoint] = [GoblinPoint] + @GP WHERE [AccountID] = @login
else
INSERT INTO CashShopData (AccountID,WCoinC,WCoinP,GoblinPoint) VALUES (@login,@WC,@WP,@GP)
end