Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon
Server setupS6, 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)?

Isinulat ng MuADMINS mula sa sourceNot 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.

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.