Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSConfig ScannerCarica lo zip dei tuoi file: rates, drop, spot, limitiApriSu MuADMINSIncontraci su DiscordChiedi aiuto, condividi quello che stai creando e parla di MU con altri proprietari di server.Apri
← Tutte le soluzioni
Setup del serverIGCNS9, S12, S16, S17, S18

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

Scritto da MuADMINS a partire dalla fonteNot 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.

Scritto da MuADMINS
Ti è stato utile?

Non hai ancora risolto? Cerca su MuGPS Chiedi all'Assistente MU

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.