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 servidorS6, S16, S17, S18, S20

How do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?

Escrita pelo MuADMINS a partir da fonteNot verified

The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint).

  1. Account offline (best: server closed), backup first, look at the row:
SELECT AccountID, WCoinC, WCoinP, GoblinPoint FROM CashShopData WHERE AccountID = 'account1';
  1. Louis Season 6 (Update 3 and newer), MSPro and similar files ship WZ_SetCoin @Account, @Name, @Value1, @Value2, @Value3: it adds Value1 to WCoinC, Value2 to WCoinP and Value3 to GoblinPoint, each only when it is above 0:
EXEC WZ_SetCoin 'account1', '', 500, 0, 0;
  1. Files without WZ_SetCoin (X-Team, MuDevs scripts): a plain UPDATE with WHERE:
UPDATE CashShopData SET WCoinC = WCoinC + 500 WHERE AccountID = 'account1';
  1. No row in CashShopData = nothing is added: check step 1 first.

Season 4 style files keep the coins elsewhere (WZ_SetCoin comments: MEMB_INFO Cash / Gold and PcPointdata). X-Team Season 2 has no CashShopData table.

Source: Louis S6 Update 3 "Procedure SetCoin.sql" and Update 2 WZ_SetReward / WZ_SetRewardAll; procedure lists of the Louis V13 / U27, MSPro V14 and S6 ZG backups; X-Team S17 and MuDevs S18 MuOnline scripts.

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.