Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions
Server setupIGCNS9, S12, S16, S17, S18

How do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?

Written by MuADMINS from the sourceNot verified

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)
  1. The account must be offline (best: server closed). Back up first.
  2. Look at the row:
SELECT * FROM T_InGameShop_Point WHERE AccountID = 'account1';
  1. 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.

  1. 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);
  1. 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.

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.