Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir
← Todas las soluciones
Instalación del servidorIGCNS9, S12, S16, S17, S18

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

Escrito por MuADMINS a partir de la fuenteNot 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 por MuADMINS
¿Te sirvió?

¿Sigues atascado? Buscar en MuGPS Pregúntale al Asistente MU

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.