The table is T_InGameShop_Point, but the columns changed between seasons:
- Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float)
- Season 16, 17, 18: AccountID, WCoin, GoblinPoint (float)
- The account must be offline (best: server closed). Back up first.
- Look at the row:
SELECT * FROM T_InGameShop_Point WHERE AccountID = 'account1';- Add with IGCN's own procedure
WZ_IBS_AddCoin @AccountID, @Type, @Coin:
EXEC WZ_IBS_AddCoin 'account1', 0, 500;Season 16+: Type 0 = WCoin, 1 = GoblinPoint. Season 9: 0 = WCoinC, 1 = WCoinP, 2 = GoblinPoint.
- WZ_IBS_AddCoin is only an UPDATE: if step 2 returned no row nothing is added. Create the row first (Season 16+ columns):
IF NOT EXISTS (SELECT 1 FROM T_InGameShop_Point WHERE AccountID = 'account1')
INSERT INTO T_InGameShop_Point (AccountID, WCoin, GoblinPoint) VALUES ('account1', 0, 0);- Website credits are another table: MEMB_CREDITS (memb___id, credits, used).
Negative balances: the maintenance script "Check & Fix negative Coins.sql" (Take server offline before proceeding) first lists SELECT * FROM T_InGameShop_Point WHERE WCoin < 0 OR GoblinPoint < 0 and only then sets them to 0.
Source: IGCN S9 MuOnline(Without_MD5).sql, S12.2 MuOnline.sql, S16/S17/S18 MuOnline_without_MD5.sql (T_InGameShop_Point, WZ_IBS_AddCoin), S17 2. Update Scripts/Maintenance Scripts/Check & Fix negative Coins.sql.