Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

10 solutions for “coins” in Server setup · Clear

  1. Server setupIGCNS16, S17, S18

    IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)

    IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...

    Not verifiedWritten by MuADMINS
  2. Server setupMSProS2, S3, S6

    MSPro: the shipped query "Dar coin ganador gs" (WCoin for the Castle Siege winner) is broken

    The file Tools - Querys Y Otros\Query-Sql\Dar coin ganador gs.txt has three problems: 1. Line 1 update CashShopData set WCoinC= WCoinC+1000 where AccountID in has nothing after IN (syntax...

    Not verifiedWritten by MuADMINS
  3. 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)?

    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...

    Not verifiedWritten by MuADMINS
  4. Server setupIGCNS9, S12, S16, S17, S18

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

    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, GoblinPo...

    Not verifiedWritten by MuADMINS
  5. Server setupOpenMUS6E3

    OpenMU: how do I turn on the in-game cash shop (X key), and where do players get WCoin and Goblin Points?

    1. On the Plugins page the plugin Cash shop switches the shop on and off. Its settings: gifting, gifting to the own account, and the maximum storage items (0 means unlimited). 2. Players...

    MuADMINS rewrite of the sourceNot verifiedGitHub (MUnique/OpenMU) · 2026-10-07
  6. Server setup

    I changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)

    The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...

    Not verifiedWritten by MuADMINS
  7. Server setupX-TeamS2, S15, S17, S18

    What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?

    X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...

    Not verifiedWritten by MuADMINS
  8. Server setupMuEmu / LouisSeason 6 (Louis update 27)

    Louis update 27: CashShopData is not updated with the Custom Arena reward when the event ends.

    1. The procedure WZ_CustomArenaRanking only rewards arena index 0 (IF @ArenaNumber = 0), so check which arena number you use. 2. Add the reward for your arena index if it is not 0. 3. The...

    ✓ Confirmed by the topic starterCreandoMU · 2021-09-19
  9. Server setupMSProS2, S3, S6

    What are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?

    MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...

    Not verifiedWritten by MuADMINS
  10. Server setupIGCNS9, S12, S16, S17, S18

    Which databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?

    IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...

    Not verifiedWritten by MuADMINS

Videos on MUTube

More videos for “coins”

Still stuck? Ask the MU Assistant Search MuGPS

MuADMINS Community Alpha: free and community made, in active development.