Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir
← Todas as soluções
Configuração do servidorIGCNS9, S12, S16, S17, S18

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

Escrita pelo MuADMINS a partir da 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.

Escrito pelo MuADMINS
Isso ajudou?

Ainda com problema? Buscar no MuGPS Pergunte ao Assistente MU

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.