The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint).
- Account offline (best: server closed), backup first, look at the row:
SELECT AccountID, WCoinC, WCoinP, GoblinPoint FROM CashShopData WHERE AccountID = 'account1';- Louis Season 6 (Update 3 and newer), MSPro and similar files ship
WZ_SetCoin @Account, @Name, @Value1, @Value2, @Value3: it adds Value1 to WCoinC, Value2 to WCoinP and Value3 to GoblinPoint, each only when it is above 0:
EXEC WZ_SetCoin 'account1', '', 500, 0, 0;- Files without WZ_SetCoin (X-Team, MuDevs scripts): a plain UPDATE with WHERE:
UPDATE CashShopData SET WCoinC = WCoinC + 500 WHERE AccountID = 'account1';- No row in CashShopData = nothing is added: check step 1 first.
Season 4 style files keep the coins elsewhere (WZ_SetCoin comments: MEMB_INFO Cash / Gold and PcPointdata). X-Team Season 2 has no CashShopData table.
Source: Louis S6 Update 3 "Procedure SetCoin.sql" and Update 2 WZ_SetReward / WZ_SetRewardAll; procedure lists of the Louis V13 / U27, MSPro V14 and S6 ZG backups; X-Team S17 and MuDevs S18 MuOnline scripts.